Program Performance Report (States)

DOL-Only Performance Accountability, Information, and Reporting System

INA QPR Template and Specifications_022820.XLSX

Program Performance Report (States)

OMB: 1205-0521

Document [xlsx]
Download: xlsx | pdf

Overview

INA_QPR Template
INA_QPR Specs


Sheet 1: INA_QPR Template


OMB Control Number: 1205-0521














Expiration Date: 06-30-2021 xx-xx-xxxx












Date of Report:










ETA-9173-DINAP

PY 20xx Qtr x Performance Report for Indian and Native American Program













Time Period: (Choose Only One) o Quarterly
o Rolling 4 Quarters









REPORTING PERIOD COVERED: Current Period: (mm/dd/yyyy - mm/dd/yyyy) Program Year to Date: (mm/dd/yyyy - mm/dd/yyyy)

























Performance Items Total Previous Period Total Current Period Total Program Year to Date

A. SUMMARY INFORMATION Cohort Period: (TCP mm/dd/yyyy - mm/dd/yyyy) and (PYTD mm/dd/yyyy - mm/dd/yyyy)

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

2. Total Participants Served A-2-1 A-2-2 A-2-3

3. New Participants Served A-3-1 A-3-2 A-3-3

4. Total Reportable Individuals (i.e., self-service customers) A-4-1 A-4-2 A-4-3

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

Sex 1a. Male B-1a-1 B-1a-2 B-1a-3

1b. Female B-1b-1 B-1b-2 B-1b-3

1c. Did not Specify




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

Ethnicity/Race 2a. American Indian or Alaskan Native B-2a-1 B-2a-2 B-2a-3

2b. Native Hawaiian B-2b-1 B-2b-2 B-2b-3

Age at Enrollment 3a. Age 14-21 B-3a-1 B-3a-2 B-3a-3

3b. Age 22-24 B-3b-1 B-3b-2 B-3b-3

3c. Age 25-54 B-3c-1 B-3c-2 B-3c-3

3d. Age 55 and Older B-3d-1 B-3d-2 B-3d-3

Other Demographics 4a. Eligible Veterans B-4a-1 B-4a-2 B-4a-3

4b. Employed B-4b-1 B-4b-2 B-4b-3

4c. Not Employed B-4c-1 B-4c-2 B-4c-3

Educatin Level 5a. Not Attending School, H.S. Dropout B-5a-1 B-5a-2 B-5a-3

5b. In School, H.S. or Less B-5b-1 B-5b-2 B-5b-3

5c. Not Attending School, H.S. Graduate or Equivalent B-5c-1 B-5c-2 B-5c-3

5d. In School, Post H.S. B-5d-1 B-5d-2 B-5d-3

5e. Associates Degree or Equivalent B-5e-1 B-5e-2 B-5e-3

5f. Bachelor's Degree, Equivalent or Degree Beyond Bachelors Degree B-5f-1 B-5f-2 B-5f-3

C. EMPLOYMENT BARRIERS Cohort Period: (TCP mm/dd/yyyy - mm/dd/yyyy) and (PYTD mm/dd/yyyy - mm/dd/yyyy)

1. Individuals with a Disability





C-1-1 C-1-2 C-1-3

2. Low-Income Individuals





C-2-1 C-2-2 C-2-3

3. Ex-Offenders





C-3-1 C-3-2 C-3-3

4. Public Assistance Recipients





C-4-1 C-4-2 C-4-3

5. Homeless Individuals or Runaway Youth





C-5-1 C-5-2 C-5-3

6. Single Parents (Including Single Pregnant Women)





C-6-1 C-6-2 C-6-3

7. Long-term Unemployed (27 or More Consecutive Weeks)





C-7-1 C-7-2 C-7-3

8. Basic Skills Deficient





C-8-1 C-8-2 C-8-3

D. WIOA PRIMARY INDICATORS OF PERFORMANCE

1. Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Combined Supplemental Combined Supplemental Combined Supplemental


D-1-1
D-1-2
D-1-3

UI Match UI Match UI Match






2. Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Combined Supplemental Combined Supplemental Combined Supplemental


D-2-1
D-2-2
D-2-3

UI Match UI Match UI Match






3. Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) Combined Supplemental Combined Supplemental Combined Supplemental


D-3-1
D-3-2
D-3-3

