Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
B. Grantee Summary Information
For each data row, include only those participants whose Enrollment Status = Complete
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

1. New Participants Enrolled

PQ
CQ
PYtD

Count number of participants with Enrollment Date in quarter prior to selected report quarter end date
Count number of participants with Enrollment Date in selected report quarter end date
Count number of participants with Enrollment Date in start date of program year in which selected report quarter
falls through selected report quarter end date
Count number of participants with Enrollment Date in start date of grant period through selected report quarter end
date
Count number of participants with:
1. any Program Service Date of Service in quarter prior to selected report quarter end date OR
2. Internship Date Entered in quarter prior to selected report quarter end date OR
3. Internship Date Completed in quarter prior to selected report quarter end date OR
4. YCC Course Date Began in quarter prior to selected report quarter end date

Enrollment Date
Program Year (for PYtD)

CGtD
2. Participants Receiving Program
Services

PQ

CQ

PYtD

CGtD

3. Participants Completed Program PQ
CQ
PYtD
CGtD
4. Participants Exited Program

PQ
CQ
PYtD
CGtD

Questions/Notes:

Program Service: Date of Service
Program year (for PYtD)
Internship Date Began
Internship Date Ended
YCC Course Date Began

Count number of participants with:
1. any Program Service Date of Service in selected report quarter end date OR
2. Internship Date Entered in selected report quarter end date OR
3. Internship Date Completed in selected report quarter end date OR
4. YCC Course Date Began in selected report quarter end date
Count number of participants with:
1. any Program Service Date of Service in start date of program year in which selected report quarter falls through
selected report quarter end date OR
2. Internship Date Entered in start date of program year in which selected report quarter falls through selected
report quarter end date OR
3. Internship Date Completed in start date of program year in which selected report quarter falls through selected
report quarter end date OR
4. YCC Course Date Began in start date of program year in which selected report quarter falls through selected
report quarter end date
Count number of participants with:
1. any Program Service Date of Service in start date of grant period through selected report quarter end date OR
2. Internship Date Entered in start date of grant period through selected report quarter end date OR
3. Internship Date Completed in start date of grant period through selected report quarter end date OR
4. YCC Course Date Began in start date of grant period through selected report quarter end date
Count number of participants with Program Completion Date in quarter prior to selected report quarter end date
Count number of participants with Program Completion Date in selected report quarter end date
Count number of participants with Program Completion Date in start date of program year in which selected report
quarter falls through selected report quarter end date
Count number of participants with Program Completion Date in start date of grant period through selected report
quarter end date
Count number of participants with Exit Date in quarter prior to selected report quarter end date
Count number of participants with Exit Date in selected report quarter end date
Count number of participants with Exit Date in start date of program year in which selected report quarter falls
through selected report quarter end date
Count number of participants with Exit Date in start date of grant period through selected report quarter end date

Exit Reason
Program Completion Date
Program Year (for PYtD)

Exit Reason
Exit Date
Program Year (for PYtD)

1

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
C. Participant Summary Information
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. count number of participants with Enrollment Date in the specified time frame
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

Gender
1a. Male

All

AND Gender = Male

Gender
1b. Female

All

AND Gender = Female

Ethnicity/Race
2a. Hispanic/Latino

All

AND Ethnicity = Hispanic or Latino

Ethnicity/Race
2b. American Indian or Alaska
Native
Ethnicity/Race
2c. Asian

All

AND Race = American Indian or Alaska Native

All

AND Ethnicity = Asian

Ethnicity/Race
2d. Black or African American

All

AND Ethnicity = Black or African American

Ethnicity/Race
2e. Native Hawaiian or Other
Pacific Islander
Ethnicity/Race
2f. White

All

AND Ethnicity = Native Hawaiian or Other Pacific Islander

All

AND Ethnicity = White

Ethnicity/Race
2g. More Than One Race

All

Other Demographics
3a. Eligible Veteran

All

AND 2 or more of the following:
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
AND Eligible Veteran Status = (Yes, <=180 days OR Yes, Eligible Veteran OR Yes, Other Eligible Person)

Enrollment Date
Program Year (for PYtD)
Gender
Enrollment Date
Program Year (for PYtD)
Gender
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Ethnicity
Enrollment Date
Program Year (for PYtD)
Race
Ethnicity

Other Demographics
3b. Individuals with a Disability

All

AND Disability = Yes

Questions:

Enrollment Date
Program Year (for PYtD)
Eligible Veteran Status
Enrollment Date
Program Year (for PYtD)
Disability

2

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
C. Participant Summary Information
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. count number of participants with Enrollment Date in the specified time frame
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

Other Demographics
3c. Homeless/Runaway

All

AND Homeless Individual and/or Runaway Youth = Yes

Other Demographics
3d. Offender

All

AND Offender = Yes

Other Demographics
3e. Low Income

All

AND Low Income (Free/Reduced Lunch Eligible) = (Free lunch program eligible OR Reduced lunch program eligible)

Other Demographics
3f. Limited English Language
Proficiency

All

AND Limited English Language Proficiency = Yes

Enrollment Date
Program Year (for PYtD)
Homeless Individual and/or Runaway
Youth
Enrollment Date
Program Year (for PYtD)
Offender
Enrollment Date
Program Year (for PYtD)
Low Income (Free/Reduced Lunch
Eligible)
Enrollment Date
Program Year (for PYtD)
Limited English Language Proficiency

Other Demographics
3g. Pregnant/Parenting Youth

All

AND Pregnant or Parenting Youth = Yes

Other Demographics
3h. Foster Youth

All

AND Foster Care Youth = Yes

Grade at time of Enrollment
4a. 9th Grade

All

AND Grade at time of Enrollment = 9th grade

Grade at time of Enrollment
4b. 10th Grade

All

AND Grade at time of Enrollment = 10th grade

Grade at time of Enrollment
4c. 11th Grade

All

AND Grade at time of Enrollment = 11th grade

Questions:

Enrollment Date
Program Year (for PYtD)
Pregnant or Parenting Youth
Enrollment Date
Program Year (for PYtD)
Foster Care Youth
Enrollment Date
Program Year (for PYtD)
Grade at time of Enrollment
Enrollment Date
Program Year (for PYtD)
Grade at time of Enrollment
Enrollment Date
Program Year (for PYtD)
Grade at time of Enrollment

3

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
D. Program Services
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those Program Services with Date of Service between Enrollment Date and Exit Date, inclusive
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

1. Number of Professional
PQ
Development Activities Conducted
CQ
PYtD
CGtD
2. Number of Students Participated PQ
in Career/Academic Counseling
CQ

PYtD

CGtD

3. Number of Students Participated PQ
in Community Service Learning
CQ

PYtD

CGtD

4. Number of Students Participated PQ
in Mentoring

Calculation

PTS Fields used:

