CORELMI_US_V3.DAT_STAFFING - Removing support for AREAID_TYPE "ZIP" & "TRACT"

30 days and 55 minutes
Underway
Underway

The scheduled maintenance is now underway. We'll keep you updated on our progress.

Scheduled

Due to the increasing size of the CORELMI_US_V3.DAT_STAFFING table, we are planning an upcoming change to optimize performance and reduce storage and data transfer costs.

As part of this change, the following AREAID_TYPE levels will be removed from the table:

  • ZIP
  • TRACT

The table will continue to support the following AREAID_TYPE levels:

  • NATION
  • STATE
  • MSA
  • COUNTY

Removing these two most granular levels will reduce the overall size of the table by approximately 95%, resulting in improved query performance and lower costs associated with storage and data transfer.

If you have any questions, concerns, or believe this change may impact your workflows, please reach out to your Lightcast representative.

Affected components
  • Data Share
    • Core LMI US