S_NC_GUARDIAN (ver 13.6.0)
This table is a child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Emerg_CallSeq | 13.6.0 | NUMBER(11,0) | The numerical order for which emergency contact to call. |
Emerg_CanPickUp | 13.6.0 | VARCHAR2(1) | Indicates the person can pick up the student from school. |
Emerg_Relation_Code | 13.6.0 | VARCHAR2(3) | Indicates the relationship of this person to the student. |
GOVT_Work_LOC_Code | 13.6.0 | VARCHAR2(30) | |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
Language_Code | 13.6.0 | NUMBER(11,0) | |
Language_Spoken | 13.6.0 | VARCHAR2(30) | The primary language spoken for this person. |
Language_Written | 13.6.0 | VARCHAR2(30) | The primary language used for writing for this person. |
Parent_Address | 13.6.0 | VARCHAR2(150) | The street address for this person. |
Parent_AvailableAtWork | 13.6.0 | VARCHAR2(1) | Indicates if the person can be contacted at work. |
Parent_CellPhone | 13.6.0 | VARCHAR2(10) | The person's cell phone. |
Parent_CopyOfCorr | 13.6.0 | VARCHAR2(1) | Indicates if the contact should received correspondence. |
Parent_Corr_Code | 13.6.0 | NUMBER(11,0) | |
Parent_DayPhone | 13.6.0 | VARCHAR2(10) | The person's day time phone number. |
Parent_EduLevel_Code | 13.6.0 | VARCHAR2(5) | The person's highest educational level. |
Parent_Email | 13.6.0 | VARCHAR2(100) | The person's email address. |
Parent_EmergContact | 13.6.0 | VARCHAR2(1) | |
Parent_Employer | 13.6.0 | VARCHAR2(50) | The employer of the contact. |
Parent_FirstName | 13.6.0 | VARCHAR2(20) | The contact's first name. |
Parent_HomePhone | 13.6.0 | VARCHAR2(10) | The contact's home phone. |
Parent_LastName | 13.6.0 | VARCHAR2(20) | The contact's last name. |
Parent_LivingWith | 13.6.0 | VARCHAR2(1) | Indicates if the student lives with this contact. |
Parent_MilitaryEmp | 13.6.0 | VARCHAR2(1) | Indicates if this contact is employed by the military. |
Parent_Note | 13.6.0 | VARCHAR2(1000) | Notes about this contact. |
Parent_Occupation | 13.6.0 | VARCHAR2(40) | Indicates the occupation of the contact. |
Parent_SpeakEnglish | 13.6.0 | VARCHAR2(1) | Indicates if the person speaks English or not. |
Parent_Type_Code | 13.6.0 | VARCHAR2(1) | Indicates if the contact is a parent, emergency, or other contact. |
Parent_Unlisted | 13.6.0 | VARCHAR2(1) | Indicates if the phone number is unlisted. |
Parent_Volunteer | 13.6.0 | VARCHAR2(1) | |
Prefix | 13.6.0 | NUMBER(11,0) | Indicates the prefix for the contact. |
Select_Emergency_Contact | 13.6.0 | VARCHAR2(1) | |
| StudentsDCID | 13.6.0 | NUMBER(19,0) | Foreign key to link to the students table. |
Work_Extension | 13.6.0 | VARCHAR2(5) |