06 input geocoding transaction file es2igt
Input Geocoding Transaction File (ES2IGT)
ES2IGT - Length 491 - Revised 11/11/2008
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 2 | 2 | Key | Char | IGT-STATE-FIPS | State FIPS (Federal Information Processing Standards) numeric code |
3 | 7 | 5 | Key | Char | IGT-REF-YEARQ | Reference Year/quarter for geocoding data to follow - used for assignment of quarter-specific fields; yyyyq format |
8 | 22 | 15 | Key | Char | IGT-SESA-ID | Combined U-I account number and reporting unit number (a.k.a. SESA ID) of the establishment with data to follow; redefined below |
8 | 17 | 10R | Key | Char | IGT-ACCT | U-I account number portion of the SESA ID |
18 | 22 | 5R | Key | Char | IGT-RPT-UNIT | Reporting Unit Number (or RUN) portion of the SESA ID |
23 | 57 | 35 | Char | IGT-TRADE-NAME | Trade or Doing-Business-As (DBA) name for this establishment; added with V8.0 | |
58 | 92 | 35 | Char | IGT-LEGAL-NAME | Legal or Corporate name for this establishment; added with V8.0 | |
93 | 100 | 8 | Char | IGT-PLA-DATE-CHANGED | Date when the physical location address (PLA) was last changed (presumably with this IGT update method; replaces initial liability date, which had been provided for reference purposes only (yyyymmdd format) | |
101 | 104 | 4 | Char | IGT-ARS-REFILE-YEAR | Ending year of refiling cycle for which this establishment was most recently solicited | |
105 | 105 | 1 | Char | IGT-MEEI-CODE | Multi-establishment employer indicator for the establishment; added with V8.0 | |
106 | 111 | 6 | Char | IGT-NAICS | North American Industry Classification System code for this employer | |
112 | 112 | 1 | Char | IGT-OWN | Single-digit ownership code of the employer (1, 2, 3, or 5) | |
113 | 115 | 3 | Char | IGT-CNTY | FIPS County Code for designated quarter | |
116 | 121 | 6 | Num | IGT-MONTH3 | Third-month employment in reference quarter | |
122 | 156 | 35 | Char | IGT-PLA-ADDR1 | First line of physical location address (PLA) street address (reformatted by BLS; not to be loaded yet, as reverifications are ongoing; same with other PLA fields) | |
157 | 191 | 35 | Char | IGT-PLA-ADDR2 | Second PLA street address line | |
192 | 221 | 30 | Char | IGT-PLA-CITY | PLA city name (last two characters truncated on transfer into micro data) | |
222 | 223 | 2 | Char | IGT-PLA-STATE | State postal abbreviation | |
224 | 232 | 9 | Char | IGT-PLA-ZIP | Full PLA zip code, broken into components below | |
224 | 228 | 5R | Char | IGT-PLA-ZIP5 | Standard 5-digit zip code | |
229 | 232 | 4R | Char | IGT-PLA-ZIP4 | PLA ZIP+4 extension to zip code | |
233 | 235 | 3 | Char | FILLER | spaces | |
236 | 246 | 11 | Num | IGT-LONGITUDE | Geographic longitude of the establishment (+ddd.ffffff format, where 'ddd' is the integer degree value, and 'ffffff' represents the fractional part of the degrees; sign (sub-defined as IGT-SIGN) is set to negative ('-') for Western Hemisphere, units are millionths of a degree, which equates to an east-west placement supposedly accurate to within ± 1.68099 inches measured at 40° latitude | |
247 | 255 | 9 | Num | IGT-LATITUDE | Geographic latitude of the establishment (dd.ffffff format, with 'dd' representing whole degrees (northern latitude only), and 'ffffff' denotes the fractional portion of the degree; units are millionths of a degree, equating to a north-south location placement to the nearest ±2.18572 inches at 40° latitude | |
256 | 259 | 4 | Char | IGT-MATCH-CODE | Geographic matching code; valid values found in Lookup File | |
260 | 262 | 3 | Char | IGT-LOCATION-CODE | Special geographic location code; valid values found in Lookup File | |
263 | 267 | 5 | Num | IGT-PLACE-CODE | Place code number (originally referred to as the "City code", a community identifier; redefined as IGT-PLACE-CODE-X for non-numeric values; values in Lookup | |
268 | 269 | 2 | Char | IGT-PLACE-CLASS | Sub-classification for place code, originally called the "City Identifier"; values found in Lookup File | |
270 | 284 | 15 | Char | IGT-CENSUS-ID | Merged fields used for geographic positioning by the Census Department, including sub-fields for State, County, Tract, Suffix and Block | |
285 | 288 | 4 | Char | FILLER | spaces | |
289 | 289 | 1 | Char | IGT-ADDR-SOURCE-CODE | Code denoting the source of the physical location address | |
290 | 349 | 60 | Char | IGT-EMAIL-ADDRESS | E-Mail address of the employer | |
350 | 491 | 142 | Char | IGT-ALT-SOURCE-DATA | Group-level alternate source data; broken out below | |
350 | 355 | 6R | Char | IGT-ALT-NAICS | NAICS code derived from an alternative data source | |
356 | 370 | 15R | Char | IGT-ALT-PHONE | Phone number and extension brought in from an external data source; the first ten characters are in aaaxxxssss format (where 'aaa' is the area code, 'xxx' is the exchange and 'ssss' is the suffix; the last five are an optional extension number | |
371 | 380 | 10R | Char | IGT-ALT-FAX-PHONE | Phone number for a facsimile machine at the establishment, drawn from alternate data source; aaaxxxssss format, as delineated above | |
381 | 415 | 35R | Char | IGT-ALT-MOA-ADDRESS1 | Mailing/other address first street address line, extracted from a foreign data source | |
416 | 450 | 35R | Char | IGT-ALT-MOA-ADDRESS2 | Second street address line of externally derived mailing/other address | |
451 | 480 | 30R | Char | IGT-ALT-MOA-CITY | City field of MOA brought in from an alternative data source | |
481 | 482 | 2R | Char | IGT-ALT-MOA-STATE | MOA State code determined by an alternate source of data | |
483 | 487 | 5R | Char | IGT-ALT-MOA-ZIP-5 | First five digits of the alternate-source MOA zip code | |
488 | 491 | 4R | Char | IGT-ALT-MOA-ZIP-4 | ZIP+4 portion of the MOA zip code brought in from alternative data source | |
Input Geocoding Transaction File Data Set Name: WS.ES202.CENCO.GEO.scmmddyy Service Center DSN: YBUssX.A145.CENCO.GEO.scmmddyy, ('ss' = State FIPS code; 'sc' = State Postal abbreviation; 'mmddyy' = Date of IGT transmission) Type of File: Sequential File Layout: ES2IGT The Input Geocoding Transaction (or IGT) File is produced by the BLS National Office by running a state's EQUI data through geocoding software to determine the geographic location of the establishment. The output IGT is made available to the state in a machine-readable format (EUS Direct, CD, etc.), for processing by EXPO Job 35D. In addition to defining longitude, latitude and other geocoding values, this file also represents a standardized notation for the physical address with consistent abbreviations, spacing of words, etc. This represents the standard interface method for applying geocode fields to micro data. As geocoding becomes more globally available, more applications and other systems will likely draw upon these values for further analysis. |
Related Links