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

  • Data Mart models are Ministry of Forests and Range dimensional reporting models

  • 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. If you have any questions please contact Gord Duff at (250)376-8094.

 

Top

Data Models


Model Application Name ERDs Definitions Comments

AACDET

Allowable Annual Cut Database System

ERD

Entities
Attributes
Tables

 

ABR

As-Built Roads

ERD

Entities & Attributes
Tables & Columns

 

APT

Apportionment

ERD

Entities
Attributes

Tables

 

BCTSADMIN

BC Timber Sales Administration System

ERD

Entities & Attributes
Tables & Columns

Note: Updated July 2008 

BEC

Biogeoclimatic Ecosystem Classification             ERD                  LRDW
 

Entities & Attributes
Tables & Columns LRDW Tables

Note: Updated July 2008 

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                   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 still implemented on the ENVPROD1 server while transitioning back to MoFR.
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

Note: Updated August 2008 

EMS

Export Management System

ERD

Entities
Attributes
Tables

Being replaced by LEXIS

ESF

Electronic Submission Framework

ERD

Entities
Attributes
Tables

 

FOREST HEALTH

Forest Health ERD
LRDW

Entities & Attributes
Tables & Columns LRDW Tables

Note: Updated May 2008 

 

FREP

 

Forest Resource Evaluation Program

ERD

Entities & Attributes
Tables & Columns

Note: Updated August 2008 

FSP

Forest Stewardship Plan

ERD             LRDW

 

Entities & Attributes
Tables & Columns  LRDW Tables

 

Note: Updated July 2008 

FTA 3.0

Forest Tenure Administration

ALL
BCTS
General Tenure Range
Recreation
Tenure Application Timber
 

 

Entities & Attributes
Tables & Columns    

 

Note: Deactivated

Posted date: May 2, 2008

FTA 4.0

Forest Tenure Administration

ERD
Core             LRDW

Entities & Attributes
Tables & Columns  LRDW Tables

Note: FTA 4 is now in production. 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.

Posted date: May 2, 2008

GAS

General Appraisal System

ERD

Entities & Attributes
Tables & Columns

Note: Updated July 2008 

GBS

General Billing System

ERD

Entities
Attributes
Tables

 

GENUS

 

 

 

Note: non-disclosure order for system documentation

GYS

Growth and Yield

ERD
ERD with Codes LRDW

Entities & Attributes
Tables & Columns

Posted date: Nov 28, 2007

HBS

Harvest Billing System - Phase 1

Attributed Harvest

Entities
Attributes
Tables

 

HBS

Harvest Billing System - Phase 2

Phase 2A
Phase 2B

Entities
Attributes
Tables

 

HBS

Harvest Billing System - Phase 3&4

Phase 3-4
Stratum Planner

Entities
Attributes
Tables

 

HBS

Harvest Billing System - Scaling and Billing

Scaling History

Entities
Attributes
Tables

 

IAPP

Invasive Alien Plant Program ERD
LRDW

Entities & Attributes
Tables & Columns LRDW Tables

 

LEXIS

Log Export Information System ERD  

Entities & Attributes
Tables & Columns

Note: Updated August 2008 

MAX

Performance Management Application

ERD

 

Entities
Attributes
Tables

 

NVAF

Net Volume Adjustment Factor

ERD

Entities
Attributes
Tables

Note: NVAF is still implemented on the ENVPROD1 server while transitioning back to MoFR.

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

Note: Updated August 2008 

SCS

Scale Control System

ERD

Entities
Attributes
Tables

 

SPAR

Seed Planning and Registry System

ERD
Code Tables
SPIR

Entities & Attributes
Tables & Columns

Note: Updated August 2008 

VGIS

Vegetation Ground Inventory Sample

ERD
LRDW


Entities & Attributes
Tables & Columns LRDW Tables

 

Note: VGIS is still implemented on the ENVPROD1 server while transitioning back to MoFR.
Posted date: Feb 28, 2007

VRIMS

Vegetation Resource Inventory Management System

ERD
LRDW


Entities & Attributes
Tables & Columns

 

Note: Updated August 2007 

VSC

Volume Sample Collection

ERD

Entities
Attributes
Tables

Note: VSC is still implemented on the ENVPROD1 server while transitioning back to MoFR.

WASTE

WASTE System

ERD

Entities
Attributes

Tables

 

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_entity.pdf = Entity and attribute definitions report

  • XXX_table.pdf = Table and column definitions report

  • XXX_other1.pdf = other documentation (2, 3, etc)

  • XXX_LRDW.pdf = LRDW Server Model Diagram

  • XXX_LRDW_table.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.