06 lookup file es2lkup
Jump to navigation
Jump to search
Lookup File (ES2LKUP)
ES2LKUP - Length 132 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 2 | 2 | Key | Char | LKUP-REC-TYPE | Lookup key record type; 'AN' = Aux-to-NAICS pairing, 'BC' = Refiling batch header, 'CC' = County FIPS code, 'CM' = Comment code, 'CZ' = County/Zone (or county/ township) pair, 'FD' = VSAM File definition 'GC' = Group header, 'GP' = Publication "Group" header data, 'LC' = Location code definition, 'LK' = Micro File data lock flags, 'MC' = Match code definition, 'ME' = Micro Edit Distribution; 'MS' = Modern (5-digit) MSA code; 'NA' = NAICS code, 'N2' = NAICS Sector (2-digit) code, 'N3' = NAICS Sub-Sector (3-digit) definition; 'N4' = NAICS 4-digit code; 'N5' = NAICS 5-digit definition; 'OC' = Ownership code, 'PK' = Program constant (editing and estimation), 'PL' = Place ("City") code definition, 'SM' = MSA/County pair (using old 4-byte MSA), 'SP' = State usage parameter, 'ST' = State-specific constant data |
| 3 | 12 | 10 | Key | Char | LKUP-KEY-DATA | Key data for associated record type; formats defined below, except for the State-specific parameters ('SP' records, which take the form of a 'PK' record, but are otherwise undefined in format, since they are not used in EXPO at all) Note: Trailing fillers to complete the key at position 12 are not listed in the elements listed below |
| 3 | 6 | 4R | Key | Char | LKUP-BC-BATCH | Refiling batch header ('BC' record) batch ID code |
| 3 | 5 | 3R | Key | Char | LKUP-CC-CNTY | County FIPS code (in 'CC' record) |
| 3 | 4 | 2R | Key | Char | LKUP-CM-CMNT | Comment code (in 'CM' record) |
| 3 | 9 | 7R | Key | Char | LKUP-CZ-CNTY-ZONE | County and zone combination (in 'CZ' record); subdivided below |
| 3 | 5 | 3R | Key | Char | LKUP-CZ-CNTY | County portion of valid county-zone or county-township pairing |
| 6 | 9 | 4R | Key | Char | LKUP-CZ-ZONE | Zone (or township) portion of valid county-zone pairing |
| 3 | 6 | 4R | Key | Char | LKUP-FD | File Definition File ID code ('ALPH', 'ATRN', etc.); used with 'FD' record |
| 3 | 6 | 4R | Key | Char | LKUP-GC-GROUP | Group code for 'GC' record |
| 7 | 9 | 3R | Key | Char | LKUP-GC-ZEROES | Constant '000' (three zeroes) trailer for Group header key |
| 3 | 6 | 4R | Key | Char | LKUP-GP-PUB-ID | Publication "group" ID for 'GP' record |
| 7 | 9 | 3R | Key | Char | LKUP-GP-ZEROES | Zeroes ('000') trailer for publication header key ('GP' record) |
| 3 | 5 | 3R | Key | Char | LKUP-LC-LOC-CODE | Location code value, found within the 'LC' record; used in the ES2C Geocode screen, denoting the type of location used within the geocoding framework; Made up of two-byte alpha code for the geographic area in use, plus a numeric digit for degree of certainty in the location identification; the first two-byte values include- 'AS' = Address by house range; 'AX' = Address intersection; 'ZB' = Block zip code centroid; 'ZC' = Unclassified Census zip-code centroid; 'ZT' = Census tract zip code centroid |
| 3 | 5 | 3R | Key | Char | LKUP-LK-202 | Constant to identify record locking flags in 'LK' record; set to '202' |
| 3 | 6 | 4R | Key | Char | LKUP-MC-MATCH-CODE | Geographic match code denoting the level of address matching, within the 'MC' record type, a data reliability indicator; comprised of letter code and 3-digit number for method of code determination; letter codes are- 'A' = Match to Alias or alternate record from USPS data; 'D' = Small town with PO box or General Delivery address; 'S' = Directly matched to USPS data; 'T' = Zip code Street segment match; 'U' = USPS match, but ZIP+4 dependent on firm name; 'X' = Match on street intersection; 'Y' = Matched to intersection using street name alias; 'Z' = Zip code verified, but no address provided |
| 3 | 3 | 1R | Key | Char | LKUP-MC-MATCH-LETTER | Letter code denoting the general matching level; "E" entries are accompanied by a 3-digit numeric value for an error code processing notation; all other entries are listed as a single alpha character; values include- 'A' = Alias/alternate USPS data; 'D' = Small town with PO Box or general delivery; 'S' = USPS direct match; 'T' = Zip code street segment; 'U' = ZIP+4 match; 'X' = Street intersection match; 'Y' = Intersection with street name alias; 'Z' = Zip code verification without address |
| 3 | 6 | 4R | Key | Char | LKUP-ME-SEQ | Micro Edit Distribution ('ME' record type) record sequence number |
| 3 | 7 | 5R | Key | Char | LKUP-MS-MSA | MSA code for 'MS' record type (used instead of 'MS' due to now-obsolete acronym of 'SMSA' ("Standard Metropolitan Statistical Area"), but the "Standard" was later discontinued); the "MS" variable names are now used in the field names |
| 3 | 5 | 3R | Key | Char | LKUP-MS-MSA-PREFIX | Portion of the MSA code used to check for the use of a QMSA; if this is a QMSA, these two positions = 'Q00' (Q-zero-zero) |
| 6 | 7 | 2R | Key | Char | LKUP-MS-QMSA-SEQ | Last two characters of the MSA code; if these are numeric and the QMSA prefix (previous line) is identified, this is a QMSA (partitioning of the state into geographic districts) |
| 8 | 10 | 3R | Key | Char | LKUP-MS-CNTY | County FIPS code associated with the MSA ('MS' record type) |
| 3 | 8 | 6R | Key | Char | LKUP-NA-NAICS | Valid NAICS code (for 'NA' record type) |
| 3 | 4 | 2R | Key | Char | LKUP-N2-BEGIN | First 2-digit value of a NAICS sector (used with 'N2' record type); used in conjunction with "LKUP-N2-END" field (described later) to span the sector |
| 3 | 5 | 3R | Key | Char | LKUP-N3 | Sub-sector NAICS 3-digit value for description in 'N3' record type |
| 3 | 6 | 4R | Key | Char | LKUP-N4 | NAICS 4-digit value listed for description in 'N4' record type |
| 3 | 7 | 5R | Key | Char | LKUP-N5 | 5-digit NAICS value (used with 'N5' record type) |
| 3 | 4 | 2R | Key | Char | LKUP-OC-OWNER | Valid ownership code (in 'OC' record) |
| 3 | 5 | 3R | Key | Num | LKUP-PK-ID | Sequence number for editing constant (in 'PK' record) |
| 3 | 7 | 5R | Key | Char | LKUP-PL-PLACE-ID | Place code used for city/community identification in the 'PL' record; shown on ES2C Geocoding screen and utilized by Job 36D |
| 3 | 5 | 3R | Key | Char | LKUP-ST-ATE | Constant trailer on the State-specific Constants record (record type 'ST'); always set to 'ATE' |
| 13 | 132 | 120 | Char | LKUP-DATA | Data portion of Lookup Record; this takes on several formats, as shown below; a dark line separates each type of record layout | |
| *** STATE CONSTANTS *** | ||||||
| 13 | 14 | 2 | Num | LKUP-STATE-FIPS | FIPS state code (01 = Alabama, 02 = Alaska, etc.) | |
| 15 | 16 | 2 | Char | LKUP-STATE-ABBREV | State postal abbreviation (AL, AK, AZ, CA, etc.) | |
| 17 | 30 | 14 | Char | LKUP-STATE-NAME | Name of the state (only need for an abbreviation is for District of Columbia) | |
| 31 | 32 | 2 | Num | LKUP-CES-SHIFT-CT | Obsolete field once used with ACES data | |
| 33 | 33 | 1 | Num | LKUP-SUPPRESS-CT | Number of leading zeroes to suppress from U-I account number in reports (0-9) | |
| 34 | 34 | 1 | Char | LKUP-ZONE-TOWNSHIP | Zone field usage indicator; 'N' = Not used, 'T' = Townships used, 'Z' = Zones used | |
| 35 | 35 | 1 | Char | LKUP-Z-T-VERIFY | Indicates whether CZ records are used to verify zone/town data (Y/N) | |
| 36 | 36 | 1 | Char | LKUP-CES-202-SW | Firm list and summary report selection mode; 'C' = CES-based, '2' = 202-based | |
| 37 | 42 | 6 | Char | LKUP-ST-USE-HEAD1 | First line of report heading for quarterly state usage field, if used | |
| 43 | 45 | 6 | Char | LKUP-ST-USE-HEAD2 | Second line of report heading for quarterly state usage field, if used | |
| 49 | 51 | 6 | Char | LKUP-ST-USE-DEFAULT | Default setting for quarterly state usage field when no IMT data exist | |
| 55 | 59 | 5 | Num | LKUP-MINIMUM-ZIP-CODE | Minimum allowable 5-digit zip code for an in-state address | |
| 60 | 64 | 5 | Num | LKUP-MAXIMUM-ZIP-CODE | Maximum allowable 5-digit zip code for an in-state address | |
| 65 | 65 | 1 | Char | LKUP-CARS-STATE-SW | Switch to note whether State participates in the Centralized Annual Refiling Survey (CARS) project (Y/N) | |
| 66 | 66 | 1 | Char | LKUP-EARS-CODE-UPDATE | EARS switch to allow immediate code change copying to micro data (Y/N) | |
| 67 | 67 | 1 | Char | LKUP-MWRWEB-STATE-SW | Switch to demonstrate whether State participates in the web-based multiple worksite report (MWR-Web) program (Y/N) | |
| 68 | 72 | 5 | Num | LKUP-CICS-IO-LIMIT | Maximum number of file reads in a CICS transaction before processing is interrupted | |
| 73 | 77 | 5 | Char | LKUP-EDIT-SORT-PARMS | Edit and estimation sort parameters, entered in the Job 01Q run, can be changed in ES2L in mid-quarter; can be any combination of the following codes- 'A' = Administrative/Employment-wage edit split, 'C' = County, 'E' = AME, 'F' = Fester score, 'G' = Gross error code, 'N' = NAICS, 'O' = Owner, 'P' = Split reported/ estimated, 'R' = Lowest error number, 'T' = Township, 'V' = Type Covg, 'Z' = Zone | |
| 78 | 78 | 1 | Char | LKUP-EDIT-FAM-EXEMPT-SW | Switch to leave multi families in SESA ID order in estimation and edit reports, after all singles have been listed ('B' = Split multi's, EDI's and PEO's, 'E' = Split EDI's and multi's, 'M' = Split multi's; 'N' = No splits, 'P' = Split multi's and PEO's) | |
| 79 | 84 | 6 | Num | LKUP-EDIT-MIN-AME | Minimum employment level required to list an account in micro edit report | |
| 85 | 90 | 6 | Num | LKUP-EDIT-MIN-TOTW | Minimum total wages required to list an account in micro edit report (used in combination with minimum employment; only when both employment and wages fall below these cutoff values will an account be skipped from edit report inclusion | |
| 91 | 95 | 5 | Num | LKUP-OLD-ARCH-YEARQ | Oldest year/quarter found in the Micro Archive File (yyyyq format; used in 20D runs) | |
| 96 | 100 | 5 | Num | LKUP-NEW-ARCH-YEARQ | Newest year/quarter found in the Micro Archive File (yyyyq format; used in 20D runs) | |
| 101 | 101 | 1 | Char | LKUP-PLA-COPY-SW | Physical location address copy switch, used to allow the 202 analyst to copy a MOA or UIA to the PLA area of the micro record by typing a '1' in the address type code from the ES2C first or second screen. | |
| 102 | 102 | 1 | Char | LKUP-BOQ-EOL-ACTV-SW | Distinguishes between States that consider an end-of-liability (EOL) date set to the first day of the quarter to be active or inactive for that quarter; 'Y' = Account is active when EOL date is on first day of the quarter | |
| 103 | 106 | 4 | Char | LKUP-EDIT-EST-UI-DIGITS | Area kept in reserve for a collection of U-I digits for estimation and edit report sorting; not yet active, but will eventually be called upon instead of hard-coding U-I digits in sorting mechanisms (currently only applies to California) | |
| 107 | 107 | 1 | Char | LKUP-CQ-BYPASS-SW | Edit processing switch that can allow accounts with non-crucial, current-quarter edits (and no administrative exceptions) to be bypassed from normal listings when a comment code has been assigned for the quarter (Y/N) | |
| 108 | 108 | 1 | Char | LKUP-WAVE2-INCLUDE-SW | Obsolete; this flag denotes whether to include Wave 2 accounts with Wave 1 (Y/N) | |
| 109 | 109 | 1 | Char | LKUP-NEW-SCORE-SW | Not used yet; when implemented, will instruct the system whether to use the new score in both the batch and on-line edits (Y/N) | |
| 110 | 110 | 1 | Char | LKUP-EARS-ADDR-UPDATE | Obsolete: when refiling had its own address, this switch could instruct the system whether to post it automatically and immediately to the Micro File (Y/N) | |
| 111 | 111 | 1 | Char | LKUP-EARS-PHYS-ADDR-VER | Obsolete: when refiling had its own address, this switch would tell the system whether to post the PLA immediately to the Micro File (Y/N) | |
| 112 | 132 | 21 | Char | FILLER | spaces | |
| * * * Refiling Batch Header (BC) Record * * * | ||||||
| 13 | 16 | 4 | Num | LKUP-BC-COUNT | Number of refiling records involved in this batch | |
| 17 | 18 | 2 | Char | LKUP-BC-RESPONSE-STATUS | Common response code used for the records in this refiling batch | |
| 19 | 26 | 8 | Char | LKUP-BC-FIRST-UPDATE-DATE | Creation date for this refiling batch (yyyymmdd format) | |
| 27 | 34 | 8 | Char | LKUP-BC-LAST-UPDATE-DATE | Most recent change date for this batch (yyyymmdd format) | |
| 35 | 132 | 98 | Char | FILLER | spaces | |
| * * * County Code (CC) Record * * * | ||||||
| 13 | 51 | 39 | Char | LKUP-CC-CNTY-NAME | County name | |
| 52 | 56 | 5 | Char | LKUP-CC-QMSA | Quasi-MSA Districting association for this county (if QMSA's are used in the State) | |
| 52 | 54 | 3R | Char | LKUP-CC-QMSA-PFX | Standard prefix to distinguish QMSA's from standard MSA's; value is always 'Q00' for QMSA's | |
| 55 | 56 | 2R | Char | LKUP-CC-QMSA-NUM | Numeric value of this county's QMSA (e.g., for 'Q013', the value is '13') | |
| 57 | 132 | 76 | Char | FILLER | spaces | |
| * * * File Definition (FD) Record * * * | ||||||
| 13 | 28 | 16 | Char | LKUP-FD-NAME | File name | |
| 29 | 35 | 7 | Char | LKUP-FD-ID | File ID | |
| 36 | 43 | 8 | Char | LKUP-FD-OLD-DATE | Date of oldest data on the file (yyyymmdd format; blank if unused) | |
| 36 | 40 | 5R | Char | LKUP-FD-OLD-YEARQ | Oldest data year/qtr on the file (alternative to date; yyyyq format, blank if unused) | |
| 44 | 51 | 8 | Char | LKUP-FD-NEW-DATE | Date of newest data on the file (yyyymmdd format, or blank if unused) | |
| 44 | 48 | 5R | Char | LKUP-FD-NEW-YEARQ | Newest year/qtr of data on the file (alternative to date; yyyyq format; blank if unused) | |
| 52 | 60 | 9 | Num | LKUP-FD-COUNT | Number of records on the file | |
| 61 | 69 | 9 | Char | LKUP-FD-LAST-UPD | Date of last update (dd-mmm-yy format) | |
| 70 | 73 | 4 | Char | LKUP-FD-JOB-ID | Job ID of the last batch job that updated this file (e.g., '103D') | |
| 74 | 75 | 2 | Num | LKUP-FD-KEYL | Field length of the file's record key | |
| 76 | 79 | 4 | Num | LKUP-FD-RECL | Record length for the file | |
| 80 | 132 | 53 | Char | FILLER | spaces | |
| * * * Accounts Group (GR) Record * * * | ||||||
| 13 | 124 | 112 | Char | FILLER | spaces | |
| 125 | 132 | 8 | Num | LKUP-GROUP-COUNT | Number of entries (line items -- SESA ID's or U-I accounts with blank RUN) in group | |
| * * * Micro Lock Switches Record * * * | ||||||
| 13 | 13 | 1 | Char | LKUP-LK-ADMIN | Micro File administrative data lock switch; blank = Unlocked; 'A' = Administrative data locked | |
| 14 | 20 | 7 | Char | LKUP-LK-QTR(1) – (7) | Redefinition of following breakout | |
| 14 | 14 | 1R | Char | LKUP-LK-QTR1 | First Micro File quarter (i.e., future quarter) data lock switch; blank = Unlocked; '1' = Future quarter data locked; Lock fields are redefined as an array, using the naming convention - LKUP-LK-QTR(n) where 'n' is a subscript from 1 to 7 | |
| 15 | 15 | 1R | Char | LKUP-LK-QTR2 | Second ("current") quarter data lock switch; blank = Unlocked; '2' = Current qtr locked | |
| 16 | 16 | 1R | Char | LKUP-LK-QTR3 | Third (i.e., prior) quarter data lock switch for Micro File; blank = Unlocked; '3' = Prior quarter data locked | |
| 17 | 17 | 1R | Char | LKUP-LK-QTR4 | Fourth Micro File quarter data lock switch; blank = Unlocked; '4' = Quarter locked | |
| 18 | 18 | 1R | Char | LKUP-LK-QTR5 | Fifth Micro File quarter data lock switch; blank = Unlocked; '5' = Quarter locked | |
| 19 | 19 | 1R | Char | LKUP-LK-QTR6 | Sixth Micro File quarter data lock switch; blank = Unlocked; '6' = Quarter locked | |
| 20 | 20 | 1R | Char | LKUP-LK-QTR7 | Seventh Micro File quarter data lock switch; blank = Unlocked; '7' = Quarter locked | |
| 21 | 21 | 1 | Char | FILLER | space | |
| 22 | 22 | 1 | Char | LKUP-LK-PLA | Additional administrative data lock for physical location address and geocoding data | |
| 23 | 23 | 1 | Char | LKUP-LK-EARS | Separate lock especially for the EARS Refiling File, used at the end of the refiling year | |
| 24 | 132 | 109 | Char | FILLER | spaces | |
| * * * Micro Edit Distribution (ME) Record * * * | ||||||
| 13 | 15 | 3 | Char | LKUP-ME-USER-ID | Editing user ID (positions 4-6 from CICS sign-on ID) for this range assignment | |
| 16 | 52 | 37 | Char | LKUP-ME-RANGE-BEGIN | Beginning key for range of micro editing keys | |
| 53 | 89 | 37 | Char | LKUP-ME-RANGE-END | Ending key for range of micro editing keys | |
| 90 | 95 | 6 | Char | LKUP-ME-ADD-DATE | Date on which this range was first added to the file (yymmdd format) | |
| 96 | 101 | 6 | Char | LKUP-ME-UPDATE-DATE | Date on which this record was last modified (yymmdd format) | |
| 102 | 132 | 31 | Char | FILLER | spaces | |
| * * * NAICS (NA) record * * * | ||||||
| 13 | 98 | 86 | Char | LKUP-NAICS-DESCR | NAICS code description | |
| 13 | 52 | 40R | Char | LKUP-SHORT-DESC | Shortened industry descriptions used for publications in ES2U via Job 48D; this field is used for 'N2', 'N3', 'N4', and 'N5' types of records. | |
| 99 | 100 | 2 | Char | LKUP-NA-OBSOLETE-YEAR | Code to denote NAICS values that will become obsolete during the next revision; blank if still a current code; '\02' denotes a 2002 NAICS code that is not valid in 2007 (same process for '07' '12' '17' items) | |
| 101 | 106 | 6 | Char | LKUP-NA-NAICS-2002-CODE | 2002-based NAICS code related to this 2007-based NAICS code; several revisions later, it still goes by this name | |
| 107 | 128 | 22 | Char | FILLER | spaces | |
| 129 | 132 | 4 | Char | LKUP-NA-YEAR-ADDED | Revision year for which this NAICS code first became valid; blank = Original 1997 NAICS code; '2002' = Part of the 2002 NAICS revision; '2007' = Added in 2007 NAICS revision; the same is true for '2012' and '2017' | |
| 131 | 132 | 2R | Char | LKUP-N2-END | Ending 2-digit value for a sector range; used solely for 'N2' record type | |
| * * * Program Constants (PK) Record * * * | ||||||
| 13 | 14 | 2 | Char | FILLER | Spaces | |
| 15 | 20 | 6 | Num | LKUP-PK-NUM | Numeric constant used in editing or estimation operations (see Appendix F); some constants don't require six digits, appearing as two-digit values, as shown below | |
| 19 | 20 | 2R | Num | LKUP-PK-NUM2 | Smaller constant using a 2-digit value (identified when PK-NUM is not numeric | |
| 21 | 70 | 50 | Char | LKUP-PK-DESC | General, short description of the editing constant | |
| 71 | 110 | 40 | Char | FILLER | spaces | |
| 111 | 118 | 8 | Char | LKUP-JPID | Identifier of most recent updater of this PK value | |
| 119 | 120 | 2 | Char | LKUP-JPCENT | Century portion of date (should be '20') | |
| 121 | 126 | 6 | Char | LKUP-JPDATE | Date of the last change (yymmdd format) | |
| 127 | 132 | 6 | Char | LKUP-JPTIME | Time of the last change (hhmmss format) | |
* * * Place (PL) Record * * * | ||||||
| 13 | 47 | 35 | Char | LKUP-PLACE-NAME | Name of geographic place associated with place code | |
| 48 | 132 | 85 | Char | FILLER | Spaces | |
Lookup (Table) File Data Set Name: WS.ES202.LOOKUP Service Center DSN: YBUssX.A145.LOOKUP, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2LKUP CICS ID: ES2LKUP (standard); EssLKUP (Service Center; ss=State) The Lookup File presents multiple tables of valid codes, editing constants, etc., for use in data editing, performing estimates, determining state-specific processing, etc. Even though this information is considered auxiliary tabled data, the Lookup File is the most universally used file in the EXPO/EARS environment. Records in this file are maintained through the ES2L screens, which require special authorization for access. Some records may be added or deleted, such as county codes or NAICS codes. Other records require BLS approval for additions, such as new State-specific constants and editing constants. There has been a continual expansion of the Lookup File over the years, as ever more auxiliary data needs have come to light, requiring the addition of more types of records to this file. As a result, there are several portions of the file that are now documented elsewhere, since they form an entirely different branch of data from the original constants noted above. Examples include the batch job parameters, micro editing bookmark records, etc. These records are established or maintained by other programs (usually on-line applications), and are dealt with separately from "standard" Lookup records. | ||||||
Related Links
