Apprenticeship QPR Template and Specifications - Tracked Changes

Apprenticeship QPR Template and Specifications.xlsx

DOL-Only Performance Accountability, Information, and Reporting System

Apprenticeship QPR Template and Specifications - Tracked Changes

OMB: 1205-0521

Document [xlsx]
Download: xlsx | pdf

Overview

Tab 1 Adult QPR Template
Tab 2 Adult Aggregation Rules
Tab 3 Youth QPR Template
Tab 4 Youth Aggregation Rules

Sheet 1: Tab 1 Adult QPR Template

OMB Control Number: 1205-0521

















Expiration Date: 06/30/2023

















Date of Report:












ETA-9173-APPSHP



PY 20xx Qtr x Performance Report for Apprenticeship

















Time Period: (Choose Only One)





Quarterly
Rolling 4 Quarters
Program-to-Date






Reporting Period Covered: mm/dd/yyyy - mm/dd/yyyy




























GRANT OVERVIEW

















Grant Number:





Grantee Name:




























Performance Items Total Current Period Total Previous Period



A. SUMMARY INFORMATION

















1.a. Total Participants A-1a-1 A-1a-2



2 1b. Total Entered Pre-Apprentice










A-2-1b-1 A-2-1b-2



3 1c. Total New Apprentice Participants










A-1c-1 A-2c-2



2. Total New Registered Apprentices











A-2-1 A-2-2



2. Total Reportable Individuals A-2-1 A-2-2



3. Total Exiters A-3-1 A-3-2



B. PARTICIPANT SUMMARY INFORMATION

















Sex 1a Male







B-1a-1 B-1a-2



1b Female







B-1b-1 B-1b-2



Ethnicity/Race 2a Hispanic/Latino







B-2a-1 B-2a-2



2b American Indian or Alaskan Native







B-2b-1 B-2b-2



2c Asian







B-2c-1 B-2c-2



2d Black or African American







B-2d-1 B-2d-2



2e Native Hawaiian or Other Pacific Islander







B-2e-1 B-2e-2



2f White







B-2f-1 B-2f-2



2g More Than One Race







B-2g-1 B-2g-2



Education Level 3a In Secondary School or Equivalency Program







B-3a-1 B-3a-2



3b Secondary School Graduate or Equivalent







B-3b-1 B-3b-2



3c Completed 1 or More Years of Postsecondary Education







B-3c-1 B-3c-2



3d Postsecondary Certification, License, or Educational Certificate (Non-Degree)







B-3d-1 B-3d-2



3e Associate's Degree







B-3e-1 B-3e-2



3f Bachelor's Degree or Equivalent







B-3f-1 B-3f-2



3g Advanced Degree Beyond Bachelor's Degree







B-3g-1 B-3g-2



Other Demographics 4a Youth and Young Adults, Ages 16-24 B-4a-1 B-4a-2



4b Adults, Ages 25-54 B-4b-1 B-4b-2



4c Older Adults, Ages 55+ B-4c-1 B-4c-2



4d Individuals with a Disability B-4d-1 B-4d-2



4e Veterans B-4e-1 B-4e-2



Employment Status
at Participation		 5a Unemployed Individuals B-5a-1 B-5a-2



5b Long-Term Unemployed (27 or More Consecutive Weeks) B-5b-1 B-5b-2



5c Incumbent Workers B-5c-1 B-5c-2



1d Incarcerated







B-5d-5 B-5d-2


5d Employed B-5d-1 B-5d-2



C. WIOA PRIMARY INDICATORS OF PERFORMANCE

















1. Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match



C-1-1 C-1-2



2. Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match



C-2-1 C-2-2



3. Median Earnings (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match



C-3-1 C-3-2



4. Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) C-4-1 C-4-2



5. Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) C-5-1 C-5-2



D. OTHER OUTCOMES

















1. Average Wage at Exit D-1-1 D-1-2



2. Q2 Post-Exit Training-Related Employment D-2-1 D-2-2



