ANZ POSTINGS

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
ACTIVE_SOURCES_INFO	ARRAY	JSON	ARRAY	JSON	Source information for each active url.
ACTIVE_URLS	ARRAY	JSON	ARRAY	JSON	URLs for the job posting that are determined to be active at the time of the last periodic check.
ANZSCO_1	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 1 code
ANZSCO_1_NAME	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 1 name
ANZSCO_2	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 2 code
ANZSCO_2022_1	VARCHAR	STRING	STRING	STRING	(BETA) 1st-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_1_NAME	VARCHAR	STRING	STRING	STRING	(BETA) Name belonging to the 1st-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_2	VARCHAR	STRING	STRING	STRING	(BETA) 2nd-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_2_NAME	VARCHAR	STRING	STRING	STRING	(BETA) Name belonging to the 2nd-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_3	VARCHAR	STRING	STRING	STRING	(BETA) 3rd-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_3_NAME	VARCHAR	STRING	STRING	STRING	(BETA) Name belonging to the 3rd-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_4	VARCHAR	STRING	STRING	STRING	(BETA) 4th-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_4_NAME	VARCHAR	STRING	STRING	STRING	(BETA) Name belonging to the 4th-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_5	VARCHAR	STRING	STRING	STRING	(BETA) 5th-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2022_5_NAME	VARCHAR	STRING	STRING	STRING	(BETA) Name belonging to the 5th-level ANZSCO code (taxonomy version: ANZSCO 2022).
ANZSCO_2_NAME	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 2 name
ANZSCO_3	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 3 code
ANZSCO_3_NAME	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 3 name
ANZSCO_4	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 4 code
ANZSCO_4_NAME	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 4 name
ANZSCO_5	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 5 code
ANZSCO_5_NAME	VARCHAR	STRING	STRING	STRING	Standard Classification of Occupations Level 5 name
ANZSIC_1	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 1 code
ANZSIC_1_NAME	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 1 name
ANZSIC_2	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 2 code
ANZSIC_2_NAME	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 2 name
ANZSIC_3	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 3 code
ANZSIC_3_NAME	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 3 name
ANZSIC_4	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 4 code
ANZSIC_4_NAME	VARCHAR	STRING	STRING	STRING	Standard Industrial Classification level 4 name
AU_LGA	VARCHAR	STRING	STRING	STRING	Local Government Area code (Australia only)
AU_LGA_NAME	VARCHAR	STRING	STRING	STRING	Local Government Area name (Australia only)
AU_SA3	VARCHAR	STRING	STRING	STRING	Statistical Area level 3 code (Australia only)
AU_SA3_NAME	VARCHAR	STRING	STRING	STRING	Statistical Area level 3 name (Australia only)
AU_SA4	VARCHAR	STRING	STRING	STRING	Statistical Area level 4 code (Australia only)
AU_SA4_NAME	VARCHAR	STRING	STRING	STRING	Statistical Area level 4 code (Australia only)
BODY	VARCHAR	STRING	STRING	STRING	Job posting body
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	List of certification IDs included in the posting
CERTIFICATIONS_NAME	ARRAY	JSON	ARRAY	JSON	List of certification names included in the posting
CIP2	ARRAY	JSON	ARRAY	JSON	2-digit CIP code of any educational requirements mentioned.
CIP2_NAME	ARRAY	JSON	ARRAY	JSON	Name belonging to the 2-digit CIP code(s) of any educational requirements mentioned.
CIP4	ARRAY	JSON	ARRAY	JSON	4-digit CIP code of any educational requirements mentioned.
CIP4_NAME	ARRAY	JSON	ARRAY	JSON	Name belonging to the 4-digit CIP code(s) of any educational requirements mentioned.
CITY	VARCHAR	STRING	STRING	STRING	ID of the city in which a job is located. Neighborhoods within a city are standardized to the city name.
CITY_NAME	VARCHAR	STRING	STRING	STRING	Name of the city in which a job is located. Neighborhoods within a city are standardized to the city name.
COMMON_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of common skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
COMMON_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of common skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
COMPANY	VARCHAR	STRING	STRING	STRING	Company ID of the posting
COMPANY_IS_STAFFING	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the job's employer is a staffing or recruitement company.
COMPANY_NAME	VARCHAR	STRING	STRING	STRING	Company name of the posting
COMPANY_RAW	VARCHAR	STRING	STRING	STRING	Raw company name of the posting
CONTRACT_TYPE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	ID of the contract type.
CONTRACT_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Name of the contract type.
DUPLICATES	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Specifies the quantity of duplicate posts found for the individual job.
DURATION	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	A curated analytical field for determining aggregate durations. Based on Lightcast analysis, Duration is NULL for postings that would have a duration value greater than 60. Duration is also NULL on postings where Expired is NULL.
EMPLOYMENT_TYPE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Employment type ID
EMPLOYMENT_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Employment type name
EXPIRED	DATE	DATE	DATE	DATE	Date when the posting expired
ID	VARCHAR	STRING	STRING	STRING	Posting ID
ISCED_LEVELS	ARRAY	JSON	ARRAY	JSON	IDs of the International Standard Classification of Education (ISCED) levels of educational requirements in the posting.)
ISCED_LEVELS_MAX	VARCHAR	STRING	STRING	STRING	ID of the highest International Standard Classification of Education (ISCED) level of educational requirements in the posting.)
ISCED_LEVELS_MAX_NAME	VARCHAR	STRING	STRING	STRING	Name of the highest International Standard Classification of Education (ISCED) level of educational requirements in the posting.)
ISCED_LEVELS_MIN	VARCHAR	STRING	STRING	STRING	ID of the lowest International Standard Classification of Education (ISCED) level of educational requirements in the posting.)
ISCED_LEVELS_MIN_NAME	VARCHAR	STRING	STRING	STRING	Name of the lowest International Standard Classification of Education (ISCED) level of educational requirements in the posting.)
ISCED_LEVELS_NAME	ARRAY	JSON	ARRAY	JSON	Names of the International Standard Classification of Education (ISCED) levels of educational requirements in the posting.)
IS_INTERNSHIP	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Boolean indicating the posting is for an internship position
LAA_COUNTRY	VARCHAR	STRING	STRING	STRING	2-digit country code where the posting is located. (Eg. AU).
LAA_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING	Name of the country where the posting is located. (Eg. Australia)
LAST_UPDATED_TIMESTAMP	TIMESTAMP_TZ	TIMESTAMP	TIMESTAMP	TIMESTAMP_TZ	Timestamp when the posting enrichments or other fields were modified on this posting (in UTC time).
LOCATION	OBJECT	JSON	STRING	STRING	Approximate lat/lon of the job posting based on the city.
LOT_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the ANZ Postings Meta).
LOT_V6_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V7_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
MAX_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Maximum years of experience listed in the posting (if mentioned).
MIN_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Minimum years of experience listed in the posting (if mentioned).
NATION	VARCHAR	STRING	STRING	STRING	Nation ID of the posting (eg. DEU).
NATION_NAME	VARCHAR	STRING	STRING	STRING	Nation Name of the posting (eg Germany
NZ_RC	VARCHAR	STRING	STRING	STRING	Regional Council code (New Zealand only)
NZ_RC_NAME	VARCHAR	STRING	STRING	STRING	Regional Council name (New Zealand only)
NZ_TA	VARCHAR	STRING	STRING	STRING	Territorial Authority code (New Zealand only)
NZ_TA_NAME	VARCHAR	STRING	STRING	STRING	Territorial Authority name (New Zealand only)
POSTED	DATE	DATE	DATE	DATE	Date when the posting was created
REGION_NAME	VARCHAR	STRING	STRING	STRING	Abbreviation of the state or territory (if from Australia) or country (if from New Zealand)
REMOTE_TYPE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Remote type of the posting
REMOTE_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Remote type name of the posting
SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Minimum advertised salary found in the posting
SALARY_TO	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Maximum advertised salary found in the posting
SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
SOFTWARE_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of software skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
SOFTWARE_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of software skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
SOURCES	ARRAY	JSON	ARRAY	JSON	Web sources the posting comes from
SOURCE_TYPES	ARRAY	JSON	ARRAY	JSON	The set of distinct types of the sources. Being distinct this array is not intended for matching a source type to a source but rather as a guide to what kinds of sources have displayed the posting.
SPECIALIZED_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of specialized skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
SPECIALIZED_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of specialized skills requested in the posting (taxonomy version: see the ANZ Postings Meta).
TITLE	VARCHAR	STRING	STRING	STRING	Job title ID of the posting (taxonomy version: see the ANZ Postings Meta).
TITLE_CLEAN	VARCHAR	STRING	STRING	STRING	The cleaned - but not normalized - job title.
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Job title name of the posting (taxonomy version: see the ANZ Postings Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw job title name of the posting
URL	ARRAY	JSON	ARRAY	JSON	Posting source URLs