Tool Search: SASID Import
The SASID Import tool imports student State ID numbers to the Campus database.
Example Import
Import Layout
Element | Description | Location |
---|---|---|
ID | Reports blank | Reports blank |
LASID | The locally assigned student identification number. Alphanumeric, 20 characters | Demographics > Person Identifiers > Student Number Person.studentNumber |
SchoolNbr | The school number. Numeric, 5 digits | School Information > School Detail> State School Number School.number |
SchoolName | The school name. Alphanumeric, 50 characters | School Information > School Detail> State School Name School.name |
FirstName | The student's first name. Alphanumeric, 32 characters | Demographics > Person Information > First Name Identity.firstName |
MiddleName | The student's middle name. Alphanumeric, 32 characters | Demographics > Person Information > Middle Name Identity.middleName |
LastName | The student's last name. Alphanumeric, 50 characters | Demographics > Person Information > Last Name Identity.lastName |
Suffix | The student's identifier after their last name. Report NULL if the Suffix is blank. Alphanumeric, 10 characters | Demographics > Person Information > Suffix Identity.suffix |
Gender | The student's gender. Alphanumeric, 1 character | Demographics > Person Information > Gender Identity.gender |
Age | The age of the student. Numeric, 2 digits | Demographics > Person Information > Birth Date Age calculated based on birth date and date the report is generated. |
DateOfBirth | The month, day, and year when the student was born. Date Field, MM/DD/YYYY | Demographics > Person Information > Birth Date Identity.dateOfBirth |
TownOfBirth | The town where the student was born. Alphanumeric, 50 characters | Demographics > Person Information > Town of Birth Identity.birthCity |
SASID | The student's State-assigned student identification number. Alphanumeric, 10 characters | Demographics > Person Identifiers > State ID Person.stateID |
Race | The student's race/ethnicity. Numeric, 2 digits | Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
CountryOfBirth | The country where the student was born. Alphanumeric, 50 characters | Demographics > Person Information > Birth Country Identity.birthCountry |
DateFirstEnteredUSSch | The month, day, and year when the student first entered the U.S. school system. Date Field, MM/DD/YYYY | Demographics > Person Information > Date Entered US School Identity.dateEnteredUSSchool |
CreateDate | Reports blank | Reports blank |