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. |