Program Performance Report (Private Sector) IC (ETA- 9173)

DOL-Only Performance Accountability, Information, and Reporting System

Apprenticeship QPR Template and Specifications CLEAN 12.6.24.xlsx

Program Performance Report (Private Sector) IC (ETA- 9173)

OMB: 1205-0521

Document [xlsx]
Download: xlsx | pdf

Overview

NEW - AP Adult QPR
AP Adult Specifications
NEW - AP Youth QPR
AP Youth Specifications


Sheet 1: NEW - AP Adult QPR


OMB Control Number: 1205-0521




Expiration Date: 03/31/2027



Date of Report:

ETA-9173-APPSHP

PY 20xx Qtr x Performance Report for Apprenticeship



REPORT OVERVIEW



Grant Overview Item Grant Overview Item Response Time Period:
(choose only one)
REPORTING PERIOD COVERED:

Submitter Name: [Grantee Response] o Quarterly mm/dd/yyyy - mm/dd/yyyy

State: [Grantee Response] o Rolling 4 Quarters

Submitter Contact Information: [Grantee Response] o Program to Date

Grant Number: [Grantee Response]


Grant Name: [Grantee Response]


A. SUMMARY INFORMATION



Performance Items Cohort Period Total Current Period Program to Date

1. Total Participants mm/dd/yyyy - mm/dd/yyyy A-1-1 A-1-2

1a. Total Pre-Apprentices mm/dd/yyyy - mm/dd/yyyy A-1a-1 A-1a-2

1b. Total Apprentices mm/dd/yyyy - mm/dd/yyyy A-1b-1 A-1b-2

1c. Total Incumbent Apprentices mm/dd/yyyy - mm/dd/yyyy A-1c-1 A-1c-2

2. Total Reportable Individuals mm/dd/yyyy - mm/dd/yyyy A-2-1 A-2-2

3. Total Exiters mm/dd/yyyy - mm/dd/yyyy A-3-1 A-3-2

B. PARTICIPANT SUMMARY INFORMATION (Cohort Period: mm/dd/yyyy - mm/dd/yyyy)



B.1. SEX



Performance Items Cohort Period Total Current Period Program to Date

1a. Male mm/dd/yyyy - mm/dd/yyyy B-1a-1 B-1a-2

1b. Female mm/dd/yyyy - mm/dd/yyyy B-1b-1 B-1b-2

B.2. Ethnicity/Race



Performance Items Cohort Period Total Current Period Program to Date

2a. Hispanic/Latino mm/dd/yyyy - mm/dd/yyyy B-2a-1 B-2a-2

2b. American Indian or Alaska Native mm/dd/yyyy - mm/dd/yyyy B-2b-1 B-2b-2

2c. Asian mm/dd/yyyy - mm/dd/yyyy B-2c-1 B-2c-2

2d. Black or African American mm/dd/yyyy - mm/dd/yyyy B-2d-1 B-2d-2

2e. Middle Eastern or North African mm/dd/yyyy - mm/dd/yyyy B-2e-1 B-2e-2

2f. Native Hawaiian or Other Pacific Islander mm/dd/yyyy - mm/dd/yyyy B-2f-1 B-2f-2

2g. White mm/dd/yyyy - mm/dd/yyyy B-2g-1 B-2g-2

2h. Multiracial and/or Multiethnic mm/dd/yyyy - mm/dd/yyyy B-2h-1 B-2h-2

B.3. Education Level



Performance Items Cohort Period Total Current Period Program to Date

3a. In Secondary School or Equivalency Program mm/dd/yyyy - mm/dd/yyyy B-3a-1 B-3a-2

3b. Secondary School Graduate or Equivalent mm/dd/yyyy - mm/dd/yyyy B-3b-1 B-3b-2

3c. Completed 1 or More Years of Postsecondary Education mm/dd/yyyy - mm/dd/yyyy B-3c-1 B-3c-2

3d. Postsecondary Certification, License, or Educational Certificate (Non-Degree) mm/dd/yyyy - mm/dd/yyyy B-3d-1 B-3d-2

3e. Associate's Degree mm/dd/yyyy - mm/dd/yyyy B-3e-1 B-3e-2

3f. Bachelor's Degree or Equivalent mm/dd/yyyy - mm/dd/yyyy B-3f-1 B-3f-2

3g. Advanced Degree Beyond Bachelor's Degree mm/dd/yyyy - mm/dd/yyyy B-3g-1 B-3g-2

B.4. Other Demographics



Performance Items Cohort Period Total Current Period Program to Date

4a. Youth and Young Adults, Ages 16-24 mm/dd/yyyy - mm/dd/yyyy B-4a-1 B-4a-2

4b. Adults, Ages 25-54 mm/dd/yyyy - mm/dd/yyyy B-4b-1 B-4b-2

4c. Older Adults, Ages 55+ mm/dd/yyyy - mm/dd/yyyy B-4c-1 B-4c-2

4d. Out-of-School Youth mm/dd/yyyy - mm/dd/yyyy B-4d-1 B-4d-2

4e. Individuals with a Disability mm/dd/yyyy - mm/dd/yyyy B-4e-1 B-4e-2

4f. Veterans mm/dd/yyyy - mm/dd/yyyy B-4f-1 B-4f-2

B.5. Employment Status
at Participation




Performance Items Cohort Period Total Current Period Program to Date

5a. Unemployed Individuals mm/dd/yyyy - mm/dd/yyyy B-5a-1 B-5a-2

5b. Long-Term Unemployed (27 or More Consecutive Weeks) mm/dd/yyyy - mm/dd/yyyy B-5b-1 B-5b-2

5c. Incumbent Workers mm/dd/yyyy - mm/dd/yyyy B-5c-1 B-5c-2
5d. Employed mm/dd/yyyy - mm/dd/yyyy B-5d-1 B-5d-2

C. WIOA PRIMARY INDICATORS OF PERFORMANCE



