LEHD Schema Changelog (V4.11.2)

Added IPEDS status flag for partially missing counts

Updated PSEO earnings to 2019 dollars

Update of institution list (label_institution.csv)

Underlying geovintage updated to reflect 2020 TIGER/Line geography (except for CBSAs - "gb" and "gm" features)

Updated shapefiles based on TIGER/Line 2020 (except for CBSAs - "gb" and "gm" shapefile types) ==

Update EmpSpv due to the restructuring of the QWI weights

Added PSEO metadata files for data partners and coverage

Underlying geovintage updated to reflect 2020 TIGER/Line geography - except for CBSAs.

Tabulations for "B" and "M" geo_levels continue to use 2019 TIGER/Line geographies.

Merge PSEO schema files into official release version

Minor formatting changes

Additional status flags on PSEO Earnings

Additional measures on PSEO Flows to report unobserved/marginally employed

Earnings reported at 2-digit CIPCODE level

Institution code changed to 8-digits

Updated to 2020 CIPCODE

Underlying geovintage updated to reflect 2019 census geography

Updated shapefiles based on TIGER 2019

Added documentation of new J2J Earnings indicators (coming soon in next release of J2J data)

Added PSEO draft schema csv files

Added PSEO sourcing and documentation

Minor layout changes for better readability

Underlying geovintage updated to reflect 2018 census geography

Updated shapefiles based on TIGER 2018

PR geography labels added

Added state part to non-metro/non-micro areas in state label files

Removed nonexistent VT geography from labels

Switch to different rendering engine, only stylistic changes

Due to a change of the geographic boundaries for a WIB in Iowa, the shape files need to be updated.

Adjust the "supersedes" definition to correctly reference the prior version.

Changed the format of the version.txt file. This does not affect data files, but it does affect the metadata, and thus requires an increase in the minor version.

Changed the description of the download locations of the QWI files, as part of the "naming" schema.

Changed the format of the version.txt file. This does not affect data files, but it does affect the metadata, and thus requires an increase in the minor version.

Changed the description of the download locations of the QWI files, as part of the "naming" schema.

Updated industry classification from NAICS 2012 to NAICS 2017

Added J2J Explorer-specific description of metadata for convenience (lehd_j2jexplorer_schema.html)

Added a column ind_level to label_industry.csv similar to the geo_level

Added additional columns to the variable metadata schema for greater clarity

Added a (draft) taxonomy of concepts used in the LEHD data world (label_concept_draft.csv)

Fixed the labeling of ownership code A00 to correctly reflect scope

Added files describing the number of quarters of data availability required relative to start and end quarters (lags_qwi.csv and lags_j2j.csv), and its metadata (variables_lags.csv)

Incorporates forgotten updates to j2japp descriptions. This does not affect the structure or contents of any released data files, but it affects the unreleased J2J app updates downstream.

clarifying the version.txt description - removed the mention of fips replacing by geonum

Moved stusps to the geography section, where it rightfully belongs.

Clarified language and usage of metropolitan area codes in label_geography_metro.csv, removed unused label_geography_cbsa.csv

Expanded definition of [geohi] to include CBSA codes for metropolitan areas

Description on J2JOD earnings measures reversed, fixed. Only affects the J2J app metadata.

Description on J2JOD earnings measures reversed, should have also fixed on J2JOD description.

Description on J2JOD earnings measures reversed

stusps file is not in Geography section of lehd_schema.html

variables_j2japp.csv wasn’t updated in 4.2b-draft

Review "concept" field for MJobStart/MJobEnd

Adjust description of XLS files for J2J

J2J will use status flag 5

Add something about which series are seasonally adjustment to the schema

J2J measures contain fields not in CSV

J2JOD - renaming stable count variables

Update agg_level labels

Discussing presence of Application Name or alternate schema file or other.

J2J measures contain fields not in CSV

J2JOD - renaming stable count variables

Update agg_level labels

Discussing presence of Application Name or alternate schema file or other.

Fix EOL issues

Additional EOL issues

Updated industry classification from NAICS 2012 to NAICS 2017

Added a column ind_level to label_industry.csv similar to the geo_level

