PS_Calendar_Day (ver5.0.0)
This view projects Track, Membership, and Schedule columns from the Calendar_Day and Prefs tables.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
A | 5.0.0 | Longint | [From Calendar_Day] Track A from Calendar_Day. |
B | 5.0.0 | Longint | [From Calendar_Day] Track B from Calendar_Day. |
C | 5.0.0 | Longint | [From Calendar_Day] Track C from Calendar_Day. |
D | 5.0.0 | Longint | [From Calendar_Day] Track D from Calendar_Day. |
E | 5.0.0 | Longint | [From Calendar_Day] Track E from Calendar_Day. |
F | 5.0.0 | Longint | [From Calendar_Day] Track F from Calendar_Day. |
Bell_Schedule_ID | 5.0.0 | Longint | [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed. |
Cycle_Day_ID | 5.0.0 | Longint | [From Cycle_Day] Foreign key to the Cycle_Day table. Indexed. |
Date_Value | 5.0.0 | Date | [From Calendar_Day] Calendar date for this schedule. |
ID | 5.0.0 | Longint | [From Calendar_Day] Calendar day unique identifier. |
InSession | 5.0.0 | Longint | [From Calendar_Day] Course in session flag. |
Interval_Duration | 5.0.0 | Longint | [From Prefs] The school's scheduling interval duration. |
MembershipValue | 5.0.0 | Real | [From Students and ReEnrollments] The amount of a student's membership this school claims. |
Presence_Status_Code | 5.0.0 | String10 | [From Attendance_Code] Presence Status Code value. Indexed. |
ScheduleID | 5.0.0 | Longint | [From Calendar_Day] The foreign key to the Schedules table. |
SchoolID | 5.0.0 | Longint | [From Calendar_Day] ID Linked to the School_Number from the Schools table. Indexed. |