Performance Items Cohort Period Total Current Period Program to Date

1a. Employment Rate (Q2) mm/dd/yyyy - mm/dd/yyyy C-1-1 C-1-2

2a. Employment Rate (Q4) mm/dd/yyyy - mm/dd/yyyy C-2-1 C-2-2

3a. Median Earnings mm/dd/yyyy - mm/dd/yyyy C-3-1 C-3-2

4. Credential Rate mm/dd/yyyy - mm/dd/yyyy C-4-1 C-4-2

5. Measurable Skill Gains mm/dd/yyyy - mm/dd/yyyy C-5-1 C-5-2

6a. Retention with the Same Employer in the 2nd and 4th Quarter After Exit mm/dd/yyyy - mm/dd/yyyy C-6-1 C-6-2

D. OTHER OUTCOMES



Performance Items Cohort Period Total Current Period Program to Date

1. Average Wage at Exit mm/dd/yyyy - mm/dd/yyyy D-1-1 D-1-2

2. Q2 Post-Exit Training-Related Employment mm/dd/yyyy - mm/dd/yyyy D-2-1 D-2-2

4. Total Participants Who Received a Degree/Credential mm/dd/yyyy - mm/dd/yyyy D-4-1 D-4-2

E. SUPPORTIVE SERVICES



E.1. Received Supportive Services



Performance Items Cohort Period Total Current Period Program to Date

1a. Childcare mm/dd/yyyy - mm/dd/yyyy E-1a-1 E-1a-2

1b. Tools/Equipment mm/dd/yyyy - mm/dd/yyyy E-1b-1 E-1b-2

1c. Transportation mm/dd/yyyy - mm/dd/yyyy E-1c-1 E-1c-2

1d. Uniforms mm/dd/yyyy - mm/dd/yyyy E-1d-1 E-1d-2

1e. Other Supportive Services mm/dd/yyyy - mm/dd/yyyy E-1e-1 E-1e-2

E.2. Supportive Services Provider



Performance Items Cohort Period Total Current Period Program to Date

2a.Grantee or sub-recipient/local project mm/dd/yyyy - mm/dd/yyyy E-2a-1 E-2a-2

2b.Workforce partner mm/dd/yyyy - mm/dd/yyyy E-2b-1 E-2b-2

2c. Both: Grantee or sub-recipient/local project and Workforce partner mm/dd/yyyy - mm/dd/yyyy E-2c-1 E-2c-2

2d. Other mm/dd/yyyy - mm/dd/yyyy E-2d-1 E-2d-2

F. REGISTERED APPRENTICESHIP PARTICIPATION



F.1. Pre-apprenticeship Status



Performance Items Cohort Period Total Current Period Program to Date

1a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-1a-1 F-1a-2

1b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-1b-1 F-1b-2

1c. Completed, has not continued into Registered Apprenticeship Program (RAP) mm/dd/yyyy - mm/dd/yyyy F-1c-1 F-1c-2

1d. Completed, continued into RAP mm/dd/yyyy - mm/dd/yyyy F-1d-1 F-1d-2

1e. In Pre-Apprenticeship Program with an Articulated Agreement mm/dd/yyyy - mm/dd/yyyy F-1e-1 F-2e-2

F.2. Registered Apprenticeship Program Status



Performance Items Cohort Period Total Current Period Program to Date

2a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-2a-1 F-2a-2

2b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-2b-1 F-2b-2

2c. Completed mm/dd/yyyy - mm/dd/yyyy F-2c-1 F-2c-2

F.3. Incumbent Registered Apprenticeship Program Status



Performance Items Cohort Period Total Current Period Program to Date

3a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-3a-1 F-3a-2

3b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-3b-1 F-3b-2

3c. Completed mm/dd/yyyy - mm/dd/yyyy F-3c-1 F-3c-2

F.4. Type of Registered Apprenticeship Program Training Approach



Performance Items Cohort Period Total Current Period Program to Date

4a. Time-Based mm/dd/yyyy - mm/dd/yyyy F-4a-1 F-4a-2

4b. Competency-Based mm/dd/yyyy - mm/dd/yyyy F-4b-1 F-4b-2

4c. Hybrid mm/dd/yyyy - mm/dd/yyyy F-4c-1 F-4c-2

F.5. Type of Related Training Instruction (RTI) Provider



Performance Items Cohort Period Total Current Period Program to Date

5a. Joint Apprenticeship Training Committee mm/dd/yyyy - mm/dd/yyyy F-5a-1 F-5a-2

5b. Community College mm/dd/yyyy - mm/dd/yyyy F-5b-1 F-5b-2

5c. Vocational/Technical School mm/dd/yyyy - mm/dd/yyyy F-5c-1 F-5c-2

5d. Four-Year Educational Institution mm/dd/yyyy - mm/dd/yyyy F-5d-1 F-5d-2

5e. Other mm/dd/yyyy - mm/dd/yyyy F-5e-1 F-5d-2






*When available, DOL/ETA will match wage records on behalf of grantees in order to capture these employment-based outcome measures for participants that have successfully exited the program benig reported for. These outcome measures are dependent on the participant-level data that grantees submit on a quarterly basis; however, these outcome measures will be populated after the QPR is certified by the grantee. The outcome data reported in these fields are not included in the performance data that grantees submit and certify for the purposes of quarterly reporting. Grantees do not need to certify this DOL-populated data.













Sheet 2: AP Adult Specifications



APPRENTICESHIP - ADULT QPR SPECIFICATIONS


Report Item No. Identifier (Definition) Technical Specifications - Total Current Period

A. SUMMARY INFORMATION A-1-1 Total Participants Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3)
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1a-1 Total Pre-Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND Pre-Apprenticeship Program Status [PIRL 2901] > 0
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1b-1 Total Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND Apprenticeship Program Status [PIRL 2907] > 0
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1c-1 Total Incumbent Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND Apprenticeship Program Status [PIRL 2907] is NOT null
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-2-1 Total Reportable Individuals Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND (DATE OF MOST RECENT REPORTABLE INDIVIDUAL CONTACT [PIRL 1007] => beginning of the reporting period))