3. Retention with the Same Employer in the 2nd and 4th Quarter After Exit (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) D-3-1 D-3-2



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



E. SUPPORTIVE SERVICES

















1 Received Supportive Services

















1a Childcare









E-1a-1 E-1a-2




1b Tools/Equipment E-1b-1 E-1b-2




1c Transportation E-1c-1 E-1c-2




1d Uniforms E-1d-1 E-1d-2




1e Other Supportive Services E-1e-1 E-1e-2



2 Supportive Services Funding

















2a Grant Funds









E-2a-1 E-2a-2




2b WIOA Title I









E-2b-1 E-2b-2




2c WIOA (not Title I)









E-2c-1 E-2c-2




2d State Funding Sources









E-2d-2 E-2E-2




2e GI Bill









E-2e-1 E-2e-2




2f PELL Grant









E-2f-1 E-2f-2



F. APPRENTICESHIP PARTICIPATION

















1 Pre-apprenticeship Status

















1a Enrolled









F-1a-1 F-1a-2




1b Cancelled or Withdrew









F-1b-1 F-1b-2




1c Completed









F-1c-1 F-1c-2




1d Completed and Continued into Registered Apprenticeship Program (RAP)









F-1d-1 F-1d-2




1e Completed and Continued into IRAP









F-1e-1 F-1e-2




1e In Pre-Apprenticeship Program with an Articulated Agreement









F-1e-1 F-2e-2



2 Registerd Apprenticeship Program Status






2a Enrolled F-2a-1 F-2a-2




2b Cancelled or Withdrew F-2b-1 F-2b-2




2c Completed F-2c-1 F-2c-2



3 Type of Apprenticeship Program Enrollment







3a Registered Apprenticeship F-3a-1 F-3a-2




4b IRAP









F-4b-1 F-4b-2




4c Other









F-4c-1 F-4c-2



3 Type of Registered Apprenticeship Program Training Approach








3a Time-Based









F-3a-1 F-3a-2




3b Competency-Based









F-3b-1 F-3b-2




3c Hybrid









F-3c-1 F-3c-2



6 Source of OJT Funding




6a Grant Funds









F-6a-1 F-6a-2




6b WIOA Title I









F-6b-1 F-6b-2




6c WIOA (not Title I)









F-6c-1 F-6c-2




6d State Funding Sources









F-6d-1 F-6d-2




6e GI Bill









F-6e-1 F-6d-2



7 Source of RTI Funding




7a Grant Funds









F-7a-1 F-7a-2




7b WIOA Title I









F-7b-1 F-7b-2




7c WIOA (not Title I)









F-7c-1 F-7c-2




7d State Funding Sources









F-7d-1 F-7d-2




7e GI Bill









F-7e-1 F-7e-2




7f PELL Grant









F-7f-1 F-7f-2



4 Type of Related Training Instruction (RTI) Provider




4a Joint Apprenticeship Training Committee









F-4a-1 F-4a-2




4b Community College









F-4b-1 F-4b-2




4c Vocational/Technical School









F-4c-1 F-4c-2




4d Four-Year Educational Institution









F-4d-1 F-4d-2




4e Other









F-4e-1 F-4d-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.
Public Burden Statement (1205-0521)

Persons are not required to respond to this collection of information unless it displays a currently valid OMB control number. Respondent’s reply to these reporting requirements is mandatory (Workforce Innovation and Opportunity Act, Section 116). Public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate to the Office of Policy Development and Research ● U.S. Department of Labor ● Room N-5641 ● 200 Constitution Ave., NW, ● Washington, DC ● 20210.
Do NOT send the completed application to this address.


Sheet 2: Tab 2 Adult Aggregation Rules






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

A. SUMMARY INFORMATION A-1a-1 Total New Participants Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 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)

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-1b-1 Total New Pre-Apprentice Participants (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 COMPLETED PRE-APPRENTICESHIP [PIRL 2905] is null) AND (DATE OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (APPRENTICESHIP PROGRAM STATUS [PIRL 2907] is null))

