06 input refiling transaction irt file earirt

Input Refiling Transaction (IRT) File (EARIRT)

EARIRT - Length 295 - Revised 8/19/2002

​Columns​ ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	15	15	Key	Char	IRT-SESA-ID	Employer SESA ID (U-I account plus reporting unit number)
1	10	10R	Key	Char	IRT-ACCT	U-I account portion of SESA ID
11	15	5R	Key	Num	IRT-RPT-UNITX	Reporting Unit Number (RUN) portion of SESA ID
16	16	1		Char	IRT-CHECK-DIGIT	Optional check digit
17	20	4		Char	FILLER	spaces (formerly pre-refiling SIC code)
21	26	6		Char	IRT-OLD-NSTA	Pre-refiling SIC-based NAICS code
27	32	6		Char	IRT-OLD-NAICS	Pre-refiling NAICS code
33	33	1		Char	IRT-OLD-OWN	Pre-refiling ownership code
34	36	3		Char	IRT-OLD-CNTY	Pre-refiling FIPS county code
37	40	4		Char	IRT-OLD-ZONE	Pre-refiling sub-county zone or New England township code
37	39	3R		Char	IRT-OLD-TOWN	Pre-refiling sub-county township code
41	41	1		Char	IRT-OLD-AUX	Pre-refiling auxiliary code – obsolete
42	45	4		Char	FILLER	spaces
46	51	6		Char	IRT-NEW-NSTA	Post-refiling SIC-based NAICS code – obsolete
52	57	6		Char	IRT-NEW-NAICS	Post-refiling NAICS code
58	58	1		Char	IRT-NEW-OWN	Post-refiling ownership code
59	61	3		Char	IRT-NEW-CNTY	Post-refiling FIPS county code
62	65	4		Char	IRT-NEW-ZONE	Post-refiling sub-county zone or New England township code
62	64	3R		Char	IRT-NEW-TOWN	Post-refiling township code
66	66	1		Char	IRT-NEW-AUX	Revised auxiliary code, if affected by refiling
67	101	35		Char	IRT-ADDR1	First street address line of physical address
102	136	35		Char	IRT-ADDR2	Second line of physical street address
137	166	30		Char	IRT-CITY	Physical address city
167	168	2		Char	IRT-STATE	Physical address state code
169	177	9		Char	IRT-ZIP-CODE	Full 9-digit zip code for physical address, subdivided below
169	173	5R		Char	IRT-ZIP-5	Physical address 5-digit zip code
174	177	4R		Char	IRT-ZIP-4	Physical address ZIP+4 extension
178	178	1		Char	IRT-CHGIND-ADD	Flag denoting change characteristics of the physical address block; 'N' = Not correct address, 'P' = Physical address change pending, 'S' = System-updated address, 'V' = Physical address has been verified; No Longer Used
179	179	1		Char	IRT-NEW-MEEI	Post-refiling MEEI code; '1' = Single, '2' = Master, '3' = Worksite, '4' = Known multi refusal, '5' = Composite worksite, '6' = Low-employment multi kept single
180	185	6		Char	IRT-AME	Average monthly employment
186	186	1		Char	IRT-OLD-MEEI	Original MEEI code (same values as shown above)
187	187	1		Char	IRT-CARRY-OVER-IND	Flag showing carry-over status from last year's refiling, '1' = Not a carry-over acct, '2' = Carried-over non-respondent last year, '3' = Carried over with late-response, received this year, '4' = Carried-over with late response received last year
188	191	4		Char	IRT-BATCH-NO	Batch ID showing grouped returned forms
192	199	8		Char	IRT-UPDATE-DATE	Most recent change date (yyyymmdd format); Not used in batch refiling updates.
200	207	8		Char	IRT-USABLE-RESP-DATE	Date on which a refiling response could be considered complete (yyyymmdd format)    No longer used
208	209	2		Char	IRT-RESP-CODE	Refiling response code; '00' = Form mailable, not sent, '01' = Form mailed once, '02' = Form mailed twice, '03' = Form mailed thrice, '11' = Clean worksite record in a mailable family, '12' = Clean record in non-mailable family (other worksite with errors), '30' = Responded but has "I" errors, '31' = Not reviewed, pending, '41' = Reviewed, no CCS change exists, '42' = Misunderstood industry description, '46' =  Clean record with CCS change, '50' = Code change from external source, '63' = Returned by USPS, '64' = Out of business, '65' = Refused to respond, '98' = Carry- over nonrespondent, probably out of business, '99' = Unmailable due to errors
210	211	2		Char	IRT-ERR-STAT	Error processing status, from edit, mailing, general and CCS errors.  No longer used
212	213	2		Char	FILLER	spaces
214	219	6		Char	IRT-DEC-EMPL	December employment during the refiling year; No longer used
220	230	11		Char	IRT-QTR4-WAGES	Fourth quarter total wages; No longer used
231	236	6		Char	IRT-JAN-EMPL	January employment; No longer used
237	242	6		Char	IRT-FEB-EMPL	February employment; No longer used
243	248	6		Char	IRT-MAR-EMPL	March employment; No longer used
249	259	11		Char	IRT-QTR1-WAGES	First calendar quarter total wages; No longer used
260	260	1		Char	IRT-SALES-RCPT-IND	Sales/receipts indicator; not presently in use; Not used
261	295	35		Char	IRT-STATE-USAGE	Free-form state-specific data; No longer used
​​​​​Input Refiling Transaction File Data Set Name:                   EAR.REFILING.TRANS.FILE Service Center DSN:           YBUssX.A145.REFILING.TRANS.FILE ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          EARIRT The Input Refiling Transaction (or IRT) File is the functional equivalent of the EXPO IMT File.  It is created by a state-specific data extraction program that draws information pertinent to the refiling cycle from state source files.  These can include tax file data, Micro File data and any other source files that provide useful information about changes to NAICS codes, counties, sub-county zones or townships, etc.  In addition, data may be brought forth for address changes to records already present on the Refiling File. The IRT records contain only the information needed to update the corresponding record on the Refiling File.  All other fields are set to low-values (binary zeroes) to signify that the field should remain unchanged in the Refiling File.  Should the IRT record not have a match on the Refiling File, a new record will be written, filling in whatever information has been supplied, and setting default values for any remaining fields.  If the record is present on the Micro File, that data may be relied upon heavily to fill in missing elements. The DSN shown above is the original IRT File.  The records are sorted by SESA ID before processing the data in the EARRF01 program, which reads a sequential copy of the Refiling File and writes out a second sequential file with the updated data prepared from the IRT merger.  The new sequential file is used to rebuild the VSAM Refiling File.  At this point, the IRT File has completed its task, so it can be deleted.  However, this deletion is not performed automatically by the EARS system.  The reasoning is that this is a State-developed file that may be utilized elsewhere for another auxiliary purpose. Note:  At one time, the IRT File used the exact same format as that of the Refiling File.  Yet, the IRT does not continue to mimic EARREF (shown later), because such changes require adjustments to State-specific extract programs that prepare the IRT.  Fields that have been appended to the Refiling File format (such as error codes), are inaccessible to the IRT.​ ​ ​ ​ ​ ​

Related Links

• EARS Job Parameters File (Lookup File Subset) (EARJPRM)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home