Data Models


Introduction

This page includes all data model diagrams and data dictionary definition reports, by application, for Ministry of Forests and Range applications. By definition, all material is copyrighted and cannot be used for commercial purposes without express written consent.

NOTE: Applications generally use data from several different business areas (i.e., different Data Custodians) and therefore no ownership of the data contained in the models below is necessarily implied towards the custodian responsible for that Application. More information about Data Custodians and ownership of Applications can be found at the Data Custodianship Page

Note:

  • LRDW are components that have data replicated to the Land & Resource Data Warehouse

  • Details of Entities and Attributes are available in the Entity and Attributes report, or in the Integrated Data Dictionary

Link to the Integrated Data Dictionary for cross-ministry searching of entity, attribute, and codes information.

We are currently in the process of updating the Data Models website to ensure that the models posted are the most current versions available. Models that have been recently posted will have the posted date listed.

Data Models


Model Application Name ERDs Definitions Comments

AACDET

Allowable Annual Cut Database System

ERD

Entities & Attributes
Tables & Columns

 

ABR

As-Built Roads

ERD

Entities & Attributes
Tables & Columns

 

APT

Apportionment

ERD

Entities & Attributes
Tables & Columns

 

BCTSADMIN

BC Timber Sales Administration System

ERD

Entities & Attributes
Tables & Columns

 

BEC

Biogeoclimatic Ecosystem Classification ERD
LRDW
 

Entities & Attributes
Tables & Columns LRDW Tables

 

CBR

Corporate Bridge Register ERD

Entities & Attributes
Tables & Columns

 

CIMS

Compliance Information Management System

Inspection Plan Inspection Reports
FTA Data

Risk and Priority
User Profile      LRDW

Entities & Attributes
Tables & Columns LRDW Tables

 

CLIENT

Client Management

 

ERD
Reorganization ERD

 

Entities & Attributes
Tables & Columns

Note: current version of client ( July 2008 )

CONSEP

Cone & Seed Processing

ERD

Entities
Tables

 

DSC

Decay Sample System

ERD

Entities & Attributes
Tables & Columns

Note: DSC is implemented on the ENVPROD1 server.
Posted date: Feb 28, 2007

ECAS

ECommerce Appraisal Application

ADS
Audit
Client and Tenure
Coastal
Common
GAS
GAS2
High Level
Interior
MoF User
Template

Entities & Attributes
Tables & Columns

 

EMS

Export Management System

ERD

Entities
Attributes

Tables

Being replaced by LEXIS

ESF

Electronic Submission Framework

ERD

Entities & Attributes
Tables & Columns

 

FOREST HEALTH

Forest Health ERD
LRDW

Entities & Attributes
Tables & Columns LRDW Tables

 

FNIRS

First Nations Information Reporting ERD

Entities & Attributes
Tables & Columns

 

FREP

Forest Resource Evaluation Program

ERD

Entities & Attributes
Tables & Columns

 

FSP

Forest Stewardship Plan

ERD             LRDW

 

Entities & Attributes
Tables & Columns  LRDW Tables & Columns

 

 

FTA 4.0

Forest Tenure Administration

ERD
Core
FN Free Use Permit
Oil and Gas
Range Tenure
Recreation
Roads
Timber Mark
LRDW

Entities & Attributes
Tables & Columns  LRDW Tables & Columns

Note: With FTA 4 TIMBER MARK is being phased out and has been replaced by HAULING AUTHORITY and HARVEST AUTHORITY which should be used in all future application development.

GAS

General Appraisal System

ERD

Entities & Attributes
Tables & Columns

 

GBS

General Billing System

ERD

Entities & Attributes
Tables & Columns

 

GENUS

 

 

 

Note: non-disclosure order for system documentation

GYS

Growth and Yield

ERD

Entities & Attributes
Tables & Columns

 

HBS

Harvest Billing System

Core
Data Aquisition and Delivery
Infrastructure
Stratum Advisor

Entities & Attributes
Tables & Columns

 

IAPP

Invasive Alien Plant Program ERD
LRDW

Entities & Attributes
Tables & Columns LRDW Tables

 

LEXIS

Log Export Information System ERD  

Entities & Attributes
Tables & Columns

 

NVAF

Net Volume Adjustment Factor

ERD

Entities & Attributes
Tables & Columns

Note: NVAF is implemented on the ENVPROD1 server.

NSA

Nursery & Shipping Administration System

ERD

Entities & Attributes
Tables & Columns

 

Official Notices

Official Notices

ERD

Entities & Attributes
Tables & Columns

 

RESULTS

Results Based Code Silviculture and Landstatus Tracking System

Activity Administration
Spatial
Audit
Forest Cover Silviculture Standard
LRDW

Entities & Attributes
Tables & Columns
LRDW Tables

 

SCS

Scale Control System

ERD

Entities & Attributes
Tables & Columns

 

SPAR

Seed Planning and Registry System

ERD
Parent Tree
Tree Testing
Nursery
Veg Lot
Spatial
SPIR

Entities & Attributes
Tables & Columns

 

VGIS

Vegetation Ground Inventory Sample

ERD
LRDW


Entities & Attributes
Tables & Columns LRDW Tables & Columns

 

Note: VGIS is implemented on the ENVPROD1 server.

VRIMS

Vegetation Resource Inventory Management System

ERD
LRDW


Entities & Attributes
Tables & Columns
LRDW Tables & Columns

 

 

VSC

Volume Sample Collection

ERD

Entities & Attributes
Tables & Columns

Note: VSC is implemented on the ENVPROD1 server.

WASTE

WASTE System

ERD

Entities & Attributes
Tables & Columns

 

WEBADE_ADAM

WEBADE_ADAM

Authorization Client Location
Mail Scheduler
Reporting
 

Entities & Attributes
Tables & Columns

 

Naming standards for linked files (e.g. FTA_ERD.pdf):

  • XXX = 3- or 4-character acronym corresponding to the project's model (usually an application abbreviation; may be longer)

  • XXX_ERD.pdf = Entity Relationship Diagram

  • XXX_ENT_ATT.pdf = Entity and attribute definitions report

  • XXX_TAB_COL.pdf = Table and column definitions report

  • XXX_LRDW_PD.pdf = LRDW Physical Server Model Diagram

  • XXX_LRDW_TAB_COL.pdf =  LRDW Table and column definitions report

Contact List

The Data Administration team can be contacted if you have any questions or concerns. See Guide S7 in IMG's Systems Development Guides for a detailed description of the data modelling process in a development project.