INA_QPR_Template_and_Specifications.xlsx

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 1803 (DATE ATTAINED RECOGNIZED CREDENTIAL #2) is within the reporting period and PIRL 1802 (TYPE OF RECOGNIZED CREDENTIAL #2) = 1) or PIRL 1805 (DATE ATTAINED RECOGNIZED CREDENTIAL #3) is within the reporting period and PIRL 1804 (TYPE OF RECOGNIZED CREDENTIAL #3) = 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 (DATE COMPLETED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT is null or within the reporting period) 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. ADDITIONAL INDICATORS	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 <= the end of 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 <= the end of 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 <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 and PIRL 1302 (Date Entered Training #1) is <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 1803 (DATE ATTAINED RECOGNIZED CREDENTIAL #2) is within the reporting period and PIRL 1802 (TYPE OF RECOGNIZED CREDENTIAL #2) = 1) or PIRL 1805 (DATE ATTAINED RECOGNIZED CREDENTIAL #3) is within the reporting period and PIRL 1804 (TYPE OF RECOGNIZED CREDENTIAL #3) = 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 (DATE COMPLETED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT is null or within the reporting period) 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. ADDITIONAL INDICATORS	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 <= the end of 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 <= the end of 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 <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 and PIRL 1302 (Date Entered Training #1) is <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 1803 (DATE ATTAINED RECOGNIZED CREDENTIAL #2) is within the reporting period and PIRL 1802 (TYPE OF RECOGNIZED CREDENTIAL #2) = 1) or PIRL 1805 (DATE ATTAINED RECOGNIZED CREDENTIAL #3) is within the reporting period and PIRL 1804 (TYPE OF RECOGNIZED CREDENTIAL #3) = 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 (DATE COMPLETED DURING PROGRAM PARTICIPATION IN AN EDUCATION OR TRAINING PROGRAM LEADING TO A RECOGNIZED POSTSECONDARY CREDENTIAL OR EMPLOYMENT is null or within the reporting period) 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. ADDITIONAL INDICATORS	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 <= the end of 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 <= the end of 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 <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 4 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 4 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 2, 6 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 2, 6 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 1, 5 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 1, 5 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 9 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 9 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 <= the end of the reporting period) or (PIRL 1310 (Type of Training Service #2) = 3 and PIRL 1309 (Date Entered Training #2) is <= the end of the reporting period) or (PIRL 1315 (Type of Training Service #3) = 3 and PIRL 1314 (Date Entered Training #3) is <= the end of 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 Type	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified	0000-00-00
File Created	0000-00-00