S_ID_USR_ProgramContacts_C (ver 17.8.0)
This table is a child table of USERS.
Column Name | Version | Data Type | Description |
unique_id | 17.8.0 | Number(11,0) | Record ID Migrated from [ID_ProgramContacts.unique_ID]. |
schoolID | 17.8.0 | Number(11,0) | School ID Migrated from [ID_ProgramContacts.schoolID]. |
foreignKey | 17.8.0 | Number(11,0) | Reserved for future use. Migrated from [ID_ProgramContacts.foreignKey]. |
foreignKey_alpha | 17.8.0 | Varchar2(31) | Reserved for future use. Migrated from [ID_ProgramContacts.foreignKey_alpha]. |
Location | 17.8.0 | Number(11,0) | Location Migrated from [ID_ProgramContacts.user_defined_integer]. |
JobTitle | 17.8.0 | Varchar2(75) | Job Title Migrated from [ID_ProgramContacts.user_defined_text]. |
RoleTitle | 17.8.0 | Varchar2(75) | Role Title Migrated from [ID_ProgramContacts.user_defined_text2]. |
StartDate | 17.8.0 | Date | Start Date Migrated from [ID_ProgramContacts.user_defined_date]. |
EndDate | 17.8.0 | Date | End Date Migrated from [ID_ProgramContacts.user_defined_date2]. |
RoleCode | 17.8.0 | Varchar2(6) | Role Code Migrated from [ID_ProgramContacts.ID_RoleCode]. |
TeacherID | 17.8.0 | Number(11,0) | Teacher Id Migrated from [ID_ProgramContacts.teacherId]. |
IsPrimaryContact | 24.6.2.0 | Number(1,0) | Primary Contact |