A-1c-1 Total New Apprentice Participants (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 OR 2) 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 OF PROGRAM ENTRY [PIRL 900] is within the reporting period))

A-2 -1 Total New Registered Apprentices (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 OF PROGRAM ENTRY [PIRL 900] is within the reporting period) AND (Apprenticeship Program [PIRL 2914] = 1))

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) 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) 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) 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) 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 Alaskan Native Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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) 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) 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 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) 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-2f-1 White Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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-2g-1 More Than One Race Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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) 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) 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 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) 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) 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) 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) 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) 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 STARTED APPRENTICESHIP [PIRL 2908] - DATE OF BIRTH [PIRL 200] >= 16 years AND DATE STARTED APPRENTICESHIP [PIRL 2908] - 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) 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 STARTED APPRENTICESHIP [PIRL 2908] - DATE OF BIRTH [PIRL 200] >= 25 years) AND (DATE STARTED APPRENTICESHIP [PIRL 2908] - 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) 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 STARTED APPRENTICESHIP [PIRL 2908] (WIOA) - DATE OF BIRTH [PIRL 200] => 55 years)

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) 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) 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) 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 ((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) 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-5d-5 Incarcerated Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Incarcerated at Program Entry (PIRL 2413) = 1) AND (Date Release from Incarceration [PIRL 2414] is 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-5e-1 Employed Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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) 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) 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) 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) 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) 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))

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) AND (APPRENTICESHIP PROGRAM STATUS [2907] PIRL > 1) 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 PROGRAM STATUS > 1 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) 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 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 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)

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 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) 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) 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) 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) 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 Supportive Services Funding - Grant Funding Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 1) AND (DATE OF PROGRAM ENTRY [PIRL 900] is not null) AND ((DATE OF PROGRAM ENTRY [PIRL 900] is within the) AND (DATE OF PROGRAM EXIT [PIRL 901] is within the report period or DATE OF PROGRAM EXIT [PIRL 901] is null))


E-2b-1 Supportive Services Funding - WIOA Title I Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 2) 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))


E-2c-1 Supportive Services Funding - WIOA (not Title I) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 3) 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))


E-2d-2 Supportive Services Funding - State Funding Sources Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 4) 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))


E-2e-1 Supportive Services Funding - GI Bill Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 5) 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))


E-2f-1 Supportive Services Funding - PELL Grant Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 AND ((Supportive Services Funding [PIRL 2914] = 6) AND (Pell Grant Recipient [PIRL 1320] = 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 report 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 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 CHANGED STATUS FROM PRE-APPRENTICE TO APPRENTICE [PIRL 2906] is 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, continue 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 CHANGED STATUS FROM PRE-APPRENTICE TO APPRENTICE [PIRL 2906] is 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 Pre-apprenticeship Status - Completed, continue into IRAP (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) AND ((PRE-APPRENTICESHIP PROGRAM STATUS [PIRL 2901] = 5) 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 900] is within report period OR DATE OF PROGRAM EXIT [PIRL 901] is null))

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) 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 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) 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) 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) 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-6a-1 Source of OJT Funding - Grant Funding Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received OJT Services (Identification of Funding Source(s)) [PIRL 2915] = 1) 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))

F-6b-1 Source of OJT Funding - WIOA Title I Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received OJT Services (Identification of Funding Source(s)) [PIRL 2915] = 2) 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))

F-6c-1 Source of OJT Funding - WIOA (not Title I) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received OJT Services (Identification of Funding Source(s)) [PIRL 2915] = 3) 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))

F-6d-1 Source of OJT Funding - State Funding Sources Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received OJT Services (Identification of Funding Source(s)) [PIRL 2915] = 4) 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))

F-6e-1 Source of OJT Funding - GI Bill (DELETE) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received OJT Services (Identification of Funding Source(s)) [PIRL 2915] = 5) 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))