A-3-1 Total Exiters Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] < the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period))

B. PARTICIPANT SUMMARY INFORMATION B-1a-1 Male Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SEX [PIRL 201] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-1b-1 Female Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SEX [PIRL 201] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))
B-2a-1 Hispanic/Latino Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HISPANIC/LATINO [PIRL 210] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2b-1 American Indian or Alaska Native Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((AMERICAN INDIAN/ALASKA NATIVE [PIRL 211] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901]is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2c-1 Asian Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((ASIAN [PIRL 212] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2d-1 Black or African American Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((BLACK OR AFRICAN AMERICAN [PIRL 213] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2e-1 Middle Eastern or North African Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((MIDDLE EASTERN OR NORTH AFRICAN [PIRL 21x] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2f-1 Native Hawaiian or Other Pacific Islander Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER [PIRL 214] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2g-1 White Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((WHITE [PIRL 215]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2h-1 Multiracial and/or Multiethnic Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((two or more of PIRL 210, 211, 212, 213, 214, 215 = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period))

B-3a-1 In Secondary School or Equivalency Program Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SCHOOL STATUS AT PROGRAM ENTRY [PIRL 409] = 1 OR 2 OR 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3b-1 Secondary School Graduate or Equivalent Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 1 OR 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3c-1 Completed 1 or more years of Postsecondary Education Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3d-1 Postsecondary Certification, License, or Educational Certificate (non-degree) Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 5) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901]is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3e-1 Associate's Degree Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 6) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3f-1 Bachelor's Degree or Equivalent Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 7) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3g-1 Advanced Degree Beyond Bachelor's Degree Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 8) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4a-1 Youth and Young Adults, Ages 16-24 Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null) AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] >= 16 years AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] < 25 years))

B-4b-1 Adults, Ages 25-54 Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)) AND ((DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] >= 25 years) AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] < 55 years))

B-4c-1 Older Adults, Ages 55+ Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)) AND ((DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] => 55 years)

B-4d-1 Out-of-School Youth Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((SCHOOL STATUS AT PROGRAM ENTRY [PIRL 409] = 4 OR 5 OR 6) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= then end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4d-1 Individuals with a Disability Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((INDIVIDUAL WITH A DISABILITY [PIRL 202] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND( DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4e-1 Veterans Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((VETERAN STATUS [PIRL 300] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5a-1 Unemployed Individuals Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PROGRAM ENTRY [PIRL 400] = 0) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5b-1 Long-Term Unemployed (27 or More Consecutive Weeks) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((LONG-TERM UNEMPLOYED AT PROGRAM ENTRY [PIRL 402]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5c-1 Incumbent Workers Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PARTICIPATION [PIRL 400] = 1 or 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5e-1 Employed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PROGRAM ENTRY [PIRL 400] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

C. WIOA PRIMARY INDICATORS OF PERFORMANCE C-1-1 Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from Employment Rate (Q2) DENOMINATOR where (EMPLOYED 2ND QUARTER AFTER EXIT QUARTER [PIRL 1602] > 0 and < 9)
divided by
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and Date of Program Exit [PIRL 901] is within the report period and OTHER REASON FOR EXIT [PIRL 923] = 00


C-2-1 Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from Employment Rate (Q4) DENOMINATOR where (EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] > 0 and < 9)
divided by
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and Date of Program Exit is within the report period and OTHER REASON FOR EXIT = 00


C-3-1 Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) The value of WAGES 2ND QUARTER AFTER EXIT QUARTER [PIRL 1704] that is the mid-point between the value of the lowest wage reported and the value of the highest wage reported for the UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and (WAGES 2ND QUARTER AFTER THE EXIT QUARTER [PIRL 1704] > 0 and WAGES 2ND QUARTER AFTER THE EXIT QUARTER [PIRL 1704] < 999999.99) and Date of Program Exit [PIRL 901] is within the reporting period and OTHER REASON FOR EXIT [PIRL 923] = 00

C-4-1 Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from CREDENTIAL RATE DENOMINATOR where (DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND
1) ((TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] > 1) or (TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] > 1) or (TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] > 1)) or
2) (TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1)) OR (DATE ATTAINED RECOGNIZED CREDENTIAL #2 [PIRL 1803] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] = 1)) OR (DATE ATTAINED RECOGNIZED CREDENTIAL #3 [PIRL 1805] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] = 1)) AND a) (DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL [PIRL 1406] – DATE OF PROGRAM EXIT [PIRL 901] <=365 or b) EMPLOYED 1ST QUARTER AFTER EXIT QUARTER [PIRL 1600] is (>= 0 AND < 9) or c) Employed 2nd Quarter After Exit Quarter [PIRL 1602] is (>= 0 AND < 9) or d) EMPLOYED 3RD QUARTER AFTER EXIT QUARTER [PIRL 1604] is (>= 0 AND < 9) or e) EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] is (>= 0 AND < 9))
divided by Count of UNIQUE RECORDS Where ( APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND Apprenticeship Programs Grants Status [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM EXIT [PIRL 901] is within the report period AND Other Reason for Exit [PIRL 923] is 00)


C-5-1 Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from MEASURABLE SKILLS GAIN DENOMINATOR where 1) Date of Most Recent Measurable skill gain: Educational Functioning Level (EFL) [PIRL 1806] is within the reporting period or 2) DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1 or DATE ATTAINED RECOGNIZED CREDENTIAL #2 [PIRL 1803] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1802] = 1 or DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1805] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1804] = 1 or 3) DATE OF MOST RECENT MEASURABLE SKILL GAINS: SECONDARY TRANSCRIPT/REPORT CARD [PIRL 1808] is within the reporting period or 4) DATE OF MOST RECENT MEASURABLE SKILL GAINS: POSTSECONDARY TRANSCRIPT/REPORT CARD [PIRL 1807] is within the reporting period or 5) DATE OF MOST RECENT MEASURABLE SKILL GAINS: TRAINING MILESTONE [PIRL 1809] is within the reporting period or 6) DATE OF MOST RECENT MEASURABLE SKILL GAINS: SKILLS PROGRESSION [PIRL 1810] is within the reporting period divided by Count of UNIQUE RECORDS Where ( APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND Apprenticeship Programs Grants Status [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is null or within the report period) AND (Other Reason for Exit [PIRL 923] = 00))



