PSSIS_Student_Scheduling (ver5.0.0)
This view provides scheduling information related to Students.
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. |
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. |
Sched_LockStudentSchedule | 5.0.0 | Longint | [From Students] True/False: True (selected)=Do not allow the schedule to be changed by PowerScheduler. False (deselected)=Schedule this student when the scheduling engine is run. |
Sched_NextYearBuilding | 5.0.0 | String10 | [From Students] The building this student will be in next year for schools with multi-building needs. |
Sched_NextYearGrade | 5.0.0 | Longint | [From Students] The grade the student is going to be in next year. If the student is being retained, this should be the same as the current grade level. |
Sched_NextYearHouse | 5.0.0 | String10 | [From Students] The house this student will belong to next year. This is used for scheduling purposes. A house is most often used for schoolwithinaschool type of scheduling. |
Sched_NextYearTeam | 5.0.0 | String10 | [From Students] The team this student will belong to next year. |
Sched_Priority | 5.0.0 | Longint | [From Students] Indicates when you want this student to be scheduled in relation to the other students. The lower the number, the sooner he or she is scheduled. |
Sched_Scheduled | 5.0.0 | Longint | [From Students] A flag indicating if this student has had a schedule built for them. True means they do have a schedule and another will not be made unless the engine is told to reschedule regardless of this flag. False, the engine will build a schedule for this student next time. |
Sched_YearofGraduation | 5.0.0 | Longint | [From Students] Year of graduation. This changes if the student fails or skips a grade. |
Current_Team | 5.0.0 | String10 | [From Students] This field is the team value assigned in PowerScheduler to a student. |
Track | 5.0.0 | String20 | [From Students] A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools. |