S_OH_CONTACT_RELATIONSHIP_S (ver 14.6.3)
This table is a standalone table and stores the relationship between the student and the contact record created in the [S_OH_CONTACTS_S] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 14.6.3 | Number(11,0) | Primary Key. |
| S_OH_CONTACTS_S_ID | 14.6.3 | Number(11,0) | A foreign key link to S_OH_CONTACTS_S.ID. |
| STUDENTS_DCID | 14.6.3 | Number(11,0) | A foreign key that relates the extended table to the [Students] table. |
| CANPICKUP | 14.6.3 | VarChar2(1) | Value is Yes if this contact is allowed to pick up the associated student. |
| CONTACT_SEQUENCE | 14.6.3 | Number(11,0) | The numeric value of the sequence in which a contact is be contacted. |
| COPY_OF_CORRESPONDENCE | 14.6.3 | VarChar2(1) | Value is Yes if this contact needs to receive mailings for the associated student. |
| CUSTODIAL_FLAG | 14.6.3 | VarChar2(1) | Value is Yes if this contact is named the custodian for the associated student. |
| EMERGENCY_CONTACT | 14.6.3 | VarChar2(1) | Value is Yes if this is an emergency contact for the associated student. |
| END_DATE | 14.6.3 | Date | End date for when the data are no longer valid. |
| LEGAL_GUARDIANSHIP_FLAG | 14.6.3 | VarChar2(1) | Value is Yes if this contact is named the legal guardian for the associated student. |
| NOTES | 14.6.3 | VarChar2(4000) | Extended field to capture other information about the contact. |
| RELATIONSHIP_CODE | 14.6.3 | VarChar2(6) | Used to define the relationship that exists between the student and the contact. Contact Relationship codes are defined by the state. |
| START_DATE | 14.6.3 | Date | Start date for when the data are valid. |