Taxonomy Lot 3 Specialized Occupation
TAXONOMY 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 aquire a certification or lisence, 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_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 cosidered 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. |
Updated about 8 hours ago
