Back to Federal guidance
Online ETA 9002 and VETS 200 labor exchange reporting
Summary ETA instructed state workforce agencies to submit quarterly ETA 9002 and VETS 200 labor exchange reports online through the Labor Exchange Reporting System. It set a 45-day deadline after each quarter, described account and certification roles, and linked a user guide with report layouts and checks. ETA now labels this advisory Canceled.
Document
Federal guidance
Agency
U.S. Department of Labor, Employment and Training Administration (ETA)
Document number
TEGL No. 8-02
Date issued
October 4, 2002
Status
Rescinded
ETA labels this advisory Canceled as of October 25, 2026. The letter itself prints an expiration date of September 30, 2003.
Status last verified October 25, 2026
Is this still the rule?
This document has been rescinded. Ezel checks what federal law requires today, under current federal labor law, and answers your situation with citations.
About this page: The full text below is the official document from U.S. Department of Labor, Employment and Training Administration (ETA). Ezel adds the plain-English summary and tracks the document's status. The official source linked on this page is authoritative for any reliance.
The official HTML letter prints October 4, 2002; ETA's listing dates the entry September 30, 2003. Section 4 of the published letter also contains a paragraph about unemployment insurance overpayment measurement that is reproduced below as printed. The attached PDF ends mid-formula in Appendix O; the transcription ends where the official file ends.
Official HTML letter (https://www.dol.gov/sites/dolgov/files/ETA/advisories/TEGL/2002/TEGL8-02.html):
Employment and Training Administration Advisory System
U.S. Department of Labor
Washington, D.C. 20210
CLASSIFICATION: Labor Exchange Reporting System
CORRESPONDENCE SYMBOL: ES/ALMS
DATE: October 4, 2002
ADVISORY: TRAINING AND EMPLOYMENT GUIDANCE LETTER NO. 8-02
TO: ALL STATE WORKFORCE LIAISONS
ALL STATE EMPLOYMENT WORKFORCE AGENCIES
ALL STATE WORKER ADJUSTMENT LIAISONS
ALL ONE-STOP CAREER CENTER SYSTEM LEADS
/s/
FROM: EMILY STOVER DeROCCO, Assistant Secretary
SUBJECT: ONLINE REPORTING INSTRUCTIONS FOR LABOR EXCHANGE REPORTING SYSTEM
1. Purpose. To transmit instructions for submission of quarterly Labor Exchange reports, ETA 9002 A through E, and VETS 200 A through C, via the web-based Enterprise Information Management, Labor Exchange Reporting System (LERS).
2. References. Wagner-Peyser Act as amended, Section 10 (c) and Section 3(c); and Workforce Investment Act of 1998 Section 168; 20 CFR part 652.3; Training and Employment Guidance Letter No. 1-02 and 20 CFR 667.300.
3. Background. Under 20 CFR 667.300, "All States and other direct grant recipients must report financial, participant, and performance data in accordance with instructions issued by DOL." Following the announcement of the labor exchange performance measurement system in the Federal Register on May 31, 2001, the Department revised the reporting instructions for the ETA 9002 and VETS 200 reports and published them for comment on June 6, 2001 (66 FR 30487). In accordance with the Paperwork Reduction Act, the Office of Management and Budget approved the collection of data using the revised reporting instructions contained in the ETA Handbook No. 406. The Employment and Training Administration now has the capacity to receive these state reports via the Internet. A LERS user guide complete with report record layouts and edits of internal consistency is provided as attachments to the user's guide.
RESCISSIONS: None
EXPIRATION DATE: September 30, 2003
4. STATE REPORTING PROCESS. Since 1988, ETA has published a measure based on the Benefit Accuracy Measurement (BAM) program that provides a comprehensive estimate of all overpayments in the UI system. Its standard is each state's own eligibility requirements as embodied in its law and policy. Although BAM provides statistically valid and representative estimates, the variation from one state to another reflects more the differing potential for error due to more or less stringent eligibility requirements than the quality of the states' benefit payment administration. Many of the errors are "technical" in nature. Many also do not tie well to the other source of information on overpayments, which are data on the amount of actual overpayments detected and recovered through ongoing Benefit Payment Control (BPC) operations. For example, BAM estimates include several categories of overpayments such as failure to meet work search requirements, that are not readily detectable, or cost-effective to detect, through BPC operations. They also include overpayments that the agency cannot recover and thus lie outside the scope of BPC.
With the implementation of Internet-based reporting, states will have sole control over data entry. Passwords assigned to states will permit access to the appropriate screens for the quarterly Labor Exchange reports and assigned Personal Identification Numbers (PINs) will enable report certification.
Attached to the LERS Users' Guides are the eight required report record layouts and the system edits to ensure internal consistency in reports. The detailed instructions contained in this attachment are to be used by states to access the reporting Web site and LERS forms for submitting required data. States will be responsible for submitting data no later than 45 days after the end of each reporting quarter.
After the state certifies its reports as complete and accurate by entry of the assigned PIN, they are available for ETA Regional Office review. In that process, regional offices will frequently be in communication with the states in a continuing effort to maximize data integrity and to resolve concerns. Only the state can modify LERS reports.
To gain access to the LERS, a user must enter a password and a user must enter a PIN to certify the state's reports. Each State Workforce Agency (SWA) should designate a primary and secondary contact who will be granted access to LERS to complete quarterly reporting. The primary contact person is the person who has signatory authority for labor exchange reports. The primary contact will be assigned a password and a PIN needed to certify the state's quarterly reports. The secondary contact person would be the individual who is responsible for preparing, entering, or uploading report data to the LERS. The secondary contact will be assigned a password only.
Each SWA must provide agency and contact information to establish contact user accounts in the LERS. The information required includes the contact persons' names, agency addresses, telephone numbers, fax numbers, and most importantly, e-mail addresses. A data form is attached to this TEGL for your convenience. Please note there are only one primary and one secondary contact per state. It is a matter of state discretion to share the required password and/or PIN with other staff to complete state reporting. Information for primary and secondary contacts should be e-mailed to Ola Abina at [email protected] at the national office no later than September 30, 2002.
5. Action Required. States are required to submit Labor Exchange reports on the attached formats via the electronic online system, beginning with data for the quarter ending September 30, 2002, which is due no later than November 14, 2002. State Workforce Liaisons are requested to provide this TEGL to all officials within the state who need such information to comply with the new reporting requirements of the LERS.
6. Inquiries. Questions concerning this TEGL should be directed to Anthony D. Dais at [email protected] or 202-693-2784 or to your regional office.
7. Attachments. Labor Exchange Reporting System User's Guide including attachments; record layouts and edits; and contact information.
Labor Exchange Reporting System User’s Guide (https://www.dol.gov/sites/dolgov/files/ETA/advisories/TEGL/2002/TEGL8-02_Attach.pdf):
Labor Exchange / VETS
Contact Information
AGENCY Information
Name
Address
City
State / ZIP
Phone
Fax
E-Mail
Primary Contact Information
This is the person the Password and PIN will be assigned to.
Name
Address
City
State / ZIP
Phone
Fax
E-Mail
Secondary Contact Information
Name
Address
City
State / ZIP
Phone
Fax
E-Mail
LABOR EXCHANGE 9002/VETS 200
REPORTING SYSTEM
Please e-mail to [email protected] no later than September 30, 2002.
User’s Guide
Documentation Version: Draft, August 19, 2002
The Labor Exchange 9002/VETS 200 Reporting System
was designed, programmed, and documented for the:
United States Department of Labor
Employment and Training Administration
Office of National Programs
Contents
Access Labor Exchange 9002/VETS 200 Reporting System ...................................................1
Enter VETS DVOP Report (Form 200A) ................................................................................3
Access VETS DVOP Report.......................................................................................................3
Enter/Submit VETS DVOP Report .............................................................................................6
Submit Data by Uploading File ...........................................................................................6
Submit Data Manually.........................................................................................................9
Enter VETS LVER Report (Form 200B)...............................................................................10
Access VETS LVER Report .....................................................................................................10
Enter/Submit VETS LVER Report............................................................................................12
Submit Data by Uploading File .........................................................................................12
Submit Data Manually.......................................................................................................15
Enter VETS DVOP/LVER (Form 200C) ...............................................................................16
Access VETS DVOP/LVER Report..........................................................................................16
Enter/Submit VETS DVOP/LVER Report ................................................................................18
Submit Data by Uploading File .........................................................................................18
Submit Data Manually.......................................................................................................21
Enter Labor Exchange Service to Job Seeker Report (Form 9002A) ..................................22
Access Labor Exchange Service to Job Seeker Report ..............................................................22
Enter/Submit Labor Exchange Service to Job Seeker Report.....................................................25
Submit Data by Uploading File .........................................................................................25
Submit Data Manually.......................................................................................................28
Enter Labor Exchange Service to Veterans Report (Form 9002B) .....................................29
Access Labor Exchange Service to Veterans Report..................................................................29
Enter/Submit Labor Exchange Service to Veterans Report........................................................31
Submit Data by Uploading File .........................................................................................31
Submit Data Manually.......................................................................................................34
Enter Labor Exchange Performance Outcomes - Job Seekers/Employers Report (Form
9002C) .....................................................................................................................................35
Access Labor Exchange Performance Outcomes - Job Seekers/Employers Report ...................35
Enter/Submit Labor Exchange Performance Outcomes- Job Seekers/Employers Report............37
Submit Data by Uploading File .........................................................................................37
Submit Data Manually.......................................................................................................40
Enter Labor Exchange Performance Outcomes – Veterans Report (Form 9002D)............41
Access Labor Exchange Performance Outcomes – Veterans Report..........................................41
Enter/Submit Labor Exchange Performance Outcomes – Veterans Report ...............................43
Submit Data by Uploading File .........................................................................................43
Submit Data Manually.......................................................................................................46
Enter Labor Exchange Job Openings Received Report (Form 9002E) ................................47
Access Labor Exchange Job Openings Received Report ...........................................................47
Enter/Submit Labor Exchange Job Openings Received Report..................................................49
Submit Data by Uploading File .........................................................................................49
Submit Data Manually.......................................................................................................52
Appendix A: EIMS - Labor Exchange Reporting System - Zero Report Handling.......53
Appendix B: Record Layout VETS 200 A (DVOP) Quarterly Report............................54
Appendix C: Record Layout VETS 200 B (LVER) Quarterly Report ............................55
Appendix D: Record Layout VETS 200 C (DVOP/LVER) Quarterly Report ................56
Appendix E: Record Layout ETA 9002 A (Service to Job Seekers) Quarterly Report ..57
Appendix F: Record Layout ETA 9002 B (Service to Veterans) Quarterly Report .......58
Appendix G: Record Layout ETA 9002 C (Performance Outcomes – Job
Seekers/Employers) Quarterly Report...................................................................................59
Appendix H: Record Layout ETA 9002 D (Performance Outcomes – Veterans)
Quarterly Report ....................................................................................................................60
Appendix I: Record Layout ETA 9002 E (Job Openings Received) Quarterly Report .61
Appendix J: State and National Summary Edit checks ETA 9002A (Service to Job
Seekers) Quarterly Report .....................................................................................................62
Appendix K: State and National Summary Edit checks ETA 9002B (Service to Job
Seekers) Quarterly Report .....................................................................................................63
Appendix L: State and National Summary Edit checks ETA 9002C (Performance
Outcomes-Job Seekers/Employers) Quarterly Report ..........................................................64
Appendix M: State and National Summary Edit checks ETA 9002D (Performance
Outcomes – Veterans) Quarterly Report ...............................................................................65
Appendix N: State and National Summary Edit checks ETA 9002E (Job Openings
Received) Quarterly Report ...................................................................................................66
Appendix O: State and National Summary Edit Checks ETA VETS 200 A (DVOP),
VETS 200 B (LVER),VETS 200 C (DVOP / LVER) Quarterly Reports..............................67
Access Labor Exchange 9002/VETS 200
Reporting System
Follow the steps below to access the ETA Labor Exchange 9002 /VETS 200 Reporting
System.
1. Open your Web browser and type the following address in the URL Location field at the
top of the window: http://www.etareports.doleta.gov (Figure 1).
Figure 1: Web Browser – Location Field Displayed
2. Press Enter. The ETA Login window is displayed (Figure 2).
Figure 2: ETA Login Window
3. Type the Password. Click . The Labor Exchange 9002/VETS 200 Reporting
System Choose Report Program Window is displayed (Figure 3).
Figure 3: Choose Report Program Window
Labor Exchange 9002/VETS Reporting System Page 2
Enter VETS DVOP Report (Form 200A)
Access VETS DVOP Report
Follow the steps below to access the VETS DVOP Report.
1. To access VETS 200 forms, you must first access the reporting system’s Choose Report
Program window (Figure 3). See Access Labor Exchange 9002/VETS 200 Reporting
System above.
2. Click in the Choose Report Program window. The Choose Report
Period window (Figure 4) is displayed.
Figure 4: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 7) is displayed. Continue to step 4. If you get an error message, see Note A
below.
Labor Exchange 9002/VETS Reporting System Page 3
Note A: You must submit VETS 200 quarterly reports in order. If you
fail to select the correct quarter in the step above, an error message (Figure
5) and a follow-up message (Figure 6) are displayed.
The error message tells you what reports must be filed. Click
in the error message window to view the follow-up message, which guides
you through the process of filing the missing reports.
Figure 5: VETS 200 Report Selection Error Message
Figure 6: VETS 200 Error Follow-Up Window
Labor Exchange 9002/VETS Reporting System Page 4
Figure 7: Form Selection Window
4. Click in the Form Selection window. The Data
Submission Options window is displayed (Figure 8).
Figure 8: DVOP Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 5
Enter/Submit VETS DVOP Report
You may submit the VETS DVOP Report by uploading a data file or by entering the data
manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window. The Upload File to Server window (Figure 9) is
displayed.
Figure 9: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 10) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 6
Figure 10: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File to
Server window (Figure 9) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The DVOP Quarterly Report form is displayed (Figure 11).
Labor Exchange 9002/VETS Reporting System Page 7
Figure 11: DVOP Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 12).
Labor Exchange 9002/VETS Reporting System Page 8
Figure 12: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 8). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 12).
Labor Exchange 9002/VETS Reporting System Page 9
Enter VETS LVER Report (Form 200B)
Access VETS LVER Report
Follow the steps below to access the VETS LVER Report
1. To access VETS 200 forms, you must first access the reporting system’s Choose Report
Program window (Figure 3). See Access Labor Exchange 9002/VETS 200 Reporting
System above.
2. Click in the Choose Report Program window. The Choose Report
Period window (Figure 13) is displayed.
Figure 13: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 14) is displayed. Continue to step 4. If you get an error message, see Note A
above.
Labor Exchange 9002/VETS Reporting System Page 10
Figure 14: Form Selection Window
4. Click in the Form Selection window. The Data Submission
Options window is displayed (Figure 15).
Figure 15: DVOP Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 11
Enter/Submit VETS LVER Report
You may submit the VETS LVER Report by uploading a data file or by entering the data
manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window. The Upload File to Server window (Figure 16) is
displayed.
Figure 16: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 17) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 12
Figure 17: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File to
Server window (Figure 16) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The LVER Quarterly Report form is displayed (Figure 18).
Labor Exchange 9002/VETS Reporting System Page 13
Figure 18: LVER Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 19).
Labor Exchange 9002/VETS Reporting System Page 14
Figure 19: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 15). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 19).
Labor Exchange 9002/VETS Reporting System Page 15
Enter VETS DVOP/LVER (Form 200C)
Access VETS DVOP/LVER Report
Follow the steps below to access the VETS DVOP/LVER Report.
1. To access VETS 200 forms, you must first access the reporting system’s Choose Report
Program window (Figure 3). See Access Labor Exchange 9002/VETS 200 Reporting
System above.
2. Click in the Choose Report Program window. The Choose Report
Period window (Figure 20) is displayed.
Figure 20: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 21) is displayed. Continue to step 4. If you get an error message, see Note A
above.
Labor Exchange 9002/VETS Reporting System Page 16
Figure 21: Form Selection Window
4. Click in the Form Selection window. The Data
Submission Options window is displayed (Figure 22).
Figure 22: DVOP/LVER Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 17
Enter/Submit VETS DVOP/LVER Report
You may submit the DVOP/LVER Report by uploading a data file or by entering the data
manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window. The Upload File to Server window (Figure 23) is
displayed.
Figure 23: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 24) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 18
Figure 24: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File to
Server window (Figure 23) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The DVOP/LVER Quarterly Report form is displayed (Figure 25).
Labor Exchange 9002/VETS Reporting System Page 19
Figure 25: DVOP/LVER Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 26).
Labor Exchange 9002/VETS Reporting System Page 20
Figure 26: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 22). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 26).
Labor Exchange 9002/VETS Reporting System Page 21
Enter Labor Exchange Service to
Job Seeker Report (Form 9002A)
Access Labor Exchange Service to Job Seeker Report
Follow the steps below to access the Labor Exchange Service to Job Seeker Report.
1. To access VETS 200 forms, you must first access the reporting system’s Choose Report
Program window (Figure 3). See Access Labor Exchange 9002/VETS 200 Reporting
System above.
2. Click in the Choose Report Program window. The
Choose Report Period window (Figure 27) is displayed.
Figure 27: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 30) is displayed. Continue to step 4. If you get an error message, see Note B
below.
Labor Exchange 9002/VETS Reporting System Page 22
Note B: You must submit Labor Exchange 9002 quarterly reports in
order. If you fail to select the correct quarter in the step above, an error
message (Figure 28) and a follow-up message (Figure 29) are displayed.
The error message tells you what reports must be filed. Click
in the error message window to view the follow-up message, which guides
you through the process of filing the missing reports.
Figure 28: Labor Exchange 9002 Report Selection Error Message
Figure 29: Labor Exchange 9002 Error Follow-Up Window
Labor Exchange 9002/VETS Reporting System Page 23
Figure 30: Form Selection Window
4. Click in the Form Selection window. The Data
Submission Options window is displayed (Figure 31).
Figure 31: Service to Job Seeker Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 24
Enter/Submit Labor Exchange Service to Job Seeker Report
You may submit the Labor Exchange Service to Job Seeker Report by uploading a data file or
by entering the data manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window (Figure 31). The Upload File to Server window
(Figure 32) is displayed.
Figure 32: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 33) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 25
Figure 33: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File
to Server window (Figure 32) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The Service to Job Seekers Quarterly Report form is displayed
(Figure 34).
Labor Exchange 9002/VETS Reporting System Page 26
Figure 34: Service to Job Seekers Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation message is
displayed showing the date and time (Figure 35).
Labor Exchange 9002/VETS Reporting System Page 27
Figure 35: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 31). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 35).
Labor Exchange 9002/VETS Reporting System Page 28
Enter Labor Exchange
Service to Veterans Report (Form 9002B)
Access Labor Exchange Service to Veterans Report
Follow the steps below to access the Labor Exchange Service to Veterans Report.
1. To access Labor Exchange 9002 forms, you must first access the reporting system’s
Choose Report Program window (Figure 3). See Access Labor Exchange 9002/VETS
200 Reporting System above.
2. Click in the Choose Report Program window. The
Choose Report Period window (Figure 36) is displayed.
Figure 36: Choose Report Period Window
3. Click the arrow at the end of the Choose Report Period field and select the desired date,
then click . If your report submissions are up to date, the Form Selection
window (Figure 37) is displayed. Continue to step 4. If you get an error message, see
Note B above.
Labor Exchange 9002/VETS Reporting System Page 29
Figure 37: Form Selection Window
4. Click in the Form Selection window. The Data
Submission Options window is displayed (Figure 38).
Figure 38: Service to Veterans Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 30
Enter/Submit Labor Exchange Service to Veterans Report
You may submit the Labor Exchange Service to Veterans Report by uploading a data file or by
entering the data manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window (Figure 38). The Upload File to Server window (Figure
39) is displayed.
Figure 39: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 40) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 31
Figure 40: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File
to Server window (Figure 39) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The Service to Veterans Quarterly Report form is displayed
(Figure 41).
Labor Exchange 9002/VETS Reporting System Page 32
Figure 41: Service to Veterans Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 42).
Labor Exchange 9002/VETS Reporting System Page 33
Figure 42: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 38). The Quarterly Report form is displayed.
2. Type the report data in the fields within the white boxes. These fields must have a valid
numerical entry. If there is no data for a field, a zero must be entered. Press the Tab key
to move from field to field. The Reports Comments field is the only field that accepts
text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 42).
Labor Exchange 9002/VETS Reporting System Page 34
Enter Labor Exchange Performance Outcomes -
Job Seekers/Employers Report (Form 9002C)
Access Labor Exchange Performance Outcomes -
Job Seekers/Employers Report
Follow the steps below to access the Labor Exchange Performance Outcomes - Job
Seekers/Employers Report.
1. To access Labor Exchange 9002 forms, you must first access the reporting system’s
Choose Report Program window (Figure 3). See Access Labor Exchange 9002/VETS
200 Reporting System above.
2. Click in the Choose Report Program window. The
Choose Report Period window (Figure 43) is displayed.
Figure 43: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 44) is displayed. Continue to step 4. If you get an error message, see Note B
above.
Labor Exchange 9002/VETS Reporting System Page 35
Figure 44: Form Selection Window
4. Click in the Form
Selection Window. The Data Submission Options window is displayed (Figure 45).
Figure 45: Performance Outcomes – Job Seekers/Employers
Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 36
Enter/Submit Labor Exchange Performance
Outcomes- Job Seekers/Employers Report
You may submit the Labor Exchange Performance Outcomes – Job Seekers/Employers
Report by uploading a data file or by entering the data manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window (Figure 45). The Upload File to Server window (Figure
46) is displayed.
Figure 46: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 47) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 37
Figure 47: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File
to Server window (Figure 46) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The Performance Outcomes – Job Seekers/Employers Quarterly
Report form is displayed (Figure 48).
Labor Exchange 9002/VETS Reporting System Page 38
Figure 48: Performance Outcomes – Job Seekers/Employers Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 49).
Labor Exchange 9002/VETS Reporting System Page 39
Figure 49: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 45). The Quarterly Report form is displayed.
2. Type the report data in the fields within the white boxes. These fields must have a valid
numerical entry. If there is no data for a field, a zero must be entered. Press the Tab key
to move from field to field. The Reports Comments field is the only field that accepts
text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 49).
Labor Exchange 9002/VETS Reporting System Page 40
Enter Labor Exchange Performance
Outcomes – Veterans Report (Form 9002D)
Access Labor Exchange Performance Outcomes – Veterans Report
Follow the steps below to access the Labor Exchange Performance Outcomes – Veterans
Report.
1. To access Labor Exchange 9002 forms, you must first access the reporting system’s
Choose Report Program window (Figure 3). See Access Labor Exchange 9002/VETS
200 Reporting System above.
2. Click in the Choose Report Program window. The
Choose Report Period window (Figure 50) is displayed.
Figure 50: Choose Report Period Window
3. Click the arrow at the end of the Choose Report Period field and select the desired date,
then click . If your report submissions are up to date, the Form Selection
window (Figure 51) is displayed. Continue to step 4. If you get an error message, see
Note B above.
Labor Exchange 9002/VETS Reporting System Page 41
Figure 51: Form Selection Window
4. Click in the Form Selection window.
The Data Submission Options window is displayed (Figure 52).
Figure 52: Performance Outcomes – Veterans Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 42
Enter/Submit Labor Exchange Performance
Outcomes – Veterans Report
You may submit the Labor Exchange Performance Outcomes – Veterans Report by
uploading a data file or by entering the data manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window (Figure 52). The Upload File to Server window (Figure
53) is displayed.
Figure 53: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 54) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 43
Figure 54: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File
to Server window (Figure 53) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The Performance Outcomes – Veterans Quarterly Report form is
displayed (Figure 55).
Labor Exchange 9002/VETS Reporting System Page 44
Figure 55: Performance Outcomes – Veterans Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 56).
Labor Exchange 9002/VETS Reporting System Page 45
Figure 56: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 52). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 56).
Labor Exchange 9002/VETS Reporting System Page 46
Enter Labor Exchange Job Openings Received
Report (Form 9002E)
Access Labor Exchange Job Openings Received Report
Follow the steps below to access the Labor Exchange Job Openings Received
Report.
1. To access Labor Exchange 9002 forms, you must first access the reporting system’s
Choose Report Program window (Figure 3). See Access Labor Exchange 9002/VETS
200 Reporting System above.
2. Click in the Choose Report Program window. The
Choose Report Period window (Figure 57) is displayed.
Figure 57: Choose Report Period Window
3. Click the arrow at the end of the Report Period field and select the desired date, then
click . If your report submissions are up to date, the Form Selection window
(Figure 58) is displayed. Continue to step 4. If you get an error message, see Note B
above.
Labor Exchange 9002/VETS Reporting System Page 47
Figure 58: Form Selection Window
4. Click in the Form Selection window, the Data
Submission Options window is displayed (Figure 59).
Figure 59: 9002E Data Submission Options Window
Labor Exchange 9002/VETS Reporting System Page 48
Enter/Submit Labor Exchange Job Openings Received Report
You may submit the Labor Exchange Job Openings Received Report by uploading a data file
or by entering the data manually.
Submit Data by Uploading File
1. To use the upload data option, click Submit your data by uploading a file in the Data
Submission Options window (Figure 59). The Upload File to Server window (Figure
60) is displayed.
Figure 60: Upload File to Server Window
2. If you know the path name of the upload file, type it in the field; if you do not, click
. The File Upload window (Figure 61) is displayed. Select Text[*.txt] in the
Files of Type field before you begin your search. Then select the upload file.
Labor Exchange 9002/VETS Reporting System Page 49
Figure 61: File Upload Window
3. When the desired file appears in the File name field, click . The Upload File
to Server window (Figure 60) is displayed again. The path and name for the selected file
should appear in the Browse field.
4. Click . The Quarterly Report form is displayed (Figure 62).
Labor Exchange 9002/VETS Reporting System Page 50
Figure 62: ETA 9002E Quarterly Report Form
5. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (Figure 63).
Labor Exchange 9002/VETS Reporting System Page 51
Figure 63: Confirmation Message
Submit Data Manually
1. To enter report data manually, click Submit your data manually in the Data
Submission Options window (Figure 59). The Quarterly Report form is displayed.
2. Type the report data into the appropriate fields. All fields must have a valid numerical
entry. If there is no data for a field, a zero must be entered. Press the Tab key to move
from field to field. The Reports Comments field is the only field that accepts text.
3. After you type all the report data, print a copy of the report to review for accuracy and to
file in your records.
4. To submit this form, you must enter your PIN in the Your PIN Number field, then click
. When the report is accepted, it is entered to the system, and a confirmation
message is displayed showing the date and time (See Figure 63).
Labor Exchange 9002/VETS Reporting System Page 52
Appendix A: EIMS - Labor Exchange Reporting System - Zero Report
Handling
Report 1 Report 2 Report 3 Report 4 Report 5
“ZERO REPORT”
900,000 1,000,000 1,000,000 1,100,000 975,000
Q1 Q2 Q3 Q4 Q2 Q3 Q4 Q5 Q2 Q3 Q4 Q5 Q4 Q5 Q6 Q7 Q5 Q6 Q7 Q8
* * * * * * * * - * * * * * * * * * * *
This is the example of the Three quarters of data After fixing the system
Rolling 4 quarte rs reporting (3,4&5) would have been problem the state reports 4
included in the report. full quarters of data from the
Therefore, the report is off correct quarters.
by 1 quarter of data.
A Zero Report allows the Upon certification of Report Using the figures above, the
state 45 days from the end of 4, Report 3 is LOCKED. A following chart shows a
the reporting period (which state could correct Report 3 possible Zero Report
is 45 days after the end of the before entering and scenario and the effect of an
quarter) to fix the problem certifying Report 4. This un-corrected Zero Report.
before or 90 days before the would not be required
next report is due. however.
Registrants by Quarter
1,200,000
1,000,000
Registrants
800,000
600,000 Registrants
400,000
200,000
0
REPORT
Report 3
Report 1
Report 5
ZERO
Quarterly Reports
Appendix B: Record Layout VETS 200 A (DVOP)
Quarterly Report
Row # State Rep Qtr Form Name 2 3 4 5 6 7 8 9
1 VA 20011231 200 A 99 99 99 99 99 99 99 99
"1","VA","20011231","200A",99,99,99,99,99,99,99,99
"2","VA","20011231","200A",99,99,99,99,99,99,99,,
"3","VA","20011231","200A",99,99,99,99,99,99,99,,
"4","VA","20011231","200A",99,99,99,99,99,99,99,99
"5","VA","20011231","200A",99,99,99,99,99,99,99,99
"6","VA","20011231","200A",99,99,99,99,99,99,99,99
"7","VA","20011231","200A",99,99,99,99,99,99,99,99
"8","VA","20011231","200A",99,99,99,99,99,99,99,99
"9","VA","20011231","200A",99,99,99,99,99,99,99,99
"10","VA","20011231","200A",99,99,99,99,99,99,99,99
"11","VA","20011231","200A",99,99,99,99,99,99,99,99
"12","VA","20011231","200A",99,99,99,99,99,99,99,99
"13","VA","20011231","200A",99,99,99,99,99,99,99,99
"14","VA","20011231","200A",99,99,99,99,99,99,99,99
"15","VA","20011231","200A",99,99,99,99,99,99,99,99
"16","VA","20011231","200A",,99,99,99,,99,99,,
"17","VA","20011231","200A",99,99,99,99,99,99,99,99
"18","VA","20011231","200A",99,99,99,99,99,99,99,99
"19","VA","20011231","200A",99,99,99,99,99,99,99,99
"20","VA","20011231","200A",,99,99,99,99,99,99,99
"21","VA","20011231","200A",,99,99,99,99,99,99,99
"22","VA","20011231","200A",,99,99,99,99,99,99,99
"23","VA","20011231","200A",,99,99,99,99,99,99,99
"24","VA","20011231","200A",,99,99,99,99,99,99,99
"25","VA","20011231","200A",,99,99,99,99,99,99,99
"26","VA","20011231","200A",,99,99,99,99,99,99,99
"27","VA","20011231","200A",,99,99,99,99,99,99,99
"28","VA","20011231","200A",,99,99,99,99,99,99,99
"29","VA","20011231","200A",99,99,99,99,99,99,99,99
"30","VA","20011231","200A",99,99,99,99,99,99,99,99
"31","VA","20011231","200A",,99,99,99,,99,99,,
Appendix C: Record Layout VETS 200 B (LVER)
Quarterly Report
Row # State Rep Qtr Form Name 2 3 4 5 6 7 8 9
1 VA 20011231 200 B 99 99 99 99 99 99 99 99
"1","VA","20011231","200B",99,99,99,99,99,99,99,99
"2","VA","20011231","200B",99,99,99,99,99,99,99,,
"3","VA","20011231","200B",99,99,99,99,99,99,99,,
"4","VA","20011231","200B",99,99,99,99,99,99,99,99
"5","VA","20011231","200B",99,99,99,99,99,99,99,99
"6","VA","20011231","200B",99,99,99,99,99,99,99,99
"7","VA","20011231","200B",99,99,99,99,99,99,99,99
"8","VA","20011231","200B",99,99,99,99,99,99,99,99
"9","VA","20011231","200B",99,99,99,99,99,99,99,99
"10","VA","20011231","200B",99,99,99,99,99,99,99,99
"11","VA","20011231","200B",99,99,99,99,99,99,99,99
"12","VA","20011231","200B",99,99,99,99,99,99,99,99
"13","VA","20011231","200B",99,99,99,99,99,99,99,99
"14","VA","20011231","200B",99,99,99,99,99,99,99,99
"15","VA","20011231","200B",99,99,99,99,99,99,99,99
"16","VA","20011231","200B",,99,99,99,,99,99,,
"17","VA","20011231","200B",99,99,99,99,99,99,99,99
"18","VA","20011231","200B",99,99,99,99,99,99,99,99
"19","VA","20011231","200B",99,99,99,99,99,99,99,99
"20","VA","20011231","200B",,99,99,99,99,99,99,99
"21","VA","20011231","200B",,99,99,99,99,99,99,99
"22","VA","20011231","200B",,99,99,99,99,99,99,99
"23","VA","20011231","200B",,99,99,99,99,99,99,99
"24","VA","20011231","200B",,99,99,99,99,99,99,99
"25","VA","20011231","200B",,99,99,99,99,99,99,99
"26","VA","20011231","200B",,99,99,99,99,99,99,99
"27","VA","20011231","200B",,99,99,99,99,99,99,99
"28","VA","20011231","200B",,99,99,99,99,99,99,99
"29","VA","20011231","200B",99,99,99,99,99,99,99,99
"30","VA","20011231","200B",99,99,99,99,99,99,99,99
"31","VA","20011231","200B",,99,99,99,,99,99,,
Labor Exchange 9002/VETS Reporting System Page 55
Appendix D: Record Layout VETS 200 C
(DVOP/LVER) Quarterly Report
Row # State Rep Qtr Form Name 2 3 4 5 6 7 8 9
1 VA 20011231 200 C 99 99 99 99 99 99 99 99
"1","VA","20011231","200C",99,99,99,99,99,99,99,99
"2","VA","20011231","200C",99,99,99,99,99,99,99,,
"3","VA","20011231","200C",99,99,99,99,99,99,99,,
"4","VA","20011231","200C",99,99,99,99,99,99,99,99
"5","VA","20011231","200C",99,99,99,99,99,99,99,99
"6","VA","20011231","200C",99,99,99,99,99,99,99,99
"7","VA","20011231","200C",99,99,99,99,99,99,99,99
"8","VA","20011231","200C",99,99,99,99,99,99,99,99
"9","VA","20011231","200C",99,99,99,99,99,99,99,99
"10","VA","20011231","200C",99,99,99,99,99,99,99,99
"11","VA","20011231","200C",99,99,99,99,99,99,99,99
"12","VA","20011231","200C",99,99,99,99,99,99,99,99
"13","VA","20011231","200C",99,99,99,99,99,99,99,99
"14","VA","20011231","200C",99,99,99,99,99,99,99,99
"15","VA","20011231","200C",99,99,99,99,99,99,99,99
"16","VA","20011231","200C",,99,99,99,,99,99,,
"17","VA","20011231","200C",99,99,99,99,99,99,99,99
"18","VA","20011231","200C",99,99,99,99,99,99,99,99
"19","VA","20011231","200C",99,99,99,99,99,99,99,99
"20","VA","20011231","200C",,99,99,99,99,99,99,99
"21","VA","20011231","200C",,99,99,99,99,99,99,99
"22","VA","20011231","200C",,99,99,99,99,99,99,99
"23","VA","20011231","200C",,99,99,99,99,99,99,99
"24","VA","20011231","200C",,99,99,99,99,99,99,99
"25","VA","20011231","200C",,99,99,99,99,99,99,99
"26","VA","20011231","200C",,99,99,99,99,99,99,99
"27","VA","20011231","200C",,99,99,99,99,99,99,99
"28","VA","20011231","200C",,99,99,99,99,99,99,99
"29","VA","20011231","200C",99,99,99,99,99,99,99,99
"30","VA","20011231","200C",99,99,99,99,99,99,99,99
"31","VA","20011231","200C",,99,99,99,,99,99,,
Labor Exchange 9002/VETS Reporting System Page 56
Appendix E: Record Layout ETA 9002 A (Service to Job Seekers)
Quarterly Report
Row # State Rep Qtr Form Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
1 MD 20011231 9002A 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
“1”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“2”, “MD”, “20011231”, ”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“3”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“4”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, , 99
“5”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“6”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“7”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“8”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“9”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“10”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“11”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“12”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“13”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“14”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“15”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“16”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“17”, “MD”, “20011231”,”9002A”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
Appendix F: Record Layout ETA 9002 B (Service to Veterans) Quarterly
Report
Row State Rep Qtr Form 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
# Name
1 MD 20011231 9002B 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
“1”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“2”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“3”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“4”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“5”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“6”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“7”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“8”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“9”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“10”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“11”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“12”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“13”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“14”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“15”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, , , , , 99, 99, 99, 99, 99
“16”, “MD”, “20011231”,”9002B”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, , , , , 99, 99, 99, 99, 99
Labor Exchange 9002/VETS Reporting System Page 58
Appendix G: Record Layout ETA 9002 C (Performance Outcomes – Job
Seekers/Employers) Quarterly Report
Row State Rep Qtr Form 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
# Name
1 MD 20011231 9002C 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
“1”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“2”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“3”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“4”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, , 99
“5”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“6”, “MD”, “20011231”,”9002C”, 99, , , 99, , , , , , , , , , , , , , 99, 99, 99
“7”, “MD”, “20011231”,”9002C”, 99, , , 99, , , , , , , , , , , , , , 99, 99, 99
“8”, “MD”, “20011231”,”9002C”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“9”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“10”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“11”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“12”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“13”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“14”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“15”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“16”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
“17”, “MD”, “20011231”, ”9002C”, , , , , , , , , , , , , , , , , , , ,
Labor Exchange 9002/VETS Reporting System Page 59
Appendix H: Record Layout ETA 9002 D (Performance Outcomes –
Veterans) Quarterly Report
Row State Rep Qtr Form 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
# Name
1 MD 20011231 9002D 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
“1”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“2”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“3”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“4”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“5”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“6”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“7”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“8”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“9”, “MD”, “20011231”,”9002D”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, , , , , 99, 99, 99, 99, 99
Labor Exchange 9002/VETS Reporting System Page 60
Appendix I: Record Layout ETA 9002 E (Job Openings Received)
Quarterly Report
Row State Rep Qtr Form 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
# Name
1 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
“1”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“2”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“3”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“4”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“5”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“6”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“7”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“8”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“9”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“10”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“11”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“12”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“13”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“14”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“15”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“16”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“17”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“18”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“19”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“20”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“21”, “MD”, “20011231”,”9002E”, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99, 99
“22”, “MD”, “20011231”,”9002E”, , , , , , , , , , , , , , , , , , , , ,
“23”, “MD”, “20011231”,”9002E”, , , , , , , , , , , , , , , , , , , , ,
“24”, “MD”, “20011231”,”9002E”, , , , , , , , , , , , , , , , , , , , ,
Labor Exchange 9002/VETS Reporting System Page 61
Appendix J: State and National Summary Edit
Checks ETA 9002A (Service to Job
Seekers) Quarterly Report
For every row on the 9002 A, the value in Column A1 is equal to the sum of the values in
ColumnB2 plus Column B 3 for that row.
Column A1 Row 1 = Column B2 Row 1 + Column B3 Row 1
Column A1 Row 2 = Column B2 Row 2 + Column B3 Row 2
Column A1 Row 3 = Column B2 Row 3 + Column B3 Row3
Column A1 Row 4 = Column B2 Row 4 + Column B3 Row 4
Column A1 Row 5 = Column B2 Row 5 + Column B3 Row 5
Column A1 Rows 6 – 15 = Columns B2 Rows 6-15 + Columns B3 Rows 6-15
For every column on the 9002 A, the value in Row 1 is equal to or greater than the value in every
other row for that column.
Column A1 Row 1 >= Column A1 Row 2 thru A1 Row 15
Column B2 Row 1 >= Column B2 Row 2 thru B2 Row 15
Column B3 Row 1 >= Column B3 Row 2 thru B3 Row 15
Column C4 Row 1 >= Column C4 Row 2 thru C4 Row 15
For every column on the 9002 A, the value in Row 1 is equal to or greater than the sum of the
values in Row 5 plus Row 6 for that column.
Column A1 Row 1 >= Column A1 Row 5 + Column A1 Row 6
Column B2 Row 1 >= Column B2 Row 5 + Column B2 Row 6
Column B3 Row 1 >= Column B3 Row 5 + Column B3 Row 6
Column C4 Row 1 >= Column C4 Row 5 + Column C4 Row 6
For every column on the 9002 A, the value in Row 1 is equal to or greater than the sum of the
values in Row 7 plus Row 8 for that column.
Column A1 Row 1 >= Column A1 Row 7 + Column A1 Row 8
Column B2 Row 1 >= Column B2 Row 7 + Column B2 Row 8
Column B3 Row 1 >= Column B2 Row 7 + Column B2 Row 8
Column C4 Row 1 >= Column C4 Row 7 + Column C4 Row 8
For every column on the 9002 A, the value in Row 8 is equal to the sum of the values in Row 9
plus Row 10 plus Row 11 for that column.
Column A1 Row 8 = Column A1 Row 9 + Column A1 Row 10 + Column A1 Row 11
Column B2 Row 8 = Column B2 Row 9 + Column B2 Row 10 + Column B2Row 11
Column B3 Row 8 = Column B3 Row 9 + Column B3 Row 10 + Column B3 Row 11
Column C4 Row 8 = Column C4 Row 9 + Column C4 Row 10 + Column C4 Row11
Appendix K: State and National Summary Edit
Checks ETA 9002B (Service to Job
Seekers) Quarterly Report
For every column on the 9002 B, the value in Row 1 is equal to or greater than the value in every other
row for that column.
Column A1Row 1 >= Columns A1 Row 2 thru A1 Row 14
Column A2 Row1 >= Columns A2 Row 2 thru A2 Row 14
Column A3 Row 1 >= Columns A3 Row 2 thru A3 Row 14
Column A4 Row 1 >= Columns A4 Row 2 thru A4 Row 14
Columns B5 - 8 Row 1 >= Columns B5-8 Row 2 thru B5-8 Row 16
Columns C9-10 Row 1 >= Columns C9-10 Row 2 thru C9-10 Row 16
Columns D13-14 Row 1>= Columns D13-16 Row 2 thru D13-16 Row 14
Columns E17-20 Row 1>= Columns E17-20 Row 2 thru E17-20 Row 16
Columns F21 Row 1 >= Columns F21 Row 2 thru F21 Row 16
For the value in Column A4 Row 4 is equal to or greater than the value in Rows 5 - 14.
For the value in Column B8 Row 4 is equal to or greater than the value in Rows 5 - 16.
For the value in Column C12 Row 4 is equal to or greater than the value in Rows 5 - 16.
For the value in Column D16 Row 4 is equal to or greater than the value in Rows 5 - 14.
For the value in Column E20 Row 4 is equal to or greater than the value in Rows 5 - 16.
For the value in Column F21 Row 4 is equal to or greater than the value in Rows 5 - 16.
Column A4 Row 4 >= Columns A4 Row 5 thru A4 Row 14
Column B8 Row 4 >= Columns B8 Row 5 thru A4 Row 16
Column C12 Row 4 >= Columns C12 Row 5 thru A4 Row 16
Column D16 Row 4 >= Columns D16 Row 5 thru A4 Row 14
Column E20 Row 4 >= Columns E20 Row 5 thru A4 Row 16
Column F21 Row 4 >= Columns F21 Row 5 thru A4 Row 16
For Sections A through E on the 9002 B, the value in the Total column of each section is greater than or
equal to the sum of the three age breakdown columns in that section.
Column A4 Row 1 >= Column A1 Row 1 + Column A2 Row 1 +Column A3 Row 1
Column A4 Row 2 >= Column A1 Row 2+ Column A2 Row 2 + Column A3 Row 2
Column A4 Rows 3-14 >= Column A1 Rows 3-14 + Columns A2 Rows 3-14 + Columns A3 Rows 3-14
Column B8 Row 1 >= Column B5 Row 1 + Column B6 Row 1+ Column B7 Row1
Column B8 Rows 2 – 16 >= Column B5 Row 2 – 16 + Column B6 Rows 2 – 16 + Column B7 Rows 2 – 16
Column C12 >= Column C9 Row 1 + Column C10 Row 1 + Column C11 Row 1
Column C12 >= Column C9 Rows 2 – 16 + Column C10 Rows 2-16 + Column C11 Rows 2-16
Column D16 >= Column D13 Row 1 + Column D14 Row 1 + Column D15 Row 1
Column D16 >= Column D13 Row 2-14 + Column D14 Rows 2 – 14 + Columns D15 Rows 2-14
Column E20 >= Column 17 Row 1 + Column 18 Row 1 + Column 19 Row 1
Column E20 >= Column 17 Row 2-16 + Column 18 Row 2-16 + Column 19 Row 2-16
For Sections A through F, the value in Row 1 of each column is equal to or greater than the sum of the
values in Row 2 plus Row 3 for that column.
Column A1 Row 1 >= Column A1 Row 2 + Column A1 Row 3
Column A2 Row 1 >= Column A2 Row 2 + Column A2 Row 3
Column A3 Row 1 >= Column A3 Row 2 + Column A3 Row 3
Column A4 Row 1 >= Column A4 Row 2 + Column A4 Row 3
Appendix L: State and National Summary Edit
Checks ETA 9002C (Performance
Outcomes-Job Seekers/Employers)
Quarterly Report
For every column on the 9002 C, the value in Row 1 of that column is equal to or greater than
the sum of the values in Row 2 plus Row 3 plus Row 4 plus Row 5 for that column.
ColumnA1 Row1 >= ColumnA1 Row2 + ColumnA1 Row3 + ColumnA1 Row4 + ColumnA1 Row5
ColumnB2 Row1 >= ColumnB2 Row2 + ColumnB2 Row3 + ColumnB2 Row4 + ColumnB2 Row5
ColumnB3 Row1 >= ColumnB3 Row2 + ColumnB3 Row3 + ColumnB3 Row4 + ColumnB3 Row5
ColumnC4 Row1 >= ColumnC4 Row2 + ColumnC4 Row3+ ColumnC4 Row4 + ColumnC4 Row5
For every unshaded row on the 9002 C, the value in Column A1 is equal to or greater than the
sum of the values in Column B2 plus Column B 3 for that row.
Column A1 Row 1 >= Column B2 Row 1 + Column B3 Row 1
Column A1 Row 2 >= Column B2 Row 2 + Column B3 Row 2
Column A1 Row 3 >= Column B2 Row 3 + Column B3 Row 3
Column A1 Row 4 >= Column B2 Row 4 + Column B3 Row 4
Column A1 Row 5 >= Column B2 Row 5 + Column B3 Row 5
Column A1 Row 8 >= Column B2 Row 8 + Column B3 Row 8
The value in Column A1 Row 7 is equal to the value in Column A1 Row 1 divided by the value
in Column A1 Row 6 and rounded to the next whole number
Column A1 Row 7 = Column A1 Row 1 divided by Column A1 Row 6
The value in Column A1 Row 10 is equal to the value in Column A1 Row 8 divided by the value
in Column A1 Row 9 and rounded to the next whole number
Column A1 Row 10 = Column A1 Row 8 divided by Column A1 Row 9
The value in Column A1 Row 12 is to be rounded to the next whole number
The value in Column A1 Row 15 is to be rounded to the next whole number
Appendix M: State and National Summary Edit
Checks ETA 9002D (Performance
Outcomes – Veterans) Quarterly Report
For Sections A through E on the 9002 D, the value in the Total column of each section is greater than or equal to the
sum of the three age breakdown columns in that section.
Column A4 Row 1 >= Column A1 Row 1 + Column A2 Row 1 +Column A3 Row 1
Column A4 Row 2 >= Column A1 Row 2+ Column A2 Row 2 + Column A3 Row 2
Column A4 Row 4 >= Column A1 Row 4 + Columns A2 Row 4 + Columns A3 Row 4
Column A4 Row 5 >= Column A1 Row 5 + Columns A2 Row 5 + Columns A3 Row 5
Column A4 Row 7 >= Column A1 Row 7 + Columns A2 Row 7 + Columns A3 Row 7
Column A4 Row 8 >= Column A1 Row 8 + Columns A2 Row 8 + Columns A3 Row 8
Column B8 Row 1 >= Column B5 Row 1 + Column B6 Row 1+ Column B7 Row1
Column B8 Rows 2 – 9 >= ColumnB5 Row 2 – 9 + Column B6 Rows 2 – 9 + Column B7 Rows 2 – 9
Column C12 >= Column C9 Row 1 + Column C10 Row 1 + Column C11 Row 1
Column C12 >= Column C9 Rows 2 – 9+ Column C10 Rows 2-9+ Column C11 Rows 2-9
Column D16 >= Column D13 Row 1 + Column D14 Row 1 + Column D15 Row 1
Column D16 >= Column D13 Row 2-9 + Column D14 Rows 2 – 9+ Columns D15 Rows 2-9
Column E20 >= Column 17 Row 1 + Column 18 Row 1 + Column 19 Row 1
Column E20 >= Column 17 Row 2-9 + Column 18 Row 2-9 + Column 19 Row 2-9
For every column on the 9002 D, the value in Row 3 is equal to the value in Row 1 divided by the value in Row 2
for that column.
Column A1 Row 3 = Column A1 Row 1 divided by Column A1 Row 2
Column A2 Row 3 = Column A2 Row 1 divided by Column A2 Row 2
Column A3 Row 3 = Column A3 Row 1 divided by Column A3 Row 2
Column A4 Row 3 = Column A4 Row 1 divided by Column A4 Row 2
Columns B 5-8 Row 3 = Columns B5 – 8 Row 1 divided by Columns B5 – 8 Row 2
Columns C 9-12 Row 3 = Columns C9 – 12 Row 1 divided by Columns C9 – 12 Row 2
Columns D 13-16 Row 3 = Columns D13 – 16 Row 1 divided by Columns D 13 – 16 Row 2
Columns E 17-20 Row 3 = Columns E 17 – 20 Row 1 divided by Columns E17 – 20 Row 2
Column F 21 Row 3 = Column F21 Row 1 divided by Column F21 Row 2
For every column on the 9002 D, the value in Row 6 is equal to the value in Row 4 divided by the value in Row 5
for that column.
Column A1 Row 6 = Column A1 Row 4 divided by Column A1 Row 5
Column A2 Row 6 = Column A2 Row 4 divided by Column A2 Row 5
Column A3 Row 6 = Column A3 Row 4 divided by Column A3 Row 5
Column A4 Row 6 = Column A4 Row 4 divided by Column A4 Row 5
Column B5-8 Row 6 = Column B5 – 8 Row 4 divided by Columns B5 – 8 Row 5
Column C 9-12 Row 6 = Column C9-12 Row 4 divided by Columns C9-12 Row 5
Column D13-16 Row 6 = Column D13-16 Row 4 divided by Columns D13-16 Row 5
Column E17-20 Row 6 = Column E17-20 Row 4 divided by Columns E17 –20 Row 5
Column F21 Row 6 = Column F21 Row 4 divided by Column F21 Row 5
For every column on the 9002 D, the value in Row 9 is equal to the value in Row 7 divided by the value in Row 8
for that column.
Column A1 Row 9 = Column A1 Row 7 divided by Column A1Row 8
Column A2 Row 9 = Column A2 Row 7divided by Column A2 Row 8
Column A3 Row 9 = Column A3 Row 7 divided by Column A3 Row 8
Column A4 Row 9 = Column A4 Row 7 divided by Column A4 Row 8
Columns B5-8 Row 9 = Columns B5 – 8 Row 7 divided by Columns B 5 – 8 Row 8
Columns C9-12 Row 9 = Columns C9-12 Row 7 divided by Columns C9-12 Row 8
Columns E17-20 Row 9 = Columns E17-20 Row 7 divided by Columns E17 –20 Row 8
Column F21 Row 9 = Column F21 Row 7 divided by Column F21 Row 8
Appendix N: State and National Summary Edit
Checks ETA 9002E (Job Openings
Received) Quarterly Report
For every column on the 9002 E, the value in Row 1 is equal to the sum of the values in Row 11
through Row 92 for that column.
Column A Row 1 = the sum of Rows 11 - 92
Column B Row 1 = the sum of Rows 11 – 92
Column C Row 1 = the sum of Rows 11-92
Column D – W Row 1 = the sum of Rows 11-92
For every row on the 9002 E, the value in Column A is equal to the sum of the values in Column
B through Column X for that row.
Column A Row 1 = the sum of Column B Row 1 thru Column W Row 1
Column A Row 21 = the sum of Columns B Row 11 thru Column W Row 11
Column A Row 22 = the sum of Columns B Row 22 thru Column W Row 22 (23, 31-33, 42,44-
45,48-49,51,52,53,54,55,56,61,62,71,72,81,92)
Appendix O: State and National Summary Edit
Checks ETA VETS 200 A (DVOP),
VETS 200 B (LVER),VETS 200 C
(DVOP / LVER) Quarterly Reports
For Column A Row 1 is equal to or greater than the sum of the values in Column A Row 2 plus Column
A Row 3.
For Column B Row 1 is equal to or greater than the sum of the values in Column B Row 2 plus Column B
Row 3.
Column A Row 1 >= Column A Row 2 + Column A Row 3
Column B Row 1 >= Column B Row 2 + Column B Row 3
For Column A Row 1 is equal to or greater than the sum of the values in Column A Row 4 plus Column
A Row 5 plus Column A Row 6.
For Column B Row 1 is equal to or greater than the sum of the values in Column B Row 4 plus Column B
Row 5 plus Column B Row 6.
Column A Row 1 >= Column A Row 4 + Column A Row 5 + Column A Row 6
Column B Row 1 >= Column B Row 4 + Column B Row 5 + Column B Row 6
For Column A Row 7 is equal to or greater than or equal to the values in Column A Row 8 thru Column
A Row 15.
For Column B Row 7 is equal to or greater than or equal to the values in Column B Row 8 thru Column B
Row 16.
Column A Row 7 >= Column A Row 8 thru Row 15
Column B Row 7 >= Column B Row 8 thru Row 16
For Column A Row 7 value in equal to or greater than Column A Row 1.
Column A Row 7 >= Column A Row 1
For Column B Row 7 value in equal to or greater than Column B Row 1.
Column A Row 7 >= Column A Row
The value in Column A Row 19 is equal to the Column A Row 17 divided by the value in Column A Row
18 multiplied by 100 and rounded to the next whole number.
The value in Column B Row 19 is equal to the Column B Row 17 divided by the value in Column B Row
18 multiplied by 100 and rounded to the next whole number.
Column A Row 19 = Round (Column A Row 17 / Column A Row 18 * 100)
Column B Row 19 = Round (Column B Row 17 / Column B Row 18 * 100)
The value in Column B Row 22 is equal to the Column B Row 20 divided by the value in Column B Row
21 multiplied by 100 and rounded to the next whole number.
The value in Column B Row 25 is equal to the Column B Row 23 divided by the value in Column B Row
24 multiplied by 100 and rounded to the next whole number.
The value in Column B Row 28 is equal to the Column B Row 26 divided by the value in Column B Row
27 multiplied by 100 and rounded to the next whole number.
Column B Row 22 = Round (Column B Row 21 / Column B Row 23 * 100)
Column B Row 25 = Round (Column B Row 23 / Column B Row 24 * 100)
Column B Row 28 = Round (Column B Row 26
What does federal law require today?
This guidance has been rescinded. Ezel checks current federal labor law as it stands now and answers your situation with citations.
Opens in Ezel Pro.
- Checks the law as it stands today, not only this page
- Cites every source it relies on, so you can verify it
- Chat, drafting and research in one workspace