C-6-1 Retention with the Same Employer in the 2nd AND 4th Quarter After Exit Count of UNIQUE RECORDS from RETENTION WITH SAME EMPLOYER IN THE 2ND AND 4TH QUARTERS AFTER EXIT DENOMINATOR where (RETENTION WITH SAME EMPLOYER IN THE 2ND AND 4TH QUARTERS (WIOA) [PIRL 1618 ] = 1) DIVIDED BY Count of UNIQUE RECORDS from APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period AND Other Reasons For Exit (WIOA) [PIRL 923] = 00 AND (Employed 2nd Quarter After Exit Quarter (WIOA)[PIRL 1602] is > 0 AND < 9)

D. OTHER OUTCOMES D-1-1 Average Wage at Exit SUM of EXIT WAGE [PIRL 2917] for all records where (((APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND (APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 2 or 3) AND (DATE OF PROGRAM EXIT [PIRL 901] => beginning of the report period))) DIVIDED BY (Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period)


D-2-1 Q2 Post-Exit Training-Related Employment Count of UNIQUE RECORDS where A(APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 3) AND (Date completed Apprenticeship [PIRL 2911] is not null AND
DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period) AND (Employment related to training (2nd quarter after exit) [PIRL 1608]= 1))



D-3-1 Total Participants Who Received a Degree/Credential Count of UNIQUE RECORDS where (DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1)) AND a) (DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL [PIRL 1406] – DATE OF PROGRAM EXIT [PIRL 901] <=365 or b) EMPLOYED 1ST QUARTER AFTER EXIT QUARTER [PIRL 1600] is (>= 0 AND < 9) or c) Employed 2nd Quarter After Exit Quarter [PIRL 1602] is (>= 0 AND < 9) or d) EMPLOYED 3RD QUARTER AFTER EXIT QUARTER [PIRL 1604] is (>= 0 AND < 9) or e) EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] is (>= 0 AND < 9)) AND (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM EXIT [PIRL 901] is within the report period


E. SUPPORTIVE SERVICES E-1a-1 Received Supportive Services - Childcare Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND ((Type of Supportive Services Received [PIRL 2913] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1b-1 Received Supportive Services - Tools/Equipment Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)

E-1c-1 Received Supportive Services - Transportation Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1d-1 Received Supportive Services - Uniforms Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1e-1 Received Supportive Services - Other
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 5) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))


E-2a-1 Grantee or sub-recipient/local project Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SUPPORTIVE SERVICE PROVIDER [PIRL 2830 ] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))


E-2b-1 Workforce partner Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SUPPORTIVE SERVICE PROVIDER [PIRL 2830 ] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))


E-2c-1 Both: Grantee or sub-recipient/local project and Workforce partner Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SUPPORTIVE SERVICE PROVIDER [PIRL 2830 ] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))


E-2d-1 Other Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SUPPORTIVE SERVICE PROVIDER [PIRL 2830 ] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F. APPRENTICESHIP PARTICIPATION F-1a-1 Pre-apprenticeship Status - Enrolled Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 1) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is not null) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the report period))

F-1b-1 Pre-apprenticeship Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null AND DATE OF PROGRAM EXIT [PIRL 900] is within the report period))

F-1c-1 Pre-apprenticeship Status - Completed, has not continued into RAP Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 3) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is within the reporting period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null)

F-1d-1 Pre-apprenticeship Status - Completed, continued into RAP Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 4) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE CHANGED STATUS FROM PRE-APPRENTICE TO APPRENTICE [PIRL 2906] is withing the reporting period)

F-1e-1 Enrolled in Pre-Apprenticeship with Articulated Agreement Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 1) AND (PRE-APPRENTICESHIP PROGRAM WITH AN ARTICULATED AGREEMENT [PIRL 2904] = 1) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null)(DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is within the report period))

F-2a-1 Registered Apprenticeship Program Status - Enrolled Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 1) AND (TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is within the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-2b-1 Registered Apprenticeship Program Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 2) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 900] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null))

F-2c-1 Registered Apprenticeship Program Status - Completed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 3) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is not null) AND (DATE COMPLETED APPRENTICESHIP [PIRL 2911] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-3a-1 Incumbent Registered Apprenticeship Status - Enrolled (Transitioned from an Expired Grant Program) Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 1) AND (TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-3b-1 Incumbent Registered Apprenticeship Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 2) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 900] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null))

F-3c-1 Incumbent Registered Apprenticeship Status - Completed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 3) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is not null) AND (DATE COMPLETED APPRENTICESHIP [PIRL 2911] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-3a-1 Type of Registered Apprenticeship Program Training Approach - Time-Based Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-3b-1 Type of Registered Apprenticeship Program Training Approach - Competency Based Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-3c-1 Type of Registered Apprenticeship Program Training Approach - Hybrid Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4a-1 Type of RTI Provider - Joint Apprenticeship Training Committee Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4b-1 Type of RTI Provider - Community College Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4c-1 Type of RTI Provider - Vocational/Technical School Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4d-1 Type of RTI Provider - Four-Year Educational Institution Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4e-1 Type of RTI Provider - Other
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 5) AND (DATE OF PROGRAM ENTRY+D80:D81 [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))














Sheet 3: NEW - AP Youth QPR


OMB Control Number: 1205-0521




Expiration Date: 03/31/2027



Date of Report:

ETA-9173-APPSHP

