PA Secure ID

Introduction

This report generates an extract for requesting unique state IDs (PAsecureIDs) for students enrolled in the district. Prior to submitting data to the state, verify that all fields on all records have a value. You must correct all missing/invalid data and re-run the report. This report should be run at the district level, not for an individual school. The PA Secure ID report replaces the reporting engine with the SRP platform allowing you to schedule and run the report.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the Students table where the student was enrolled in the school on the snapshot date.

The report end date is used as the snapshot date.
The student must already be assigned a PASecureID if “with Secure ID” is selected when running the report.
The PA SecureID value is entered via Start Page > Student > State/Province – PA > PA SecureID tab.

Report Input

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

Field	Description
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM: 05.
Report Start Date	Enter the start date for the reporting period.
Report End Date	Enter the end date for the reporting period. Note: Start/End Dates replace “Date to Scan.” If you want to scan for a single date, enter that date in both Report Start and End Dates
Restrict to Students	Choose one of the following from the pop-up menu: Without Secure ID – Only include students who are not assigned a PA Secure ID. With Secure ID – Only include students who are assigned a PA Secure ID. With or Without Secure ID – Include all students, both those with and without a PA Secure ID.
Print Student Legal Name and Gender	Select the Checkbox to Enable

Report Output

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

Item #	Data Element	Description	[Table]FieldName
1	Record Type	The value “ID” is reported.	Static – always a TT
2	Current School Code	The PDE 4-digit code of the school where the student is enrolled during the specified date range. Either the School Number or the Alternate School Number is extracted from Start Page > District Setup > Schools/School Info > Edit School. This field is required.	[Schools]School_Number [Schools]Alternate_School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID
3	Resident District Code	The PDE 9-digit AUN code of the LEA fiscally responsible for the student. This value is extracted from Start Page > Student > Transfer Info > Edit Enrollment. This field is required.	[Students]DistrictofResidence [ReEnrollments]DistrictofResidence If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number
4	Legal Last Name	The student’s legal last name. This field is required.	[Students]last_name or StudentCoreFields.PSCore_Legal_Last_Name
5	Legal First Name	The student’s legal first name. This field is required.	[Students]First_Name or StudentCoreFields.PSCore_Legal_First_Name
6	Legal Middle Name	The student’s legal middle name. This field is optional.	[Students]Middle_Name or StudentCoreFields.PSCore_Legal_Middle_Name
7	Legal NameSuffix	The student’s legal name suffix.	[Students]Name_Suffix or StudentCoreFields.PSCore_Legal_Suffix_Name
8	Gender	The student’s gender. This field is required.	[Students]Gender or StudentCoreFields.PSCore_Legal_Gender
9	Date of Birth	The student’s date of birth.	[Students]DOB
10	Current Grade Level	The student’s current grade level.	[S_PA_STU_X/S_PA_REN_X] State_Grade_Code. If empty then extract [Students]Grade_Level [ReEnrollments]Grade_Level
11	Local Student ID	The PowerSchool unique student number. This value is used when importing PAsecureIDs into PowerSchool. This field is required.	[Students]Student_Number
12	Social Security Number	The student’s social security number. This field is optional.	[Students]SSN
13	Race/Ethnicity	The student’s race/ethnicity. This field is required.	If ethnicity is Hispanic, the race code of 4 is extracted. If not the race is extracted from the [StudentRace] table.
14	PAsecureID	The student’s PAsecureID. This value is reported if “with Secure ID” or “without or without Secure ID” was chosen when running the report.	[Students]State_StudentNumber
15	Current District Code	The PDE 9-digit AUN code of the LEA educating the student. The report extracts this from the field PA_districtAUN. This field is required.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number
16	Current School Year	The current school year. The report extracts this from the beginning year of the currently selected school year.	Derived based on the last day of the school year. Example: 2020