PS_Membership_Reg (ver5.0.0)
This view provides student membership information for each day that the student has an active enrollment on valid in-session school days.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ATT_CalcCntPresentAbsent | 5.0.0 | String7 | [From PS_Enrollment_All] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
ATT_IntervalDuration | 5.0.0 | String30 | [From PS_Enrollment_All] The Interval Duration from the Prefs table (ATT_IntervalDuration). |
Attendance_Conversion_ID | 5.0.0 | Longint | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
Bell_Schedule_ID | 5.0.0 | Longint | [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed. |
CalendarDate | 5.0.0 | Date | [From Calendar_Day] The date value from Calendar_Day. Indexed. |
CalendarMembership | 5.0.0 | Real | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Cycle_Day_ID | 5.0.0 | Longint | [From Calendar_Day] Foreign key to the Cycle_Day table. Indexed. |
Dflt_Att_Mode_Code | 5.0.0 | Longint | [From PS_Enrollment_All] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 5.0.0 | Longint | [From PS_Enrollment_All] Default Conversion Mode Code. Indexed. |
FTEID | 5.0.0 | Longint | [From PS_Enrollment_All] The FTE ID from the FTE table. Indexed. |
Grade_Level | 5.0.0 | Longint | [From PS_Enrollment_All] The student's current grade level. |
OffTrack | 5.0.0 | Longint | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
OnTrack | 5.0.0 | Longint | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
SchoolID | 5.0.0 | Longint | [From PS_Enrollment_All] ID Linked to the School_Number from the Schools table. Indexed. |
StudentID | 5.0.0 | Longint | [From PS_Enrollment_All] The internal number for the student this record is associated with. Indexed. |
StudentMembership | 5.0.0 | Real | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Student_Track | 5.0.0 | String20 | [From PS_Enrollment_All] Represents the times during the year when the student goes to school. |
Track_A | 5.0.0 | Longint | [From Calendar_Day] Track A from Calendar_Day. |
Track_B | 5.0.0 | Longint | [From Calendar_Day] Track B from Calendar_Day. |
Track_C | 5.0.0 | Longint | [From Calendar_Day] Track C from Calendar_Day. |
Track_D | 5.0.0 | Longint | [From Calendar_Day] Track D from Calendar_Day. |
Track_E | 5.0.0 | Longint | [From Calendar_Day] Track E from Calendar_Day. |
Track_F | 5.0.0 | Longint | [From Calendar_Day] Track F from Calendar_Day. |
YearID | 5.0.0 | Integer | [From PS_Enrollment_All] Current school year for the student. |