S_TX_CONTACT_RELATIONSHIP_S (ver 14.2.2)
No longer used. The functionality has been replaced by S_TX_CONTACT_RELATIONSHIP_C.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 14.2.2 | Number(11,0) | Primary Key. |
S_TX_Contacts_S_ID | 14.2.2 | Number(11,0) | A foreign key link to S_TX_CONTACTS_S.ID. |
Students_DCID | 14.2.2 | Number(11,0) | A foreign key that relates the extended table to the [Students] table. |
Allowed_Pickup | 14.2.2 | Varchar2(5) | Value is Yes if this contact is allowed to pick up the associated student. |
Contact_Order | 14.2.2 | Number(11,0) | The numeric value of the order to contact this person. |
End_Date | 14.2.2 | Date | End date for authorization to view this student's data. |
Needs_Mailing | 14.2.2 | Varchar2(5) | Value is Yes if this contact needs to receive mailings for the associated student. |
Relationship_Code | 14.2.2 | Varchar2(6) | Used to define the relationship that exists between the student and the adult contact. Contact Relationship codes are defined by the state |
Responsible_For | 14.2.2 | Varchar2(5) | Value is Yes if this contact is responsible for the associated student. |
Start_Date | 14.2.2 | Date | Start date for authorization to view this student's data. |
Student_Reside | 14.2.2 | Varchar2(5) | Value is Yes if the student resides with this contact. |