Lot 3 Specialized Occupation

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area.
CAREER_AREA_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the Career Area.
CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area.
CERTIFICATION_TYPICALLY_REQUIRED	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Boolean field stating whether a certification is typically must be attained in order to perform work in that occupation.
DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the Specialized Occupation.
DESCRIPTION_AU	VARCHAR	STRING	STRING	STRING
DESCRIPTION_CA	VARCHAR	STRING	STRING	STRING
DESCRIPTION_GB	VARCHAR	STRING	STRING	STRING
DESCRIPTION_NZ	VARCHAR	STRING	STRING	STRING
DESCRIPTION_SG	VARCHAR	STRING	STRING	STRING
ID	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation.
IS_SUPPLY_ONLY	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Boolean field stating if this Specialized Occupation only applies to profiles
LATEST_VERSION	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the version is the latest Taxonomy version. This is relative to the taxonomy itself. To know the version a dataset is on, please see the dataset meta (for example, GLOBAL.POSTINGS_META).
LEVEL	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Level of the dimension hierarchy.
LICENSE_TYPICALLY_REQUIRED	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Boolean field stating whether a license is typically must be attained in order to perform work in that occupation.
LICENSE_TYPICALLY_REQUIRED_UK	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	UK-specific Boolean field stating whether a license is typically must be attained in order to perform work in that occupation.
MINIMUM_TRAINING_LENGTH_MONTHS	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	The minimum months typically required or spent to complete training, earn a degree, or acquire a certification or license, in order to work in an occupation.
NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation.
NAME_AU	VARCHAR	STRING	STRING	STRING
NAME_CA	VARCHAR	STRING	STRING	STRING
NAME_GB	VARCHAR	STRING	STRING	STRING
NAME_NZ	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_AU	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_CA	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_GB	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_NZ	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_SG	VARCHAR	STRING	STRING	STRING
NAME_PLURAL_US	VARCHAR	STRING	STRING	STRING
NAME_SG	VARCHAR	STRING	STRING	STRING
OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation.
OCCUPATION_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the Occupation.
OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group.
OCCUPATION_GROUP_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the Occupation Group.
OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group.
OCCUPATION_LEVEL	VARCHAR	STRING	STRING	STRING	Describes Occupation Level of corresponding Specialized Occupation. This field is derived from ISCO Major Groups and reflects the relative skill and responsibility level of occupations. For the client-facing field, ISCO groups (4-8) are consolidated, and ISCO Major Group 1 (Managers) have been split to provide easy use. This allows users to explore profiles and postings data using broad Occupation Levels for high-level analysis.
OCCUPATION_LEVEL_ID	VARCHAR	STRING	STRING	STRING	ID value corresponding to the Occupation Level metadata field.
OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation.
REQUIREMENT_LEVEL	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	ID of the Requirement Level, which is a mutually exclusive categorical tag indicating the level of education or training typically achieved or required to perform the specialized occupation.
REQUIREMENT_LEVEL_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Name of the Requirement Level, which is a mutually exclusive categorical tag indicating the level of education or training typically achieved or required to perform the specialized occupation.
REQUIREMENT_LEVEL_UK	VARCHAR	STRING	STRING	STRING	UK-specific Requirement Level, which is a mutually exclusive categorical tag indicating the level of education or training typically achieved or required to perform the specialized occupation.
REQUIRES_SPECIALIZED_TRAINING	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Boolean flag indicating is additional education or training credentials are mandatory in order to be considered for an specialized occupation.
REQUIRES_SPECIALIZED_TRAINING_UK	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	UK-specific Boolean flag indicating is additional education or training credentials are mandatory in order to be considered for an specialized occupation.
SPECIALIZED_TRAINING_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Brief description of the typical education, training, or certification path taken to be qualified for the specialized occupation.
TYPICAL_EDUCATION	VARCHAR	STRING	STRING	STRING	Describes the typical level of education required for the corresponding Occupation and Specialized Occupation
VERSION	VARCHAR	STRING	STRING	STRING	Taxonomy version.