Added additional columns to the variable metadata schema for greater clarity

Added a (draft) taxonomy of concepts used in the LEHD data world (label_concept_draft.csv)

Fixed the labeling of ownership code A00 to correctly reflect scope

Added files describing the number of quarters of data availability required relative to start and end quarters (lags_qwi.csv and lags_j2j.csv), and its metadata (variables_lags.csv)

Implemented select changes from V4.1d-draft: Key changes are

Changed structure of state-level geography labels (flat directory structure) e5dbe97

Describes National QWI files and J2J files (both of which are still in beta), added J2J, National QWI spec

added additional geo_level for CBSA (complete), additional description, sources in label_geo_level.csv 1eb399f,27a2674

adjusted AL, AR, GA, IA, KY, LA, MN, MS, NM, PA, TN, TX metropolitan areas for 2016 geo vintage

Added description,definition of SHP files

Modified Indicator Names for J2J variable metadata.

adjusted AL, AR, GA, IA, KY, LA, MN, MS, NM, PA, TN, TX metropolitan areas for 2016 geo vintage

Implemented select changes from V4.1d-draft: Key changes are

Changed structure of state-level geography labels (flat directory structure) e5dbe97

Describes National QWI files and J2J files (both of which are still in beta), added J2J, National QWI spec

added additional geo_level for CBSA (complete), additional description, sources in label_geo_level.csv 1eb399f,27a2674

Added description,definition of SHP files

Modified Indicator Names for J2J variable metadata.

Implemented select changes from V4.1d-draft: Key changes are

Changed structure of state-level geography labels (flat directory structure) e5dbe97

Describes National QWI files and J2J files (both of which are still in beta), added J2J, National QWI spec

added additional geo_level for CBSA (complete), additional description, sources in label_geo_level.csv 1eb399f,27a2674

corrected flag values

documents are now identified by date, not revision

Correction of the TIGER vintage that is used for geographic references

added J2J, National QWI spec

corrected flag values

documents are now identified by date, not revision

Correction of the TIGER vintage that is used for geographic references

Added URL for J2J

Correction of typo in type naming convention, rename of naming_fipsalpha.csv to naming_geohi.csv to be consistent.

Changing of naming convention for to-be-released files based on federal government from fg → of. At this time, no such files have been released.

Changes to alternate name of SepSnx and EmpSpv, tentative rate names

Changes to name of variable schema files (qwipu → qwi), addition of variability variable schema files.

Fixed small typos in QWI variable short names

Updated agg_level description, replaced agg_level.csv file

Fixed minor rendering bug for QWI rate variability names.

No change to actual metadata.

Fixed a minor coding error in label_fipsnum.csv, added a concatenation of geography files as label_geography_all.csv.

Minor text change for agg_level, modified agg_level file.

Removed the last 4 rows of variables_j2jod.csv, since they are not on the current beta J2JOD files.

Added a extension component [ext] to the file naming convention to reflect availability of Excel files (and PDF files)

Removed extraneous empty lines

Fixed typo in variables_qwi.csv (FrmJbLsS, EarnHirNS and status variables)

Incorporated all state-level geography from 4.0.5

Added additional geo_level for CBSA (complete)

Added additional agg_level values

Clarified labels of j2jod identifiers

Renamed label_geography_all as label_geography

Added a column geo_level to all label_geography_* files

Corrected erroneous Oregon geography labels.

added J2J, National QWI spec

added geohi category of ALL, US

added definitions of variability measures

added definitions of rates on separate file

added naming convention for additional files

added agg_level variable

added additional geo_level for CBSA (complete)

added SHP files and description thereof

corrected flag values

documents are now identified by date, not revision

Correction of the TIGER vintage that is used for geographic references

Added URL for J2J

Correction of typo in type naming convention, rename of naming_fipsalpha.csv to naming_geohi.csv to be consistent.

Changing of naming convention for to-be-released files based on federal government from fg → of. At this time, no such files have been released.

Changes to alternate name of SepSnx and EmpSpv, tentative rate names

Changes to name of variable schema files (qwipu → qwi), addition of variability variable schema files.

Fixed small typos in QWI variable short names

