11 multi worksite family balance processing program es2mi03
Multi-Worksite Family Balance Processing (Program ES2MI03)
Note: The remaining edit codes use a continuation of the edit numbering sequence just described for the micro edits. However, most other codes (from 151 through the 190’s) are not forwarded to the Micro Edit File. Therefore, when the ES2E CICS screen examines edit exceptions, they will only include program ES2MI28’s edits. Because of this, the BLS edit classification codes will be shown, but not the EXPO “G” codes. One of the ES2H screens can show out-of-balance families, which carry records on the Micro Edit File. Eventually predecessor/successor edits may also be visible on another, new CICS screen.
The balancing of multi-worksite families is one of the important aspects of micro-level data editing which is not covered by the standard micro edit program (ES2MI28). This processing is separate from the micro edits since the MI28 edit report format is completely alien to that of the multi-family balance editing. The report is also not as variable as the standard micro edit and integrated edit reports, since there are no sort sequencing options, specialized page breaks, etc. The multi balance report appears in U-I account number sequence to keep all of the multi families together.
Note: A few States sort processing by one or more digits of the U-I account number. Unlike other edit sort parameters (NAICS, county, employment size, error code, etc.), the U-I account digits are still useful within multi-family processing. Even multi-balance edits can use different digits of the account number for a sorting mechan¬ism, whereas worksites will not have identical county, industry, etc., codes univer¬sally applied. In Version 7.0, high-level U-I digit sort parameters will be respected in processing the multi-balance edits. If the sorting is secondary for these digits (not at the front of the sort parameters list), they will be ignored.
The multi balance edits appear in two reports. The first is the balance report itself, showing the families that are out of balance, flagging the particular fields with unacceptable variance between master and summed worksite values, and noting master and worksite detail information that may be needed in the balancing process. The second report is the Warnings Report, which provides notes of unusual family situations, such as an inactive master with active worksites, etc. These will be described later.
Both the out-of-balance errors and the warning messages are associated with 3-digit exception codes that are an extension of the standard micro edit and macro edit exception codes that ended at Code 145. In the conditions that will be described in the next pages, the edit code number will also be listed. These were introduced with Version 5 as part of MicMac design implementation, which sought to provide a unifying set of codes for all types of edit conditions. Even though the multi balancing edits are generally deemed more important than predecessor/successor edits, the BLS numbering scheme actually places multi-balance codes after predecessor/successor codes, which are numbered 151 through 163. The multi balance edits are numbered 171 through 184. Edits are listed here in the order of the first batch Job ID that calls the associated program (i.e., Job 001D for micro edits, Job 003D for multi-balance edits, Job 015D for predecessor/successor edits, and Job 061D for wage sum¬mary edits). This is also the sequence prescribed by BLS in the newer A-B-C list structure.
Related Links
