PSM_Student (ver1.0)
This table contains student demographic information. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
BirthDate | 1.5 | Date | Date of birth. |
Citizenship | 1.5 | Varchar2(30) | Currently not used. |
CorrespondenceLanguage | 1.5 | Varchar2(30) | Currently not used. |
FirstName | 1.0 | Varchar2(50) | Student's first name. Required. |
Gender | 1.5 | Varchar2(10) | Valid values: M = Male, F = Female. |
GradeLevel | 1.5 | Varchar2(30) | Current grade level of the student. Valid values: 0 = Kindergarten, -1 = Preschool, -2 = Preschool, 99 = Graduated. |
HomePhone | 1.5 | Varchar2(30) | Home phone number for the student. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
LastName | 1.0 | Varchar2(50) | Student's last name. Required. |
MiddleName | 1.0 | Varchar2(30) | Student's middle name. |
NickName | 1.5 | Varchar2(256) | Currently not used. |
PrimaryLanguage | 1.5 | Varchar2(30) | Currently not used. |
PrimaryRaceCode | 1.5 | Varchar2(10) | Currently not used. |
StudentIdentifier | 1.0 | Varchar2(30) | Student number. |