Count number of Professional Development Activity Records with Activity Date in quarter prior to selected report
quarter end date
Count number of Professional Development Activity Records with Activity Date in selected report quarter end date

Professional Development Activities
Activity Date
Program Year (for PYtD)

Count number of Professional Development Activity Records with Activity Date in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Professional Development Activity Records with Activity Date in start date of grant period through
selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Career/Academic Counseling AND
2. Date of Service in quarter prior to selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Career/Academic Counseling AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Career/Academic Counseling AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Career/Academic Counseling AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Community Service Learning AND
2. Date of Service in quarter prior to selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Community Service Learning AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Community Service Learning AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Community Service Learning AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Mentoring AND
2. Date of Service in quarter prior to selected report quarter end date

Questions:

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

4

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
D. Program Services
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those Program Services with Date of Service between Enrollment Date and Exit Date, inclusive
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
4. Number of Students Participated
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date
in Mentoring

Indicator Name

Time Period

1. Number of Professional
CQ
Development Activities Conducted
PYtD

CGtD

5. Number of Students Participated PQ
in Work Experience
CQ

PYtD

CGtD

6. Number of Students Participated PQ
in Leadership Development
CQ

PYtD

CGtD

Calculation
Count number of participants with one or more Program Service records having:
1. Service Category = Mentoring AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Mentoring AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Mentoring AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Work Experience Activity AND
2. Date of Service in quarter prior to selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Work Experience Activity AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Work Experience Activity AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Work Experience Activity AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Leadership Development AND
2. Date of Service in quarter prior to selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Leadership Development AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Leadership Development AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Leadership Development AND
2. Date of Service in start date of grant period through selected report quarter end date

Program Service: Service Category
Program Service: Date of Service
PTS Fields
Program
Yearused:
(for PYtD)
Professional Development Activities
Activity Date
Program Year (for PYtD)

Questions:

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

5

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
D. Program Services
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those Program Services with Date of Service between Enrollment Date and Exit Date, inclusive
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

1.
7. Number of Professional
Students who
PQ
Development
Activities
Conducted
Received
Supportive
Services
CQ

PYtD

CGtD

8. Number of Students Participated PQ
in Internship

CQ

PYtD

CGtD

9. Number of Students Participated PQ
in Employer Provided Services

Calculation

PTS Fields used:

Count number of participants with one or more Program Service records having:
1. Service Category = Support Service AND
2. Date of Service in quarter prior to selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Support Service AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Support Service AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Support Service AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with:
1. one or more Program Service records having Service Category = Internship AND Date of Service in quarter prior
to selected report quarter end date OR
2. Internship Date Entered in quarter prior to selected report quarter end date OR
3. Internship Date Completed in quarter prior to selected report quarter end date
Count number of participants with:
1. one or more Program Service records having a Service Category = Internship AND Date of Service in selected
report quarter end date OR
2. Internship Date Entered in selected report quarter end date OR
3. Internship Date Completed in selected report quarter end date
Count number of participants with:
1. one or more Program Service records having a Service Category = Internship AND Date of Service in start date
of program year in which selected report quarter falls through selected report quarter end date OR
2. Internship Date Entered in start date of program year in which selected report quarter falls through selected
report quarter end date OR
3. Internship Date Completed in start date of program year in which selected report quarter falls through selected
report quarter end date
Count number of participants with:
1. one or more Program Service records having a Service Category = Internship AND Date of Service in start date
of grant period through selected report quarter end date OR
2. Internship Date Entered in start date of grant period through selected report quarter end date OR
3. Internship Date Completed in start date of grant period through selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Employer Service in School AND
2. Date of Service in quarter prior to selected report quarter end date

Professional
Development
Activities
Program Service:
Service Category
Activity Date
Program
Service: Date of Service
Program Year (for PYtD)

Questions:

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)
Internships: Date Entered
Internships: Date Completed

Program Service: Service Category
Program Service: Date of Service
Program Year (for PYtD)

6

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
D. Program Services
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those Program Services with Date of Service between Enrollment Date and Exit Date, inclusive
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
9. Number of Students Participated
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date
in Employer Provided Services

Indicator Name

Time Period

1. Number of Professional
CQ
Development Activities Conducted
PYtD

CGtD

10. Number of Students Entered
Industry-Specific YCC Courses

PQ
CQ
PYtD

CGtD

Calculation

Program Service: Service Category
Program Service: Date of Service
PTS Fields
Program
Yearused:
(for PYtD)
Professional Development Activities
Activity Date
Program Year (for PYtD)

Questions:

Count number of participants with one or more Program Service records having:
1. Service Category = Employer Service in School AND
2. Date of Service in selected report quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Employer Service in School AND
2. Date of Service in start date of program year in which selected report quarter falls through selected report
quarter end date
Count number of participants with one or more Program Service records having:
1. Service Category = Employer Service in School AND
2. Date of Service in start date of grant period through selected report quarter end date
Count number of participants with one or more Industry-Specific YCC Course records having a Date Began in quarter Industry-Specific YCC Course:
prior to selected report quarter end date
Date Began
Count number of participants with one or more Industry-Specific YCC Course records having a Date Began in selected Program Year (for PYtD)
report quarter end date
Count number of participants with one or more Industry-Specific YCC Course records having a Date Began in start
date of program year in which selected report quarter falls through selected report quarter end date
Count number of participants with one or more Industry-Specific YCC Course records having a Date Began in start
date of grant period through selected report quarter end date

7

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.i. Participant Activities
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

1. Number of Students who
PQ
Entered Unsubsidized Employment
CQ
PYtD
CGtD
2. Number of Students who
Entered Training-Related
Employment

PQ

CQ

PYtD

CGtD

3. Number of Students who
Entered Long-Term Occupational
Skills Training

PQ
CQ
PYtD
CGtD

4. Number of Students who
PQ
Entered Post-Secondary Education
CQ

Calculation

PTS Fields used:

Questions:

Count number of Participants with Post Exit Outcome (PEO) Unsubsidized Employment Date Entered in quarter prior PEO Unsubsidized Employment Date
Entered
to selected report quarter end date
Count number of Participants with PEO Unsubsidized Employment Date Entered in selected report quarter end date Program Year (for PYtD)
Count number of Participants with PEO Unsubsidized Employment Date Entered in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Participants with PEO Unsubsidized Employment Date Entered in start date of grant period through
selected report quarter end date
Count number of Participants with PEO Unsubsidized Employment record with:
1. Training Related = Yes AND
2. Date Entered in quarter prior to selected report quarter end date
Count number of Participants with PEO Unsubsidized Employment record with:
1. Training Related = Yes AND
2. Date Entered in selected report quarter end date
Count number of Participants with PEO Unsubsidized Employment record with:
1. Training Related = Yes AND
2. Date Entered in start date of program year in which selected report quarter falls through selected report quarter
end date
Count number of Participants with PEO Unsubsidized Employment record with:
1. Training Related = Yes AND
2. Date Entered in start date of grant period through selected report quarter end date
Count number of Participants with PEO Occupational Skills Training Date Entered in quarter prior to selected report
quarter end date
Count number of Participants with PEO Occupational Skills Training Date Entered in selected report quarter end date
Count number of Participants with PEO Occupational Skills Training Date Entered in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Participants with PEO Occupational Skills Training Date Entered in start date of grant period
through selected report quarter end date
Count number of Participants with:
1. PEO Post-Secondary Education Date Entered in quarter prior to selected report quarter end date OR
2. Date First Entered Post-Secondary School in quarter prior to selected report quarter end date

