Skip to main content
Skip table of contents

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 NameInitial VersionData TypeDescription

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.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.