UK CORE LMI DAT_STAFFING

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
AREAID	VARCHAR	STRING	STRING	STRING	Geographic region code.
AREAID_NAME	VARCHAR	STRING	STRING	STRING	Geographic region name.
AREAID_TYPE	VARCHAR	STRING	STRING	STRING	Geographic area type.
CLASSID	VARCHAR	STRING	STRING	STRING	Class of worker ID.
CLASSID_NAME	VARCHAR	STRING	STRING	STRING	Class of worker name.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. One worker might fill more than one position.
INDID	VARCHAR	STRING	STRING	STRING	SIC code.
INDID_NAME	VARCHAR	STRING	STRING	STRING	Industry by name.
OCCID	VARCHAR	STRING	STRING	STRING	SOC code.
OCCID_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the SOC code.
PERCENT	FLOAT	FLOAT	DOUBLE	FLOAT	The percent of employment in the industry that is accounted for by the occupation.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.