PEO Unsubsidized Employment:
Date Entered
Training Related?
Program Year (for PYtD)

PEO Occupational Skills Training Date
Entered
Program Year (for PYtD)

PEO Post-Secondary Education Date
Entered
Program Year (for PYtD)

Count number of Participants with:
1. PEO Post-Secondary Education Date Entered in selected report quarter end date OR
2. Date First Entered Post-Secondary School in selected report quarter end date

8

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.i. Participant Activities
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
4. Number
of Students
Current
Quarter who
(CQ) = selected report quarter end date
Entered
Post-Secondary
Education
Program
Year to Date
(PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

1. Number of Students who
PYtD
Entered Unsubsidized Employment

CGtD

5. Number of Students who Earned PQ
an Industry-Recognized Credential
CQ
PYtD
CGtD
6. Number of Students who Earned PQ
a High School Diploma
CQ
PYtD
CGtD
7. Number of Students who
PQ
Entered Registered Apprenticeship
CQ
PYtD
CGtD

PEO Post-Secondary Education Date
Entered
Program Year (for PYtD)

Calculation

PTS Fields used:

Count number of Participants with:
1. PEO Post-Secondary Education Date Entered in start date of program year in which selected report quarter falls
through selected report quarter end date OR
2. Date First Entered Post-Secondary School in start date of program year in which selected report quarter falls
through selected report quarter end date
Count number of Participants with:
1. PEO Post-Secondary Education Date Entered in start date of grant period through selected report quarter end
date OR
2. Date First Entered Post-Secondary School in start date of grant period through selected report quarter end date

PEO Unsubsidized Employment Date
Entered
Program Year (for PYtD)

Questions:

Count number of Participants with STO Recognized Credentials Attainment Date in quarter prior to selected report Short Term Outcomes (STO)
quarter end date
Recognized Credentials Attainment
Count number of Participants with STO Recognized Credentials Attainment Date in selected report quarter end date Date
Program Year (for PYtD)
Count number of Participants with STO Recognized Credentials Attainment Date in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Participants with STO Recognized Credentials Attainment Date in start date of grant period through
selected report quarter end date
Count number of Participants with STO High School Diploma Attainment Date in quarter prior to selected report
Short Term Outcomes (STO) High
quarter end date
School Diploma Attainment Date
Program Year (for PYtD)
Count number of Participants with STO High School Diploma Attainment Date in selected report quarter end date
Count number of Participants with STO High School Diploma Attainment Date in start date of program year in which
selected report quarter falls through selected report quarter end date
Count number of Participants with STO High School Diploma Attainment Date in start date of grant period through
selected report quarter end date
Count number of Participants with PEO Registered Apprenticeship Date Entered in quarter prior to selected report PEO Registered Apprenticeship
quarter end date
Date Entered
Count number of Participants with PEO Registered Apprenticeship Date Entered in selected report quarter end date Program Year (for PYtD)
Count number of Participants with PEO Registered Apprenticeship Date Entered in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Participants with PEO Registered Apprenticeship Date Entered in start date of grant period through
selected report quarter end date

9

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.ii. Completion Outcomes
For each data row:
1. include only those participants with Enrollment Status = Complete
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

8. Number of Students who
Completed Program and Entered
Unsubsidized Employment

PQ

Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in quarter prior to
selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in selected report
quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in start date of
program year in which selected report quarter falls through selected report quarter end date

Program Completion Date
PEO Unsubsidized Employment Date
Entered
Program Year (for PYtD)

CQ

PYtD

9. Number of Students who
Completed Program and Entered
Training-Related Employment

CGtD

Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in start date of
grant period through selected report quarter end date

PQ

Count number of Participants with:
Program Completion Date
1. Program Completion Date AND
PEO Unsubsidized Employment
2. one or more PEO Unsubsidized Employment Date Entered AND
Date Entered
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in quarter prior to
Training Related?
selected report quarter end date
Program Year (for PYtD)

CQ

Questions:

Consider only those PEO Unsubsidized Employment records with Training Related = Yes
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in selected report
quarter end date
Consider only those PEO Unsubsidized Employment records with Training Related = Yes

10

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
9. Number of Students who
Completed Program and Entered
For
each data row:
Training-Related
Employment

Program Completion Date
PEO Unsubsidized Employment
Date Entered
1. include only those participants with Enrollment Status = Complete
Training Related?
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC
Course,
Short
Program
Year
(for Term
PYtD) Outcome, or Post-Exit Outcome.

E.ii. Completion Outcomes

Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

8. Number of Students who
Completed Program and Entered
Unsubsidized Employment

PYtD

Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in start date of
program year in which selected report quarter falls through selected report quarter end date

Program Completion Date
PEO Unsubsidized Employment Date
Entered
Program Year (for PYtD)

CGtD

10. Number of Students who
Completed Program and Entered
Long-Term Occupational Skills
Training

PQ

CQ

PYtD

CGtD

Questions:

Consider only those PEO Unsubsidized Employment records with Training Related = Yes
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Unsubsidized Employment Date Entered AND
3. either Program Completion Date OR at least one PEO Unsubsidized Employment Date Entered in start date of
grant period through selected report quarter end date
Consider only those PEO Unsubsidized Employment records with Training Related = Yes
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Occupational Skills Training Date Entered AND
3. either Program Completion Date OR at least one PEO Occupational Skills Training Date Entered in quarter prior
to selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Occupational Skills Training Date Entered AND
3. either Program Completion Date OR at least one PEO Occupational Skills Training Date Entered in selected
report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Occupational Skills Training Date Entered AND
3. either Program Completion Date OR at least one PEO Occupational Skills Training Date Entered in start date of
program year in which selected report quarter falls through selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Occupational Skills Training Date Entered AND
3. either Program Completion Date OR at least one PEO Occupational Skills Training Date Entered in start date of
grant period through selected report quarter end date

Program Completion Date
PEO Occupational Skills Training Date
Entered
Program Year (for PYtD)

11

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.ii. Completion Outcomes
For each data row:
1. include only those participants with Enrollment Status = Complete
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

8. Number
11.
NumberofofStudents
Studentswho
who
Completed Program and Entered
Unsubsidized
Employment
Post-Secondary
Education

PQ

Count number of Participants with:
1. Program Completion Date AND
2. ((one or more PEO Post-Secondary Education Date Entered) OR Date First Entered Post-Secondary School) AND
3. (Program Completion Date OR (at least one PEO Post-Secondary Education Date Entered) OR Date First Entered
Post-Secondary School) in quarter prior to selected report quarter end date

Program Completion Date
Unsubsidized Employment
Date
PEO Post-Secondary
Education Date
Entered
Program
(for PYtD)
Date
FirstYear
Entered
Post-Secondary
School
Program Year (for PYtD)

CQ

Count number of Participants with:
1. Program Completion Date AND
2. ((one or more PEO Post-Secondary Education Date Entered) OR Date First Entered Post-Secondary School) AND
3. (Program Completion Date OR (at least one PEO Post-Secondary Education Date Entered) OR Date First Entered
Post-Secondary School) in selected report quarter end date

PYtD

Count number of Participants with:
1. Program Completion Date AND
2. ((one or more PEO Post-Secondary Education Date Entered) OR Date First Entered Post-Secondary School) AND
3. (Program Completion Date OR (at least one PEO Post-Secondary Education Date Entered) OR Date First Entered
Post-Secondary School) in start date of program year in which selected report quarter falls through selected report
quarter end date

CGtD

Count number of Participants with:
1. Program Completion Date AND
2. ((one or more PEO Post-Secondary Education Date Entered) OR Date First Entered Post-Secondary School) AND
3. (Program Completion Date OR (at least one PEO Post-Secondary Education Date Entered) OR Date First Entered
Post-Secondary School) in start date of grant period through selected report quarter end date

12. Number of Students who
PQ
Completed Program and Earned an
Industry-Recognized Credential

CQ

Count number of Participants with:
1. Program Completion Date AND
2. one or more STO Recognized Credentials Attainment Date AND
3. either Program Completion Date OR at least one STO Recognized Credentials Attainment Date in quarter prior to
selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more STO Recognized Credentials Attainment Date AND
3. either Program Completion Date OR at least one STO Recognized Credentials Attainment Date in selected report
quarter end date

Questions:

Program Completion Date
STO Recognized Credentials
Attainment Date
Program Year (for PYtD)

12

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.ii. Completion Outcomes
For each data row:
1. include only those participants with Enrollment Status = Complete
2. for
any one
participant,
Course,
Short Term
Outcome, or Post-Exit Outcome.
12.
Number
of Students
whoconsider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC
Program
Completion
Date
Completed Program and Earned an
Industry-Recognized
Time frames definedCredential
as:

Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

STO Recognized Credentials
Attainment Date
Program Year (for PYtD)

Indicator Name

Time Period

Calculation

PTS Fields used:

8. Number of Students who
Completed Program and Entered
Unsubsidized Employment

PYtD

Count number of Participants with:
1. Program Completion Date AND
2. one or more STO Recognized Credentials Attainment Date AND
3. either Program Completion Date OR at least one STO Recognized Credentials Attainment Date in start date of
program year in which selected report quarter falls through selected report quarter end date

Program Completion Date
PEO Unsubsidized Employment Date
Entered
Program Year (for PYtD)

CGtD

Count number of Participants with:
1. Program Completion Date AND
2. one or more STO Recognized Credentials Attainment Date AND
3. either Program Completion Date OR at least one STO Recognized Credentials Attainment Date in start date of
grant period through selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. STO High School Diploma Attainment Date AND
3. either Program Completion Date OR STO High School Diploma Attainment Date in quarter prior to selected
report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. STO High School Diploma Attainment Date AND
3. either Program Completion Date OR STO High School Diploma Attainment Date in selected report quarter end
date
Count number of Participants with:
1. Program Completion Date AND
2. STO High School Diploma Attainment Date AND
3. either Program Completion Date OR STO High School Diploma Attainment Date in start date of program year in
which selected report quarter falls through selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. STO High School Diploma Attainment Date AND
3. either Program Completion Date OR STO High School Diploma Attainment Date in start date of grant period
through selected report quarter end date

13. Number of Students who
PQ
Completed Program and Earned a
High School Diploma

CQ

PYtD

CGtD

14. Number of Students who
Completed Program and Entered
Registered Apprenticeship

PQ

Questions:

Program Completion Date
STO High School Diploma Attainment
Date
Program Year (for PYtD)

Count number of Participants with:
Program Completion Date
1. Program Completion Date AND
PEO Registered Apprenticeship
2. one or more PEO Registered Apprenticeship Date Entered AND
Date Entered
3. either Program Completion Date OR at least one PEO Registered Apprenticeship Date Entered in quarter prior to Program Year (for PYtD)
selected report quarter end date

13

1/5/2015

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report
E.ii. Completion Outcomes
For each data row:
1. include only those participants with Enrollment Status = Complete
2. for any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
14. Number
of Students
who (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Program
Year to Date
Completed Program and Entered
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date
Registered Apprenticeship

Indicator Name

Time Period

Calculation

8. Number of Students who
Completed Program and Entered
Unsubsidized Employment

CQ

Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Registered Apprenticeship Date Entered AND
3. either Program Completion Date OR at least one PEO Registered Apprenticeship Date Entered in selected report
quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Registered Apprenticeship Date Entered AND
3. either Program Completion Date OR at least one PEO Registered Apprenticeship Date Entered in start date of
program year in which selected report quarter falls through selected report quarter end date
Count number of Participants with:
1. Program Completion Date AND
2. one or more PEO Registered Apprenticeship Date Entered AND
3. either Program Completion Date OR at least one PEO Registered Apprenticeship Date Entered in start date of
grant period through selected report quarter end date

PYtD

CGtD

Program Completion Date
PEO Registered Apprenticeship
Date Entered
Program Year (for PYtD)

PTS Fields used:

Questions:

Program Completion Date
PEO Unsubsidized Employment Date
Entered
Program Year (for PYtD)

14

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High School Participant is defined as participant with Attending School that has Type = High School
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).

Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

1. Enrollment Rate

PYtD

Numerator: # participants with enrollment date in start date of program year in which selected report quarter
falls through selected report quarter end date

Enrollment Date
Enrollment Status
Program Year
Enrollment Goal

The number of participants enrolled
in the program compared to the
target number of participants
identified in the grant application
CGtD

2. Attendance Rate

PQ

The rate of school attendance by
high school participants in the
program

Denominator: Yearly Enrollment Goal for program year in which selected report quarter falls (to be provided by
DOE)
Numerator: # participants with enrollment date in start date of grant period through selected report quarter end
date
Denominator: Total Enrollment Goal for grant period (to be provided by DOE)
Numerator:
(# schools days in quarter prior to selected report quarter end date) - (# school days missed in
quarter prior to selected report quarter end date)

Questions:

Enrollment Date
Enrollment Status
Enrollment Goal
Schools days missed each quarter
School days in each quarter
Number of high school participants

Denominator: # schools days in quarter prior to selected report quarter end date

CQ

Calculate for each active high school participant and then take an average of the results.
Numerator:
(# schools days in selected report quarter) - (# school days missed in selected report quarter)
Denominator: # schools days in selected report quarter

Schools days missed each quarter
School days in each quarter
Number of high school participants

Calculate for each active high school participant and then take an average of the results.
PYtD

Numerator:
(# schools days from start date of program year in which selected report quarter falls through
selected report quarter end date) - (# school days missed from start date of program year in which selected report
quarter falls through selected report quarter end date)

Schools days missed each quarter
School days in each quarter
Number of high school participants

Denominator: # schools days from start date of program year in which selected report quarter falls through
selected report quarter end date

CGtD

3. Chronic Absence Rate
The percentage of high school
participants who have missed 10
percent of school days for any
reason--excused or unexcused--as
well as suspensions

PQ

Calculate for each active high school participant and then take an average of the results.
Numerator:
(# schools days from start date of grant period through selected report quarter end date) - (# school Schools days missed each quarter
days missed from start date of grant period through selected report quarter end date)
School days in each quarter
Number of high school participants
Denominator: # schools days from start date of grant period through selected report quarter end date
Calculate for each active high school participant and then take an average of the results.
Numerator: # of active high school participants whose individual attendance rate is below 90% in quarter prior to School days missed each quarter
selected report quarter end date
School days in each quarter
Number of high school participants
Denominator: # of active high school participants as of report quarter end date prior to selected report quarter end
date

15

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High School Participant is defined as participant with Attending School that has Type = High School
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).

Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
3. Chronic
Absence
Rate(CQ) = selected report quarter end date
Current
Quarter
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
The percentage
of high
school
Cumulative
Grant
to Date (CGtD) = start date of grant period through selected report quarter end date
participants who have missed 10
Indicator
Name
percent
of school
days for any
reason--excused or unexcused--as
well as suspensions

Time Period

Calculation

CQ

Numerator: # of active high school participants whose individual attendance rate is below 90% in selected report School days missed each quarter
quarter end date
School days in each quarter
Number of high school participants
Denominator: # of active high school participants as of selected report quarter end date
Numerator: # of active high school participants whose individual attendance rate is below 90% from start date of School days missed each quarter
program year in which selected report quarter falls through selected report quarter end date
School days in each quarter
Number of high school participants
Denominator: # of active high school participants in start date of program year in which selected report quarter falls
through selected report quarter end date

PYtD

CGtD

Numerator: # of active high school participants whose individual attendance rate is below 90% from start date of
grant period through selected report quarter end date

PTS Fields used:

Questions:

School days missed each quarter
School days in each quarter
Number of high school participants

Denominator: # of active high school participants enrolled in start date of grant period through selected report
quarter end date
4. Mentoring Rate

PQ

CQ

PYtD

CGtD

Numerator:
# of participants with:
1. Program Service Date of Service in quarter prior to selected report quarter end date AND
2. Service Category = Mentoring
Denominator: # of participants active in quarter prior to selected report quarter end date
Numerator:
# of participants with:
1. Program Service Date of Service in selected report quarter end date AND
2. Service Category = Mentoring
Denominator: # of participants active in selected report quarter end date
Numerator:
# of participants with:
1. Program Service Date of Service in start date of program year in which selected report quarter falls through
selected report quarter end date AND
2. Service Category = Mentoring
Denominator: # of participants active in start date of program year in which selected report quarter falls through
selected report quarter end date
Numerator: # of participants with:
1. Program Servce Date of Service in start date of grant period through selected report quarter end date AND
2. Service Category = Mentoring

Service Category
Date of Service (Program Service)

Service Category
Date of Service (Program Service)

Service Category
Date of Service (Program Service)

Service Category
Date of Service (Program Service)

Denominator: # of participants enrolled in start date of grant period through selected report quarter end date

16

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High School Participant is defined as participant with Attending School that has Type = High School
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).

Time frames defined as:
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

5. Yearly Program Retention Rate
(starting in year 2)

PYtD

Use formula below corresponding to program year in which selected quarter end date falls. For Program Enrollment Date
Program Participation Date
Year 1, cell is NA.

PTS Fields used:

Questions:

Expected Cohort Completion Date
Percentage of participants who
continue in program from one
school year to the next

Program Year 2 Retention
Numerator: # of participants:
1. enrolled in PY1 AND
2. Year 2 Program Participation Date entered

Num - people that move from one
year to the next
Den - anyone enrolled in program
who would be expected to move
from prior program year to current
program year

Denominator: # of participants enrolled in PY1
Program Year 3 Retention
Numerator:
# of participants:
1. enrolled in (PY1 or PY2) AND
2. Expected Cohort Completion Date in Program Year 3 or later AND
3. Year 3 Program Participation Date entered
Denominator: # of participants:
1. enrolled in (PY1 or PY2) AND
2. Expected Cohort Completion Date in Program Year 3 or later
Program Year 4 Retention
Numerator: # of participants:
1. enrolled in (PY1 or PY2 or PY3) AND
2. Expected Cohort Completion Date in Program Year 4 or later AND
3. Year 4 Program Participation Date entered

CGtD

6. Work Readiness Indicator
Percentage of participants who are
deemed work ready based on an
employer evaluation conducted at
the end of each paid and unpaid
internship

PQ

Denominator: # of participants:
1. enrolled in
(PY1
or PY2
or PY3)Year
AND
Numerator:
sum
yearly
Program
to Date retention rates
Denominator: count of program years (current and past)
Numerator:
# of participants with:
1. Internship Date Completed in quarter prior to selected report quarter end date AND
2. Scored as Work Ready on Work Readiness Indicator at completion of internship = Yes

Program Participation Date

Internship Date Completed
Scored as Work Ready

Denominator: # of participants with Internship Date Completed in quarter prior to selected report quarter end date
CQ

Numerator:
# of participants with:
1. Internship Date Completed in selected report quarter end date AND
2. Scored as Work Ready on Work Readiness Indicator at completion of internship = Yes
Denominator: # of participants with Internship Date Completed in selected report quarter

Internship Date Completed
Scored as Work Ready

17

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High
School
Participant
is defined as participant with Attending School that has Type = High School
6. Work
Readiness
Indicator
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).
Percentage of participants who are
deemed work ready based on an
employer
evaluation
at
Time
frames
definedconducted
as:
the end
of each Quarter
paid and (PQ)
unpaid
Previous
= quarter prior to selected report quarter end date
internship
Current Quarter (CQ) = selected report quarter end date

Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

PYtD

Numerator:
# of participants with:
1. Internship Date Completed in start date of the program year in which selected report quarter falls through
selected report quarter end date AND
2. Scored as Work Ready on Work Readiness Indicator at completion of internship = Yes

Internship Date Completed
Scored as Work Ready

CGtD

Denominator: # of participants with Internship Date Completed in start date of program year in which selected
report quarter falls through selected report quarter end date
Numerator:
# of participants with:
1. Internship Date Completed in start date of grant period through selected report quarter end date AND
2. Scored as Work Ready on Work Readiness Indicator at completion of internship = Yes

Questions:

Internship Date Completed
Scored as Work Ready

Denominator: # of participants with Internship Date Completed in start date of grant period through selected
report quarter end date
7. Internship Placement Rate

PQ

Percentage of program participants
who begin a paid or unpaid
internship
CQ

PYtD

CGtD

Numerator:

# of participants with Internship Date Entered in quarter prior to selected report quarter end date

Internship Date Entered

Denominator: # of participants active in quarter prior to selected report quarter end date
Numerator:

# of participants with Internship Date Entered in selected report quarter end date

Denominator: # of participants active in selected report quarter end date
Numerator: # of participants with Internship Date Entered in start date of program year in which selected report
quarter falls through selected report quarter end date
Denominator: # of participants active in start date of program year in which selected report quarter falls through
selected report quarter end date
Numerator: # of participants with Internship Date Entered in start date of grant period through selected report
quarter end date

Internship Date Entered

Internship Date Entered

Internship Date Entered

Denominator: # of participants enrolled in start date of grant period through selected report quarter end date
8. Internship Completion Rate
Of those participants who engage in
a paid or unpaid internship, the
percentage who complete

PQ

Numerator:

# of participants with Internship Date Completed in quarter prior to selected report quarter end date Internship Date Completed
Internship Date Entered
Denominator: # of participants who engaged in internship in quarter prior to selected report quarter end date
Program Service:
Date of Service
"Engaged in internship" is defined as:
Service Category
1. one or more Program Service records having Service Category = Internship AND Date of Service in quarter prior
to selected report quarter OR
2. Internship Date Entered in quarter prior to selected report quarter end date OR
3. Internship Date Completed in quarter prior to selected report quarter end date

18

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High
School Completion
ParticipantRate
is defined as participant with Attending School that has Type = High School
8. Internship
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).
Of those participants who engage in
a paid or unpaid internship, the
percentage
who
complete
Time
frames
defined
as:

Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

CQ

Numerator:

PTS Fields used:
# of participants with Internship Date Completed in selected report quarter end date

Denominator: # of participants who engaged in internship in selected report quarter end date

PYtD

"Engaged in internship" is defined as:
1. one or more Program Service records having Service Category = Internship AND Date of Service in selected
report quarter OR
2. Internship Date Entered in selected report quarter OR
3. Internship Date Completed in selected report quarter
Numerator: # of participants with Internship Date Completed in start date of program year in which selected
report quarter falls through selected report quarter end date
Denominator: # of participants who engaged in internship in start date of program year in which selected report
quarter falls through selected report quarter end date

Questions:

Internship Date Completed
Internship Date Entered
Program Service:
Date of Service
Service Category

Internship Date Completed
Internship Date Entered
Program Service:
Date of Service
Service Category

"Engaged in internship" is defined as:
1. one or more Program Service records having Service Category = Internship AND Date of Service in start date of
program year in which selected report quarter falls through selected report quarter end date OR
2. Internship Date Entered in start date of program year in which selected report quarter falls through selected
report quarter end date OR
3. Internship Date Completed in start date of program year in which selected report quarter falls through selected
report quarter end date
CGtD

9. Post-Secondary Credit Attainment PQ
Rate

CQ

Numerator: # of participants with an Internship Date Completed in start date of grant period through the selected Internship Date Completed
report quarter end date
Internship Date Entered
Program Service:
Denominator: # of participants who engaged in an internship in start date of grant period through the selected
Date of Service
report quarter end date
Service Category
"Engaged in internship" is defined as:
1. one or more Program Service records having Service Category = Internship AND Date of Service in start date of
grant period through selected report quarter end date OR
2. Internship Date Entered in start date of grant period through selected report quarter end date OR
3. Internship Date Completed in start date of grant period through selected report quarter end date
Numerator: # of participants with Post-Secondary Credit Date of Course Completion in quarter prior to selected Post-Secondary Credit - Date of
report quarter end date
Course Completion
Denominator: # of participants active in quarter prior to selected report quarter end date
Numerator: # of participants with Post-Secondary Credit Date of Course Completion in selected report quarter
end date
Denominator: # of participants active in selected report quarter end date

Post-Secondary Credit - Date of
Course Completion

19

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

F. Short Term Performance Indicators
For each data row:
1. include only those participants whose Enrollment Status = Complete
2. For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
High School Participant is defined as participant with Attending School that has Type = High School
Active participant is defined as participant with an Enrollment date AND (with no Exit Date OR Exit Date within specified time frame).
9. Post-Secondary Credit Attainment
Rate frames defined as:
Time
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter falls through selected report quarter end date
Cumulative Grant to Date (CGtD) = start date of grant period through selected report quarter end date

Indicator Name

Time Period

Calculation

PTS Fields used:

PYtD

Numerator: # of participants with Post-Secondary Credit Date of Course Completion in program year in which
selected report quarter falls through selected report quarter end date

Post-Secondary Credit - Date of
Course Completion

Denominator: # of participants active in program year in which selected report quarter falls
Numerator: # of participants with Post-Secondary Credit Date of Course Completion in start date of grant period
through the selected report quarter end date

Post-Secondary Credit - Date of
Course Completion

CGtD

Questions:

Denominator: # of participants enrolled in start date of grant period through selected report quarter end date
10. Average Post-Secondary Credit
Hours Attained

PQ

CQ

PYtD

CGtD

Numerator:
Sum of Number of Hours of Post-Secondary Credit for records with Post-Secondary Credit Date of
Course Completion in quarter prior to selected report quarter end date
Denominator: # of participants with Post-Secondary Credit Date of Course Completion in quarter prior to selected
report quarter end date
Numerator:
Sum of Number of Hours of Post-Secondary Credit for records with Post-Secondary Credit Date of
Course Completion in selected report quarter end date
Denominator: # of participants with Post-Secondary Credit Date of Course Completion in selected report quarter
end date
Numerator: Sum of Number of Hours of Post-Secondary Credit for records with Post-Secondary Credit Date of
Course Completion in start date of program year in which selected report quarter falls through selected report
quarter end date

Post-Secondary Credit - Date of
Course Completion
Number of Hours of Post-Secondary
Credit
Post-Secondary Credit - Date of
Course Completion
Number of Hours of Post-Secondary
Credit
Post-Secondary Credit - Date of
Course Completion
Number of Hours of Post-Secondary
Credit

Denominator: # of participants with Post-Secondary Credit Date of Course Completion in start date of program year
in which selected report quarter falls through selected report quarter end date
Numerator: Sum of Number of Hours of Post-Secondary Credit for records with Post-Secondary Credit Date of
Post-Secondary Credit - Date of
Course Completion in start date of grant period through selected report quarter end date
Course Completion
Number of Hours of Post-Secondary
Denominator: # of participants with Post-Secondary Credit Date of Course Completion in start date of grant period Credit
through selected report quarter end date

20

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

G. Long Term Performance Indicators
For each data row below, consider only those participants whose Enrollment Status = Complete
For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as (for data rows 1-4 ONLY):
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter end date falls through selected report quarter end date
Cumulative
Date (CGtD)
of grant period through selected report quarter end date
Indicator
NameGrant toTime
Period= start date
Calculation
PTS Fields used:
1. Program Completion
Rate

PYtD

Percentage of
participants who
complete the program, of
those who enter the
program
CGtD

Numerator: # of participants with:
1. Expected Cohort Completion Date in start date of program year in which selected report quarter end date falls
through selected report quarter end date AND
2. Program Completion Date on or before selected report quarter end date
Denominator: # of participants with Expected Cohort Completion Date in start date of program year in which
selected report quarter end date falls through selected report quarter end date
Numerator:
# of participants with:
1. Expected Cohort Completion Date in start date of grant period through selected report quarter end date AND
2. Program Completion Date on or before selected report quarter end date

Questions

Enrollment Date
Expected Cohort Completion Date
Program Completion Date

Enrollment Date
Expected Cohort Completion Date
Program Completion Date

Denominator: # of participants with Expected Cohort Completion Date in start date of grant period through selected
report quarter end date
2. High School Diploma
Attainment Rate
Of participants who have
reached their expected
graduation date,
percentage who attain a
high school diploma

PQ

Numerator: # of participants with:
H.S. Diploma Attainment Date
1. Expected High School Graduation Date in quarter prior to selected report quarter end date AND
Expected High School Graduation Date
2. High School Diploma Attainment Date on or before end date of quarter prior to selected report quarter end date
Denominator: # of participants with Expected High School Graduation Date in quarter prior to selected report
quarter end date

CQ

Numerator: # of participants with:
1. Expected High School Graduation Date in selected report quarter end date AND
2. High School Diploma Attainment Date on or before selected report quarter end date

H.S. Diploma Attainment Date
Expected High School Graduation Date

Denominator: # of participants with Expected High School Graduation Date in selected report quarter end date
PYtD

Numerator:
# of participants with:
1. Expected High School Graduation Date in start date of program year in which selected report quarter end date
falls through selected report quarter end date AND
2. High School Diploma Attainment Date on or before selected report quarter end date

H.S. Diploma Attainment Date
Expected High School Graduation Date

Denominator: # of participants with Expected High School Graduation Date in start date of program year in which
selected report quarter end date falls through selected report quarter end date
CGtD

Numerator:
# of participants with:
1. Expected High School Graduation Date in start date of grant period through selected report quarter end date
AND
2. High School Diploma Attainment Date on or before selected report quarter end date

H.S. Diploma Attainment Date
Expected High School Graduation Date

Denominator: # of participants with Expected High School Graduation Date in start date of grant period through
selected report quarter end date
3. Industry-Recognized
Credential Attainment
Rate
Of participants who have
reached their expected
cohort completion date,
percentage who attain an

21

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

G. Long Term Performance Indicators
For each data row below, consider only those participants whose Enrollment Status = Complete
For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Time frames defined as (for data rows 1-4 ONLY):
Previous Quarter (PQ) = quarter prior to selected report quarter end date
Current Quarter (CQ) = selected report quarter end date
Program Year to Date (PYtD) = start date of program year in which selected report quarter end date falls through selected report quarter end date
Cumulative
Date (CGtD)
of grant period through selected report quarter end date
Indicator
NameGrant toTime
Period= start date
Calculation
PTS Fields used:
1. Industry-Recognized
Program Completion
3.
PQ
Rate
Credential Attainment
Rate
Percentage of
participants
who
Of participants
who have
completetheir
the program,
reached
expected of
those who
enter the
cohort
completion
date,
program
percentage who attain an
industry-recognized
CQ
credential during the
program

Numerator:
# of participants with:
1. Expected Cohort Completion Date in quarter prior to selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
3. Recognized Credential Attainment Date before Exit Date
Denominator: # of participants with:
1. Expected Cohort Completion Date in quarter prior to selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes
Numerator:
# of participants with:
1. Expected Cohort Completion Date in selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
3. Recognized Credential Attainment Date before Exit Date
Denominator: # of participants with:
1. Expected Cohort Completion Date in selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes

PYtD

CGtD

Numerator:
# of participants with:
1. Expected Cohort Completion Date in start date of program year in which selected report quarter end date falls
through selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
3. Recognized Credential Attainment Date before Exit Date
Denominator: # of participants with:
1. Expected Cohort Completion Date in start date of program year in which selected report quarter end date falls
through selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes
Numerator:
# of participants with:
1. Expected Cohort Completion Date in start date of grant period through selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
3. Recognized Credential Attainment Date before Exit Date
Denominator: # of participants with:
1. Expected Cohort Completion Date in start date of grant period through selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes

4. Diploma and Credential PQ
Attainment Rate
Of participants who have
reached their expected
cohort completion date
and are in an industry/
occupational focus that
results in a credential
during the program,
percentage who attain a
high school diploma and
credential

Numerator:
# of participants with:
1. Expected Cohort Completion Date in quarter prior to selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
3. Recognized Credential Attainment Date before Exit Date AND
4. High School Diploma Attainment Date on or before end date of quarter prior to selected report quarter end date
Denominator: # of participants with:
1. Expected Cohort Completion Date in quarter prior to selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes

Questions

Recognized Credential Attainment Date
Expected Cohort Completion Date
Is Participant in an Ind/Occ focus that
can result in a credential during the YCC
program?
Exit Date

Recognized Credential Attainment Date
Expected Cohort Completion Date
Is Participant in an Ind/Occ focus that
can result in a credential during the YCC
program?
Exit Date

Recognized Credential Attainment Date
Expected Cohort Completion Date
Is Participant in an Ind/Occ focus that
can result in a credential during the YCC
program?
Exit Date

Recognized Credential Attainment Date
Expected Cohort Completion Cate
Is Participant in an Ind/Occ focus that
can result in a credential during the YCC
program?
Exit Date

H.S. Diploma Attainment Date
Recognized Credential Attainment date
Program Year
Expected Cohort Completion Date
Is Participant in an Ind/Occ focus that
can result in a credential during the YCC
program?

22

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

G. Long Term Performance Indicators

4. Diploma and Credential
Attainment Rate

For each data row below, consider only those participants whose Enrollment Status = Complete
For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.
Of participants who have
reached their expected
Time frames
defined
cohort
completion
dateas (for data rows 1-4 ONLY):
Previous
Quarter (PQ) = quarter prior to selected report quarter end date
and are
in an industry/
Currentfocus
Quarter
occupational
that (CQ) = selected report quarter end date
Year to Date (PYtD) = start date of program year in which selected report quarter end date falls through selected report quarter end date
resultsProgram
in a credential
Cumulative
Date (CGtD)
of grant period through selected report quarter end date
during
the program,
Indicator
NameGrant toTime
Period= start date
Calculation
PTS Fields used:
percentage
who attain a CQ
1.
Program Completion
Numerator:
# of participants with:
H.S. Diploma Attainment Date
high school diploma and
Rate
1. Expected Cohort Completion Date in selected report quarter end date AND
Recognized Credential Attainment date
credential
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
Program Year
Percentage of
3. Recognized Credential Attainment Date before Exit Date AND
Expected Cohort Completion Date
participants who
4. High School Diploma Attainment Date on or before selected report quarter end date
Is Participant in an Ind/Occ focus that
complete the program, of
can result in a credential during the YCC
those who enter the
Denominator: # of participants with:
program?
program
1. Expected Cohort Completion Date in selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes
PYtD
Numerator:
# of participants with:
H.S. Diploma Attainment Date
1. Expected Cohort Completion Date in start date of program year in which selected report quarter end date falls Recognized Credential Attainment date
through selected report quarter end date AND
Program Year
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
Expected Cohort Completion Date
3. Recognized Credential Attainment Date before Exit Date AND
Is Participant in an Ind/Occ focus that
4. High School Diploma Attainment Date on or before selected report quarter end date
can result in a credential during the YCC
program?
Denominator: # of participants with:
1. Expected Cohort Completion Date in start date of program year in which selected report quarter end date falls
through selected report quarter end date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes
CGtD
Numerator:
# of participants with:
H.S. Diploma Attainment Date
1. Expected Cohort Completion Date from the start of the grant period through the selected report quarter end
Recognized Credential Attainment Date
date AND
Expected Cohort Completion Date
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes AND
Is Participant in an Ind/Occ focus that
3. Recognized Credential Attainment Date before Exit Date AND
can result in a credential during the YCC
4. High School Diploma Attainment Date on or before selected report quarter end date
program?

5. Placement Rate
Of participants who have
exited the program,
percentage who are
placed in one of the
following:
-unsubsidized
employment
-post=secondary
education
-occupational skills
training,
-registered apprenticeship
Participant is first
included in the
denominator in the first
full quarter after program

PQ

Denominator: # of participants with:
1. Expected Cohort Completion Date from the start of the grant period through the selected report quarter end
date AND
2. Is participant in an Ind/Occ focus that can result in a credential during the YCC program = Yes
Numerator: # of participants with:
1. Exit Date in quarter that is two quarters prior to selected report quarter end date AND
2. (Post-Exit Unsubsidized Employment Date Entered OR
Post-Secondary Education Date Entered OR
Occupational Skills Training Date Entered OR
Registered Apprenticeship Date Entered) is on or before end date of quarter prior to selected report quarter
end date

Questions

Post-Exit Unsubsidized Employment
Date Entered
Post-Secondary Education Date Entered
Occupational Skills Training Date
Entered
Registered Apprenticeship Date Entered
Exit Date

Denominator: # of participants with Exit Date in quarter that is two quarters prior to selected report quarter end
date

23

Youth CareerConnect Aggregation Rules for Calculating the Quarterly Performance Report

1/5/2015

G. Long Term Performance Indicators
5.
ForPlacement
each dataRate
row below, consider only those participants whose Enrollment Status = Complete

For any one participant, consider only those records with an "event" date on or after Enrollment Date. An "event" is defined as Program Service, Internships YCC Course, Short Term Outcome, or Post-Exit Outcome.

Of participants who have
exited the program,
Time frames defined as (for data rows 1-4 ONLY):
percentage who are
(PQ) = quarter prior to selected report quarter end date
placedPrevious
in one ofQuarter
the
Current Quarter (CQ) = selected report quarter end date
following:
Program Year to Date (PYtD) = start date of program year in which selected report quarter end date falls through selected report quarter end date
-unsubsidized
Cumulative
Date (CGtD)
of grant period through selected report quarter end date
Indicator
NameGrant toTime
Period= start date
Calculation
employment
-post=secondary
1. Program Completion
CQ
Numerator: # of participants with:
education
Rate
1. Exit Date in quarter prior selected report quarter end date AND
-occupational skills
2. (Post-Exit Unsubsidized Employment Date Entered OR
training,
Percentage of
Post-Secondary Education Date Entered OR
-registered
participantsapprenticeship
who
Occupational Skills Training Date Entered OR
complete the program, of
Registered Apprenticeship Date Entered) is on or before selected report quarter end date
Participant
is firstthe
those who enter
included
program in the
Denominator: # of participants with Exit Date in quarter prior to selected report quarter end date
denominator in the first
PYtD
Numerator: # of participants with:
full quarter after program
1. Exit Date in start date of program quarter 4 of program year prior to program year in which selected report
exit
quarter end date falls through quarter prior to selected report quarter end date AND
2. (Post-Exit Unsubsidized Employment Date Entered OR
Post-Secondary Education Date Entered OR
Occupational Skills Training Date Entered OR
Registered Apprenticeship Date Entered OR
Date First Entered Post-Secondary School) is on or before quarter end date of first full quarter after exit date

PTS Fields used:

Questions

Post-Exit Unsubsidized Employment
Date Entered
Post-Secondary Education Date Entered
Occupational Skills Training Date
Entered
Registered Apprenticeship Date Entered
Exit Date
Post-Exit Unsubsidized Employment
Date Entered
Post-Secondary Education Date Entered
Occupational Skills Training Date
Entered
Registered Apprenticeship Date Entered
Exit Date

Denominator: # of participants with Exit Date in start date of program quarter 4 of program year prior to program
year in which the selected report quarter end date falls through quarter prior to selected report quarter end date
CGtD

Numerator: # of participants with:
1. Exit Date in start date of grant period through quarter prior to selected report quarter end date AND
2. (Post-Exit Unsubsidized Employment Date Entered OR
Post-Secondary Education Date Entered OR
Occupational Skills Training Date Entered OR
Registered Apprenticeship Date Entered OR
Date First Entered Post-Secondary School) is on or before quarter end date of first full quarter after exit date

Post-Exit Unsubsidized Employment
Date Entered
Post-Secondary Education Date Entered
Occupational Skills Training Date
Entered
Registered Apprenticeship Date Entered
Exit Date

Denominator: # of participants with Exit Date in start date of grant period through quarter prior to selected report
quarter end date

24