Career Pathways - UK

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
AREA_ID	VARCHAR	STRING	STRING	STRING	Geographic identifier for the shared career pathways row.
AREA_NAME	VARCHAR	STRING	STRING	STRING	Display name for the geographic scope of the row.
AREA_TYPE	VARCHAR	STRING	STRING	STRING	Geographic aggregation level for the row.
OCC_TYPE	VARCHAR	STRING	STRING	STRING	Occupation taxonomy represented by the source and destination occupations.
SOURCE_OCC_ID	VARCHAR	STRING	STRING	STRING	Source occupation identifier for the pathway.
SOURCE_OCC_NAME	VARCHAR	STRING	STRING	STRING	Source occupation display name.
SOURCE_OCC_MEAN_SALARY	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Mean salary for the source occupation in GBP.
SOURCE_OCC_REQUIREMENT_LEVEL	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Requirement level for the source occupation.
DESTINATION_OCC_ID	VARCHAR	STRING	STRING	STRING	Destination occupation identifier for the pathway.
DESTINATION_OCC_NAME	VARCHAR	STRING	STRING	STRING	Destination occupation display name.
DESTINATION_OCC_MEAN_SALARY	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Mean salary for the destination occupation.
DESTINATION_OCC_REQUIREMENT_LEVEL	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Requirement level for the destination occupation.
TRANSITION_SCORE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Career transition similarity score between the source and destination occupations.
TRANSITION_CATEGORY	VARCHAR	STRING	STRING	STRING	Bucketed transition category from the model output.

Updated about 4 hours ago

Did this page help you?