TEGL8-02_Attach.pdf

ETA Advisory File Text

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 Please e-mail to oabina doleta.gov no later than September 30 2002. User s Guide LABOR EXCHANGE 9002 VETS 200 REPORTING SYSTEM 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 E E T T A A 9 9 0 0 0 0 2 2 E E J J o o b b O O p p e e n n i i n n g g s s R R e e c c e e i i v v e e d d Q Q u u a a r r t t e e r r l l y y R R e e p p o o r r t t...........................................................................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 Labor Exchange 9002 VETS Reporting System Page 2 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 3 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 4 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 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 20 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 21 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 22 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 23 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 24 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 25 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 26 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 27 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 28 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 29 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 30 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 31 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 32 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 33 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 34 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 35 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 36 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 37 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 38 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 39 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 40 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 41 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 42 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 43 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 44 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 45 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 46 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 47 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 48 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 49 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 50 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 51 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 52 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 . Appendix A EIMS - Labor Exchange Reporting System - Zero Report Handling Report 1 Report 2 Report 3 ZERO REPORT Report 4 Report 5 900 000 1 000 000 1 000 000 1 100 000 975 000 Q1 Q 2 Q 3 Q 4 Q 2 Q 3 Q 4 Q 5 Q 2 Q 3 Q 4 Q 5 Q 4 Q 5 Q 6 Q 7 Q 5 Q 6 Q 7 Q 8 - This is the example of the Rolling 4 quarters reporting Three quarters of data 3 4 5 would have been included in the report. Therefore the report is off by 1 quarter of data. After fixing the system problem the state reports 4 full quarters of data from the correct quarters. A Zero Report allows the state 45 days from the end of the reporting period which is 45 days after the end of the quarter to fix the problem before or 90 days before the next report is due. Upon certification of Report 4 Report 3 is LOCKED. A state could correct Report 3 before entering and certifying Report 4. This would not be required however. Using the figures above the following chart shows a possible Zero Report scenario and the effect of an un-corrected Zero Report. Registrants by Quarter 0 200 000 400 000 600 000 800 000 1 000 000 1 200 000Report 1 Report 3 ZERO REPORT Report 5 Quarterly Reports RegistrantsRegistrants 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 9 99 2 VA 20011231 200A 99 99 99 99 99 99 9 3 VA 20011231 200A 99 9999 9 99 9 99 4 VA 20011231 200A 99 9 99 9 99 9999 99 5 VA 20011231 200A 99 9999 99 9 99 9 99 6 VA 20011231 200A 9999 99 9 9 99 9 99 7 VA 20011231 200A 9999 99 9999 99 99 9 8 VA 20011231 200A 99 99 9 9 99 9 9 99 9 VA 20011231 200A 99 99 9 99 9999 9999 10 VA 20011231 200A 9999 9999 9999 9999 11 VA 20011231 200A 99 99 9 9 99 9999 99 12 VA 20011231 200A 9999 9999 99 9 99 99 13 VA 20011231 200A 99 9 9 99 99 9 99 99 14 VA 20011231 200A 99 99 9 99 99 9999 99 15 VA 20011231 200A 99 99 9999 9999 99 99 16 VA 20011231 200A 9999 99 9999 17 VA 20011231 200A 99 9 99 99 99 9 99 99 18 VA 20011231 200A 99 9999 9999 99 9999 19 VA 20011231 200A 99 9 99 99 99 9 9 9 20 VA 20011231 200A 9999 9999 99 99 9 21 VA 20011231 200A 9999 9999 99 99 99 22 VA 20011231 200A 99 9 99 99 99 9999 23 VA 20011231 200A 99 99 9 99 99 99 99 24 VA 20011231 200A 9999 9999 99 99 99 25 VA 20011231 200A 9999 9999 99 99 99 26 VA 20011231 200A 99 9 99 99 99 99 99 27 VA 20011231 200A 99 9 9 99 99 9 99 28 VA 20011231 200A 9999 99 99 9 9 9 29 VA 20011231 200A 99 9 9 99 99 9999 99 30 VA 20011231 200A 99 9999 9999 99 99 99 31 VA 20011231 200A 9999 99 99 9 Labor Exchange 9002 VETS Reporting System Page 55 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 9 99 2 VA 20011231 200B 99 99 99 9 99 9 99 3 VA 20011231 200B 99 9 9 9999 99 99 4 VA 20011231 200B 99 9 99 9 9 99 9999 5 VA 20011231 200B 99 9 99 9 99 9999 99 6 VA 20011231 200B 99 9999 99 9 9 99 99 7 VA 20011231 200B 99 9999 99 9 9 99 9 8 VA 20011231 200B 9999 99 9999 99 99 9 9 VA 20011231 200B 99 99 9 9 99 99 9999 10 VA 20011231 200B 99 99 9 9 99 99 9 9 11 VA 20011231 200B 9999 9999 9 9 99 99 12 VA 20011231 200B 99 99 9 9 99 9999 99 13 VA 20011231 200B 99 99 9999 9999 9999 14 VA 20011231 200B 9999 9999 99 99 9 9 15 VA 20011231 200B 99 9 9 99 99 9 9 99 16 VA 20011231 200B 99 9 9 9999 17 VA 20011231 200B 99 9 9 99 99 9999 99 18 VA 20011231 200B 99 9 9 99 99 9 9 99 19 VA 20011231 200B 99 9999 9999 9999 99 20 VA 20011231 200B 9999 9999 99 9 99 21 VA 20011231 200B 99 9 9 99 99 9 99 22 VA 20011231 200B 9999 9999 99 9999 23 VA 20011231 200B 9999 9999 99 99 9 24 VA 20011231 200B 9999 9999 99 99 99 25 VA 20011231 200B 9999 9999 99 99 99 26 VA 20011231 200B 99 9 9 99 99 99 9 27 VA 20011231 200B 9999 9999 99 99 99 28 VA 20011231 200B 99 9 9 99 99 9999 29 VA 20011231 200B 99 9 9 99 99 99 9 99 30 VA 20011231 200B 9999 9999 99 99 99 99 31 VA 20011231 200B 9999 99 9999 Labor Exchange 9002 VETS Reporting System Page 56 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 9 99 2 VA 20011231 200C 99 99 99 99 99 99 9 3 VA 20011231 200C 9999 9 99 9 99 9 4 VA 20011231 200C 99 9 99 9 99 9 99 99 5 VA 20011231 200C 99 9999 9999 99 9 99 6 VA 20011231 200C 99 9 9 99 9 99 9999 7 VA 20011231 200C 99 99 9 99 99 9 99 99 8 VA 20011231 200C 999999 9 9 99 9 99 9 VA 20011231 200C 999999 999999 99 9 10 VA 20011231 200C 99 99 9 9 99 999999 11 VA 20011231 200C 99 99999999 9 9 99 12 VA 20011231 200C 99 99 99999999 9999 13 VA 20011231 200C 99999999 99 9 99 9 14 VA 20011231 200C 99999999 99 9 9 99 15 VA 20011231 200C 99 9 99 9 999999 99 16 VA 20011231 200C 999999 9999 17 VA 20011231 200C 99 99 9 99 9 99 9 99 18 VA 20011231 200C 99 9 99 9 99 9 9 99 19 VA 20011231 200C 99999999 99 999999 20 VA 20011231 200C 99999999 99 99 9 21 VA 20011231 200C 99999999 99 99 99 22 VA 20011231 200C 99999999 99 99 99 23 VA 20011231 200C 99 9 99 9 99 9999 24 VA 20011231 200C 99999999 99 99 99 25 VA 20011231 200C 99 9 99 9 99 99 9 26 VA 20011231 200C 99 9 9 99 99 9 99 27 VA 20011231 200C 99 9 99 9 99 99 99 28 VA 20011231 200C 99 9 9 99 99 9 99 29 VA 20011231 200C 99 99 99 9 99 9 99 99 30 VA 20011231 200C 99999999 99 99 99 99 31 VA 20011231 200C 999999 99 9 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 9 99 99 99 2 MD 20011231 9002A 99 99 9 99 9 99 99 99 99 99 99 99 99 99 9 99 99 99 99 99 3 MD 20011231 9002A 99 99 99 9 99 9 99 99 99 99 99 99 99 99 99 99 9 9 99 99 4 MD 20011231 9002A 99 9 99 9 99 9 9 99 9 9 99 99 99 99 9 9 99 99 99 5 MD 20011231 9002A 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 9 99 99 99 9 6 MD 20011231 9002A 99 99 9 99 9 99 99 99 99 99 99 9 99 9 99 99 99 99 9 99 7 MD 20011231 9002A 99 9 99 9 99 9 9 99 99 99 99 99 99 9 9 99 9 9 99 99 8 MD 20011231 9002A 99 99 99 99 99 99 99 99 99 99 99 9 9 99 99 99 9 9 99 99 9 MD 20011231 9002A 99 9 9 99 9 9 99 9 9 99 99 99 99 99 9 9 9 99 99 99 10 MD 20011231 9002A 99 9 9 99 99 99 99 99 99 99 99 9 9 99 99 9 9 9 99 99 11 MD 20011231 9002A 99 9 9 9 99 9 9 9 99 9 9 99 99 9 9 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 9 99 99 9 13 MD 20011231 9002A 99 9 99 99 9 99 99 99 99 9 99 9 99 9 99 9 99 9 99 99 14 MD 20011231 9002A 99 9 9 99 99 99 99 99 99 99 99 99 99 99 9 9 99 99 99 99 15 MD 20011231 9002A 99 9 9 99 99 99 99 99 99 9 9 99 9 9 99 9 9 99 9 9 16 MD 20011231 9002A 99 9 9 99 9 9 99 99 99 99 9 9 9 99 99 99 99 99 99 99 17 MD 20011231 9002A 99 9 9 9 99 99 99 99 99 99 99 99 99 99 9 9 9 99 99 99 Labor Exchange 9002 VETS Reporting System Page 58 Appendix F Record Layout ETA 9002 B Service to Veterans 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 21 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 9 99 99 2 MD 20011231 9002B 99 9 99 99 9 99 99 99 99 99 99 99 99 99 99 99 9 99 99 99 99 3 MD 20011231 9002B 99 99 99 99 99 99 9 99 9 99 9 99 9 9 99 99 99 9 99 9 99 4 MD 20011231 9002B 99 99 9 9 99 99 99 99 99 99 99 99 99 9 9 99 9 9 99 9 9 5 MD 20011231 9002B 99 9 9 9 99 99 99 99 99 99 99 99 99 99 9 99 99 99 99 99 9 6 MD 20011231 9002B 99 99 99 99 99 99 99 99 9 99 99 99 99 99 99 99 99 99 99 99 99 7 MD 20011231 9002B 99 9 99 99 9 9 9 99 99 99 99 99 9 9 9 99 9 9 9 99 99 8 MD 20011231 9002B 99 99 99 99 99 99 99 99 99 99 9 99 99 9 99 99 99 99 99 99 99 9 MD 20011231 9002B 99 9 9 9 9 99 99 99 99 99 9 99 9 99 99 99 99 99 99 99 99 10 MD 20011231 9002B 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 99 99 99 99 11 MD 20011231 9002B 99 99 9 99 9 99 9 9 9 9 99 9 9 9 9 99 9 99 9 99 99 12 MD 20011231 9002B 99 9 9 9 9 9 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 9 99 9 99 99 99 99 99 99 99 9 99 99 14 MD 20011231 9002B 99 99 99 99 99 99 99 9 99 9 99 99 99 99 99 99 99 99 99 99 99 15 MD 20011231 9002B 99 9 99 9 99 99 9 9 9 9 9 99 99 99 99 99 99 16 MD 20011231 9002B 99 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 Labor Exchange 9002 VETS Reporting System Page 59 Appendix G Record Layout ETA 9002 C Performance Outcomes Job Seekers Employers 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 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 9 99 2 MD 20011231 9002C 99 99 9 99 99 99 99 99 99 99 99 99 99 99 9 99 99 99 9 99 3 MD 20011231 9002C 99 9 99 9 99 9 99 9 99 99 99 99 9 9 99 99 99 9 9 99 4 MD 20011231 9002C 99 99 99 99 9 9 99 99 99 99 99 99 99 9 9 99 9 9 99 5 MD 20011231 9002C 99 9 9 99 9 9 99 9 9 99 9 9 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 9 9 99 99 99 99 99 9 9 9 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 60 Appendix H Record Layout ETA 9002 D Performance Outcomes Veterans 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 21 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 9 99 99 2 MD 20011231 9002D 99 9 99 99 99 99 9 99 99 99 99 99 99 9 99 9 99 9 99 9 9 3 MD 20011231 9002D 99 99 99 99 99 99 99 9 99 9 99 99 99 99 9 9 99 99 99 9 99 4 MD 20011231 9002D 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 9 99 99 99 99 5 MD 20011231 9002D 99 9 9 99 99 99 99 9 9 99 9 9 99 99 99 99 99 99 99 99 99 6 MD 20011231 9002D 99 9 9 99 9 9 99 9 9 99 9 9 99 99 99 99 99 99 99 99 99 7 MD 20011231 9002D 99 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 99 8 MD 20011231 9002D 99 9 9 9 99 9 9 9 99 9 9 9 99 99 99 99 99 9 9 9 99 9 MD 20011231 9002D 99 9 99 9 9 9 99 9 9 9 99 99 99 99 99 99 99 Labor Exchange 9002 VETS Reporting System Page 61 Appendix I Record Layout ETA 9002 E Job Openings Received 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 21 22 23 241 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 9 99 99 9 99 99 2 MD 20011231 9002E 99 9 99 99 99 99 9 99 9 99 9 99 9 9 99 99 99 99 99 99 99 99 99 9 3 MD 20011231 9002E 99 99 99 9 99 9 99 99 99 99 9 9 99 99 99 99 99 99 9 9 99 99 99 99 4 MD 20011231 9002E 99 99 99 99 9 9 99 9 9 99 9 9 99 9 9 99 9 9 99 9 9 99 99 99 5 MD 20011231 9002E 99 9 9 9 99 99 99 99 9 9 9 99 9 9 9 99 99 99 99 99 99 99 99 99 6 MD 20011231 9002E 99 99 99 99 99 9 9 99 9 9 9 99 99 99 99 99 99 99 99 9 9 9 99 99 7 MD 20011231 9002E 99 9 9 9 99 9 9 9 99 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 8 MD 20011231 9002E 99 9 9 9 99 99 99 99 99 9 9 9 99 99 9 9 9 9 99 99 99 99 99 9 9 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 99 99 99 99 9 9 9 99 99 10 MD 20011231 9002E 99 9 9 9 9 99 9 9 9 99 99 99 99 99 99 99 99 99 99 9 9 9 99 99 11 MD 20011231 9002E 99 9 9 9 9 99 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 12 MD 20011231 9002E 99 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 99 99 99 13 MD 20011231 9002E 99 99 99 99 99 99 99 9 9 9 99 99 99 9 9 9 9 99 99 99 99 99 99 99 14 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 99 9 9 9 9 99 99 99 15 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 9 99 99 99 99 99 99 16 MD 20011231 9002E 99 9 9 9 99 99 99 9 9 9 99 99 99 99 99 99 99 9 9 9 99 99 99 99 17 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 9 99 99 99 99 18 MD 20011231 9002E 99 99 99 99 99 99 99 99 99 99 99 99 9 9 9 9 99 9 99 9 9 9 9 99 19 MD 20011231 9002E 99 99 99 99 99 99 99 9 9 9 99 99 99 99 99 99 99 99 99 99 9 9 9 9 20 MD 20011231 9002E 99 99 99 99 99 99 99 9 9 9 99 99 9 9 9 99 99 99 99 9 9 9 9 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 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 Labor Exchange 9002 VETS Reporting System 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 Labor Exchange 9002 VETS Reporting System 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 Labor Exchange 9002 VETS Reporting System 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 Labor Exchange 9002 VETS Reporting System Appendix N State and National Summary Edit Checks E E T T A A 9 9 0 0 0 0 2 2 E E J J o o b b O O p p e e n n i i n n g g s s R R e e c c e e i i v v e e d d Q Q u u a a r r t t e e r r l l y y R R e e p p o o r r t t 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 Labor Exchange 9002 VETS Reporting System 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