| Data element |
Definition |
| Admissionsid Indexed - no
Format - Number
May be Null? Y | Reference ID from admissions-source=SLATE import file |
| Birth_Genderenum Indexed - no
Format - Number
May be Null? Y | Birth gender. source=SRS |
| Bookingid Indexed - no
Format - Number
May be Null? N | ID associated with current booking |
| Datecreated Indexed - no
Format - Date
May be Null? N | |
| Datemodified Indexed - no
Format - Date
May be Null? Y | |
| Dob Indexed - no
Format - Date
May be Null? Y | Date of birth. source=SRS |
| Entryid Indexed - yes
Format - Number
May be Null? N | Unique Identifier |
| Entrystatusenum Indexed - no
Format - Number
May be Null? N | |
| Genderenum Indexed - no
Format - Number
May be Null? N | Housing gender, for assignment purposes, as declared by student during application process |
| Id5 Indexed - no
Format - Number
May be Null? Y | |
| Namefirst Indexed - no
Format - Varchar2(160)
May be Null? Y | Firstname. source=SRS |
| Namelast Indexed - no
Format - Varchar2(160)
May be Null? Y | Lastname. source=SRS |
| Namepreferred Indexed - no
Format - Varchar2(160)
May be Null? Y | |
| Pennid Indexed - no
Format - Varchar2(120)
May be Null? Y | |
| Pennkey Indexed - no
Format - Varchar2(120)
May be Null? Y | |
| Photorowid Indexed - no
Format - Varchar2(120)
May be Null? Y | Rowid for photo lookup in penncard table |
| Testing Indexed - no
Format - Varchar2(40)
May be Null? Y | Field used for testing portal processes, this is a test account not associated with a student |