Updated agg_level description, replaced agg_level.csv file

Fixed minor rendering bug for QWI rate variability names. No change to actual metadata.

Fixed a minor coding error in label_fipsnum.csv, added a concatenation of geography files as label_geography_all.csv.

Minor text change for agg_level, modified agg_level file.

Removed the last 4 rows of variables_j2jod.csv, since they are not on the current beta J2JOD files.

Added a extension component [ext] to the file naming convention to reflect availability of Excel files (and PDF files)

Removed extraneous empty lines

Fixed typo in variables_qwi.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed typo in variables_qwi.csv (HirAS, HirNS, and status variables)

Fixed typo in variables_qwi*v.csv (HirAS, HirNS)

added J2J, National QWI spec

added geohi category of ALL, US

added definitions of variability measures

added definitions of rates on separate file

added naming convention for additional files

added agg_level variable

corrected flag values

documents are now identified by date, not revision

Correction of the TIGER vintage that is used for geographic references

Added URL for J2J

Correction of typo in type naming convention, rename of naming_fipsalpha.csv to naming_geohi.csv to be consistent.

Changing of naming convention for to-be-released files based on federal government from fg → of. At this time, no such files have been released.

Changes to alternate name of SepSnx and EmpSpv, tentative rate names

Changes to name of variable schema files (qwipu → qwi), addition of variability variable schema files.

Fixed small typos in QWI variable short names

Updated agg_level description, replaced agg_level.csv file

Fixed minor rendering bug for QWI rate variability names. No change to actual metadata.

Fixed a minor coding error in label_fipsnum.csv

added J2J, National QWI spec

added geohi category of ALL, US

added definitions of variability measures

added definitions of rates on separate file

added naming convention for additional files

added agg_level variable

added a concatenation of geography files as label_geography_all.csv.

added label_geography_us.csv for completeness

Updated LEHD shape files for Texas WIB definitions

Update the source links of metro definitions from http://www.census.gov/population/metro/ (broken) to https://www.census.gov/programs-surveys/metro-micro.html

Corrected naming of three of the status flags that have "Rate" at the end. That should be just "R".

Updated LEHD shape files, Louisiana and Alabama WIB definitions

Modifed naming_geo_cat.csv, gb value to read "Metropolitan (complete)", gm to "Metropolitan/Micropolitan (state parts)"

Updated reference in shapefile description to Job-to-Job Explorer to point to the recently released Beta webap, updated title to refer to the same name as the naming_geo_cat.csv uses

Updated TIGER references to 2016 in shapefile description

Modifed label_geo_level.csv, B value to read "Metropolitan (complete)"

Added referenced in the same file to where to find the CBSA code underlying the state-part definitions

Added a new file label_geography_metro.csv

Changed references where appropriate from label_geography_cbsa to label_geography_metro

Added additional aggregation levels, changed some labels

Removed two variables from variables_j2jod.csv that were not actually on the CSV file

Updated 2016 geography in shapefiles

Corrected naming of files inside shapefile ZIP files

Corrected naming of three of the status flags that have "Rate" at the end. That should be just "R".

Updated LEHD shape files, Louisiana and Alabama WIB definitions

Modifed naming_geo_cat.csv, gb value to read "Metropolitan (complete)", gm to "Metropolitan/Micropolitan (state parts)"

Updated reference in shapefile description to Job-to-Job Explorer to point to the recently released Beta webap, updated title to refer to the same name as the naming_geo_cat.csv uses

Updated TIGER references to 2016 in shapefile description

Modifed label_geo_level.csv, B value to read "Metropolitan (complete)"

Added referenced in the same file to where to find the CBSA code underlying the state-part definitions

Added a new file label_geography_metro.csv

Changed references where appropriate from label_geography_cbsa to label_geography_metro

Added additional aggregation levels, changed some labels

Removed two variables from variables_j2jod.csv that were not actually on the CSV file

Updated 2016 geography in shapefiles

Corrected naming of files inside shapefile ZIP files

Corrected naming of three of the status flags that have "Rate" at the end. That should be just "R".