PY 20xx Qtr x Performance Report for Apprenticeship Youth



REPORT OVERVIEW



Grant Overview Item Grant Overview Item Response Time Period:
(choose only one)
REPORTING PERIOD COVERED:

Submitter Name: [Grantee Response] o Quarterly mm/dd/yyyy - mm/dd/yyyy

State: [Grantee Response] o Rolling 4 Quarters

Submitter Contact Information: [Grantee Response] o Program to Date

Grant Number: [Grantee Response]


Grant Name: [Grantee Response]


A. SUMMARY INFORMATION



Performance Items Cohort Period Total Current Period Program to Date

1. Total Participants mm/dd/yyyy - mm/dd/yyyy A-1-1 A-1-2

1a. Total Pre-Apprentices mm/dd/yyyy - mm/dd/yyyy A-1a-1 A-1a-2

1b. Total Apprentices mm/dd/yyyy - mm/dd/yyyy A-1b-1 A-1b-2

1c. Total Incumbent Apprentices mm/dd/yyyy - mm/dd/yyyy A-1c-1 A-1c-2

2. Total Reportable Individuals mm/dd/yyyy - mm/dd/yyyy A-2-1 A-2-2

3. Total Exiters mm/dd/yyyy - mm/dd/yyyy A-3-1 A-3-2

B. PARTICIPANT SUMMARY INFORMATION (Cohort Period: mm/dd/yyyy - mm/dd/yyyy)



B.1. SEX



Performance Items Cohort Period Total Current Period Program to Date

1a. Male mm/dd/yyyy - mm/dd/yyyy B-1a-1 B-1a-2

1b. Female mm/dd/yyyy - mm/dd/yyyy B-1b-1 B-1b-2

B.2. Ethnicity/Race



Performance Items Cohort Period Total Current Period Program to Date

2a. Hispanic/Latino mm/dd/yyyy - mm/dd/yyyy B-2a-1 B-2a-2

2b. American Indian or Alaska Native mm/dd/yyyy - mm/dd/yyyy B-2b-1 B-2b-2

2c. Asian mm/dd/yyyy - mm/dd/yyyy B-2c-1 B-2c-2

2d. Black or African American mm/dd/yyyy - mm/dd/yyyy B-2d-1 B-2d-2

2e. Middle Eastern or North African mm/dd/yyyy - mm/dd/yyyy B-2e-1 B-2e-2

2f. Native Hawaiian or Other Pacific Islander mm/dd/yyyy - mm/dd/yyyy B-2f-1 B-2f-2

2g. White mm/dd/yyyy - mm/dd/yyyy B-2g-1 B-2g-2

2h. Multiracial and/or Multiethnic mm/dd/yyyy - mm/dd/yyyy B-2h-1 B-2h-2

B.3. Education Level



Performance Items Cohort Period Total Current Period Program to Date

3a. In Secondary School or Equivalency Program mm/dd/yyyy - mm/dd/yyyy B-3a-1 B-3a-2

3b. Secondary School Graduate or Equivalent mm/dd/yyyy - mm/dd/yyyy B-3b-1 B-3b-2

3c. Completed 1 or More Years of Postsecondary Education mm/dd/yyyy - mm/dd/yyyy B-3c-1 B-3c-2

3d. Postsecondary Certification, License, or Educational Certificate (Non-Degree) mm/dd/yyyy - mm/dd/yyyy B-3d-1 B-3d-2

3e. Associate's Degree mm/dd/yyyy - mm/dd/yyyy B-3e-1 B-3e-2

3f. Bachelor's Degree or Equivalent mm/dd/yyyy - mm/dd/yyyy B-3f-1 B-3f-2

3g. Advanced Degree Beyond Bachelor's Degree mm/dd/yyyy - mm/dd/yyyy B-3g-1 B-3g-2

B.4. Other Demographics



Performance Items Cohort Period Total Current Period Program to Date

4a. Youth and Young Adults, Ages 16-24 mm/dd/yyyy - mm/dd/yyyy B-4a-1 B-4a-2

4b. Adults, Ages 25-54 mm/dd/yyyy - mm/dd/yyyy B-4b-1 B-4b-2

4c. Older Adults, Ages 55+ mm/dd/yyyy - mm/dd/yyyy B-4c-1 B-4c-2

4d. Individuals with a Disability mm/dd/yyyy - mm/dd/yyyy B-4d-1 B-4d-2

4e. Veterans mm/dd/yyyy - mm/dd/yyyy B-4e-1 B-4e-2

B.5. Employment Status
at Participation




Performance Items Cohort Period Total Current Period Program to Date

5a. Unemployed Individuals mm/dd/yyyy - mm/dd/yyyy B-5a-1 B-5a-2

5b. Long-Term Unemployed (27 or More Consecutive Weeks) mm/dd/yyyy - mm/dd/yyyy B-5b-1 B-5b-2

5c. Incumbent Workers mm/dd/yyyy - mm/dd/yyyy B-5c-1 B-5c-2
5d. Employed mm/dd/yyyy - mm/dd/yyyy B-5d-1 B-5d-2

C. WIOA PRIMARY INDICATORS OF PERFORMANCE



Performance Items Cohort Period Total Current Period Program to Date

1a. Education and Employment Rate (Q2) mm/dd/yyyy - mm/dd/yyyy C-1-1 C-1-2

2a. Education and Employment Rate (Q4) mm/dd/yyyy - mm/dd/yyyy C-2-1 C-2-2

3a. Median Earnings mm/dd/yyyy - mm/dd/yyyy C-3-1 C-3-2

4. Credential Rate mm/dd/yyyy - mm/dd/yyyy C-4-1 C-4-2

5. Measurable Skill Gains mm/dd/yyyy - mm/dd/yyyy C-5-1 C-5-2

6a. Retention with the Same Employer in the 2nd and 4th Quarter After Exit mm/dd/yyyy - mm/dd/yyyy C-6-1 C-6-2

