S_NY_CONTACT_RELATIONSHIP (ver 13.9.0)
This table is a standalone table and stores student relationship information for adult contacts who have been authorized to view any student's educational data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 13.9.0 | Number (11,0) | Primary Key |
End_Date | 13.9.0 | Date | End date for authorization to view this student's data. |
Relationship_Code | 13.9.0 | Varchar2 (6) | Used to define the relationship that exists between the student and the adult contact. Contact Relationship codes are defined by the state |
S_NY_Contacts_ID | 13.9.0 | Number (11,0) | A foreign key link to S_NY_CONTACTS.ID |
Start_Date | 13.9.0 | Date | Start date for authorization to view this student's data. |
Students_DCID | 13.9.0 | Number (11,0) | Unique identifier assigned by the Local Education Agency (LEA) in which the student is enrolled |
WhenCreated | 13.9.0 | Date | Date the record was created |
WhenModified | 13.9.0 | Date | Date the record was last modified |
WhoCreated | 13.9.0 | Varchar2 (100) | The ID of the user who created the record |
WhoModified | 13.9.0 | Varchar2 (100) | The ID of the user who last modified the record |