S_SC_STU_CONTACTS_X (ver 15.7.3)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentsDCID | 15.7.3 | Number(10,0) | Foreign key that links this record to the Students table. |
| Cnt1_City | 15.7.3 | Varchar2(30) | City of the first contact. Migrated from [Students.cnt1_city]. |
| Cnt1_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the first contact. Migrated from [Students.cnt1_cphone]. |
| Cnt1_Email | 15.7.3 | Varchar2(75) | Email of the first contact. Migrated from [Students.cnt1_email]. |
| Cnt1_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt1_Employer | 15.7.3 | Varchar2(70) | Employer of the first contact. Migrated from [Students.cnt1_employer]. |
| Cnt1_FName | 15.7.3 | Varchar2(20) | First name of the first contact. Migrated from [Students.cnt1_fname]. |
| Cnt1_HPhone | 15.7.3 | Varchar2(25) | Home phone of the first contact. Migrated from [Students.cnt1_hphone]. |
| Cnt1_Living_With | 15.7.3 | Number(1,0) | This field is checked if the student lives with this contact.Migrated from [Students.cnt1_custody] |
| Cnt1_LName | 15.7.3 | Varchar2(30) | Last name of the first contact. Migrated from [Students.cnt1_lname]. |
| Cnt1_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the first contact receives a mailing. Migrated from [Students.cnt1_recvmail]. |
| Cnt1_Rel | 15.7.3 | Varchar2(20) | The relationship of the first contact to the student. MIgrated from [Students.cnt1_rel]. |
| Cnt1_State | 15.7.3 | Varchar2(3) | The state for the first contact. Migrated from [Students.cnt1_state]. |
| Cnt1_Street | 14.11.0 | Varchar2(70) | The street for the first contact. Migrated from [Students.cnt1_street]. |
| Cnt1_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the first contact. Migrated from [Students.cnt1_Wphone]. |
| Cnt1_Zip | 15.7.3 | Varchar2(10) | The zip for the first contact. Migrated from [Students.cnt1_zip]. |
| Cnt2_City | 15.7.3 | Varchar2(30) | City of the second contact. Migrated from [Students.cnt2_city]. |
| Cnt2_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the second contact. Migrated from [Students.cnt2_cphone]. |
| Cnt2_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.cnt2_custody] |
| Cnt2_Email | 15.7.3 | Varchar2(75) | Email of the second contact. Migrated from [Students.cnt2_email]. |
| Cnt2_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt2_Employer | 15.7.3 | Varchar2(70) | Employer of the second contact. Migrated from [Students.cnt2_employer]. |
| Cnt2_FName | 15.7.3 | Varchar2(20) | First name of the second contact. Migrated from [Students.cnt2_fname]. |
| Cnt2_HPhone | 15.7.3 | Varchar2(25) | Home phone of the second contact. Migrated from [Students.cnt2_hphone]. |
| Cnt2_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt2_LName | 15.7.3 | Varchar2(30) | Last name of the second contact. Migrated from [Students.cnt2_lname]. |
| Cnt2_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the second contact receives a mailing. Migrated from [Students.cnt2_recvmail]. |
| Cnt2_Rel | 15.7.3 | Varchar2(20) | The relationship of the second contact to the student. MIgrated from [Students.cnt2_rel]. |
| Cnt2_State | 15.7.3 | Varchar2(3) | The state for the second contact. Migrated from [Students.cnt2_state]. |
| Cnt2_Street | 15.7.3 | Varchar2(70) | The street for the second contact. Migrated from [Students.cnt2_street]. |
| Cnt2_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the second contact. Migrated from [Students.cnt2_Wphone]. |
| Cnt2_Zip | 15.7.3 | Varchar2(10) | The zip for the second contact. Migrated from [Students.cnt2_zip]. |
| Cnt3_City | 15.7.3 | Varchar2(30) | City of the third contact. Migrated from [Students.cnt3_city]. |
| Cnt3_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the third contact. Migrated from [Students.cnt3_cphone]. |
| Cnt3_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.cnt3_custody] |
| Cnt3_Email | 15.7.3 | Varchar2(75) | Email of the third contact. Migrated from [Students.cnt3_email]. |
| Cnt3_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt3_Employer | 15.7.3 | Varchar2(70) | Employer of the third contact. Migrated from [Students.cnt3_employer]. |
| Cnt3_FName | 15.7.3 | Varchar2(20) | First name of the third contact. Migrated from [Students.cnt3_fname]. |
| Cnt3_HPhone | 15.7.3 | Varchar2(25) | Home phone of the third contact. Migrated from [Students.cnt3_hphone]. |
| Cnt3_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt3_LName | 15.7.3 | Varchar2(30) | Last name of the third contact. Migrated from [Students.cnt3_lname]. |
| Cnt3_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the third contact receives a mailing. Migrated from [Students.cnt3_recvmail]. |
| Cnt3_Rel | 15.7.3 | Varchar2(20) | The relationship of the third contact to the student. MIgrated from [Students.cnt3_rel]. |
| Cnt3_State | 15.7.3 | Varchar2(3) | The state for the third contact. Migrated from [Students.cnt3_state]. |
| Cnt3_Street | 15.7.3 | Varchar2(70) | The street for the third contact. Migrated from [Students.cnt3_street]. |
| Cnt3_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the third contact. Migrated from [Students.cnt3_Wphone]. |
| Cnt3_Zip | 15.7.3 | Varchar2(10) | The zip for the third contact. Migrated from [Students.cnt3_zip]. |
| Cnt4_City | 15.7.3 | Varchar2(30) | City of the fourth contact. Migrated from [Students.cnt4_city]. |
| Cnt4_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the fourth contact. Migrated from [Students.cnt4_cphone]. |
| Cnt4_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.cnt4_custody] |
| Cnt4_Email | 15.7.3 | Varchar2(75) | Email of the fourth contact. Migrated from [Students.cnt4_email]. |
| Cnt4_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt4_Employer | 15.7.3 | Varchar2(70) | Employer of the fourth contact. Migrated from [Students.cnt4_employer]. |
| Cnt4_FName | 15.7.3 | Varchar2(20) | First name of the fourth contact. Migrated from [Students.cnt4_fname]. |
| Cnt4_HPhone | 15.7.3 | Varchar2(25) | Home phone of the fourth contact. Migrated from [Students.cnt4_hphone]. |
| Cnt4_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt4_LName | 15.7.3 | Varchar2(30) | Last name of the fourth contact. Migrated from [Students.cnt4_lname]. |
| Cnt4_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the fourth contact receives a mailing. Migrated from [Students.cnt4_recvmail]. |
| Cnt4_Rel | 15.7.3 | Varchar2(20) | The relationship of the fourth contact to the student. MIgrated from [Students.cnt4_rel]. |
| Cnt4_State | 15.7.3 | Varchar2(3) | The state for the fourth contact. Migrated from [Students.cnt4_state]. |
| Cnt4_Street | 15.7.3 | Varchar2(70) | The street for the fourth contact. Migrated from [Students.cnt4_street]. |
| Cnt4_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the fourth contact. Migrated from [Students.cnt4_Wphone]. |
| Cnt4_Zip | 15.7.3 | Varchar2(10) | The zip for the fourth contact. Migrated from [Students.cnt4_zip]. |
| Cnt5_City | 15.7.3 | Varchar2(30) | City of the fifth contact. Migrated from [Students.cnt5_city]. |
| Cnt5_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the fifth contact. Migrated from [Students.cnt5_cphone]. |
| Cnt5_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.cnt5_custody]. |
| Cnt5_Email | 15.7.3 | Varchar2(75) | Email of the fifth contact. Migrated from [Students.cnt5_email]. |
| Cnt5_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt5_Employer | 15.7.3 | Varchar2(70) | Employer of the fifth contact. Migrated from [Students.cnt5_employer]. |
| Cnt5_FName | 15.7.3 | Varchar2(20) | First name of the fifth contact. Migrated from [Students.cnt5_fname]. |
| Cnt5_HPhone | 15.7.3 | Varchar2(20) | Home phone of the fifth contact. Migrated from [Students.cnt5_hphone]. |
| Cnt5_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt5_LName | 15.7.3 | Varchar2(30) | Last name of the fifth contact. Migrated from [Students.cnt5_lname]. |
| Cnt5_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the fifth contact receives a mailing. Migrated from [Students.cnt5_recvmail]. |
| Cnt5_Rel | 15.7.3 | Varchar2(20) | The relationship of the fifth contact to the student. MIgrated from [Students.cnt5_rel]. |
| Cnt5_State | 15.7.3 | Varchar2(3) | The state for the fifth contact. Migrated from [Students.cnt5_state]. |
| Cnt5_Street | 15.7.3 | Varchar2(70) | The street for the fifth contact. Migrated from [Students.cnt5_street]. |
| Cnt5_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the fifth contact. Migrated from [Students.cnt5_Wphone]. |
| Cnt5_Zip | 15.7.3 | Varchar2(10) | The zip for the fifth contact. Migrated from [Students.cnt5_zip]. |
| Cnt6_City | 15.7.3 | Varchar2(30) | City of the sixth contact. Migrated from [Students.ecnt1_city]. |
| Cnt6_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the sixth contact. Migrated from [Students.ecnt1_cphone]. |
| Cnt6_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.ecnt1_custody] |
| Cnt6_Email | 15.7.3 | Varchar2(75) | Email of the sixth contact. Migrated from [Students.ecnt1_email]. |
| Cnt6_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt6_Employer | 15.8.0 | Varchar2(70) | The employer of this contact. |
| Cnt6_FName | 15.7.3 | Varchar2(20) | First name of the sixth contact. Migrated from [Students.ecnt1_fname]. |
| Cnt6_HPhone | 15.7.3 | Varchar2(25) | Home phone of the sixth contact. Migrated from [Students.ecnt1_hphone]. |
| Cnt6_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt6_LName | 15.7.3 | Varchar2(30) | Last name of the sixth contact. Migrated from [Students.ecnt1_lname]. |
| Cnt6_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the sixth contact receives a mailing. Migrated from [Students.ecnt1_recvmail]. |
| Cnt6_Rel | 15.7.3 | Varchar2(20) | The relationship of the sixth contact to the student. MIgrated from [Students.ecnt1_rel]. |
| Cnt6_State | 15.7.3 | Varchar2(3) | The state for the sixth contact. Migrated from [Students.ecnt1_state]. |
| Cnt6_Street | 15.7.3 | Varchar2(70) | The street for the sixth contact. Migrated from [Students.ecnt1_street]. |
| Cnt6_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the sixth contact. Migrated from [Students.ecnt1_Wphone]. |
| Cnt6_Zip | 15.7.3 | Varchar2(10) | The zip for the sixth contact. Migrated from [Students.ecnt1_zip]. |
| Cnt7_City | 15.7.3 | Varchar2(30) | City of the seventh contact. Migrated from [Students.ecnt2_city]. |
| Cnt7_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the seventh contact. Migrated from [Students.ecnt2_cphone]. |
| Cnt7_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.ecnt2_custody]. |
| Cnt7_Email | 15.7.3 | Varchar2(75) | Email of the seventh contact. Migrated from [Students.ecnt2_email]. |
| Cnt7_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt7_Employer | 15.8.0 | Varchar2(70) | The employer of this contact. |
| Cnt7_FName | 15.7.3 | Varchar2(20) | First name of the seventh contact. Migrated from [Students.ecnt2_fname]. |
| Cnt7_HPhone | 15.7.3 | Varchar2(25) | Home phone of the seventh contact. Migrated from [Students.ecnt2_hphone]. |
| Cnt7_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt7_LName | 15.7.3 | Varchar2(30) | Last name of the seventh contact. Migrated from [Students.ecnt2_lname]. |
| Cnt7_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the seventh contact receives a mailing. Migrated from [Students.ecnt2_recvmail]. |
| Cnt7_Rel | 15.7.3 | Varchar2(20) | The relationship of the seventh contact to the student. MIgrated from [Students.ecnt2_rel]. |
| Cnt7_State | 15.7.3 | Varchar2(3) | The state for the seventh contact. Migrated from [Students.ecnt2_state]. |
| Cnt7_Street | 15.7.3 | Varchar2(70) | The street for the seventh contact. Migrated from [Students.ecnt2_street]. |
| Cnt7_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the seventh contact. Migrated from [Students.ecnt2_Wphone]. |
| Cnt7_Zip | 15.7.3 | Varchar2(10) | The zip for the seventh contact. Migrated from [Students.ecnt2_zip]. |
| Cnt8_City | 15.7.3 | Varchar2(30) | City of the eighth contact. Migrated from [Students.ecnt3_city]. |
| Cnt8_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the eighth contact. Migrated from [Students.ecnt3_cphone]. |
| Cnt8_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.ecnt3_custody] |
| Cnt8_Email | 15.7.3 | Varchar2(75) | Email of the eighth contact. Migrated from [Students.ecnt3_email]. |
| Cnt8_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt8_Employer | 15.8.0 | Varchar2(70) | The employer of this contact. |
| Cnt8_FName | 15.7.3 | Varchar2(20) | First name of the eighth contact. Migrated from [Students.ecnt3_fname]. |
| Cnt8_HPhone | 15.7.3 | Varchar2(25) | Home phone of the eighth contact. Migrated from [Students.ecnt3_hphone]. |
| Cnt8_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt8_LName | 15.7.3 | Varchar2(30) | Last name of the eighth contact. Migrated from [Students.ecnt3_lname]. |
| Cnt8_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the eighth contact receives a mailing. Migrated from [Students.ecnt3_recvmail]. |
| Cnt8_Rel | 15.7.3 | Varchar2(20) | The relationship of the eighth contact to the student. MIgrated from [Students.ecnt3_rel]. |
| Cnt8_State | 15.7.3 | Varchar2(3) | The state for the eighth contact. Migrated from [Students.ecnt3_state]. |
| Cnt8_Street | 15.7.3 | Varchar2(70) | The street for the eighth contact. Migrated from [Students.ecnt3_street]. |
| Cnt8_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the eighth contact. Migrated from [Students.ecnt3_Wphone]. |
| Cnt8_Zip | 15.7.3 | Varchar2(10) | The zip for the eighth contact. Migrated from [Students.ecnt3_zip]. |
| Cnt9_City | 15.7.3 | Varchar2(30) | City of the ninth contact. Migrated from [Students.ecnt4_city]. |
| Cnt9_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the ninth contact. Migrated from [Students.ecnt4_cphone]. |
| Cnt9_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.ecnt4_custody]. |
| Cnt9_Email | 15.7.3 | Varchar2(75) | Email of the ninth contact. Migrated from [Students.ecnt4_email]. |
| Cnt9_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt9_Employer | 15.8.0 | Varchar2(70) | The employer of this contact. |
| Cnt9_FName | 15.7.3 | Varchar2(20) | First name of the ninth contact. Migrated from [Students.ecnt4_fname]. |
| Cnt9_HPhone | 15.7.3 | Varchar2(25) | Home phone of the ninth contact. Migrated from [Students.ecnt4_hphone]. |
| Cnt9_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt9_LName | 15.7.3 | Varchar2(30) | Last name of the ninth contact. Migrated from [Students.ecnt4_lname]. |
| Cnt9_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the ninth contact receives a mailing. Migrated from [Students.ecnt4_recvmail]. |
| Cnt9_Rel | 15.7.3 | Varchar2(20) | The relationship of the ninth contact to the student. MIgrated from [Students.ecnt4_rel]. |
| Cnt9_State | 15.7.3 | Varchar2(3) | The state for the ninth contact. Migrated from [Students.ecnt4_state]. |
| Cnt9_Street | 15.7.3 | Varchar2(70) | The street for the ninth contact. Migrated from [Students.ecnt4_street]. |
| Cnt9_WPhone | 15.7.3 | Varchar2(25) | The work phone number for the ninth contact. Migrated from [Students.ecnt4_Wphone]. |
| Cnt9_Zip | 15.7.3 | Varchar2(10) | The zip for the ninth contact. Migrated from [Students.ecnt4_zip]. |
| Cnt10_City | 15.7.3 | Varchar2(30) | City of the tenth contact. Migrated from [Students.ecnt5_city]. |
| Cnt10_CPhone | 15.7.3 | Varchar2(25) | Cell phone number of the tenth contact. Migrated from [Students.ecnt5_cphone]. |
| Cnt10_Custody | 15.7.3 | Number(1,0) | This field is checked if this contact has custody. Migrated from [Students.ecnt5_custody] |
| Cnt10_Email | 15.7.3 | Varchar2(75) | Email of the tenth contact. Migrated from [Students.ecnt5_email]. |
| Cnt10_Emerg_Ind | 15.8.0 | Number(1,0) | Indicates that this contact is an emergency contact for the student. |
| Cnt10_Employer | 15.8.0 | Varchar2(70) | The employer of this contact. |
| Cnt10_FName | 15.7.3 | Varchar2(20) | First name of the tenth contact. Migrated from [Students.ecnt5_fname]. |
| Cnt10_HPhone | 15.7.3 | Varchar2(25) | Home phone of the tenth contact. Migrated from [Students.ecnt5_hphone]. |
| Cnt10_Living_With | 15.8.0 | Number(1,0) | This field is checked if the student lives with this contact. |
| Cnt10_LName | 15.7.3 | Varchar2(30) | Last name of the tenth contact. Migrated from [Students.ecnt5_lname]. |
| Cnt10_RecvMail | 15.7.3 | Number(1,0) | This field is checked if the tenth contact receives a mailing. Migrated from [Students.ecnt5_recvmail]. |
| Cnt10_Rel | 15.7.3 | Varchar2(20) | The relationship of the tenth contact to the student. MIgrated from [Students.ecnt5_rel]. |
| Cnt10_State | 15.7.3 | Varchar2(3) | The state for the tenth contact. Migrated from [Students.ecnt5_state]. |
| Cnt10_Street | 15.7.3 | Varchar2(70) | The street for the tenth contact. Migrated from [Students.ecnt5_street]. |
| Cnt10_WPhone | 15.7.3 | Varchar2(20) | The work phone number for the tenth contact. Migrated from [Students.ecnt5_Wphone]. |
| Cnt10_Zip | 15.7.3 | Varchar2(10) | The zip for the tenth contact. Migrated from [Students.ecnt5_zip]. |
| Cnta1_Custody | 15.8.0 | Number(1,0) | Indicates this contact has custody of the student. |
| Contacts_Comments | 15.10.0 | Varchar2(400) | General comments about contacts for the student. |
| Emg_Comments | 15.7.3 | Varchar2(400) | Emergency comments. Migrated from [Students.SC_Emg_Comments]. |
| Father_Email | 15.8.0 | Varchar2(75) | The email of the student's father. |
| Guardian_Employer | 15.8.0 | Varchar2(70) | The employer of the student's guardian |
| Guardian_Home_Phone | 15.8.0 | Varchar2(25) | The home phone of the student's guardian. |
| Mother_Email | 15.8.0 | Varchar2(75) | The email of the student's mother. |