Att_AdaAdm_Defaults_All (ver12.1.0)
This internal-use table supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations. The data is available for reporting through the PS_ADAADM_DEFAULTS_ALL View.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Att_CalcCntPresentAbsent | 12.1.0 | Varchar2(7) | [From PS_Enrollment_All] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
Attendance_Conversion_ID | 12.1.0 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
AttendanceValue | 12.1.0 | Number | [From Attendance_Conversion_Items] The attendance value to use for a student for a day (a real number, typically a fraction of 1). |
CalendarDate | 12.1.0 | Date | [From PS_Membership_Reg] The calendar date. Indexed. |
CalendarMembership | 12.1.0 | Float(126) | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Dflt_A_Mode_Code | 12.1.0 | Varchar2(13) | [From PS_Membership_Reg] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 12.1.0 | Varchar2(11) | [From PS_Membership_Reg] Default Conversion Mode Code. Indexed. |
FTEID | 12.1.0 | Number(10,0) | [From PS_Membership_Reg] Key to the FTE table. Indexed. |
Grade_Level | 12.1.0 | Number(10,0) | [From PS_Membership_Reg] Student grade level. |
MembershipValue | 12.1.0 | Number | [Derived] Student membership derived from the PS_Membership_Reg view. |
Minutes_Absent | 12.1.0 | Number(10,0) | [Derived] Actual minutes absent from attendance taken. |
Minutes_Present | 12.1.0 | Number | [Derived] Actual minutes present from attendance taken. |
Offtrack | 12.1.0 | 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 | 12.1.0 | 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. |
PctDayPosAttPct | 12.1.0 | Number | [Derived] Percent day positive attendance percentage. |
PctDayNegAttPct | 12.1.0 | Number | [Derived] Percent day negative attendance percentage. |
PctTimeaAttPct | 12.1.0 | Number | [Derived] Percent time attendance percentage. |
Perc_Potential_Minutes_Present | 12.1.0 | Number | [Derived] Percent potential minutes present. |
Periods_Absent | 12.1.0 | Number(10,0) | [Derived] Actual periods absent from attendance taken. |
Potential_AttendanceValue | 12.1.0 | Number | [Derived] The potential attendance value in minutes. |
Potential_Minutes_Pre sent | 12.1.0 | Number(10,0) | [Derived] Potential minutes based on the student's enrollment. |
Potential_Periods_Present | 12.1.0 | Number(10,0) | [Derived] Potential periods based on the student's enrollment. |
SchoolID | 12.1.0 | Number(10,0) | [From PS_Membership_Reg] The unique school identifier. Indexed. |
Student_Track | 12.1.0 | Varchar2(20) | [From PS_Enrollment_All] Represents the times during the year when the Student goes to school. |
StudentID | 12.1.0 | Number(10,0) | [From PS_Membership_Reg] The internal Number for the student this record is associated with. Indexed. |
StudentMembership | 12.1.0 | Float(12 6) | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
YearID | 12.1.0 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. |