D. OTHER OUTCOMES



Performance Items Cohort Period Total Current Period Program to Date

1. Average Wage at Exit mm/dd/yyyy - mm/dd/yyyy D-1-1 D-1-2

2. Q2 Post-Exit Training-Related Employment mm/dd/yyyy - mm/dd/yyyy D-2-1 D-2-2

4. Total Participants Who Received a Degree/Credential mm/dd/yyyy - mm/dd/yyyy D-4-1 D-4-2

E. SUPPORTIVE SERVICES



E.1. Received Supportive Services



Performance Items Cohort Period Total Current Period Program to Date

1a. Childcare mm/dd/yyyy - mm/dd/yyyy E-1a-1 E-1a-2

1b. Tools/Equipment mm/dd/yyyy - mm/dd/yyyy E-1b-1 E-1b-2

1c. Transportation mm/dd/yyyy - mm/dd/yyyy E-1c-1 E-1c-2

1d. Uniforms mm/dd/yyyy - mm/dd/yyyy E-1d-1 E-1d-2

1e. Other Supportive Services mm/dd/yyyy - mm/dd/yyyy E-1e-1 E-1e-2

F. REGISTERED APPRENTICESHIP PARTICIPATION



F.1. Pre-apprenticeship Status



Performance Items Cohort Period Total Current Period Program to Date

1a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-1a-1 F-1a-2

1b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-1b-1 F-1b-2

1c. Completed, has not continued into Registered Apprenticeship Program (RAP) mm/dd/yyyy - mm/dd/yyyy F-1c-1 F-1c-2

1d. Completed, continued into RAP mm/dd/yyyy - mm/dd/yyyy F-1d-1 F-1d-2

1e. In Pre-Apprenticeship Program with an Articulated Agreement mm/dd/yyyy - mm/dd/yyyy F-1e-1 F-2e-2

F.2. Registered Apprenticeship Status



Performance Items Cohort Period Total Current Period Program to Date

2a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-2a-1 F-2a-2

2b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-2b-1 F-2b-2

2c. Completed mm/dd/yyyy - mm/dd/yyyy F-2c-1 F-2c-2

F.3. Incumbent Registered Apprenticeship Status



Performance Items Cohort Period Total Current Period Program to Date

3a. Enrolled mm/dd/yyyy - mm/dd/yyyy F-3a-1 F-3a-2

3b. Cancelled or Withdrew mm/dd/yyyy - mm/dd/yyyy F-3b-1 F-3b-2

3c. Completed mm/dd/yyyy - mm/dd/yyyy F-3c-1 F-3c-2

F.4. Type of Registered Apprenticeship Program Training Approach



Performance Items Cohort Period Total Current Period Program to Date

4a. Time-Based mm/dd/yyyy - mm/dd/yyyy F-4a-1 F-4a-2

4b. Competency-Based mm/dd/yyyy - mm/dd/yyyy F-4b-1 F-4b-2

4c. Hybrid mm/dd/yyyy - mm/dd/yyyy F-4c-1 F-4c-2

F.5. Type of Related Training Instruction (RTI) Provider



Performance Items Cohort Period Total Current Period Program to Date

5a. Joint Apprenticeship Training Committee mm/dd/yyyy - mm/dd/yyyy F-5a-1 F-5a-2

5b. Community College mm/dd/yyyy - mm/dd/yyyy F-5b-1 F-5b-2

5c. Vocational/Technical School mm/dd/yyyy - mm/dd/yyyy F-5c-1 F-5c-2

5d. Four-Year Educational Institution mm/dd/yyyy - mm/dd/yyyy F-5d-1 F-5d-2

5e. Other mm/dd/yyyy - mm/dd/yyyy F-5e-1 F-5d-2






*When available, DOL/ETA will match wage records on behalf of grantees in order to capture these employment-based outcome measures for participants that have successfully exited the program benig reported for. These outcome measures are dependent on the participant-level data that grantees submit on a quarterly basis; however, these outcome measures will be populated after the QPR is certified by the grantee. The outcome data reported in these fields are not included in the performance data that grantees submit and certify for the purposes of quarterly reporting. Grantees do not need to certify this DOL-populated data.












Sheet 4: AP Youth Specifications



APPRENTICESHIP - YOUTH QPR SPECIFICATIONS


Report Item No. Identifier (Definition) Technical Specifications - Total Current Period

A. SUMMARY INFORMATION A-1-1 Total Participants Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3)
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1a-1 Total Pre-Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND Pre-Apprenticeship Program Status [PIRL 2901] > 0
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1b-1 Total Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND Apprenticeship Program Status [PIRL 2907] > 0
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-1c-1 Total Incumbent Apprentices Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND Apprenticeship Program Status [PIRL 2907] is NOT null
AND
(DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null)


A-2-1 Total Reportable Individuals Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND ((APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 2) AND (DATE OF MOST RECENT REPORTABLE INDIVIDUAL CONTACT [PIRL 1007] => beginning of the reporting period))

A-3-1 Total Exiters Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] < the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period))

B. PARTICIANT SUMMARY INFORMATION B-1a-1 Male Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SEX [PIRL 201] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-1b-1 Female Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SEX [PIRL 201] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2a-1 Hispanic/Latino Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HISPANIC/LATINO [PIRL 210] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2b-1 American Indian or Alaska Native Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((AMERICAN INDIAN/ALASKA NATIVE [PIRL 211] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901]is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2c-1 Asian Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((ASIAN [PIRL 212] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2d-1 Black or African American Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((BLACK OR AFRICAN AMERICAN [PIRL 213] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2e-1 Middle Eastern or North African Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((MIDDLE EASTERN OR NORTH AFRICAN [PIRL 21x] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2f-1 Native Hawaiian or Other Pacific Islander Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER [PIRL 214] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2g-1 White Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((WHITE [PIRL 215]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-2h-1 Multiracial and/or Multiethnic Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((two or more of PIRL 210, 211, 212, 213, 214, 215 = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period))

B-3a-1 In Secondary School or Equivalency Program Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SCHOOL STATUS AT PROGRAM ENTRY [PIRL 409] = 1 OR 2 OR 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900 is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3b-1 Secondary School Graduate or Equivalent Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 1 OR 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900 is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3c-1 Completed 1 or more years of Postsecondary Education Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3d-1 Postsecondary Certification, License, or Educational Certificate (non-degree) Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 5) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901]is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3e-1 Associate's Degree Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 6) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3f-1 Bachelor's Degree or Equivalent Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 7) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-3g-1 Advanced Degree Beyond Bachelor's Degree Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY [PIRL 408] = 8) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4a-1 Youth, Ages 16-18 Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is <= the end of the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null) AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] >=16 years AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] <19 years))

B-4b-1 Youth, Ages 19-24 Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is <= the end of the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null) AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] >=19 years AND (DATE OF PROGRAM ENTRY [PIRL 900] - DATE OF BIRTH [PIRL 200] <25 years))

B-4c-1 Out-of-School Youth Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((SCHOOL STATUS AT PROGRAM ENTRY [PIRL 409] = 4 OR 5 OR 6) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= then end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4d-1 Individuals with a Disability Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((INDIVIDUAL WITH A DISABILITY [PIRL 202] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-4e-1 Veterans Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((VETERAN STATUS [PIRL 300] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5a-1 Unemployed Individuals Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PROGRAM ENTRY [PIRL 400] = 0) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5b-1 Long-Term Unemployed (27 or More Consecutive Weeks) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((LONG-TERM UNEMPLOYED AT PROGRAM ENTRY [PIRL 402]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5c-1 Incumbent Workers Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PARTICIPATION [PIRL 400] = 1 or 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND DATE OF PROGRAM EXIT [PIRL 901] is <= the end of the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

B-5d-1 Employed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((EMPLOYMENT STATUS AT PROGRAM ENTRY [PIRL 400] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

C. WIOA PRIMARY INDICATORS OF PERFORMANCE C-1-1 Education and Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from EDUCATION AND EMPLOYMENT RATE Q2 DENOMINATOR where ((EMPLOYED 2ND QUARTER AFTER EXIT QUARTER [PIRL 1602] > 0 and < 9) or (YOUTH 2ND QUARTER PLACEMENT (TITLE I) [PIRL 1900] > 0))
divided by
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and (Date of Program Exit is within the report period) and OTHER REASON FOR EXIT = 00


C-2-1 Education and Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from EDUCATION AND EMPLOYMENT RATE Q4 DENOMINATOR where ((EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] is > 0 and < 9) or (YOUTH 4TH QUARTER PLACEMENT (TITLE I) [PIRL 1901] > 0))
divided by
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and (Date of Program Exit is within the report period) and OTHER REASON FOR EXIT = 00


C-3-1 Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) The value of WAGES 2ND QUARTER AFTER EXIT QUARTER [PIRL 1704] that is the mid-point between the value of the lowest wage reported and the value of the highest wage reported for the UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) and (WAGES 2ND QUARTER AFTER THE EXIT QUARTER [PIRL 1704] > 0 and WAGES 2ND QUARTER AFTER THE EXIT QUARTER [PIRL 1704] < 999999.99) and Date of Program Exit [PIRL 901] is within the reporting period and OTHER REASON FOR EXIT [PIRL 923] = 00

C-4-1 Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from CREDENTIAL RATE DENOMINATOR where (DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND
1) ((TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] > 1) or (TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] > 1) or (TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] > 1)) or
2) (TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1)) OR (DATE ATTAINED RECOGNIZED CREDENTIAL #2 [PIRL 1803] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL #2 [PIRL 1802] = 1)) OR (DATE ATTAINED RECOGNIZED CREDENTIAL #3 [PIRL 1805] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL #3 [PIRL 1804] = 1)) AND a) (DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL [PIRL 1406] – DATE OF PROGRAM EXIT [PIRL 901] <=365 or b) EMPLOYED 1ST QUARTER AFTER EXIT QUARTER [PIRL 1600] is (>= 0 AND < 9) or c) Employed 2nd Quarter After Exit Quarter [PIRL 1602] is (>= 0 AND < 9) or d) EMPLOYED 3RD QUARTER AFTER EXIT QUARTER [PIRL 1604] is (>= 0 AND < 9) or e) EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] is (>= 0 AND < 9))
divided by Count of UNIQUE RECORDS Where ( APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND Apprenticeship Programs Grants Status [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM EXIT [PIRL 901] is within the report period AND Other Reason for Exit [PIRL 923] is 00)


C-5-1 Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Count of UNIQUE RECORDS from MEASURABLE SKILLS GAIN DENOMINATOR where 1) Date of Most Recent Measurable skill gain: Educational Functioning Level (EFL) [PIRL 1806] is within the reporting period or 2) DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1 or DATE ATTAINED RECOGNIZED CREDENTIAL #2 [PIRL 1803] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1802] = 1 or DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1805] is within the reporting period AND TYPE OF RECOGNIZED CREDENTIAL [PIRL 1804] = 1 or 3) DATE OF MOST RECENT MEASURABLE SKILL GAINS: SECONDARY TRANSCRIPT/REPORT CARD [PIRL 1808] is within the reporting period or 4) DATE OF MOST RECENT MEASURABLE SKILL GAINS: POSTSECONDARY TRANSCRIPT/REPORT CARD [PIRL 1807] is within the reporting period or 5) DATE OF MOST RECENT MEASURABLE SKILL GAINS: TRAINING MILESTONE [PIRL 1809] is within the reporting period or 6) DATE OF MOST RECENT MEASURABLE SKILL GAINS: SKILLS PROGRESSION [PIRL 1810] is within the reporting period divided by Count of UNIQUE RECORDS Where ( APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND Apprenticeship Programs Grants Status [PIRL 2914] = 1 or 3) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is null or within the report period) AND (Other Reason for Exit [PIRL 923] = 00))



C-6-1 Retention with the Same Employer in the 2nd and 4th Quarter After Exit Count of UNIQUE RECORDS from RETENTION WITH SAME EMPLOYER IN THE 2ND AND 4TH QUARTERS AFTER EXIT DENOMINATOR where PIRL 1618 (Retention with the same employer in the 2nd Quarter AND the 4th Quarter (WIOA)) = 1 DIVIDED BY Count of UNIQUE RECORDS from APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND PIRL 901 (DATE OF PROGRAM EXIT) is within the reporting period AND PIRL 923 (Other Reasons For Exit (WIOA)) = 00 AND PIRL 1602 (Employed 2nd Quarter After Exit Quarter (WIOA)) is > 0 AND < 9

D. OTHER OUTCOMES D-1-1 Average Wage at Exit SUM of EXIT WAGE [PIRL 2917] for all records where (((APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND ( OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND (APPRENTICESHIP PROGRAM STATUS [2907] = 2 or 3) AND (DATE OF PROGRAM EXIT [PIRL 901] =>beginning of the report period))) DIVIDED BY (Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period)


D-2-1 Q2 Post-Exit Training-Related Employment Count of UNIQUE RECORDS where Apprenticeship [PIRL 2920 is not null AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 3) AND (Date completed Apprenticeship [PIRL 2911] is not null AND
DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period) AND (Employment related to training (2nd quarter after exit) [PIRL 1608]= 1))


D-3-1 Total Participants Who Received a Degree/Credential Count of UNIQUE RECORDS where (DATE ATTAINED RECOGNIZED CREDENTIAL [PIRL 1801] – DATE OF PROGRAM EXIT [PIRL 901] <= 365) AND 1) ((TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] > 1) or 2) (TYPE OF RECOGNIZED CREDENTIAL [PIRL 1800] = 1)) AND a) (DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL [PIRL 1406] – DATE OF PROGRAM EXIT [PIRL 901] <=365 or b) EMPLOYED 1ST QUARTER AFTER EXIT QUARTER [PIRL 1600] is (>= 0 AND < 9) or c) Employed 2nd Quarter After Exit Quarter [PIRL 1602] is (>= 0 AND < 9) or d) EMPLOYED 3RD QUARTER AFTER EXIT QUARTER [PIRL 1604] is (>= 0 AND < 9) or e) EMPLOYED 4TH QUARTER AFTER EXIT QUARTER [PIRL 1606] is (>= 0 AND < 9)) AND (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM EXIT [PIRL 901] is within the report period


E. SUPPORTIVE SERVICES E-1a-1 Received Supportive Services - Childcare Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3 AND ((Type of Supportive Services Received [PIRL 2913] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period or DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1b-1 Received Supportive Services - Tools/Equipment Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1c-1 Received Supportive Services - Transportation Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1d-1 Received Supportive Services - Uniforms Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

E-1e-1 Received Supportive Services - Other Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF SUPPORTIVE SERVICES RECEIVED [PIRL 2913] = 5) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the reporting period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F. APPRENTICESHIP PARTICIPATION F-1a-1 Pre-apprenticeship Status - Enrolled Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 1) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is not null) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is within the report period))

