WorkBC Job Postings

538 views (4 recent)

Published by the Ministry of Advanced Education, Skills and Training - Trades Training, Strategic Planning & Engagement
Licensed under Access Only

Up-to-date job posting data for communities around the province, powered by the WorkBC Job Board.

WorkBC also offers a publicly available job posting application programming interface (API). The API service provides the ability to programmatically request, filter and access live job posting data. For more information about the WorkBC Job Posting API, please click here.

Data and Resources

Dataset Extent

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

Additional Information

Contact Information

NameMeaghan Stewart (pointOfContact)
EmailMeaghan.Stewart@gov.bc.ca
OrganizationMinistry of Advanced Education, Skills and Training
Sub-OrganizationTrades Training, Strategic Planning & Engagement

Access & Security

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

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-10
Resource Status onGoing

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.WBC_EMPLOYMENT_OPPS_SP

Short Name: WBC_EMP_OP
Comments: EMPLOYMENT OPP SP provides details related to businesses and organisations offering job opportunities to job-seekers in BC. This is a Point layer.

Column Name Short Name Data Type Data Precision Comments
EMPLOYMENT_OPP_ID MPLMNTPPD NUMBER 10 EMPLOYMENT OPP ID is a unique identifier assigned to the job posting. This is a primary key and user maintained. e.g., 12924
NOC_CODE NOC_CODE NUMBER 5 NOC CODE is the National Occupation Classification code. This is appled to every job posting (by the employer). The first character signifies the group of occupations with the other characters further defining the job. e.g., 5254. 5 is for "Occupations in art, culture, recreation and sport". 52 is for "Technical occupations in art, culture, recreation and sport". 525 is for "Athletes, coaches, referees and related occupations ", and 5254 is for "Program leaders and instructors in recreation, sport and fitness". Example Titles under 5254 incluldes "ski instructor".
JOB_TITLE JOB_TITLE VARCHAR2 255 JOB TITLE stores the job title offered by the occupant, e.g., ski instructor
JOB_DESCRIPTION JBDSCRPTN VARCHAR2 4000 JOB DESCRIPTION describes the job offered in detail, e.g., Education: Some high school; Credentials (certificates, licences, memberships, courses, etc.); Experience: 3 years to less than 5 years; Languages: Speak English; Type of Heavy Equipment Operated: Backhoe excavator, loader, Bulldozer; Specific Skills: Operate heavy equipment
JOB_CLOSING_DATE_TIME JBCLSNGDTT DATE 7 JOB CLOSING DATE TIME is the date the job posting expires. e.g., 04/09/2013 11:59:59 PM
JOB_EMPLOYER_NAME JBMPLRNM VARCHAR2 255 JOB EMPLOYER NAME is the employer company name. e.g., Woodstone Residence Treatment Society
JOB_LOCATION_ADDRESS_1 JBLCTNDDRS VARCHAR2 255 JOB LOCATION ADDRESS 1 is the location of the job (first part) e.g., 2400 Dundas Street West
JOB_LOCATION_ADDRESS_2 JBLCTNDDR1 VARCHAR2 255 JOB LOCATION ADDRESS 2 is the location of the job (second part) e.g., Unit 6
JOB_LOCATION_CITY JBLCTNCT VARCHAR2 100 JOB LOCATION CITY is the city where the job is located. e.g., Kamloops
WORKBC_JOB_POSTING_URL WRKBCJBPST VARCHAR2 1000 WORKBC JOB POSTING URL is the WorkBC web site link to the related Job page, e.g., http://www.workbc.ca/Jobs/JobSeekers/DisplayJobPostingApply.aspx?jobid=74443from=search
ORGANIZATION_WEBSITE RGNZTNWBST VARCHAR2 1000 ORGANIZATION WEBSITE is job posting web site. e.g., www.workbc.ca
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.