Skip to main content
Skip table of contents

Student Fact Template - Keystone Exemption

Contents

Introduction

This template is used to report students that are enrolled in Keystone trigger courses. The report indicates whether they are first-time or repeat test takers for the 2019-2020 school year.

File Format: CSV

File Name Convention: SUBMITTINGAUN_STUDENT_FACT_DATE&TIME), for example: 123456789_STUDENT_FACT_201506110800

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects which student records from the Students table based on the following criteria:

  • The student must not be excluded from state reporting.
  • The student must have a school enrollment during the reporting period.
  • The student must have 2019-2020 course enrollment where the keystone identifier is selected.

Report Input

For help with report generation and navigation, see How to Find and Generate a Report.

Field

Description

Select Schools

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria

If sub-districts are enabled:

  • Select Sub-district - Select the sub-district for which you want to run the report.
  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] students only – Run the report for students in the current selection.
  • All students – Run the report for all students in the current school or district that meet the selection criteria.

If running the report for a single student, or group of students, select the students prior to running the report.

Field Delimiter

Select the field delimiter for the extract file.

Include Header Labels in outputFrom the dialog box select Yes or No. For validation purposes select Yes, for state reporting purposes select No. Headers cannot be submitted to the state.
Ignore Exclude from State Reporting FlagSelect Enabled to ignore the Exclude from State Reporting flag when this report is run.
SchedulingSelect when to run the report.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

Submitting AUN

The unique 9-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Information.

[Prefs]Value where [Prefs]Name=PA_districtAUN

If sub-districts are enabled:

[CST_SubDistricts]Subdistrict_Number

Alpha-numeric

9

2

School Year Date

This field is calculated based on the last day of the school year for the term selected at the top of the page when running the report.

Fixed value

Alpha-numeric

10

3

PASecureID

The unique 10-digit PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.

[Students]State_StudentNumber

Alpha-numeric

10

4

Reporting Date

The report end date entered on the report page.

N/A

Numeric

10

5

Category Set Code

A code representing the Keystone subject area for which the exemption is being reported.
Valid Values:

  • ALG - Algebra 1
  • BIO - Biology
  • LIT - Literature

Calculated

If Keystone contains ALG1 print ALG
If Keystone contains BIO print BIO
If Keystone contains KLIT print LIT

Alpha-numeric

100

6

Measure Type

A constant value of ‘INDICATOR’ is reported.

Fixed value

Alpha-numeric

9

7

Not CollectedNANANANA

8

Not CollectedNANANANA

9

Not CollectedNANANANA

10

Indicator

Indicates whether the student for whom the exemption is reported completed and passed the Keystone trigger course for the subject area reported in field 5, Category Set Code.
Valid Values:
Y-Yes
N-No

Calculated

For selected trigger course report value for [S_PA_CC_X]KeystoneCompleteInd_YN; If null, extract Y.

Alpha-numeric

1

11

Not CollectedNANANANA

12

Not CollectedNANANANA

13

CommentIndicates whether the student was a first-time Keystone test-taker or a repeat-test-taker in the subject area reported in Field 5, Category Set Code.
Valid Values:
  • FIRST
  • REPEAT
[S_PA_STU_X]KeystoneComment_ALG
[S_PA_STU_X]KeystoneComment_BIO
[S_PA_STU_X]KeystoneComment_LIT
Alpha-numeric10
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.