PSSIS_Student_Sched_Class_Term (ver5.0.0)
This view provides scheduling information as well as Class and Term details.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
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. |
Gender | 5.0.0 | String2 | [From Students] Gender indicator. Indexed. |
Ethnicity_Name | 5.0.0 | String50 | [From Gen] Ethnicity from the Gen table where category = 'Ethnicity'. |
Ethnicity_Code | 5.0.0 | String20 | [From Students custom field] The student's Primary Language as decoded in the CustomVarchars table. |
Special_Ed_Student | 5.0.0 | String3 | [From Students custom field] The student's Secondary Language as decoded in the CustomVarchars table. |
Current_Building | 5.0.0 | String10 | [From Students] Student's current building. |
Current_Homeroom | 5.0.0 | String60 | [From Students] Student's current Homeroom assignment. |
Current_House | 5.0.0 | String10 | [From Students] Student's current house, if applicable. |
Current_Next_School | 5.0.0 | Longint | [From Students] Student's next school, if applicable. |
Locker_Number | 5.0.0 | String15 | [From Students] The Locker number. |
Locker_Combination | 5.0.0 | String20 | [From Students] Encrypted version of the Locker Combination. |
Course_Number | 5.0.0 | String11 | [From Courses] Student's course information. |
Course_Name | 5.0.0 | String40 | [From Courses] Name of the Course associated with the Course Number. |
Section_Number | 5.0.0 | String10 | [From CC] Section number. |
Section_Expression | 5.0.0 | String80 | [From Sections] Encoded expression for this Section. |
Teacher_Name | 5.0.0 | String40 | [From Teachers] Teacher name – last, first. |
Room_Number | 5.0.0 | String10 | [From Sections] Room Number for this Section / Course. |
Term | 5.0.0 | String6 | [From Terms] Actual Term value. |
Term_First_Day | 5.0.0 | Date | [From Terms] First day of term. |
Term_Last_Day | 5.0.0 | Date | [From Terms] Last day of Term. |
Section_School | 5.0.0 | String20 | [From Schools] School associated with this Section. |