Tool Search: PAsecureID Import
The PA SecureID Import takes in a PA SecureID Extract CSV file, and for each record, updates the stateID of the corresponding student in the Campus database to match the imported stateID. It then warns of potential misinput when the student in the import file and in the database don't match on other key identifiers.
See the PA Secure ID Extract article for information on the matching report for this import.
PAsecureID ImportLogic
The PA SecureID Import expects a comma-delimited file that resembles the PA SecureID Extract. Each row should be 16 columns wide, and each column should correspond in order to the 16 columns in the Extract. When provided a file, the import iterates through one row at a time. When a row has fewer than 16 columns, or when the row's stateID is left null, an error is logged, and the importer moves to the next row. The Importer reads the values from the following columns (index starting at 1):
- 4. lastName
- 5. firstName
- 6. middleName
- 8. gender
- 9. birthdate
- 11. studentID
- 12. ssn
- 14. stateID
The index of these columns must match that of the extract. No other columns are read by the importer.
The importer then attempts to find information on this student in the Campus database (the dbo.student view), searching by ssn when provided, otherwise by studentNumber (studentID). When more or fewer than one result is found, an error is logged, and the importer moves to the next row. When a unique result is found:
- When a stateID is found in the database and matches the imported one, no change happens.
- Otherwise, the stateID in the Campus database (the dbo.person table) is updated to the stateID provided.
- When this is replacing an existing stateID in the database, this is counted toward the "updates."
- When there was previously no stateID in the database, this is counted toward the "inserts."
Then:
- When any of the following database fields mismatch those imported, a warning is logged indicating this mismatch, despite a successful stateID import.
- firstName
- lastName
- birthdate
- gender
- Otherwise, all of those fields match, and this is counted toward the "goodCount."
Upload Layout
The upload layout must be in a comma-delimited format.
| Data Element | Description | Campus Interface |
|---|---|---|
| Record Type | Always reports a value of ID.
Alphabetic, 2 characters |
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 Information > Alt School Number
School Information > School Detail > State School Number
School.number |
| Resident District |
Reports the PDE 9-digit AUN code of the LEA fiscally responsible for the student.
Numeric, 9 digits |
District Information > District Detail > State District Number
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 |
Identities > Identity Information > Protected Identity Information > Legal Last Name
Demographics > Last Name
Identity.legalLastName Identity.lastName |
| 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 |
Identities > Identity Information > Protected Identity Information > Legal First Name
Demographics > First Name
Identity.legalFirstName Identity.firstName |
| 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 |
Identities > Identity Information > Protected Identity Information > Legal Middle Name
Demographics > Middle Name
Identity.legalMiddleName Identity.middleName |
| 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 |
Identities > Identity Information > Protected Identity Information > Legal Suffix
Demographics > Suffix
Identity.legalSuffix Identity.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 |
Identities > Identity Information > Protected Identity Information > Legal Gender
Demographics > Gender
Identity.legalGender Identity.gender |
| Date of Birth | The student's date of birth.
Date field, 10 characters, MM/DD/YYYY |
Demographics > Birth Date
Identity.birthDate |
| Grade Level |
The student's grade level of enrollment.
Alphanumeric, 3 characters |
Enrollments > General Enrollment Information > Grade
Enrollment.grade |
| Student ID | The student's local student number.
Numeric, 10 characters |
Demographics > Person Identifiers > Student Number
Person.studentNumber |
| SSN | The student's Social Security number.
Numeric, 11 digits, XXX-XX-XXXX |
Demographics > SSN
Identity.SSN |
| Race Ethnicity |
The student's indication of race.
Numeric, 1 character |
Demographics > Race/Ethnicity
Identity.race |
| State ID | The student's state-assigned identification number.
Numeric, 10 digits |
Demographics > Person Identifiers > Student State ID
Person.stateID |
| District Number | Reports the PDE 9-digit AUN code of the LEA educating the student.
Numeric, 9 digits |
Enrollments > State Reporting Fields > Resident District
District Information > State District Code
Enrollment.residentDistrict District.number |
| Year | Reports the end year of the selected school year in the Campus toolbar.
Numeric, 4 digits |
System Administration > Calendar > Calendar > End Year
Calendar.endYear |
