Pre_Mig_Student_Details_Bkup (ver12.0.0)
This table holds a static copy of the data from the Student and StudentCoreFields tables prior to the execution of the Contact Migration. It is for diagnostic purposes only and should not be used for reporting. It will be deleted in a future release.
Note: For internal use only.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Bkup_ID | 12.0.0 | Number | Unique identifier assigned by the system. |
| City | 12.0.0 | Varchar2(50) | Address City. |
| DCID | 12.0.0 | Number(10,0) | DCID for related student. Internal use only. |
| Emerg_1_PType | 12.0.0 | Varchar2(4000) | Phone Type for Emergency 1 Contact's Phone Number. |
| Emerg_1_Rel | 12.0.0 | Varchar2(4000) | Emergency 1 Contact's relationship to student. |
| Emerg_2_PType | 12.0.0 | Varchar2(4000) | Phone Type for Emergency 2 Contact's Phone Number. |
| Emerg_2_Rel | 12.0.0 | Varchar2(4000) | Emergency 2 Contact's relationship to student. |
| Emerg_3_Phone | 12.0.0 | Varchar2(4000) | Emergency Phone Number for Emergency Contact 3. |
| Emerg_3_PType | 12.0.0 | Varchar2(4000) | Phone Type for Emergency 3 Contact's Phone Number. |
| Emerg_3_Rel | 12.0.0 | Varchar2(4000) | Emergency 3 Contact's relationship to student. |
| Emerg_Contact_1 | 12.0.0 | Varchar2(60) | Name of Emergency Contact 1 for student. |
| Emerg_Contact_2 | 12.0.0 | Varchar2(60) | Name of Emergency Contact 2 for student. |
| Emerg_Contact_3 | 12.0.0 | Varchar2(4000) | Name of Emergency Contact 3 for student. |
| Emerg_Phone_1 | 12.0.0 | Varchar2(30) | Emergency Phone Number for Emergency Contact 1. |
| Emerg_Phone_2 | 12.0.0 | Varchar2(30) | Emergency Phone Number for Emergency Contact 2. |
| Father | 12.0.0 | Varchar2(60) | Father name. |
| Father_Employer | 12.0.0 | Varchar2(4000) | Employer information for student's father. |
| Father_Home_Phone | 12.0.0 | Varchar2(4000) | Home phone number for student's father. |
| FatherDayPhone | 12.0.0 | Varchar2(4000) | Daytime phone number for student's father. |
| First_Name | 12.0.0 | Varchar2(50) | Student first name. |
| Gender | 12.0.0 | Varchar2(2) | Gender from the Students table |
| Geocode | 12.0.0 | Varchar2(50) | Student Address Geocode string |
| Guardian_FN | 12.0.0 | Varchar2(4000) | Guardian's first name. |
| Guardian_LN | 12.0.0 | Varchar2(4000) | Guardian's last name. |
| Guardian_MN | 12.0.0 | Varchar2(4000) | Guardian's middle name. |
| GuardianDayPhone | 12.0.0 | Varchar2(4000) | Daytime phone number for student's guardian. |
| GuardianEmail | 12.0.0 | CLOB | Email address(es) for student's guardian. |
| Home_Phone | 12.0.0 | Varchar2(30) | Student Home Phone |
| Last_Name | 12.0.0 | Varchar2(50) | Student last name |
| Mailing_City | 12.0.0 | Varchar2(50) | Mailing City |
| Mailing_Geocode | 12.0.0 | Varchar2(50) | Mailing Address Geocode |
| Mailing_State | 12.0.0 | Varchar2(2) | Mailing State |
| Mailing_Street | 12.0.0 | Varchar2(60) | Mailing Address Street Address |
| Mailing_Zip | 12.0.0 | Varchar2(10) | Mailing Address Zip Code |
| Middle_Name | 12.0.0 | Varchar2(30) | Student middle name |
| Mother | 12.0.0 | Varchar2(60) | Mother name. |
| Mother_Employer | 12.0.0 | Varchar2(4000) | Employer information for student's mother. |
| Mother_Home_Phone | 12.0.0 | Varchar2(4000) | Home phone number for student's mother. |
| MotherDayPhone | 12.0.0 | Varchar2(4000) | Daytime phone number for student's mother. |
| Person_ID | 12.0.0 | Number(10,0) | Person_ID from Student table, pre-migration |
| State | 12.0.0 | Varchar2(2) | Address State abbreviation |
| State_StudentNumber | 12.0.0 | Varchar2(32) | State Student Number |
| Street | 12.0.0 | Varchar2(60) | 1st line of address |
| StudentEmail | 12.0.0 | Varchar2(256) | Email address(es) for student |
| WhenCreated | 12.0.0 | Timestamp(6) | The date and time when the record was created. |
| WhenModified | 12.0.0 | Timestamp(6) | The date and time when the record was modified. |
| WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. |
| WhoModified | 12.0.0 | Varchar2(100) | The name of the person who modified the record. |
| Zip | 12.0.0 | Varchar2(10) | Zip-code |