PS_AdaAdm_Defaults_All (ver5.0.0)
This view supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AttendanceValue | 5.0.0 | Real | [From Attendance_Conversion_Items] The attendance value to use for a student for a day (a real number, typically a fraction of 1). |
CalendarDate | 5.0.0 | Date | [From PS_Membership_Reg] The calendar date. |
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] Key to the FTE table. Indexed. |
Grade_Level | 5.0.0 | Longint | [From PS_Membership_Reg] Student grade level. |
MembershipValue | 5.0.0 | Real | [Derived] Student membership derived from the PS_Membership_Reg view. |
| Minutes_Absent | 12.1.1 | Number(10,0) | [Derived] Actual minutes absent from attendance taken. |
| Minutes_Present | 12.1.1 | Number(10,0) | [Derived] Actual minutes present from attendance taken (i.e., potential_minutes_present - minutes_absent). |
| Periods_Absent | 12.1.1 | Number(10,0) | [Derived] Actual periods absent from attendance taken. |
| Potential_Minutes_Present | 12.1.1 | Number(10,0) | [Derived] Potential minutes based on the student's enrollment. |
| Potential_Periods_Present | 12.1.1 | Number(10,0) | [Derived] Potential periods based on the student's enrollment. |
SchoolID | 5.0.0 | Longint | [From PS_Membership_Reg] The unique school identifier. Indexed. |
StudentID | 5.0.0 | Longint | [From PS_Membership_Reg] The internal number for the student this record is associated with. Indexed. |
| YearID | 12.1.1 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. |
| OnTrack | 12.1.1 | Longint | [Derived] The value is determined from the track information. |
| OffTrack | 12.1.1 | Longint | [Derived] The value is determined from the track information. |
| Student_Track | 12.1.1 | Longint | [Derived] The value is determined from the student track information. |
| Potential_AttendanceValue | 7.2.2 | Real | [Derived] Total attendance possible for a student for a day. |