06 wage file creator matched pairs es2wfcm

© 2019 - State of Utah - Department of Technology Services
Jump to navigation Jump to search

Wage File Creator – Matched Pairs File (ES2WFCM)

ES2WFCM - Length 72 - Revised 2/20/2018

​​Columns

LenKeyTypeCOBOL Field NameDescription & Notes
122 CharWFCM-STATE-FIPSState FIPS (Federal Information Processing Standards) Code (e.g. Alabama = '01')
31210 CharWFCM-PRIOR-QTR-UIPrior Quarter Account Number
13175 CharWFCM-PRIOR-QTR-RUN
Not Used by EXPO; Prior Quarter Reporting Unit Number
182710 CharWFCM-CURR-QTR-UINewer Quarter Account Number
28325 CharWFCM-CURR-QTR-RUNNot Used by EXPO; Newer Quarter Reporting Unit Number
33375 CharWFCM-PRIOR-YRQUsed Only in Header Portion by EXPO; prior year-qtr (yyyyq format)
38425 CharWFCM-CURR-YRQUsed Only in Header Portion by EXPO; newer year-qtr (yyyyq format)
43486 NumWFCM-NUM-EMPLNumber of Employees Involved
496012 CharWFCM-PRIOR-QTR-WAGESNot Used by EXPO; Prior Quarter's Total Wages
617212 CharWFCM-CURR-QTR-WAGESNot Used by EXPO; Newer Quarter's Total Wages

Wage File Creator – Matched Pairs File (optional)

Data Set Name:                   ES2.MATCH.PAIR.FILE

Service Center DSN:           YBUssX.A145.MATCH.PAIR.FILE, ('ss' = State FIPS code)

Type of File:                         Sequential

File Layout:                          ES2WFCM

​This file is an alternative way to get the Potential P/S File using the matched pairs from the LEHD File that is produced at the U-I section; it is only needed for States that have no other way of obtaining the Employee Transfer Transaction File and thereby the Predecessor/Successor Potential File from a State-developed file, which is processed by the 062D job. This file is processed by the 062S job instead, and would be brought directly in as a part of the P/S Potential File load. ​ ​ ​ ​ ​​


Related Links