Modifed naming_geo_cat.csv, gb value to read "Metropolitan (complete)", gm to "Metropolitan/Micropolitan (state parts)"

Updated reference in shapefile description to Job-to-Job Explorer to point to the recently released Beta webap, updated title to refer to the same name as the naming_geo_cat.csv uses

Updated TIGER references to 2016 in shapefile description

Modifed label_geo_level.csv, B value to read "Metropolitan (complete)"

Added referenced in the same file to where to find the CBSA code underlying the state-part definitions

Added a new file label_geography_metro.csv

Changed references where appropriate from label_geography_cbsa to label_geography_metro

Added additional aggregation levels, changed some labels

Removed two variables from variables_j2jod.csv that were not actually on the CSV file

Updated 2016 geography in shapefiles

Corrected naming of files inside shapefile ZIP files

Fixed a rendering issue with an empty column.

Modified the label for firm age and firm size to contain mention of "Not Available For Public-Sector Firms"

Changed description of agg_level

Removed two variables from variables_j2jod.csv that were not actually on the CSV file

Corrected bad reference to release RXXXX, which should have been R2016Q4

Corrected naming of files inside shapefile ZIP files

Corrected naming of three of the status flags that have "Rate" at the end. That should be just "R".

Implemented select changes from V4.1d-draft: Key changes are

Changed structure of state-level geography labels (flat directory structure)

Describes National QWI files and J2J files (both of which are still in beta), added J2J, National QWI spec

added additional geo_level for CBSA (complete), additional description, sources in label_geo_level.csv

Added description,definition of SHP files

Modified Indicator Names for J2J variable metadata.

adjusted AL, AR, GA, IA, KY, LA, MN, MS, NM, PA, TN, TX metropolitan areas for 2016 geo vintage

Fixed typo in variables_qwipu.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed typo in variables_qwipu.csv (HirAS, HirNS, and status variables)

removed obsolete flag values

updated IL, NE geography definitions

switched NAICS coding from 2007 to 2012

switched Geovintage to 2014, updated AK and SD files, added MA.

updated OR.

Added consolidated geography label file label_geography_all.csv

Updated the identification of the correct geo vintage

Added a link to NAICS 2012 tables

Removing the 99 row in industry values - only used for internal error checking

updated MO (new WIB code).

Added us/label_geography.csv to have an entry for the National QWI

Added better cross-links between CSV naming schame, and datafile schema

Corrected label_geo_level.csv to include the national level value.

Clarified description of geography codes

Added better cross-links between CSV naming schame, and datafile schema

Corrected label_geo_level.csv to include the national level value.

Fixed typo in variables_qwipu.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed typo in variables_qwipu.csv (HirAS, HirNS, and status variables)

removed obsolete flag values

updated IL, NE geography definitions

switched NAICS coding from 2007 to 2012

switched Geovintage to 2014, updated AK and SD files, added MA.

updated OR.

Added consolidated geography label file label_geography_all.csv

Updated the identification of the correct geo vintage

Added a link to NAICS 2012 tables

Removing the 99 row in industry values - only used for internal error checking

Added consolidated geography label file label_geography_all.csv

Updated the identification of the correct geo vintage

Fixed typo in variables_qwipu.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed error in CBSA names (failure to actually update to 2014 Geovintage)

Corrected WIB naming change in Florida and Ohio

Fixed typo in variables_qwipu.csv (HirAS, HirNS, and status variables)

removed obsolete flag values

updated IL, NE geography definitions

switched NAICS coding from 2007 to 2012

switched Geovintage to 2014, updated AK and SD files, added MA.

Initial version

Corrected release that the switch to NAICS 2012 was made

Added consolidated geography label file label_geography_all.csv

Fixed typo in variables_qwipu.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed typo in variables_qwipu.csv (HirAS, HirNS, and status variables)

removed obsolete flag values

updated IL, NE geography definitions

switched NAICS coding from 2007 to 2012

Fixed typo in variables_qwipu.csv (FrmJbLsS, EarnHirNS and status variables)

Fixed typo in variables_qwipu.csv (HirAS, HirNS, and status variables)

removed obsolete flag values

updated IL, NE geography definitions