04 job es2j013d transfer ears changes micro file
Job ES2J013D - Transfer EARS Changes to Micro File
RUN THIS JOB - As required.
This job executes the following programs (click to link to each program description):
Job Features and Functions
- For refiling records with a response code of 46 or 50, the following new codes are copied from the Refiling File to the Micro File: NAICS, county, zone, ownership and MEEI
- Response codes are copied to micro file for all refiling records regardless of code
- Verify year is only copied for records with response code 41, 42, 46, and 50
- Refile year is copied to the Micro File for all Refiling File records regardless of response code
- Batch number is copied to the Micro File for all refiling records
- It corresponds to the refile year
- If batch number is blank on the Refiling File, a space is move to the Micro File
- Old code fields are copied to old code fields in the Micro File (see third ES2C screen for old codes on the Micro File)
- Physical address is optionally copied to the Micro File - determined by parameter in ES2N
- Transaction records are created for all micro records updated by this job
- Updates Micro File with code changes when first calendar quarter is in future, present, or immediate prior quarter position in Micro File
- Performs refiling edits found in Job 102D and prints exception report
- Checks current Micro File status of refiling records and posts a response code of 64 to inactive records that have a posted response code less than 41
- Posts a comment code of 81 to those records with a non-economic code change.
- A safeguard exists in this job to prevent running too early or too late in the refiling year
- Reference to the refiling year, now stored in the Lookup File
- Prevents the job from posting new codes and other refiling data for the wrong refiling year
Job 013D transfers new codes, physical addresses refiling year, verify year, batch number, and response codes in the current Refiling File to the Micro File. It eliminates the need for duplicate data entry of changes already entered in the EARS Refiling File. The transfer of these changes to the Micro File also builds Quarterly Transaction File records, which can be used as an audit trail and to update to the Tax File, if the State chooses to do so.
This job will also post a comment code of ‘81’ to those records with a non-economic code change. A refiling year, stored in the Lookup File, blocks attempted code change transfers to the Micro File that are too early or too late. The refiling year must correspond to the quarters on the Micro File. The refiling edit program (used in Job 102D) is also performed by this job. The physical address transfer is a parameter option in this job.
This job can be run on demand during the refiling cycle. It is highly recommended for a State to run this update, to insure all refiling changes have been transferred to the Micro File. Since the first quarter EQUI is created from the Micro File, it is very important Job 013D be run before the first quarter EQUI is submitted.
Since the EQUI is the only BLS deliverable, and all EQUI data comes from the Micro File, Refiling File data should be written to the Micro File, one way or another, prior to the EQUI submittal for the first calendar year quarter. If, however, a late entry is made to the current year Refiling File, it can still be copied to the Micro File with 013D as long as the first calendar quarter is not older than the immediate prior quarter in the Micro File. Therefore, if code changes are made in the Refiling File, after the cleanup of the 1st calendar quarter, 013D can still be run to bring those changes to the Micro File for inclusion in the second quarter EQUI with a revision to first quarter. After the 1st calendar quarter has been shifted into a quarter on the Micro File that is older than the immediate prior quarter, 013D will no longer transfer the code changes to the Micro File. It is assumed that the next years refiling would be under way by that time. Late refilling updates can also be made on-line directly to the Micro File, eliminating the need to run Job 013D for just a few late entries.
This job updates the Micro File with new physical addresses from the EARS Refiling File regardless of the quarter position of the Micro File. On the other hand, code changes can only update the Micro File for the first calendar quarter of the new year, because they are considered non-economic. If the Micro File has not been shifted to the point where the first calendar quarter of the year is in either the future, current, or immediately prior quarter position, the code changes will not come across from the Refiling File. If the first quarter is in the current, future or immediate prior quarter position on the micro file, code changes will be copied to the Micro File for Refiling File records with a response code of 46 or 50. A mid-year code change can pass through this batch job anytime, if the old code is unclassified.
Economic code changes to the Micro File occurring during the calendar year must be made on-line in ES2C or in ES2V for multi sub-units. If, at the time of the job run, the first calendar quarter is in the prior quarter position, the changes are applied to the prior, current, and future quarter. If the first calendar quarter is in the current quarter position of the Micro File, the changes from the EARS Refiling File are applied to both the current and future quarter. If the first calendar quarter is in the future quarter position of the Micro File, the changes from the Refiling File are applied only to the future quarter. Micro File update reports are generated with this job.
Prior to transferring refilling data to the Micro File, Job 013D performs the refilling edits found in Job 102D and prints an exception report. The Job also checks current micro file status of refilling records and posts a response code of 64 to inactive records that have an existing response code less than 41. The new response code of 64 is copied into the Micro File.
Users need not depend completely on Job 013D to transfer code changes and address changes from the Refiling File to the Micro File. The EARC Refiling File maintenance screen may also update the Micro File simultaneous with updates to the Refiling File. For instance, new NAICS and county codes are simultaneously updated to both files if the previous value was unclassified, i.e., 9999. In addition, lines 16 and 17 in the State-specific constants table of the EARS lookup file allow physical address changes and county and NAICS code changes to simultaneously be written to both the Refiling and Micro files (first quarter only for code changes).
Job 013D will not add records to the Micro File. A record must first exist on the Micro File before this job will perform an update to the Micro File.
Related Links
