PSSIS_Student_Relationships (ver5.0.0)
This view provides Relationship information related to Students. This will include emergency contact details.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Student_Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Grade | 5.0.0 | Longint | [From Students] The Student's current grade level. Indexed. |
Type | 5.0.0 | String9 | [Derived] Values include: Doctor, Father, Mother, Emergency. |
Full_Name | 5.0.0 | String60 | [From Students] Name of the contact. |
Phone | 5.0.0 | String30 | [From Students] Phone number for the contact specified. |
Emergency_Contact_Order | 5.0.0 | String1 | [From Students] Name to contact in case of an emergency. |
Web_ID | 5.0.0 | String20 | [From Students] Student's web ID. |
Web_Password | 5.0.0 | String64 | [From Students] Student's encrypted web password. |