| Table Name | Description |
|---|---|
| admin | This file contains the administrative information for each account such as address, phone number, etc. This formation is overwritten each quarter by the extract file if not locked. |
| adm_lock | Contains locks which are currently active on the system |
| alpha | Contains legal and dba name for each employer. |
| bprocess | Holds Batch Process Records Used By Batch Programs |
| ces | CES data |
| comment-cds | Contains valid comment codes |
| control-file | Contains old codes and refile data not on admin record |
| county | Table of county codes for entire U.S. |
| ctrl-err | Table of Control File error flags generated during edits |
| ctytwn | Table of all valid cty/twn/fips codes |
| ctyzone | Used to store Zone codes |
| error-codes | Table of valid error codes |
| estimate-cds | Table of vald estimate codes |
| genrl-adm | Contains state admin level state use fields |
| lma | Contains valid lma codes and descriptions |
| lock-tbl | Contains valid system locks and descriptions |
| lookup-cd | Table of codes and descriptions for use in verification and reporting |
| lookup-strg | Contains comma delimited lists of look-up tables for use in selection lists |
| lookupa-cd | Contains lookup values and descriptions with alpha index |
| macmsa | Stores naics msa & county macro data |
| macnaics | |
| macro | Rolled micro data |
| macro-err | Table of macro error flags generated during edits |
| macro2-err | NAICS Macro Errors |
| micro-err | Table of micro error flags generated during edits |
| msa | Metropolitan Statistical Area |
| msa-xwalk | Table used to store new & old codes and decriptions. |
| naics-cluster | BLS (Pennsylvania) Industry Cluster data |
| naics-desc | Naics codes and related descriptions |
| naics-sector | Contains Sector titles for all 2 digit groups |
| naics-xwalk | Table of relationships between naics codes and sic codes |
| naics2-print | Naics print descriptions for ARCS Forms |
| nax-print | Naics codes and industry descriptions within each aux_cd. |
| nax-xwalk | Aux-cd/Aux-naics-cd crosswalk table for use with edit 142 |
| nca-control | NCA Control table used to hold and process CA Forms on demand |
| nca-counts | Used to store counts for nca-control and caforms.p |
| nonfarm | |
| param-cds | Table of state parameters |
| permissions | Contains the procedures that have security features and who can run certain procedures |
| place-cd | |
| predsucc | Stores secondary predecessor & successor acct for a UI number. Primary predecessor & successor info is stored on the micro file. |
| preferences | Used to store user preferences for accessibility and screens |
| print-prog | Contains List of available report programs |
| probsic | Table of valuesfor the Logical SIC Change Check |
| quarterly | This file contains codes and employment and wages for a particular quarter. Each quarter, new info is added by the extract |
| report-auto | Table used to run reports at specific times |
| report-parm | User defined parameters used by some Batch programs in print-prog |
| response-cds | Table of valid ARS response codes |
| sic-cd-tbl | Available list of SIC Codes |
| state-info | State specific data used to prime fields for processing |
| state-tbl | Table of valid state codes |
| status-log | Transaction log of admin and quarterly data generated by triggers |
| sum-dif | CCS summary of differences file used during 1st qtr macro edits |
| sum2-dif | CCS summary of differences file used during 1st qtr (NAICS) macro edits |
| wage-records | Table of Wage Record Totals by Quarter |
| wia | |
| wr-predsucc | |
| yrqtr-data | Holds information on which Quarters are in the database and whether they are locked |
| zip-town |
Credits
Copyright © 2010
All rights reserved.