04/28/06 11:12:21 PROGRESS Report

Database: win202v2 (PROGRESS)

Table Name Description

------

admin This file contains the administrative information for each

account such as address, phone #, 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 #.

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 values for 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