F-1b-1 Pre-apprenticeship Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null AND DATE OF PROGRAM EXIT [PIRL 900] is within the report period))

F-1c-1 Pre-apprenticeship Status - Completed, has not continued into RAP Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 3) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-1d-1 Pre-apprenticeship Status - Completed, continued into Registered Apprenticeship Program (RAP) Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 4) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-1e-1 Enrolled in Pre-Apprenticeship with an Articulated Agreement Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 1) AND (PRE-APPRENTICESHIP PROGRAM WITH AN ARTICULATED AGREEMENT [PIRL 2904] = 1) AND (DATE COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is not null) AND (DATE ENROLLED IN PRE-APPRENTICESHIP [PIRL 2902] is <= the end of the report period))

F-2a-1 Registered Apprenticeship Program Status - Enrolled Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 1) AND (TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is within the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-2b-1 Registered Apprenticeship Program Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 2) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 900] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null))

F-2c-1 Registered Apprenticeship Program Status - Completed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 3) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] is not null) AND (DATE COMPLETED APPRENTICESHIP [PIRL 2911] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-3a-1 Incumbent Registered Apprenticeship Program Status - Enrolled Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907] = 1) AND (TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is within the reporting period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-3b-1 Incumbent Registered Apprenticeship Program Status - Cancelled or Withdrew Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 2) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 900] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null))

F-3c-1 Incumbent Registered Apprenticeship Program Status - Completed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 3) AND ((APPRENTICESHIP PROGRAM STATUS [PIRL 2907} = 3) AND (Date Started Registered Apprenticeship Program Incumbent Apprentice [PIRL 2919] is not null) AND (DATE COMPLETED APPRENTICESHIP [PIRL 2911] is within the report period) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is not null) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period))

F-4a-1 Type of Apprenticeship Program Training Approach - Time-Based Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4b-1 Type of Apprenticeship Program Training Approach - Competency-Based Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-4c-1 Type of Apprenticeship Program Training Approach - Hybrid Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 or 3) AND ((TYPE OF APPRENTICESHIP PROGRAM [PIRL 2910] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-5a-1 Type of RTI Provider - Joint Apprenticeship Training Committee Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912]= 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is <= the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-5b-1 Type of RTI Provider - Community College Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912] = 2) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-5c-1 Type of RTI Provider - Vocational/Technical School Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912] = 3) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-5d-1 Type of RTI Provider - Four-Year Educational institution Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912] = 4) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null AND DATE OF PROGRAM ENTRY [PIRL 900] is the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

F-5e-1 Type of RTI Provider - Other
Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] =1 or 3) AND ((TYPE OF RTI PROVIDER [PIRL 2912] = 5) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is the end of the report period) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy