PIMS Keystone Exemption Extract

Tool Search: PIMS Extracts

The Keystone Exemption Extract identifies students enrolled in Keystone trigger courses during the 20190-20 school year. It includes information on students being first time test takers, repeat test takers within Keystone testing windows, and whether those students passed those trigger courses. 

Keystone Testing Windows are: 

  • 2019: Summer
  • 2019: Winter Wave 1  
  • 2020: Winter Wave 2  
  • 2020: Spring

Screenshot of the PIMS Keystone Exemption extract editor.PIMS Keystone Exemption Extract

Report Logic

Information is ONLY reported for the 2019-20 school year. 

  • Students must be scheduled into the course for at least one day. 
  • Students are not reported when the Course Type is RM. 
  • One record per Student State ID and Category Set Code combination reports. Up to three records can report per student, one for each Category Set Code - Algebra 1 (ALG), Biology (BIO), or Literature (LIT).

Two separate student populations report:

Population 1. 19-20 Calendar Courses

This population reports all students scheduled into courses where any of the following Keystone Assessment Codes are assigned to the Course:

  • KALG1SPR
  • KALG1SUM
  • KALG1WIN
  • KBIOSPR
  • KBIOSUM
  • KBIOWIN
  • KLITSPR
  • KLITSUM
  • KLITWIN

Population 2. 19-20 Transcript Entries

This population looks at student transcript entries for the 2019-20 school year and identifies students who were never scheduled into a course with the Assessment State Codes of the following:

  • KALG1SPR
  • KALG1SUM
  • KALG1WIN
  • KBIOSPR

  • KBIOSUM
  • KBIOWIN
  • KLITSPR
  • KLITSUM
  • KLITWIN

Use the Course Ad hoc Filter fields to find students who were never in a course with one of the above assessments and only have a transcript entry for that course. See the sample Ad hoc filter below (in the Click here to expand section) for an example.

Click here to expand...

  1. Navigate to Ad hoc Reporting and select Filter Designer. 
  2. Create a filter in the Query Wizard using the Course/Section Data Type.
  3. Choose the following fields from Course Information: 
    • State Code (courseInfo.stateCode)
    • Course Name (courseInfo.courseName)
    • Course Number (courseInfo.courseNumber)Screenshot of the Course Number, Name, and State Code fields in the Ad Hoc filter designer.Ad Hoc Filter Designer Course Fields
  4. Filter the courseInfo.stateCode field to only return courses with a specific State Code value. State Codes can be found on the Course Information or Course Master Information editor in the State Code field.Screenshot of the filter data options for the Course State Code value.Course State Code Value Filter Option
  5. Give the filter a Name and Save & Test the filter. Only those courses with the assigned State Code return. 

Students included in Population 2 are added to the students in Population 1 when the Course Ad hoc Filter is selected when generating the report. Both student populations are included in the report when using the Course Ad hoc Filter.

See the PIMS Reporting article for additional PIMS Reporting information.

Generate the Template

  1. Select 1920 Keystone Exemption Extract from the Extract Type from the dropdown list.
  2. Select the Format of the extract.
  3. Select a Course Ad hoc Filter (uses the Course/Section Data Type in the Query Wizard) to narrow the results of the extract.
  4. Select the desired Grade Levels.
  5. Select the appropriate Calendar(s) from which to include data on the extract.
  6. Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.

Screenshot of the Keystone Exemption HTML format example.Keystone Exemption - HTML Format

Screenshot of the Keystone Exemption CSV format example.Keystone Exemption - CSV Format

Report Layout

Data Element Description Campus Location
Submitting AUN Reports the State District Number
Numeric, 9 digits
District Information > State District Number

District.number
School Year Date Reports the last day of the 2019-20 school year (June 30, 2020).

Date field, 10 characters (YYYY-MM-DD)
Calendar > Calendar > End Date

Calendar.endDate
PA Secure ID Reports the student's state identification number.

Numeric, 10 digits
Demographics > Person Identifiers > Student State ID

Person.stateID
Reporting Date Reports the last day of the 2019-20 school year (June 30, 2020).

Date field, 10 characters (YYYY-MM-DD)
Calendar > Calendar > End Date

Calendar.endDate
Category Set Code Reports the Keystone Subject Area of Exemption, as one of the following:
  • ALG1920: Algebra 1
  • BIO1920: Biology
  • LIT1920: Literature
When the student matches report population 1, the Course Assessment tool is used to find the most recent associated Keystone state coded assessment:
  • Reports ALG when Assessment State Code = KALG1SPR or KALG1SUM or KALG1WIN
  • Reports LIT when Assessment State Code = KLITSPR or KLITSUM or KLITWIN
  • Reports BIO when Assessment State Code = KBIOSPR or KBIOSUM or KBIOWIN
When the student matches report population 2, the state coded course that matches the State code of the Ad hoc filter is used first, then the Course Assessment tool to find the most recent associated Keystone state coded assessment:
  • Reports ALG when Assessment State Code = KALG1SPR or KALG1SUM or KALG1WIN
  • Reports LIT when Assessment State Code = KLITSPR or KLITSUM or KLITWIN
  • Reports BIO when Assessment State Code = KBIOSPR or KBIOSUM or KBIOWI
Test Setup > Test Type > State Code

Test.stateCode
Primary Measure Type Always reports a value of INDICATOR. N/A
Filler Field
This field reports blank.
N/A
Filler Field
This field reports blank.
N/A
Filler Field
This field reports blank.
N/A
Indicator Reports whether a student completed or passed the subject.

The student's Transcript is used to find an entry with a matching course. 
  • When the Credits Earned value for that course entry is greater than zero (0), a value of Y reports. 
  • Where there is no Transcript entry or the Credits Earned for that course is 0 or blank, a value of N reports. 
Transcripts > Transcript Detail > Credit Information

TranscriptCredit.creditsEarned
Filler Field
This field reports blank.
N/A
Filler Field
This field reports blank.
N/A
Comment Reports whether the student took the test for the first time or is taking the test for a second time. Reports either FIRST or REPEAT.

Reports FIRST when the student does not have an assessment prior to July 1, 2019 where the state code on the assessment is KALG1SPR, KALG1SUM, KALG1WIN, KBIOSPR, KBIOSUM, KBIOWIN, KLITSPR, KLITSUM, KLITWIN.

Reports REPEAT when the student has an assessment prior to July 1, 2019 with the following logic:
  • The Category Set Code (field 5) is ALG, an assessment with a state code of KALG1SPR, KALG1SUM or KALG1WIN and the Assessment Subject standard code is ALG. 
  • The Category Set Code (field 5) is LIT, an assessment with a state code of KLITSPR, KLITSUM, KLITWIN or KEYSTONE and the Assessment Subject standard code is LIT.
  • The Category Set Code (field 5) is BIO, an assessment with a state code is KBIOSPR, KBIOSUM, KBIOWIN and Assessment Subject standard code is BIO.
Assessments > Name

Test.name
Test Setup > Test Type > State Code

Test.stateCode