UI Match UI Match UI Match






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

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

E. EFFECTIVENESS IN SERVING EMPLOYERS

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


E-1-1
E-1-2
E-1-3

UI Match UI Match UI Match






F. ADDITIONAL INDICATORS

1. Percent in Training (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) F-1-1 F-1-2 F-1-3

2. Employability Skills Enhancement (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) F-2-1 F-2-2 F-2-3

G. PARTICIPANT SERVICES AND ACTIVITIES Cohort Period: (TCP mm/dd/yyyy - mm/dd/yyyy) and (PYTD mm/dd/yyyy - mm/dd/yyyy)

1. Basic Career Services G-1-1 G-1-2 G-1-3

2. Individual Career Services G-2-1 G-2-2 G-2-3

2.a Work Experience G-2a-1 G-2a-2 G-2a-3

3. Training Services G-3-1 G-3-2 G-3-3

3.a Adult Basic Education or GED Preparation G-3a-1 G-3a-2 G-3a-3

3.b Occupational Skills Training G-3b-1 G-3b-2 G-3b-3

3.c On-the-Job Training G-3c-1 G-3c-2 G-3c-3

3.d Registered Apprenticeship G-3d-1 G-3d-2 G-3d-3

3.e Entrepreneurial Skills Training G-3e-1 G-3e-2 G-3e-3

4. Supportive Service G-4-1 G-4-2 G-4-3
















Common Exit Programs: Please indicate by checking the box below each program below that  utilizes a common exit policy with this program in this state.













Program Wagner-Peyser Adults, Dislocated Workers, Youth TAA Job Corps National Farmworker Jobs Program (NFJP) Indian and Native American Program (INA) Reentry Employment Opportunities (Adult) Reentry Employment Opportunities (Youth) YouthBuild H1B SCSEP

Common Exit?












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: INA_QPR Specs


