Home → Contents → Introduction → Data Entry Screens → Screens → Quarterly Processing → Lookup Tables → Administrative → Reports → Server Information → Appendices
Chapter 7: Reports
Click the [Reports] button on the "Main Menu" screen to access the "Reports" screen. The three selection tabs available are Reports, Auto Reports and Report Parameters.
Reports Tab
The "Reports" tab displays a selection list of the following reports: 1 city, 8 cluster, 1 county, 2 custom, 15 edit listings, 28 file creations, 3 forms, 32 listings, 1 location quotient (LQ), 1 macro, 5 NAICS, 8 size groups, and 1 statewide.
In the "Sort By" section you have a choice of sorting alphabetically by report-group or report title depending on your viewing preference.
Running a Report
To run a report:
- Click on a report in the browser to highlight it. Use the [Page Up] and [Page Down] buttons or the [↑] and [↓] arrows on your keyboard to scroll through the browser until you find the report you want.
- Input the desired report parameters. Click the [Run Selected Report]. A dialog box displays your report choice asking whether to continue. If the information is correct, click [Yes] to run the report otherwise, click [No] to cancel the job.
- Click [Exit] to return to the "Main Menu" screen.
All reports are written to the reports directory on your server and their output file names are listed in the WIN-202 Reports table following this section. Many file names contain "yyyy", "q" and "userid". These are simply general designations for year, quarter and user—specific substitutions are made when reports are run. A list of All WIN-202 Reports with Examples is provided on the last page of this chapter.
Custom Report Screen
Within the "Reports" screen, there are two reports with customizable output: Annual Employment & Wage Summary and Custom Quarterly Employment and Wage. Scroll to find the group "CUSTOM" and double-click either to access the "Enter Customized Report Parameters" screen (see figure below). In this screen you can modify the following characteristics:
- Year and quarter of the data used
- Type of UI coverage
- Geographic area
- Level of industry detail displayed
- Whether or not to include size class information
- Whether or not you want confidential data suppressed
- Output types for printing reports. In standard column delimited ASCII file (unformatted text) or highly formatted text document suitable for printing in Word or other word processing program
When all selections have been made, click the [Initiate Job] button. A message displays showing your selections and asking if you want to continue. Click [Yes] and a message displays about monitoring the job in the Batch Manager. Click [No] to return to the "Reports" screen. Click [Cancel] when entering parameters to return to the "Reports" screen.
NCA Flow Processing
This process consists of generating NCA forms on demand from the Reports menu. To do this, double click the "CA Forms" entry in the Reports menu to bring up the "NCA Flow Processing" screen (see figure below). Presented in this dialog box are a Range of UI #, Range of Initial Liability Date, Range of Month 3 employment, and Address Sort Selection. A user must specify range values for all three fields and decide the type of address sort for the output—Mail/Tax/Physical or Tax/Mail/Physical. After selections are made, click the [Initiate Job] button and monitor the job from the batch manager.
The following four files are generated in the win202\reports directory: catp1.xml (print file that is converted to PDF), IAncaDDMMYY.ot (unclassified management report for Iowa), IAnca-smrDDMMYY.ot (unformatted unclassified management report) and nca-nonrespDDMMYY.ot (list of NCA's that have not reported for three mailings). To cancel the job and lose any changes simply click the [Cancel] button.
CIPSEA Short File
The CIPSEA Short File report gives you the ability to build a CIPSEA protected Short Format Micro file via the "Short File Builder". Double click the "CIPSEA Short File" entry in the Reports menu to bring up the "CIPSEA Short File Builder" screen (see figure below). The Short File Builder allows you to customize your report by ownership, geography, and industry type. Note: Industry selection at the 5-digit level is limited to approximately 300 selections, therefore you should choose the "All Industries" radio button instead of selecting all the industries with your mouse. See Appendix C for the detailed record layout.
NAICS Publications
The NAICS Publications screen is used to generate annual and quarterly covered employment and wage reports customizable by geography and NAICS level. Scroll to find the group "NAICS" and double-click on the "NAICS Publications" screen (see figure below). Choose either the quarterly or annual time period and enter the year and quarter. Select a geography type and level of detail. Note: multiple geography types and levels of detail may be selected by holding down the [Ctrl] key when making your selections. Click the [Submit Job] button to run the report.
Auto Reports Tab
With this screen users can set reports to run automatically. Upon entering the "Auto Reports" tab the following fields display for each entry: Report Title, Start Date, Start Time, Run Day(Sunday = 1,…,Sat = 7), Occurs, and Parameters (see figure below).
To setup an automatic run:
- Click the [Add Report] button to access the "Auto Reports Setup Menu" screen (see figure below).
- Select a report from the list by clicking on the report or using the [↑] and [↓] arrows on your keyboard to scroll through the list.
- Choose parameters for the report i.e., year, quarter, disclosable, NAICS level, and format options. Note: The available parameters vary based on the report selected.
- Choose the frequency (today, every, next) from the section titled "This Occurs". If the Every or Next options are selected then a day of the week must be selected (i.e. Monday, Tuesday, Wednesday, etc.).
- Input a start time in the "Start Time/Date" field.
- Click [OK] to add the report to the list.
Daily Administrative and Quarterly Transactions
If the "Daily Administrative Transactions" or "Daily Quarterly Transactions" reports are not run via the Auto Reports screen, you may run the transactions through the "Create Process" option on the Administrative Screen (see Section 6, Administrative, Create Process: Ad Hoc Programs for more information).
The output file is named win202_bes_es2_adm-trans.txt
The output file is named win202_bes_es2_qtr-trans.txt
Report Parameters Tab
Within this screen is a list of parameters that users can modify to affect the way specific reports run. Click the "Report Params" tab to view the screen below. Displayed fields include: Code, Parm Value, WIN Default and Description. As an example, parameters 10-17 apply to the revised Quarterly and Annual NAICS listings. The default for each parameter produces NAICS output for each geography although, one can prevent output for a specific geography by setting its' value to 1. Parameter 9 controls how much of the status log is saved when dumping the table for reload. In this case a user can specify "0" for saving the last six months of the status log, "1" for a year and so on.... Note: With options 0-3 an output file is generated containing all data not saved for reloading.
To update specific parameters highlight one and click [Update Report Parms] to view the following screen (see figure below). Click [Update] to access the box labeled "State". Enter a different value and click [OK] to save changes otherwise, click [Cancel] to exit the screen without saving changes.
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 |
