PS_Membership_Defaults (ver5.0.14)
This table provides student membership information for each day that they have an active enrollment on valid in-session school days. It includes potential periods and minutes as well as actual periods and minutes absent.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ATT_CalcCntPresentAbsent | 5.0.14 | Varchar(7) | [From PS_Enrollment_All] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
ATT_IntervalDuration | 5.0.14 | Varchar(30) | [From PS_Enrollment_All] The Interval Duration from the Prefs table (ATT_IntervalDuration). |
Attendance_Conversion_ID | 5.0.14 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
Bell_Schedule_ID | 5.0.14 | Number(10,0) | [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed. |
CalendarDate | 5.0.14 | Date | [From Calendar_Day] The date value from Calendar_Day. Indexed. |
CalendarMembership | 5.0.14 | Float | [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.14 | Number(10,0) | [From Calendar_Day] Foreign key to the Cycle_Day table. Indexed. |
Dflt_Att_Mode_Code | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] Default Conversion Mode Code. Indexed. |
FTEID | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] The FTE ID from the FTE table. Indexed. |
Grade_Level | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] The Student's current grade level. |
Minutes_Absent | 5.0.14 | Number(10,0) | [Derived] Actual minutes absent from attendance taken. |
OffTrack | 5.0.14 | Number(10,0) | [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.14 | Number(10,0) | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Periods_Absent | 5.0.14 | Number(10,0) | [Derived] Actual periods absent from attendance taken. |
Potential_Minutes_Present | 5.0.14 | Number(10,0) | [Derived] Potential minutes based on the student's enrollment. |
Potential_Periods_Present | 5.0.14 | Number(10,0) | [Derived] Potential periods based on the student's enrollment. |
SchoolID | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] ID Linked to the School_Number from the Schools table. Indexed. |
Student_Track | 5.0.14 | Varchar(20) | [From PS_Enrollment_All] Represents the times during the year when the Student goes to school. |
StudentID | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] The internal number for the student this record is associated. Indexed. |
StudentMembership | 5.0.14 | Float | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Track_A | 5.0.14 | Number(10,0) | [From Calendar_Day] Track A from Calendar_Day. |
Track_B | 5.0.14 | Number(10,0) | [From Calendar_Day] Track B from Calendar_Day. |
Track_C | 5.0.14 | Number(10,0) | [From Calendar_Day] Track C from Calendar_Day. |
Track_D | 5.0.14 | Number(10,0) | [From Calendar_Day] Track D from Calendar_Day. |
Track_E | 5.0.14 | Number(10,0) | [From Calendar_Day] Track E from Calendar_Day. |
Track_F | 5.0.14 | Number(10,0) | [From Calendar_Day] Track F from Calendar_Day. |
YearID | 5.0.14 | Number(10,0) | [From PS_Enrollment_All] Current school year for the student. |