S_CONTACT_RELATIONSHIP_C (ver 15.7.0)
This table is a child table of the S_Contacts_S table and stores student/contact relationship information. This contact relationship table is available for all states and provinces and might or might not be utilized for your state or province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 15.7.0 | Number(11,0) | Primary Key |
| S_Contacts_SID | 15.7.0 | Number(11,0) | Foreign key to the S_Contacts_S table. |
| Association | 16.2.2 | Varchar2(100) | The association of the contact to the associated student. |
| Can_Pickup | 15.7.0 | Number(1,0) | Indicates whether the associated contact can pick up the associated student from school. |
| Contact_Order | 15.7.0 | Number(11,0) | Indicates the preferred contact order for the student. |
| Emergency_Contact | 15.7.0 | Number(1,0) | Indicates whether the associated contact is an emergency contact. |
| End_Date | 15.7.0 | Date | The end date of the student/contact relationship. |
| Has_Custody | 15.7.0 | Number(1,0) | Indicates whether the associated contact has custody. |
| Legal_Guardianship | 15.7.0 | Number(1,0) | Indicates whether the associated contact has legal guardianship. |
| Lives_With | 15.7.0 | Number(1,0) | Indicates whether the associated contact lives with the student. |
| Notes | 15.7.0 | Varchar2(4000) | Note regarding the student/contact relationship. |
| Primary_Contact | 15.7.0 | Number(1,0) | Indicates whether the associated contact is the primary contact. |
| Receive_Mailing | 15.7.0 | Number(1,0) | Indicates whether the associated contact can receive mailing for the student. |
| Relationship | 15.7.0 | Varchar2(100) | The relationship of the contact to the associated student. |
| Start_Date | 15.7.0 | Date | The start date of the student/contact relationship. |
| Secondary_Contact | 16.10.1 | Number(1,0) | Indicates whether the associated contact is the secondary contact. |
| Students_DCID | 15.7.0 | Number(10,0) | Foreign key to the Students table. |