F-7a-1 Source of RTI Funding - Grant Funding (DELETE) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received RTI Services (Identification of Funding Source(s)) [PIRL 2916]= 1) 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))

F-7b-1 Source of RTI Funding - WIOA Title I Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received RTI Services (Identification of Funding Source(s [PIRL 2916]= 2) 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))

F-7c-1 Source of RTI Funding - WIOA (not Title I) Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received RTI Services (Identification of Funding Source(s)) [PIRL 2916]= 3 ) 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))

F-7d-1 Source of RTI Funding - State Funding Sources Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received RTI Services (Identification of Funding Source(s)) [PIRL 2916]= 4) 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))

F-7e-1 Source of RTI Funding - GI Bill Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND ((Received RTI Services (Identification of Funding Source(s)) [PIRL 2916]= 5) 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))

F-7f-1 Source of RTI Funding - PELL Grant Count of UNIQUE RECORDS where APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null AND (Received RTI Services (Identification of Funding Source(s)) [PIRL 2916]= 6) AND (Pell Grant Recipient [PIRL 1320] = 1) 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))

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) 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) 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) 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) 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) 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: Tab 3 Youth QPR Template

OMB Control Number: 1205-0521














Expiration Date: 06/30/2023














Date of Report:












ETA-9173-APPSHP-Youth

PY 20xx Qtr x Performance Report for Apprenticeship Youth














Time Period: (Choose Only One)





Quarterly
Rolling 4 Quarters
Program-to-Date



Reporting Period Covered: mm/dd/yyyy - mm/dd/yyyy






















GRANT OVERVIEW














Grant Number:





Grantee Name:






















Performance Items Total Current Period Total Previous Period

A. SUMMARY INFORMATION














1. Total Participants A-1-1 A-1-2

2. Total Reportable Individuals A-2-1 A-2-2

3. Total Exiters A-3-1 A-3-2

B. PARTICIPANT SUMMARY INFORMATION














Sex 1a Male B-1a-1 B-1a-2

1b Female B-1b-1 B-1b-2

Ethnicity/Race 2a Hispanic/Latino B-2a-1 B-2a-2

2b American Indian or Alaskan Native B-2b-1 B-2b-2

2c Asian B-2c-1 B-2c-2

2d Black or African American B-2d-1 B-2d-2

2e Native Hawaiian or Other Pacific Islander B-2e-1 B-2e-2

2f White B-2f-1 B-2f-2

2g More Than One Race B-2g-1 B-2g-2

Education Level 3a In Secondary School or Equivalency Program B-3a-1 B-3a-2

3b Secondary School Graduate or Equivalent B-3b-1 B-3b-2

3c Completed 1 or More Years of Postsecondary Education B-3c-1 B-3c-2

3d Postsecondary Certification, License, or Educational Certificate (Non-Degree) B-3d-1 B-3d-2

3e Associate's Degree B-3e-1 B-3e-2

3f Bachelor's Degree or Equivalent B-3f-1 B-3f-2

3g Advanced Degree Beyond Bachelor's Degree B-3g-1 B-3g-2

Other Demographics 4a Youth, Ages 16-18 B-4a-1 B-4a-2

4b Youth, Ages 19-24 B-4b-1 B-4b-2

4c Out-of-School Youth B-4c-1 B-4c-2

4d Individuals with a Disability B-4d-1 B-4d-2

4e Veterans B-4e-1 B-4e-2

Employment Status
at Participation		 5a Unemployed Individuals B-5a-1 B-5a-2

5b Long-Term Unemployed (27 or More Consecutive Weeks) B-5b-1 B-5b-2

5c Incumbent Workers B-5c-1 B-5c-2
fd Employed B-5d-1 B-5d-2

C. WIOA PRIMARY INDICATORS OF PERFORMANCE














1. Education and Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match

C-1-1 C-1-2

2. Education and Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match

C-2-1 C-2-2

3. Median Earnings (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) UI Match UI Match

C-3-1 C-3-2

4. Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) C-4-1 C-4-2

5. Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) C-5-1 C-5-2

D. OTHER OUTCOMES














1. Average Wage at Exit D-1-1 D-1-2

2. Q2 Post-Exit Training-Related Employment D-2-1 D-2-2

3. Retention with the Same Employer in the 2nd and 4th Quarter After Exit (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) D-3-1 D-3-2

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

E. SUPPORTIVE SERVICES




1 Received Supportive Services














1a Childcare E-1a-1 E-1a-2


1b Tools/Equipment E-1b-1 E-1b-2


1c Transportation E-1c-1 E-1c-2


1d Uniforms E-1d-1 E-1d-2


1e Other Supportive Services E-1e-1 E-1e-2

F. APPRENTICESHIP PARTICIPATION














1 Pre-Apprenticeship Status


1a Enrolled F-1a-1 F-1a-2

1b Cancelled or Withdrew F-1b-1 F-1b-2

1c Completed F-1c-1 F-1c-2

1d Completed and Continued into Registered Apprenticeship Program (RAP) F-1d-1 F-1d-2

1e In Pre-Apprenticeship Program with an Articulated Agreement F-1e-1 F-2e-2

2 Registered Apprenticeship Program Status


2a Enrolled F-2a-1 F-2a-2


2b Cancelled or Withdrew F-2b-1 F-2b-2


2c Completed F-2c-1 F-2c-2

3 Type of Registered Apprenticeship Program Training Approach





3a Time-Based F-3a-1 F-3a-2


3b Competency-Based F-3b-1 F-3b-2


3c Hybrid F-3c-1 F-3c-2

4 Type of Related Training Instruction (RTI) Provider


4a Joint Apprenticeship Training Committee F-4a-1 F-4a-2


4b Community College F-4b-1 F-4b-2


4c Vocational/Technical School F-4c-1 F-4c-2


4d Four-Year Educational Institution F-4d-1 F-4d-2


4e Other F-4e-1 F-4e-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.
Public Burden Statement (1205-0521)

Persons are not required to respond to this collection of information unless it displays a currently valid OMB control number. Respondent’s reply to these reporting requirements is mandatory (Workforce Innovation and Opportunity Act, Section 116). Public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate to the Office of Policy Development and Research ● U.S. Department of Labor ● Room N-5641 ● 200 Constitution Ave., NW, ● Washington, DC ● 20210.
Do NOT send the completed application to this address.

Sheet 4: Tab 4 Youth Aggregation Rules






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)
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) 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) 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) 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) 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 Alaskan Native Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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) 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) 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 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) 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-2f-1 White Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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-2g-1 More Than One Race Count of UNIQUE RECORDS where (APPRENTICESHIP GRANT NUMBER [PIRL 2920] is not null) AND (APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1) 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) 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) 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 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) 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) 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) 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) 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) 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 STARTED APPRENTICESHIP [PIRL 2908] - DATE OF BIRTH [PIRL 200] >=16 years AND DATE STARTED APPRENTICESHIP [PIRL 2908] - 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) 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 STARTED APPRENTICESHIP [PIRL 2908] - DATE OF BIRTH [PIRL 200] >=19 years AND DATE STARTED APPRENTICESHIP [PIRL 2908] - 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) 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) 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) 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) 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 ((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) 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) 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) 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) 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) 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) 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) 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))

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) AND (APPRENTICESHIP PROGRAM STATUS [2907] PIRL > 1) 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 PROGRAM STATUS > 1 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 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 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-4-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 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 OA APPRENTICESHIP GRANTS PROGRAM STATUS [PIRL 2914] = 1 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) 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) 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) 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) 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 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 CHANGED STATUS FROM PRE-APPRENTICE TO APPRENTICE [PIRL 2906] is 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 and Continue 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 CHANGED STATUS FROM PRE-APPRENTICE TO APPRENTICE [PIRL 2906] is 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 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) 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 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) 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 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) 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) 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) 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) 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) 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) 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
© 2024 OMB.report | Privacy Policy