Report Item No. Identifier (Definition) Technical Specifications - Total Previous Quarter Period
A. SUMMARY INFORMATION A-1-1 Total Exiters - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the begining of the reporting period)
A-2-1 Total Participants Served - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-3-1 New Participants Served - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 900 (Date of Program Entry) >= the begining of the reporting period) and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-4-1 Total Reportable Individuals (i.e., self-service customers) - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 2 and (PIRL 1002 Most Recent Date Received Basic Career Services (Self-Service) => beginning of the report period or PIRL 1007 Date of Most Recent Reportable Individual Contact >= beginning of the reporting period)
B. PARTICIPANT SUMMARY INFORMATION B-1a-1 Male - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1b-1 Female - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1c-1 Did not Disclose - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 9 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2a-1 American Indian or Alaskan Native - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 211 (American Indian / Alaskan Native) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2b-1 Native Hawaiian - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 214 (Native Hawaiian / Other Pacific Islander) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3a-1 Age 14-21 - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 14 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 21 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3b-1 Age 22-24 - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 22 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 24 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3c-1 Age 25-54 - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 25 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 54 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3d-1 Age 55 and Older - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 55 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4a-1 Eligible Veterans - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 301 (Eligible Veteran Status) = 1, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4b-1 Employed - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4c-1 Not Employed - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 0, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5a-1 Not Attending School, H.S. Dropout - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 4, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5b-1 In School, H.S. or Less - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 1, 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5c-1 Not Attending School, H.S. Graduate or Equivalent - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 5 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5d-1 In School, Post H.S. - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 3 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5e-1 Associates Degree or Equivalent - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 5, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5f-1 Bachelor's Degree, Equivalent or Degree Beyond Bachelors Degree - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C. Employment Barriers Cohort Period C-1-1 Individuals with a Disability - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 202 (Individual with a Disability) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-2-1 Low-income individuals - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 802 (Low Income Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-3-1 Ex-offenders - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 801 (Ex-Offender Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-4-1 Public Assistance Recipients - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 2303 (Public Assistance Recipient) = 1, 2, 3, 4, 5, 6, 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-5-1 Homeless Individuals or Runaway Youth - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 800 (Homeless participant, Homeless Children and Youths, or Runaway Youth at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-6-1 Single Parents (Including Single Pregnant Women) - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 806 (Single Parent at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-7-1 Long-term Unemployed (27 or More Consecutive Weeks) - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 402 (Long-Term Unemployed at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-8-1 Basic Skills Deficient - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 804 (Basic Skills Deficient/Low Levels of Literacy at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
D. WIOA PRIMARY INDICATORS OF PERFORMANCE D-1-1 Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of UNIQUE RECORDS where (Employment Rate (Q2) DENOMINATOR and PIRL 1602 (EMPLOYED 2ND QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-2-1 Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of UNIQUE RECORDS where (Employment Rate (Q4) DENOMINATOR and PIRL 1606 (EMPLOYED 4TH QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-3-1 Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP The value of 2ND quarter after exit wage 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 (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 1001 (Date of First Basic Career Service) is not null or PIRL 1200 (Date of First Individualized Career Service) is not null or PIRL 1300 (Received Training) = 1) and (PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) > 0 and PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) < 999999.99) and PIRL 901 (DATE OF Program EXIT) is within the reporting Period and PIRL 923 (OTHER REASON FOR EXIT)= 00)
D-4-1 Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of UNIQUE RECORDS from CREDENTIAL RATE DENOMINATOR where (((PIRL 1801 -DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 ((Date of Program Exit) <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL > 1) or ((PIRL 1803 - DATE ATTAINED RECOGNIZED CREDENTIAL #2) – PIRL 901 (Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 > 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 > 1)) or ((((PIRL 1801 DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 Date of Program Exit <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL = 1) or ((PIRL 1803 DATE ATTAINED RECOGNIZED CREDENTIAL #2 – PIRL 901 Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 = 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – PIRL 901 Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 = 1)) and ((PIRL 1406 DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL – PIRL 901 Date of Program Exit <= 365) or PIRL 1600 EMPLOYED 1ST QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1602 EMPLOYED 2ND QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1604 EMPLOYED 3RD QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1606 EMPLOYED 4TH QUARTER AFTER EXIT QUARTER is (> 0 and < 9))) DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1300 Received Training = 1 and PIRL 900 Date of Program Entry is not null and PIRL 901 Date of Program Exit is within the report period and ((PIRL 1303 TYPE OF TRAINING #1 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1310 TYPE OF TRAINING #2 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1315 TYPE OF TRAINING #3 = 02 , 03 , 04 , 06 , 07 , 08 , 09 , 10) or PIRL 1332 Participated in POSTSECONDARY Education During Program Participation = 1 or (PIRL 408 HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY = 0 and PIRL 1401 ENROLLED IN SECONDARY EDUCATION PROGRAM = 1)) and PIRL 923 OTHER REASON FOR EXIT = 00)
D-5-1 Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of UNIQUE RECORDS from MEASURABLE SKILLS GAIN DENOMINATOR where PIRL 1806 (Date of Most Recent Measurable skill gain: Educational Functioning Level (EFL)) is within the reporting period or (PIRL 1801 (DATE ATTAINED RECOGNIZED CREDENTIAL) is within the reporting period and PIRL 1800 (TYPE OF RECOGNIZED CREDENTIAL) = 1) or PIRL 1808 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1807 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: POSTSECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1809 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: TRAINING MILESTONE) is within the reporting period or PIRL 1810 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SKILLS PROGRESSION) is within the reporting period DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (DATE OF PROGRAM ENTRY) is not null and PIRL 900 (DATE OF PROGRAM ENTRY) <= end of report period and (PIRL 901 (DATE OF EXIT) is null or PIRL 901 (DATE OF EXIT) is within the report period) and PIRL 1811 (DATE ENROLLED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT (WIOA)) is not null and PIRL 923 (OTHER REASON FOR EXIT) = 00 or 07)
E. EFFECTIVENESS IN SERVING EMPLOYERS E-1-1 Retention with the Same Employer in the 2nd and 4th Quarter After Exit (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP 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 where PIRL 913 (Indian and Native American Programs) = 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

F. ADDITIONAL INDICATORS F-1-1 Percent in Training (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of UNIQUE RECORDS where (Percent in Training Denominator and PIRL 1300 (Received Training) = 1) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 andPIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null
F-2-1 Employability Skills Enhancement (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPP Count of unique records where (Employability Skill Enhancement DENOMINATOR and PIRL 1307 (Training Completed #1) = 1 or PIRL 1312 (Training Completed #2) = 1 or PIRL 1317 (Training Completed #3) = 1 or PIRL 1812 (School Status at Exit) = 1 or PIRL 1800 (Type of Recognized Credential) = 1 or PIRL 1802 (Type of Recognized Credential #2) = 1 or PIRL 1804 (Type of Recognized Credential #3) = 1 or PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is not null or PIRL 1205 (Type of Work Experience) = 5 or PIRL 1806 (Date of Most Recent Measurable Skill Gains: Educational Functioning Level (EFL)) is not null or PIRL 1807 (Date of Most Recent Measurable Skill Gains: Postsecondary Transcript/Report Card) is not null or PIRL 1808 (Date of Most Recent Measurable Skill Gains: Secondary Transcript/Report Card) is not null or PIRL 1809 (Date of Most Recent Measurable Skill Gains: Training Milestone) is not null or PIRL 1810 (Date of Most Recent Measurable Skill Gains: Skills Progression) is not null) DIVIDED BY Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the begining of the reporting period)
G. PARTICIPANT SERVICES AND ACTIVITIES G-1-1 Basic Career Services - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1003 (Most Recent Date Received Basic Career Services ) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2-1 Individual Career Services - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1201 (Most Recent Date Received Individualized Career Service) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2a-1 Work Experience - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-3-1 Training Services - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3a-1 Adult Basic Education or GED Preparation - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 4 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3b-1 Occupational Skills Training - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 2, 6 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3c-1 On-the-Job Training - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 5 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3d-1 Registered Apprenticeship - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3e-1 Entrepreneurial Skills Training - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 3 andPIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and
PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)

G-4-1 Supportive Service - TPP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1409 (Most Recent Date Received Supportive Services) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)











Report Item No. Identifier (Definition) Technical Specifications - Total Current Quarter Period
A. SUMMARY INFORMATION A-1-2 Total Exiters - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the beginning of the reporting period)
A-2-2 Total Participants Served - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-3-2 New Participants Served - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 900 (Date of Program Entry) >= the begining of the reporting period) and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-4-2 Total Reportable Individuals (i.e., self-service customers) - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 2 and (PIRL 1002 Most Recent Date Received Basic Career Services (Self-Service) => beginning of the report period or PIRL 1007 Date of Most Recent Reportable Individual Contact >= beginning of the reporting period)
B. PARTICIPANT SUMMARY INFORMATION B-1a-2 Male - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1b-2 Female - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1c-2 Did not Disclose - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 9 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2a-2 American Indian or Alaskan Native - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 211 (American Indian / Alaskan Native) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2b-2 Native Hawaiian - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 214 (Native Hawaiian / Other Pacific Islander) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3a-2 Age 14-21 - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 14 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 21 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3b-2 Age 22-24 - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 22 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 24 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3c-2 Age 25-54 - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 25 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 54 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3d-2 Age 55 and Older - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 55 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4a-2 Eligible Veterans - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 301 (Eligible Veteran Status) = 1, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4b-2 Employed - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4c-2 Not Employed - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 0, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5a-2 Not Attending School, H.S. Dropout - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 4, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5b-2 In School, H.S. or Less - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 1, 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5c-2 Not Attending School, H.S. Graduate or Equivalent - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 5 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5d-2 In School, Post H.S. - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 3 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5e-2 Associates Degree or Equivalent - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 5, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5f-2 Bachelor's Degree, Equivalent or Degree Beyond Bachelors Degree - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C. Employment Barriers Cohort Period C-1-2 Individuals with a Disability - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 202 (Individual with a Disability) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-2-2 Low-income individuals - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 802 (Low Income Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-3-2 Ex-offenders - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 801 (Ex-Offender Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-4-2 Public Assistance Recipients - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 2303 (Public Assistance Recipient) = 1, 2, 3, 4, 5, 6, 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-5-2 Homeless Individuals or Runaway Youth - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 800 (Homeless participant, Homeless Children and Youths, or Runaway Youth at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-6-2 Single Parents (Including Single Pregnant Women) - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 806 (Single Parent at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-7-2 Long-term Unemployed (27 or More Consecutive Weeks) - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 402 (Long-Term Unemployed at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-8-2 Basic Skills Deficient - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 804 (Basic Skills Deficient/Low Levels of Literacy at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
D. WIOA PRIMARY INDICATORS OF PERFORMANCE D-1-2 Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of UNIQUE RECORDS where (Employment Rate (Q2) DENOMINATOR and PIRL 1602 (EMPLOYED 2ND QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-2-2 Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of UNIQUE RECORDS where (Employment Rate (Q4) DENOMINATOR and PIRL 1606 (EMPLOYED 4TH QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-3-2 Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP The value of 2ND quarter after exit wage 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 (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 1001 (Date of First Basic Career Service) is not null or PIRL 1200 (Date of First Individualized Career Service) is not null or PIRL 1300 (Received Training) = 1) and (PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) > 0 and PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) < 999999.99) and PIRL 901 (DATE OF Program EXIT) is within the reporting Period and PIRL 923 (OTHER REASON FOR EXIT)= 00)
D-4-2 Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of UNIQUE RECORDS from CREDENTIAL RATE DENOMINATOR where (((PIRL 1801 -DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 ((Date of Program Exit) <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL > 1) or ((PIRL 1803 - DATE ATTAINED RECOGNIZED CREDENTIAL #2) – PIRL 901 (Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 > 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 > 1)) or ((((PIRL 1801 DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 Date of Program Exit <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL = 1) or ((PIRL 1803 DATE ATTAINED RECOGNIZED CREDENTIAL #2 – PIRL 901 Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 = 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – PIRL 901 Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 = 1)) and ((PIRL 1406 DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL – PIRL 901 Date of Program Exit <= 365) or PIRL 1600 EMPLOYED 1ST QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1602 EMPLOYED 2ND QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1604 EMPLOYED 3RD QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1606 EMPLOYED 4TH QUARTER AFTER EXIT QUARTER is (> 0 and < 9))) DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1300 Received Training = 1 and PIRL 900 Date of Program Entry is not null and PIRL 901 Date of Program Exit is within the report period and ((PIRL 1303 TYPE OF TRAINING #1 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1310 TYPE OF TRAINING #2 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1315 TYPE OF TRAINING #3 = 02 , 03 , 04 , 06 , 07 , 08 , 09 , 10) or PIRL 1332 Participated in POSTSECONDARY Education During Program Participation = 1 or (PIRL 408 HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY = 0 and PIRL 1401 ENROLLED IN SECONDARY EDUCATION PROGRAM = 1)) and PIRL 923 OTHER REASON FOR EXIT = 00)
D-5-2 Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of UNIQUE RECORDS from MEASURABLE SKILLS GAIN DENOMINATOR where PIRL 1806 (Date of Most Recent Measurable skill gain: Educational Functioning Level (EFL)) is within the reporting period or (PIRL 1801 (DATE ATTAINED RECOGNIZED CREDENTIAL) is within the reporting period and PIRL 1800 (TYPE OF RECOGNIZED CREDENTIAL) = 1) or PIRL 1808 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1807 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: POSTSECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1809 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: TRAINING MILESTONE) is within the reporting period or PIRL 1810 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SKILLS PROGRESSION) is within the reporting period DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (DATE OF PROGRAM ENTRY) is not null and PIRL 900 (DATE OF PROGRAM ENTRY) <= end of report period and (PIRL 901 (DATE OF EXIT) is null or PIRL 901 (DATE OF EXIT) is within the report period) and PIRL 1811 (DATE ENROLLED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT (WIOA)) is not null and PIRL 923 (OTHER REASON FOR EXIT) = 00 or 07)
E. EFFECTIVENESS IN SERVING EMPLOYERS E-1-2 Retention with the Same Employer in the 2nd and 4th Quarter After Exit (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP 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 where PIRL 913 (Indian and Native American Programs) = 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

F. ADDITIONAL INDICATORS F-1-2 Percent in Training (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of UNIQUE RECORDS where (Percent in Training Denominator and PIRL 1300 (Received Training) = 1) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 andPIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null F-1-1/2/3 all are the same and use Date of Entry in the period rather than the consistent cohort calculation. This should have the appropriate cohort restrictions.
F-2-2 Employability Skills Enhancement (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TCP Count of unique records where (Employability Skill Enhancement DENOMINATOR and PIRL 1307 (Training Completed #1) = 1 or PIRL 1312 (Training Completed #2) = 1 or PIRL 1317 (Training Completed #3) = 1 or PIRL 1812 (School Status at Exit) = 1 or PIRL 1800 (Type of Recognized Credential) = 1 or PIRL 1802 (Type of Recognized Credential #2) = 1 or PIRL 1804 (Type of Recognized Credential #3) = 1 or PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is not null or PIRL 1205 (Type of Work Experience) = 5 or PIRL 1806 (Date of Most Recent Measurable Skill Gains: Educational Functioning Level (EFL)) is not null or PIRL 1807 (Date of Most Recent Measurable Skill Gains: Postsecondary Transcript/Report Card) is not null or PIRL 1808 (Date of Most Recent Measurable Skill Gains: Secondary Transcript/Report Card) is not null or PIRL 1809 (Date of Most Recent Measurable Skill Gains: Training Milestone) is not null or PIRL 1810 (Date of Most Recent Measurable Skill Gains: Skills Progression) is not null) DIVIDED BY Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the begining of the reporting period)
G. PARTICIPANT SERVICES AND ACTIVITIES G-1-2 Basic Career Services - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1003 (Most Recent Date Received Basic Career Services ) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2-2 Individual Career Services - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1201 (Most Recent Date Received Individualized Career Service) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2a-2 Work Experience - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-3-2 Training Services - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3a-2 Adult Basic Education or GED Preparation - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 4 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3b-2 Occupational Skills Training - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 2, 6 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3c-2 On-the-Job Training - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 5 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3d-2 Registered Apprenticeship - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3e-2 Entrepreneurial Skills Training - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 3 andPIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and
PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)

G-4-2 Supportive Service - TCP Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1409 (Most Recent Date Received Supportive Services) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)











Report Item No. Identifier (Definition) Technical Specifications - Total Program Year to Date
A. SUMMARY INFORMATION A-1-3 Total Exiters - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the beginning of the reporting period)
A-2-3 Total Participants Served - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-3-3 New Participants Served - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 900 (Date of Program Entry) >= the begining of the reporting period) and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
A-4-3 Total Reportable Individuals (i.e., self-service customers) - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 2 and (PIRL 1002 Most Recent Date Received Basic Career Services (Self-Service) => beginning of the report period or PIRL 1007 Date of Most Recent Reportable Individual Contact >= beginning of the reporting period)
B. PARTICIPANT SUMMARY INFORMATION B-1a-3 Male - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1b-3 Female - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-1c-3 Did not Disclose - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 201 (Sex) = 9 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2a-3 American Indian or Alaskan Native - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 211 (American Indian / Alaskan Native) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-2b-3 Native Hawaiian - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 214 (Native Hawaiian / Other Pacific Islander) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3a-3 Age 14-21 - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 14 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 21 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3b-3 Age 22-24 - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 22 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 24 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3c-3 Age 25-54 - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 25 years and PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) <= 54 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-3d-3 Age 55 and Older - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 900 (Date of Program Entry) - PIRL 200 (Date of Birth) >= 55 years) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4a-3 Eligible Veterans - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 301 (Eligible Veteran Status) = 1, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4b-3 Employed - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-4c-3 Not Employed - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 400 (Employment Status at Program Entry) = 0, 2, 3 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5a-3 Not Attending School, H.S. Dropout - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 4, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5b-3 In School, H.S. or Less - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 409 (School Status at Program Entry) = 1, 2 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5c-3 Not Attending School, H.S. Graduate or Equivalent - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 5 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5d-3 In School, Post H.S. - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 409 (School Status at Program Entry) = 3 and PIRL 408 (Highest Educational Level Completed at Program Entry) is not = 5, 6, 7, 8) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5e-3 Associates Degree or Equivalent - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 5, 6 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
B-5f-3 Bachelor's Degree, Equivalent or Degree Beyond Bachelors Degree - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 408 (Highest Educational Level Completed at Program Entry) = 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C. Employment Barriers Cohort Period C-1-3 Individuals with a Disability - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 202 (Individual with a Disability) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-2-3 Low-income individuals - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 802 (Low Income Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-3-3 Ex-offenders - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 801 (Ex-Offender Status at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-4-3 Public Assistance Recipients - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 2303 (Public Assistance Recipient) = 1, 2, 3, 4, 5, 6, 7, 8 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-5-3 Homeless Individuals or Runaway Youth - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 800 (Homeless participant, Homeless Children and Youths, or Runaway Youth at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-6-3 Single Parents (Including Single Pregnant Women) - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 806 (Single Parent at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-7-3 Long-term Unemployed (27 or More Consecutive Weeks) - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 402 (Long-Term Unemployed at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
C-8-3 Basic Skills Deficient - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 804 (Basic Skills Deficient/Low Levels of Literacy at Program Entry) = 1 and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
D. WIOA PRIMARY INDICATORS OF PERFORMANCE D-1-3 Employment Rate (Q2) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of UNIQUE RECORDS where (Employment Rate (Q2) DENOMINATOR and PIRL 1602 (EMPLOYED 2ND QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-2-3 Employment Rate (Q4) (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of UNIQUE RECORDS where (Employment Rate (Q4) DENOMINATOR and PIRL 1606 (EMPLOYED 4TH QUARTER AFTER EXIT QUARTER) > 0 and < 9) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (DATE OF EXIT) is within the report period and PIRL 923 (OTHER REASON FOR EXIT) = 00)
D-3-3 Median Earnings (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD The value of 2ND quarter after exit wage 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 (PIRL 913 (Indian and Native American Programs) = 1 and (PIRL 1001 (Date of First Basic Career Service) is not null or PIRL 1200 (Date of First Individualized Career Service) is not null or PIRL 1300 (Received Training) = 1) and (PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) > 0 and PIRL 1704 (WAGES 2ND QUARTER AFTER THE EXIT QUARTER) < 999999.99) and PIRL 901 (DATE OF Program EXIT) is within the reporting Period and PIRL 923 (OTHER REASON FOR EXIT)= 00)
D-4-3 Credential Rate (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of UNIQUE RECORDS from CREDENTIAL RATE DENOMINATOR where (((PIRL 1801 -DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 ((Date of Program Exit) <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL > 1) or ((PIRL 1803 - DATE ATTAINED RECOGNIZED CREDENTIAL #2) – PIRL 901 (Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 > 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 > 1)) or ((((PIRL 1801 DATE ATTAINED RECOGNIZED CREDENTIAL – PIRL 901 Date of Program Exit <= 365) and PIRL 1800 TYPE OF RECOGNIZED CREDENTIAL = 1) or ((PIRL 1803 DATE ATTAINED RECOGNIZED CREDENTIAL #2 – PIRL 901 Date of Program Exit <= 365) and PIRL 1802 TYPE OF RECOGNIZED CREDENTIAL #2 = 1) or ((PIRL 1805 DATE ATTAINED RECOGNIZED CREDENTIAL #3 – PIRL 901 Date of Program Exit <= 365) and PIRL 1804 TYPE OF RECOGNIZED CREDENTIAL #3 = 1)) and ((PIRL 1406 DATE ENROLLED IN POST-EXIT EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL – PIRL 901 Date of Program Exit <= 365) or PIRL 1600 EMPLOYED 1ST QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1602 EMPLOYED 2ND QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1604 EMPLOYED 3RD QUARTER AFTER EXIT QUARTER is (> 0 and < 9) or PIRL 1606 EMPLOYED 4TH QUARTER AFTER EXIT QUARTER is (> 0 and < 9))) DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1300 Received Training = 1 and PIRL 900 Date of Program Entry is not null and PIRL 901 Date of Program Exit is within the report period and ((PIRL 1303 TYPE OF TRAINING #1 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1310 TYPE OF TRAINING #2 = 02, 03, 04, 06, 07, 08, 09, 10 or PIRL 1315 TYPE OF TRAINING #3 = 02 , 03 , 04 , 06 , 07 , 08 , 09 , 10) or PIRL 1332 Participated in POSTSECONDARY Education During Program Participation = 1 or (PIRL 408 HIGHEST EDUCATIONAL LEVEL COMPLETED AT PROGRAM ENTRY = 0 and PIRL 1401 ENROLLED IN SECONDARY EDUCATION PROGRAM = 1)) and PIRL 923 OTHER REASON FOR EXIT = 00)
D-5-3 Measurable Skill Gains (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of UNIQUE RECORDS from MEASURABLE SKILLS GAIN DENOMINATOR where PIRL 1806 (Date of Most Recent Measurable skill gain: Educational Functioning Level (EFL)) is within the reporting period or (PIRL 1801 (DATE ATTAINED RECOGNIZED CREDENTIAL) is within the reporting period and PIRL 1800 (TYPE OF RECOGNIZED CREDENTIAL) = 1) or PIRL 1808 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1807 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: POSTSECONDARY TRANSCRIPT/REPORT CARD) is within the reporting period or PIRL 1809 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: TRAINING MILESTONE) is within the reporting period or PIRL 1810 (DATE OF MOST RECENT MEASURABLE SKILL GAINS: SKILLS PROGRESSION) is within the reporting period DIVIDED BY Count of UNIQUE RECORDS Where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 900 (DATE OF PROGRAM ENTRY) is not null and PIRL 900 (DATE OF PROGRAM ENTRY) <= end of report period and (PIRL 901 (DATE OF EXIT) is null or PIRL 901 (DATE OF EXIT) is within the report period) and PIRL 1811 (DATE ENROLLED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT (WIOA)) is not null and PIRL 923 (OTHER REASON FOR EXIT) = 00 or 07)
E. EFFECTIVENESS IN SERVING EMPLOYERS E-1-3 Retention with the Same Employer in the 2nd and 4th Quarter After Exit (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD 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 where PIRL 913 (Indian and Native American Programs) = 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

F. ADDITIONAL INDICATORS F-1-3 Percent in Training (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of UNIQUE RECORDS where (Percent in Training Denominator and PIRL 1300 (Received Training) = 1) DIVIDED BY Count of UNIQUE RECORDS where (PIRL 913 (Indian and Native American Programs) = 1 andPIRL 900 (Date of Program Entry) <= the end of the reporting period and PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null
F-2-3 Employability Skills Enhancement (Cohort Period: mm/dd/yyyy - mm/dd/yyyy) - TPYTD Count of unique records where (Employability Skill Enhancement DENOMINATOR and PIRL 1307 (Training Completed #1) = 1 or PIRL 1312 (Training Completed #2) = 1 or PIRL 1317 (Training Completed #3) = 1 or PIRL 1812 (School Status at Exit) = 1 or PIRL 1800 (Type of Recognized Credential) = 1 or PIRL 1802 (Type of Recognized Credential #2) = 1 or PIRL 1804 (Type of Recognized Credential #3) = 1 or PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is not null or PIRL 1205 (Type of Work Experience) = 5 or PIRL 1806 (Date of Most Recent Measurable Skill Gains: Educational Functioning Level (EFL)) is not null or PIRL 1807 (Date of Most Recent Measurable Skill Gains: Postsecondary Transcript/Report Card) is not null or PIRL 1808 (Date of Most Recent Measurable Skill Gains: Secondary Transcript/Report Card) is not null or PIRL 1809 (Date of Most Recent Measurable Skill Gains: Training Milestone) is not null or PIRL 1810 (Date of Most Recent Measurable Skill Gains: Skills Progression) is not null) DIVIDED BY Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 901 (Date of Program Exit) is not blank and PIRL 901 (Date of Program Exit) is <= the end of the reporting period and PIRL 901 (Date of Program Exit) >= the begining of the reporting period)
G. PARTICIPANT SERVICES AND ACTIVITIES G-1-3 Basic Career Services - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1003 (Most Recent Date Received Basic Career Services ) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2-3 Individual Career Services - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1201 (Most Recent Date Received Individualized Career Service) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-2a-3 Work Experience - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1203 (Most Recent Date Received Internship or Work Experience opportunities) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null))
G-3-3 Training Services - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 2, 3, 4, 5, 6, 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3a-3 Adult Basic Education or GED Preparation - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 4 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3b-3 Occupational Skills Training - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 2, 6 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3c-3 On-the-Job Training - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 1, 5 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3d-3 Registered Apprenticeship - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 9 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
G-3e-3 Entrepreneurial Skills Training - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and ((PIRL 1303 (Type of Training Service #1) = 3 and PIRL 1302 (Date Entered Training #1) is within the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is within the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is within the reporting period)) and
PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)

G-4-3 Supportive Service - TPYTD Count of unique records where (PIRL 913 (Indian and Native American Programs) = 1 and PIRL 1409 (Most Recent Date Received Supportive Services) is within the reporting period and PIRL 900 (Date of Program Entry) <= the end of the reporting period and (PIRL 901 (Date of Exit) >= the first date of the reporting period or PIRL 901 (Date of Exit) is null)
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy