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 output	From 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 Flag	Select Enabled to ignore the Exclude from State Reporting flag when this report is run.
Scheduling	Select 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 Collected	NA	NA	NA	NA
8	Not Collected	NA	NA	NA	NA
9	Not Collected	NA	NA	NA	NA
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 Collected	NA	NA	NA	NA
12	Not Collected	NA	NA	NA	NA
13	Comment	Indicates 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-numeric	10