Future labour force expansion and replacement for occupations across development regions

205 views (3 recent)

Published by the Ministry of Jobs, Trade and Technology - International Marketing
Licensed under Access Only

Information about future labour force expansion and replacement for occupations across BC's development regions. The report provides projections to identify occupations in BC at various skill levels that may face shortages of workers.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/)

Lineage Statement

Data source: BC Ministry of Jobs, Tourism and Skills Training (Labour Market Outlook Model), 2014

Contact Information

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-05-04
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_LABOUR_MARKET_EXPREP

Short Name: LBRMKT_XPR
Comments: Reports on future labour force expansion and replacement for occupations across BC's development regions. The report provides projections to identify occupations in BC at various skill levels that may face shortages of workers.

Column Name Short Name Data Type Data Precision Comments
LABOUR_MARKET_EXPREP_ID LBRMRKTXPR NUMBER 10 LABOUR_MARKET_EXPREP_ID is a system generated unique identification number. This is the primary key of this table. e.g., 1
CENSUS_YEAR CNSSR NUMBER 4 CENSUS_YEAR: is the census year that the data is collected. e.g., 2006, 2011. This is also the year of the NOC classification.
GEOGRAPHY_ID GGRPHD VARCHAR2 5 GEOGRAPHY_ID: is the census id for the Province ('59' for BC) or Census Division (e.g., '5965').
GEOGRAPHY_NAME GGRPHNM VARCHAR2 50 GEOGRAPHY_NAME: Name of the geography represented. e.g., British Columbia
PROJECTION_START_YEAR PRJCTNSTRT NUMBER 4 PROJECTION_START_YEAR: The year in which the estimate period begins, e.g., 2010.
PROJECTION_END_YEAR PRJCTNNDR NUMBER 4 PROJECTION_END_YEAR: The year in which the estimate period ends, e.g., 2010.
OCCUPATION_CODE CCPTNCD VARCHAR2 6 OCCUPATION_CODE: An occupation's National Occupational Classification (NOC) code. e.g., NOC001
OCCUPATION_DESCRIPTION CCPTNDSCRP VARCHAR2 100 OCCUPATION_DESCRIPTION: An occupation's National Occupational Classification (NOC) title. e.g., Legislators and senior management
OCCUPATION_CHARACTERISTIC CCPTNCHRCT VARCHAR2 20 OCCUPATION_CHARACTERISTIC: The occupation characteristic estimate reported on. Possible values include : 1. Expansion: New job openings that arise due to economic and industry growth. It is the difference between the Demand Outlook in 2020 and 2010.2. Replacement: Job openings that need to be filled due to retirements and deaths.3. Total: Estimated number of job openings over the outlook period due to expansion and replacement.
EXPANSION_OR_REPLACEMENT_VALUE XPNSNRRPLC NUMBER 7 EXPANSION_OR_REPLACEMENT_VALUE Estimated value for the specified geography, projection start year, projection end year, occupation and characteristic combination. e.g., 25660