PS_Membership_Prog (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 | String10 | [From PS_Membership_Reg] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
ATT_IntervalDuration | 5.0.0 | Longint | [From PS_Membership_Reg] The Interval Duration from the Prefs table (ATT_IntervalDuration). |
Attendance_Conversion_ID | 5.0.0 | Longint | [From PS_Membership_Reg] Foreign key to the Attendance Conversion table. Indexed. |
Bell_Schedule_ID | 5.0.0 | Longint | [From PS_Membership_Reg] Foreign key to the Bell Schedule table. Indexed. |
CalendarDate | 5.0.0 | Date | [From PS_Membership_Reg] The date value from Calendar_Day. Indexed. |
CalendarMembership | 5.0.0 | Real | [From PS_Membership_Reg] The student's calendar membership value. |
Cycle_Day_ID | 5.0.0 | Longint | [From PS_Membership_Reg] Foreign key to the Cycle_Day table. Indexed. |
Dflt_Att_Mode_Code | 5.0.0 | Longint | [From PS_Membership_Reg] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 5.0.0 | Longint | [From PS_Membership_Reg] Default Conversion Mode Code. Indexed. |
FTEID | 5.0.0 | Longint | [From PS_Membership_Reg] The FTE ID from the FTE table. Indexed. |
Grade_Level | 5.0.0 | Longint | [From PS_Membership_Reg] The student's current grade level. |
OffTrack | 5.0.0 | Longint | [From PS_Membership_Reg] The value is determined from the track information returned by the PS_Membership_Reg view and the Calendar_Day track values. |
OnTrack | 5.0.0 | Longint | [From PS_Membership_Reg] The value is determined from the track information returned by the PS_Membership_Reg view and the Calendar_Day track values. |
ProgramID | 5.0.0 | Longint | [From PS_Enrollment_Prog] The Foreign key to the Program table from |
SchoolID | 5.0.0 | Longint | [From PS_Enrollment_Prog] ID Linked to the School_Number from the Schools table. Indexed. |
StudentID | 5.0.0 | Longint | [From PS_Enrollment_Prog] The internal number for the student this record is associated with. Indexed. |
StudentMembership | 5.0.0 | Real | [From PS_Membership_Reg] The student membership value from the PS_Enrollment_Reg view. |
Student_Track | 5.0.0 | String20 | [From PS_Membership_Reg] Represents the times during the year when the student goes to school. |
Track_A | 5.0.0 | Longint | [From PS_Membership_Reg] Track A from Calendar_Day. |
Track_B | 5.0.0 | Longint | [From PS_Membership_Reg] Track B from Calendar_Day. |
Track_C | 5.0.0 | Longint | [From PS_Membership_Reg] Track C from Calendar_Day. |
Track_D | 5.0.0 | Longint | [From PS_Membership_Reg] Track D from Calendar_Day. |
Track_E | 5.0.0 | Longint | [From PS_Membership_Reg] Track E from Calendar_Day. |
Track_F | 5.0.0 | Longint | [From PS_Membership_Reg] Track F from Calendar_Day. |