VWStudentCoreFieldsUC (ver11.1.0)
This table serves as a backward-compatibility view for core custom fields based on data that was migrated to new UC schema.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Emerg_1_PType | 11.1.0 | Varchar2(4000) | Student's first emergency phone type. |
Emerg_1_Rel | 11.1.0 | Varchar2(4000) | Student's first emergency contact relationship. |
Emerg_2_PType | 11.1.0 | Varchar2(4000) | Student's second emergency phone type. |
Emerg_2_Rel | 11.1.0 | Varchar2(4000) | Student's second emergency contact relationship. |
Emerg_3_Phone | 11.1.0 | Varchar2(4000) | Student's third emergency phone number. |
Emerg_3_PType | 11.1.0 | Varchar2(4000) | Student's third emergency phone type. |
Emerg_3_Rel | 11.1.0 | Varchar2(4000) | Student's third emergency contact relationship. |
Emerg_Contact_3 | 11.1.0 | Varchar2(4000) | Student's third emergency contact. |
Father_Employer | 11.1.0 | Varchar2(4000) | Student's father's employer. |
Father_Home_Phone | 11.1.0 | Varchar2(4000) | Student's father's home phone number. |
FatherDayPhone | 11.1.0 | Varchar2(4000) | Student's father's daytime phone number. |
Guardian_FN | 11.1.0 | Varchar2(4000) | Student's guardian's first name. |
Guardian_LN | 11.1.0 | Varchar2(4000) | Student's guardian's last name. |
Guardian_MN | 11.1.0 | Varchar2(4000) | Student's guardian's middle name. |
GuardianDayPhone | 11.1.0 | Varchar2(4000) | Student's guardian's daytime phone number. |
ID | 11.1.0 | Number(10,0) | Unique sequential number generated by the application. Indexed. Required. |
Mother_Employer | 11.1.0 | Varchar2(4000) | Student's mother's employer. |
Mother_Home_Phone | 11.1.0 | Varchar2(4000) | Student's mother's home phone number. |
MotherDayPhone | 11.1.0 | Varchar2(4000) | Student's mother's daytime phone number. |
StudentsDCID | 11.1.0 | Number(10,0) | Unique sequential number generated by the application. Indexed. Required. |