Classic View: PA State Reporting > PAsecure ID Extract
Search Terms: PAsecure ID
The PA Secure ID Extract provides student demographic information to the State Department of Education in order for students to be assigned a state identification number.
Report Logic
This extract returns all students who have an active enrollment record and a Local Student Number but do not have a State Student ID Number (PAsecureID). It can also be generated for students who do have a State Student Number, if needed (remove the checkbox on the report editor for Students w/o stateIDs).
Report Editor
Field | Description |
---|---|
Effective Date | Indicates which enrollments are reviewed for inclusion on the report. The field populates with the current date, but can be modified by typing a new date in mmddyy format or using the calendar icon to select a date. |
Students w/o State IDs | When marked, only students who do not have a State ID are returned in the extract. When not marked, all students who have an State ID and who do not have a State ID are returned in the extract. |
Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
Format | The extract can be generated in HTML, CSV, XML or State Format (csv with header and footer). Use the State Format when submitting the extract to the state. Use the other formats for review prior to submitting the file to the state. |
Calendar Selection | Indicates from which calendar data is returned. At least one calendar needs to be selected in order to generate the report. |
Generate the Report
- Enter the desired Effective Date.
- Determine if Students without IDs should be included in the report (leave the checkbox marked) or if all students with and without IDs (remove the checkmark) should be included in the report.
- If desired, mark the Report Protected Identities checkbox.
- Select the desired Format from the dropdown list.
- Select the desired Calendar(s) to include in the report.
- Click the Generate Report button. The report displays in the desired format.
Report Layout
Data Element | Description | Type, Format and Length | Campus Database | Campus Interface |
---|---|---|---|---|
Header Record Information | ||||
Record Type | Always reports a value of TH. | Alphanumeric, 2 characters | N/A | N/A |
Extract Date | Reports the date the extract was generated. | Date field, 10 characters DD/MM/YYYY | N/A | N/A |
Extract Time | Reports the time the extract was generated. | Time field, 8 characters HH:MM:SS | N/A | N/A |
Transmission ID | Reports an arbitrary number. | Numeric, 10 digits | N/A | N/A |
Version | Always reports a value of 1.0. | Numeric, 2 digits | N/A | N/A |
Delimiter= | Always reports a value of "Delimiter=." | Alphanumeric, 9 characters | N/A | N/A |
Extract Information | ||||
Record Type | Always reports a value of ID. | Alphabetic, 2 characters | N/A | N/A |
School Number | Reports the PDE 4-digit coude of the school where the student is enrolled. This value reports from the Alt School Number field. If that field is not populated, the State School Number reports. When the student is not currently enrolled in a school, a value of 9999 reports. | Numeric, 4 digits | School.number | System Administration > Resources > School > Alt School Number System Administration > Resources > School > School Detail > State School Number |
Resident District | Reports the PDE 9-digit AUN code of the LEA fiscally responsible for the student. | Numeric, 9 digits | District.number | System Administration > District Information > District Detail > State District Number |
Last Name | Reports the legal last name of the student, if populated, and the Report Protected Identities checkbox is marked on the Extract editor. If the Legal Last Name field is not populated, reports from the Last Name field. | Alphanumeric, 60 characters | Identity.legalLastName Identity.lastName | Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Census > People > Demographics > Last Name |
First Name | Reports the legal first name of the student, if populated, and the Report Protected Identities checkbox is marked on the Extract editor. If the Legal First Name field is not populated, reports from the First Name field. | Alphanumeric, 60 characters | Identity.legalFirstName Identity.firstName | Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Census > People > Demographics > First Name |
Middle Name | Reports the legal middle name of the student, if populated, and the Report Protected Identities checkbox is marked on the Extract editor If the Legal Middle Name field is not populated, reports from the Middle Name field. | Alphanumeric, 60 characters | Identity.legalMiddleName Identity.middleName | Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name Census > People > Demographics > Middle Name |
Suffix | The additional identifier of the student's name, such as Jr, Sr, etc. If the Legal Suffix field is populated and the Report Protected Identities checkbox is marked on the Extract editor, information reports from that field. | Alphanumeric, 10 characters | Identity.legalSuffix Identity.suffix | Census > People > Identities > Identity Information > Protected Identity Information > Legal Suffix Census > People > Demographics > Suffix |
Gender | The student's gender. If the Legal Gender field is populated and the Report Protected Identities checkbox is marked on the Extract editor, information reports from that field. | Alphanumeric, 1 character M or F | Identity.legalGender Identity.gender | Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Census > People > Demographics > Gender |
Date of Birth | The student's date of birth. | Datef field, 10 characters MM/DD/YYYY | Identity.birthDate | Census > People > Demographics > Birth Date |
Grade Level | The student's grade level of enrollment. | Alphanumeric, 3 characters | Enrollment.grade | Student Information > General > Enrollments > General Enrollment Information > Grade |
Student ID | The student's local student number. | Numeric, 10 characters | Person.studentNumber | Census > People > Demographics > Person Identifiers > Student Number |
SSN | The student's Social Security number. | Numeric, 11 digits XXX-XX-XXXX | Identity.SSN | Census > People > Demographics > SSN |
Race Ethnicity | The student's indication of race. 1 = American Indian/ Alaskan Native | Numeric, 1 character | Identity.race | Census > People > Demographics > Race/Ethnicity |
State ID | The student's state-assigned identification number. | Numeric, 10 digits | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
District Number | Reports the PDE 9-digit AUN code of the LEA educating the student. | Numeric, 9 digits | Enrollment.residentDistrict District.number | Student Information > General > Enrollments > State Reporting Fields > Resident District System Administration > Resources > District> State District Code |
Year | Reports the end year of the selected school year in the Campus toolbar. | Numeric, 4 digits | Calendar.endYear | System Administration > Calendar > Calendar > End Year |
Trailer Record Information | ||||
Record Type | Always reports a value of TT. | Alphanumeric, 2 characters | N/A | N/A |
Transmission ID | Reports the same arbitrary number as reported in the header file. | Numeric, 10 digits | N/A | N/A |
Records | Reports the total number of records included in the file. | Numeric, 4 digits | N/A | N/A |