06 refiling transactions file earrtrn

Refiling Transactions File (EARRTRN)

EARRTRN - Length 224 - 2/13/2018

​​Columns​ ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	15	15	Key	Char	RTRN-SESA-ID	State Employment Security Agencies (SESA) Identification Number (U-I account number and reporting unit number; broken out as shown below)
1	10	10R	Key	Char	RTRN-ACCT	U-I Account Number
11	15	5R	Key	Num	RTRN-RUN	Reporting Unit Number portion of the SESA ID
16	29	14	Key	Char	RTRN-DATE-TIME	Date and Time-of-Day when the refiling transaction was written to the file
16	23	8R	Key	Num	RTRN-DATE	Date of refiling transaction (yyyymmdd format)
24	29	6R	Key	Num	RTRN-TIME	Time of Day when the refiling transaction took place (hhmmss format)
30	30	1	Key	Char	RTRN-TRANS-TYPE	Type of Transaction; 'A' = Added Refiling record; 'C' = Change to existing Refiling record; 'D' = Deletion of Refiling record
31	38	8		Char	RTRN-USER-ID	CICS Logon ID or Batch Program ID enacting this transaction; when conducted via CICS, the first six positions represent the logon ID of the person making the change, whereas the last two positions denote the CICS transaction in effect at the time; this has values such as 'C3' = Third screen of ES2C; 'RC' = EARC; 'RR' = EARR
39	131	93		Char	RTRN-BEFORE-IMAGE	Refiling File record as it existed before the change, or when the add or delete occurred
39	39	1R		Char	RTRN-BI-CHECK-DIGIT	Rarely used, non-functional check digit field before change
40	43	4R		Char	RTRN-BI-CARS-SEQ-NUM	If included in the CARS refiling processing, this contains the sequential ID number of the CARS batch
44	44	1R		Char	RTRN-BI-WAVE	The "Wave" is supposed to have been the time that the account was picked for processing; however, it has gone by the wayside, and is not used
45	49	5R		Char	FILLER	spaces (Reserved for NAICS code related to revision (was used as NAICS02 in 2007 revision, available for NAICS07 during 2007 revision)
50	55	6R		Char	RTRN-BI-OLD-NAICS	Pre-refiling NAICS code, before change
56	56	1R		Char	RTRN-BI-OLD-OWN	Pre-refiling ownership code, before change
57	59	3R		Char	RTRN-BI-OLD-CNTY	Pre-refiling county code, before change
60	63	4R		Char	RTRN-BI-OLD-ZONE	Pre-refiling sub-county zone or township, before change
64	64	1R		Char	RTRN-BI-OLD-MEEI	Pre-refiling MEEI code, before change
65	76	12R		Char	FILLER	spaces (originally was new SIC and NSTA and old/new auxiliary codes)
77	82	6R		Char	RTRN-BI-NEW-NAICS	Post-refiling NAICS, before change
83	83	1R		Char	RTRN-BI-NEW-OWN	Post-refiling ownership code, before change
84	86	3R		Char	RTRN-BI-NEW-CNTY	Post-refiling county code, before change
87	90	4R		Char	RTRN-BI-NEW-ZONE	Post-refiling sub-county zone or township, before change
91	91	1R		Char	RTRN-BI-NEW-MEEI	Post-refiling MEEI code, before change
92	97	6R		Char	RTRN-BI-AME	Average monthly employment (if numeric), before change
98	98	1R		Char	RTRN-BI-CARRY-OVER-IND	Refiling carry-over indicator, before change
99	102	4R		Char	RTRN-BI-BATCH-NO	Batch identification code denoting the collection of forms containing this account, before change
103	110	8R		Char	RTRN-BI-UPDATE-DATE	Date upon which the account was last modified (yyyymmdd format)
111	112	2R		Char	RTRN-BI-RESP-CODE	Refiling response code for the employer, before change
113	121	9R		Char	RTRN-BI-ERRORS	Set of up to three error codes related to refiling data, before change
113	115	3R		Char	RTRN-BI-ERROR-CODE(1)	First error code assigned to this employer, before change
116	118	3R		Char	RTRN-BI-ERROR-CODE(2)	Second error code for employer, before change
119	121	3R		Char	RTRN-BI-ERROR-CODE(3)	Third error code listed for this establishment, before change
122	123	2R		Char	RTRN-BI-COLLECTION-MODE-IND	Collection mode indicator, used for TRS processing, before change
124	131	8R		Char	RTRN-BI-USER	User ID of last person to make a change to this refiling record, before change
132	224	93		Char	RTRN-AFTER-IMAGE	Refiling File record as it existed after a change was enacted (blank for add or delete)
132	132	1R		Char	RTRN-AI-CHECK-DIGIT	Rarely used, non-functional check digit field after change
133	136	4R		Char	RTRN-AI-CARS-SEQ-NUM	If included in CARS, sequential ID number within the CARS batch
137	137	1R		Char	RTRN-AI-WAVE	Post-refiling wave; an obsolete value
138	142	5R		Char	FILLER	spaces (Reserved for NAICS code related to revision (was used as NAICS02 in 2007 revision, available for NAICS07 during 2007 revision)
143	148	6R		Char	RTRN-AI-OLD-NAICS	Pre-refiling NAICS code, after change
149	149	1R		Char	RTRN-AI-OLD-OWN	Pre-refiling ownership code, after change
150	152	3R		Char	RTRN-AI-OLD-CNTY	Pre-refiling county code, after change
153	156	4R		Char	RTRN-AI-OLD-ZONE	Pre-refiling sub-county zone or township, after change
157	157	1R		Char	RTRN-AI-OLD-MEEI	Pre-refiling MEEI code, after change
158	169	12R		Char	FILLER	spaces (originally was new SIC and NSTA and old/new auxiliary codes)
170	175	6R		Char	RTRN-AI-NEW-NAICS	Post-refiling NAICS, after change
176	176	1R		Char	RTRN-AI-NEW-OWN	Post-refiling ownership code, after change
177	179	3R		Char	RTRN-AI-NEW-CNTY	Post-refiling county code, after change
180	183	4R		Char	RTRN-AI-NEW-ZONE	Post-refiling sub-county zone or township, after change
184	184	1R		Char	RTRN-AI-NEW-MEEI	Post-refiling MEEI code, after change
185	190	6R		Char	RTRN-AI-AME	Average monthly employment (if numeric), after change
191	191	1R		Char	RTRN-AI-CARRY-OVER-IND	Refiling carry-over indicator, after change
192	195	4R		Char	RTRN-AI-BATCH-NO	Batch identification code denoting the collection of forms containing this account, after change
196	203	8R		Char	RTRN-AI-UPDATE-DATE	Date upon which the account was last modified (yyyymmdd format), after change This should be identical to the transaction date, mentioned earlier
204	205	2R		Char	RTRN-AI-RESP-CODE	Refiling response code for the employer, after change
206	214	9R		Char	RTRN-AI-ERRORS	Set of up to three error codes related to refiling data, after change
206	208	3R		Char	RTRN-AI-ERROR-CODE(1)	First error code assigned to this employer, after change
209	211	3R		Char	RTRN-AI-ERROR-CODE(2)	Second error code for employer, after change
212	214	3R		Char	RTRN-AI-ERROR-CODE(3)	Third error code listed for this establishment, after change
215	216	2R		Char	RTRN-AI-COLLECTION-MODE-IND	Collection mode indicator, used for TRS processing, after change
217	224	8R		Char	RTRN-AI-USER	User ID of last person to make a change to this refiling record, after change; this should match the RTRN-USER-ID field mentioned in positions 31-38
Refiling Transaction File Data Set Name:                   WS.ES202.REFILE.TRANS Service Center DSN:           YBUssW.A145.REFILE.TRANS ('ss' = State FIPS code) Type of File:                         VSAM indexed File Layout:                          EARRTRN CICS ID:                               EARRTRN (EssRTRN for Service Center; 'ss' = State Postal Abbr.) ​The Refiling Transaction File is used to gather a complete history of the changes enacted to records found in the Refiling File.  Its actions parallel (though on a smaller scale) the capabilities found in the EXPO Transaction Files (Administrative, Micro Auxiliary, and Quarterly).  On-line changes to refiling data are detailed in these records, as are most batch changes.  The only batch process that does not produce Refiling Transactions currently is the IRT (Input Refiling Transaction) procedure of Job 101D.  These updates are exempted from transaction copying, since the data in the IRT should be recoverable from other sources. EARC provides a significant portion of the on-line transactions in this file, as does EARR.  Probably the most voluminous set of changes stems from the Refiling  Form processing of Jobs 103D and 104D.  These set the response code of all refiled accounts to note how many times the refiling form has been sent to this employer.  Another source of batch changes is the Micro File quarter shift process, which allows refiling updates for multi-family breakouts. ​EARP provides a listing of the contents of the Refiling Transaction records, listing before-and-after images as side-by-side representations.  Restoring a record to its pre-changed value is available as one of the function keys for this transaction.  Such a restoration will generate its own transaction.  An audit trail of some or all of the refiling change history can be generated with Job 116D.  The Refiling Transaction File is used throughout the duration of the refiling cycle.  When the new year's refiling cycle is initiated by creating the new Refiling File, the Refiling Transaction File is purged of all of its contents.  Transactions relating to records no longer on the Refiling File hold no utility once the next refiling year has begun.​ ​ ​ ​ ​ ​

Related Links

• Summary of Differences File (EARSDIF)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home