List of All WIN-202 Reports with Examples
Below is a list of all the reports on the WIN-202 System. There are 106 Reports on the system. Examples are provided below when confidentiality is not an issue. Click the "Report Title" to open the example in Microsoft Word format. The reports in the following table are listed in the same order as they appear on the WIN-202 System sorted by "Report Group". Click on a hyperlink below to jump to the group listing.
| Report Group | Report Title | Variables | Description | Output |
|---|---|---|---|---|
| City | Quarter by City by Ownership by Sector Report | Year, Quarter, Disclosable | A quarterly report provides sector data by ownership within a given city | Cityxoxsect-q-yyyy.userid |
| Cluster | Quarterly Industry Cluster by City | Year, Quarter | A quarterly report providing employment and wages by city grouped into the NAICS industry clusters developed by Pennsylvania | qtr-CIT-yyyy-qconfid-form-CLUSTER.txt qtr-CIT-yyyy-q-confid-unform-CLUSTER.txt qtr-CIT-yyyy-q-public-form-CLUSTER.txt qtr-CIT-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by County | Year, Quarter | A quarterly report providing employment and wages by county grouped into the NAICS industry clusters developed by Pennsylvania | qtr-CTY-yyyy-qconfid-form-CLUSTER.txt qtr-CTY-yyyy-q-confid-unform-CLUSTER.txt qtr-CTY-yyyy-q-public-form-CLUSTER.txt qtr-CTY-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by LMA | Year, Quarter | A quarterly report providing employment and wages by LMA grouped into the NAICS industry clusters developed by Pennsylvania | qtr-LMA-yyyy-qconfid-form-CLUSTER.txt qtr-LMA-yyyy-q-confid-unform-CLUSTER.txt qtr-LMA-yyyy-q-public-form-CLUSTER.txt qtr-LMA-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by MSA | Year, Quarter | A quarterly report providing employment and wages by MSA grouped into the NAICS industry clusters developed by Pennsylvania | qtr-MSA-yyyy-qconfid-form-CLUSTER.txt qtr-MSA-yyyy-q-confid-unform-CLUSTER.txt qtr-MSA-yyyy-q-public-form-CLUSTER.txt qtr-MSA-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by Residence | Year, Quarter | A quarterly report providing employment and wages by residence grouped into the NAICS industry clusters developed by Pennsylvania | qtr-RES-yyyy-qconfid-form-CLUSTER.txt qtr-RES-yyyy-q-confid-unform-CLUSTER.txt qtr-RES-yyyy-q-public-form-CLUSTER.txt qtr-RES-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by Statewide | Year, Quarter | A quarterly report providing employment and wages by Statewide grouped into the NAICS industry clusters developed by Pennsylvania | qtr-STW-yyyy-qconfid-form-CLUSTER.txt qtr-STW-yyyy-q-confid-unform-CLUSTER.txt qtr-STW-yyyy-q-public-form-CLUSTER.txt qtr-STW-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by WIA | Year, Quarter | A quarterly report providing employment and wages by WIA grouped into the NAICS industry clusters developed by Pennsylvania | qtr-WIA-yyyy-qconfid-form-CLUSTER.txt qtr-WIA-yyyy-q-confid-unform-CLUSTER.txt qtr-WIA-yyyy-q-public-form-CLUSTER.txt qtr-WIA-yyyy-q-public-unform-CLUSTER.txt |
| Cluster | Quarterly Industry Cluster by Zone | Year, Quarter | A quarterly report providing employment and wages by zone grouped into the NAICS industry clusters developed by Pennsylvania | qtr-ZON-yyyy-qconfid-form-CLUSTER.txt qtr-ZON-yyyy-q-confid-unform-CLUSTER.txt qtr-ZON-yyyy-q-public-form-CLUSTER.txt qtr-ZON-yyyy-q-public-unform-CLUSTER.txt |
| County | 15 Month Listing - Statewide | Year, Quarter | 15 month individual firm Listing used for CES benchmark | mth15xctyyyyyq.userid |
| Custom | Annual Employment and Wage Summary (Custom report) | Custom parameters | Annual employment and wage report using either geographic area, LMA, size, ownership, etc. | NcrAppppppppp.userid **p represents a customized report parameter. |
| Custom | Custom Quarterly Employment and Wage | Custom parameters | Quarterly employment and wage report using geographic area, LMA, size, ownership, etc. | NcrQppppppppp.userid **p represents a customized report parameter. |
| Edit Listing | Admin Edit Listing by County | None | Sorts the Admin error listing by county | adminctyeditmmdd.ot |
| Edit Listing | Admin Edit Listing by Error | None | Sorts the Admin error listing by error number | adminerreditmmdd.ot |
| Edit Listing | EIN Listing | None | Lists accounts with invalid Employer Identification Numbers (EIN) | einlstmmdd.ot |
| Edit Listing | Identical Monthly Employment | None | Lists accounts with the same monthly employment for all three months of a quarter | identmoempmmdd.ot |
| Edit Listing | Integrated NAICS Edit Listing | None | Listing of all macro errors, showing any quarterly or admin errors for each macro cell | intedmmdd.userid |
| Edit Listing | Long Integrated NAICS Edit Listing | None | Listing of all macro errors for the selected year/quarter up to 5 quarters. Shows any quarterly or admin errors for each macro cell. | Int2editlongmmdd.userid |
| Edit Listing | Macro Error (NAICS) Edit Listing | None | Macro errors for the current quarter, also showing up to five quarters prior | macro2-errmmdd.userid |
| Edit Listing | Micro Error Report for Multis (Short) | Year, Quarter | Micro errors for multi-site employers, including quarterly data for current quarter only. It produces two reports, EDI & Non-EDI, for ‘M’ type errors only {171 — 184} which relate to unbalanced accounts. | Micromerrs-EDIyyyyq, micromerrs-EDIyyyyq |
| Edit Listing | Micro Error Report for Multis (Long) | None | Micro errors for multi-site employers, including admin data as well as quarterly data for current and prior quarter for all units. Two reports, EDI & Non-EDI. | micromerrl-EDIyyyyq, micromerrl-EDIyyyyq |
| Edit Listing | Micro Error Report—Singles by County | None | Lists micro-error file errors and quarterly data for single site employers in error code order within county | microscty-yyyyq.userid |
| Edit Listing | Micro Error Report Singles by UI | None | List micro-error file errors and quarterly data for single site employers in UI order | microsur-yyyyq.userid |
| Edit Listing | Minimalist Edit by County (Singles) | None | List of UI#, RUN, size, comment codes and error codes. Two separate reports, one for singles (sngl) and one for multis (mlt) in county order. | Minedctysglmmdd.userid AND minedctymltmmdd.userid |
| Edit Listing | Minimalist Edit by Error | None | List of UI#, RUN, size, comment codes and error codes. Two separate reports, one for singles (sngl) and one for multis (mlt) in UI# order. | Minederrsglmmdd.userid AND minederrmltmmdd.userid |
| Edit Listing | QTR Edit Listing | None | Quarterly micro errors listed by unum, rnum within error level. Summary shows number of occurrences of each error. | Lvl16edmmdd.ot, lvl79edmmdd.ot, summarymmdd.ot |
| Edit Listing | Scoring Edit Listing | None | Lists UI accounts scored by magnitude of error and error code—descending order within county. The UI # is only listed 1x per yr/qtr with highest score. | Scored-ctymmdd.userid scored- errmmdd.userid |
| File | 7 Quarter History File - WIN202 | Year, Quarter | Dumps the seven most recent quarters; including future quarters. | Micfile.ot |
| File | 7 Quarter History File – EXPO Format | None | Dumps the seven most recent quarters, including future quarters in the EXPO format | micro-expo.txt |
| File | Annual Regional DA - County | Year, NAICS level | Unformatted annual file by county for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-CTY#-yyyy.txt |
| File | Annual Regional DA – Residence | Year, NAICS level | Unformatted annual file by residence for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-RES#-yyyy.txt |
| File | Annual Regional DA – Zone | Year, NAICS level | Unformatted annual file by zone for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-ZON#-yyyy.txt |
| File | CIPSEA Short File | Year, Quarter, Ownership, Geography, NAICS level | Unformatted user defined CIPSEA protected micro data file | shortfile-yyyyq### |
| File | Daily Administrative Transactions | None | Lists all transactions that occurred on the admin table for a specified date. Use the Auto Reports Setup Menu to run automatically or run via Create Process on the Administrative screen. | WIN202-BES_ES2_ADM- TRANS.txt |
| File | Daily Quarterly Transactions | None | Lists all transactions that occurred on the quarterly table for a specified date. Use the Auto Reports Setup Menu to run automatically or run via Create Process on the Administrative screen. | WIN202_BES_ES2_QTR- TRANS.txt |
| File | Delinquent Accounts Report Unformatted | Year, Quarter | Creates a file of delinquent employers (180 characters per record) for states to generate missing employment notices | Delquempyyq.ot |
| File | EQUI (1060) CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open records in the 1060 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-1060-CIPSEA- restricted-YYQ |
| File | EQUI (1060) Data Share PEO Supressed | Year, Quarter | Creates an EQUI File of open records in the 1060 format, which includes data that can be shared (ie does not include CIPSEA restricted data). Certain fields are blanked out for subunits of PEOs. | equi-1060-CIPSEA- restricted-YYQ |
| File | EQUI (1060) Data Sharing | Year, Quarter | Creates an EQUI File of open records in the 1060 format, which includes data that can be shared (ie does not include CIPSEA restricted data) | equi-1060-data- sharing-YYQ |
| File | EQUI (1060) O/C CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open & closed records in the 1060 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-1060-oc-CIPSEA- restricted-YYQ |
| File | EQUI (1060) O/C Data Sharing | Year, Quarter | Creates an EQUI File of open & closed records in the 1060 format, which includes data that can be shared (ie does not include CIPSEA restricted data) | equi-1060-oc-data- sharing-YYQ |
| File | EQUI (1166) CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open records in the 1166 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-1166-CIPSEA- restricted-YYQ |
| File | EQUI (1166) O/C CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open records & closed in the 1166 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-1166-oc-CIPSEA- restricted-YYQ |
| File | EQUI (724) CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open records in the 724 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-724-CIPSEA- restricted-YYQ |
| File | EQUI (724) O/C CIPSEA Restricted | Year, Quarter | Creates an EQUI File of open & closed records in the 724 format, which includes CIPSEA restricted data (ie data marked as ‘A’) | equi-1166-oc-CIPSEA- restricted-YYQ |
| File | Macro Deliverable | Year, Quarter | Produces three files—one summary file and two files with records for each ownership total and NAICS by town or county. | TOWN-MACRO-yyq.txt BEA-MACROTRANS-yyq.txt BEA-MACRO-yyq.txt |
| File | Macro File (Cty/NAICS) | Year, Quarter | EXPO version of macro file | WIN202_BES_ES2_MACRO.txt |
| File | MLS Establishment Reports | Year, Quarter | Input file for the Mass Layoff Statistics Program | est202-20yyyyq.txt est202a-20yyyyq.txt |
| File | NY Apparel File | None | File for Labor Standards Apparel Firms | Apparel.txt |
| File | NY MWR Master Delinquency File | Year, Quarter | File listing private ownership master records with no reported employment | Mwrmast-del.txt |
| File | NY MWR No Answer File | None | Data Extract for UI Database MWR Update | Mwrna.txt |
| File | Quarterly Regional DA – County | Year, Quarter, NAICS | Unformatted quarterly file by county for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-CTY#-yyyyQ#.txt |
| File | Quarterly Regional DA – Residence | Year, Quarter, NAICS | Unformatted quarterly file by residence for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-RES#-yyyyQ#.txt |
| File | Quarterly Regional DA - Zone | Year, Quarter, NAICS | Unformatted quarterly file by zone for Regional Data Analysis Tool (RDAT) MS Access database | RDTA-ZON#-yyyyQ#.txt |
| File | Quarterly MLS/LLD | Year, Quarter | input file used to load to the system | admin-mls.d qtrly-mls.d |
| Forms | ARCS Forms (Mailing) VS, VM | Year, Parm Value 19 (1 = central printing) | Creates refiling forms with commands for the Xerox printer using address priority of Mail/Tax/Physical | vs-trs-tp1, vmtp1, vstp1 and noadmin.txt |
| Forms | ARCS Forms (Tax) VS, VM | Year, Parm Value 19 (1 = central printing) | Creates refiling forms with commands for the Xerox printer using address priority of Tax/Mail/Physical | vs-trs-tp1, vmtp1, vstp1 and noadmin.txt |
| Forms | CA Forms | Year, Quarter | Creates multiple worksite reports with commands for the Xerox printer | catp1, sfnca-smrmmddyy, sfncammddyy.ot, **sf is state FIPS code |
| Listing | 46F NAICS Report | Year, Quarter | An 8 quarter summary of employment and wages at the 2 digit sector level by ownership | 46F23yyyyq.txt |
| Listing | Annual Avg > 1000 | Year | A list of employers with annual average employment > 1000 | annual_avg_emp_1000.userid |
| Listing | Annual Code Validation | Year | A list of all invalid or unknown codes per UNUM, RUN & quarter for the selected year. | code-validation-yyyy.txt |
| Listing | Annual High > 1000 | Year | A list of employers with highest months employment > 1000 | annual_high_month_emp_ 1000.userid |
| Listing | ARCS Management Report | Year | Summary Report for filing with the regional office. Includes ARS responses broken down by size and response type. | Arcsummmdd.ot |
| Listing | ARCS Nonrespondents by Size | Year | A list of nonrespondents by size with employer name, unum, rnum and phone number. | Nonrspxszmmdd.ot |
| Listing | CES Reports | None | CES reports: Gets the most current month/year from the CES table and calculates 13 months prior and outputs the data in lma order, in alpha order. | ces-lma-alphayymm.userid ces-lma-sicyymm.userid ces-Cty-SICyymm.userid |
| Listing | Control File Listing for Non-Respondents | Year | List the counts of individual CMI (Collection Mode Indicators) for non respondents. Includes counts for TRS-NVS, Non-TRS-NVS and NVM forms. | trs-listing-yyyy |
| Listing | Data Counts Listing | Year, Quarter | Lists numbers and percents of units and employment by various categories of interest | dcountsyymm.userid |
| Listing | Delinquent Accounts Report Formatted | Year, Quarter | Creates a listing of delinquent employers. | Delqu2empyyq.userid |
| Listing | Employers w/Qtr AME > 1000 | Year, Quarter | Report of employers with a quarter average monthly employment greater than 1000 | Emplgmmdd.userid |
| Listing | Macro Comment Listing | Year, Quarter | List of macro comment codes for the selected year and quarter | Macrocomyyq.userid |
| Listing | Macro NAICS Comment Listing | Year, Quarter | List of macro NAICS comment codes for the selected year and quarter | Macnaicscomyyq.userid |
| Listing | Multi Delinquency Report | Year, Quarter | List of multi accounts whose subunits are all delinquent | Multidelrptyyq.userid |
| Listing | Multi Site Employers - Short List | Year, Quarter, Disclosable | List of multi employers with their quarterly data for the current quarter | MultiShort-yyyyq.userid |
| Listing | Multi-Site Employers -Long List | Year, Quarter | List of multi employers with quarterly information for current and prior quarters for all subunits (active, closed, and pending) | MultiLong-yyyyq.userid |
| Listing | Multiple Worksite Listing | Year, Quarter | List UI accounts for which MWR forms are printed | Multiwksiteyyq.userid |
| Listing | NAICS 9's by M3 Emp | Year, Quarter | Lists NAICS 9 accounts by M3emp for a specific yr/qtr | naics9m3-yyyyq.userid |
| Listing | NAICS 9's by UI | Year, Quarter | Lists NAICS 9 accounts by UI # for a specific year/quarter | naics9ui-yyyyq.userid |
| Listing | NAX Management Report | Year | Report summary of usable, other and total response rates | Naxsummmdd.ot and Naxmangmtmmddyyyy.ot |
| Listing | Output Parm Listing | Year, Quarter | List of parameter values and descriptions, showing BLS standard and state values | Parmlist.ot |
| Listing | QTR Profile Report Listing | Year, Quarter | Compares average monthly employment for current quarter and previous quarter to data from one year ago. Listing is by 3 digit SIC and ownership. | Qtrprofileyyq.userid |
| Listing | QTR Records w/no Admin | Year, Quarter | List of accounts with a Quarterly record and no Admin record. | Noadminyyyyq.userid |
| Listing | Quarterly Code Validation | Year, Quarter | A list of all invalid or unknown codes per UNUM, RUN & year/quarter for the selected quarter. | code-validation-yyyy-q |
| Listing | Receiving MWR Form Listing | Year, Quarter | Lists accounts receiving MWR forms | Mwr-rptyyyyq.userid |
| Listing | Subset EQUI Listing | None | Lists the UI, RUN, Year, Quarter, and Subset Indicator for the records ‘marked’ for the Subset EQUI | Subset-equi-listing-mmddyyyy |
| Listing | Top 100 by County (Annual) | Year | A list of the top 100 employers by county based on AME | top100xCTY_yyyy.userid |
| Listing | Top 100 by LMA (Annual) | Year | A list of the top 100 employers by LMA based on AME | top100xLMA_yyyy.userid |
| Listing | Top 100 by WIA (Annual) | Year | A list of the top 100 employers by WIA based on AME | top100xWIA_yyyy.userid |
| Listing | Top 100 Statewide (Annual) | Year | A list of the top 100 employers Statewide based on AME | top100xSTA_yyyy.userid |
| Listing | Top 20 Employers by CTY | Year, Quarter | top 20 employers list by county | top20xcty.txt |
| Listing | Undeliverable ARS Forms Report | Year | Lists control file records with response code 63 indicating returned mail | Undeliverable-yyyy.txt |
| LQ | LQ Report vs. Nation | Year, Quarter, NAICS | Creates location quotient report comparing state data to national data. Note: This report uses the shareware utility pkunzip and the ftp command native to windows DOS. The WIN-202 server must have access to the ftp TCP/IP port in order to run this report | national-lq-yyq-#digit-public.txt national-lq-yyq-#digit.txt |
| Macro | Macro Rollup Report | Year, Quarter | Report containing 4 quarters of employment, average monthly employment, total wages and average quarterly wage by ownership, division and SIC | Macro-rollup1yyyyq.txt |
| NAICS | 15 Month NAICS – CTY | Year, Quarter | 15 month listing of employment by county for NAICS | Mth15xctyyyyyq.userid |
| NAICS | 15 Month NAICS – LMA | Year, Quarter | 15 month listing of employment by LMA for NAICS | Mth15xlmayyyyyq.userid |
| NAICS | 15 Month NAICS – MSA | Year, Quarter | 15 month listing of employment by MSA for NAICS | Mth15xmsayyyyq.userid |
| NAICS | 15 Month NAICS – STW | Year, Quarter | 15 month listing of Statewide employment for NAICS | Mth15xstayyyyq.userid |
| NAICS | NAICS Publications | Year, Quarter | Select one or more statewide, county, residence, zone, LMA, MSA, and/or WIA covered employment and wage reports customizable by sector, 3, 4, 5, and 6-digit level NAICS codes. By Area/Ownership | Up to 21 outputs can be generated. 5 geographies with 4 outputs each plus the Almis 2.2 file. |
| Size | Quarterly Ownership by Size Report | Year, Quarter | Report of employment and wages by size class by ownership | Sizeqyyq.userid |
| Size | Quarter Size Class by County | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and county. | employees-by-size-by-ctyyyy-q |
| Size | QTR Size Class by LMA | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and LMA | employees-by-size-by-lmayyyy-q |
| Size | QTR Size Class by MSA | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and MSA | employees-by-size-by-msayyyy-q |
| Size | QTR Size Class by Residence | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and residence | employees-by-size-by-resyyyy-q |
| Size | QTR Size Class by WIA | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and WIA | employees-by-size-by-wiayyyy-q |
| Size | QTR Size Class by Zone | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code and zone | employees-by-size-by-zonyyyy-q |
| Size | QTR Size Class by Statewide | Year, Quarter, Disclosable | List of employment per NAICS by size (i.e. 0-4) for each ownership code | employees-by-size-by-stayyyy-q |
| Statewide | 15 Month Listing - STW | Year, Quarter | 15 month listing of employment by firm | mth15xstwyyyyq.userid |
