Att_AdaAdm_Defaults_HIS (ver12.1.1)
This internal-use table supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations. This table is used by nightly to keep track of the past school years attendance data. The data is available for reporting through the PS_ADAADM_DEFAULTS_ALL View.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Att_CalcCntPresentAbsent | 12.1.1 | Varchar2(7char) | [From PS_Enrollment_All] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
Attendance_Conversion_ID | 12.1.1 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
AttendanceValue | 12.1.1 | 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.1 | Date | [From PS_Membership_Reg] The calendar date. Indexed. |
CalendarMembership | 12.1.1 | 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_Att_Mode_Code | 12.1.1 | Varchar2(13char) | [From PS_Membership_Reg] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 12.1.1 | Varchar2(11 char) | [From PS_Membership_Reg] Default Conversion Mode Code. Indexed. |
FTEID | 12.1.1 | Number(10,0) | [From PS_Membership_Reg] Key to the FTE table. Indexed. |
Grade_Level | 12.1.1 | Number(10,0) | [From PS_Membership_Reg] Student grade level. |
MembershipValue | 12.1.1 | Number | [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 | [Derived] Actual minutes present from attendance taken. |
OffTrack | 12.1.1 | 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.1 | 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.1 | Number | [Derived] Percent day positive attendance percentage. |
PctDayNegAttPct | 12.1.1 | Number | [Derived] Percent day negative attendance percentage. |
PctTimeAttPct | 12.1.1 | Number | [Derived] Percent time attendance percentage. |
Perc_Potential_Minutes_Present | 12.1.1 | Number | [Derived] Percent potential minutes present. |
Periods_Absent | 12.1.1 | Number(10,0) | [Derived] Actual periods absent from attendance taken. |
Potential_AttendanceValue | 12.1.1 | Number | [Derived] The potential attendance value in minutes. |
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 | 12.1.1 | Number(10,0) | [From PS_Membership_Reg] The unique school identifier. Indexed. |
Student_Track | 12.1.1 | Varchar2(20char) | [From PS_Enrollment_All] Represents the times during the year when the Student goes to school. |
StudentID | 12.1.1 | Number(10,0) | [From PS_Membership_Reg] The internal number for the student this record is associated with. Indexed. |
StudentMembership | 12.1.1 | Float(126) | [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.1 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. |