PS_Attendance_Time (ver5.0.0)
This view provides all Time Attendance records that fall within a valid in-session school calendar day. This includes both present and absent attendance records.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Attendance_CodeID | 5.0.0 | Longint | [From Attendance] The Attendance Code ID from the Attendance Code table. Indexed. |
Att_Code | 5.0.0 | String10 | [From Attendance_Code] The Attendance Code value from the Attendance Code table. Indexed. |
Att_Date | 5.0.0 | Date | [From Attendance] The Attendance Date from the Attendance Code table. Indexed. |
Att_Mode_Code | 5.0.0 | String20 | [From Attendance] The Attendance Mode Code from the Attendance Code table. Indexed. |
Calendar_DayID | 5.0.0 | Longint | [From Calendar_Day] The unique identifier from the Calendar_Day table. |
Count_For_ADA | 5.0.0 | Longint | [From Attendance_Code] Calculate ADA (y or n). |
Cycle_Day_Abbreviation | 5.0.0 | String3 | [From Cycle_Day] Cycle Day (3 character) Abbreviation. |
Cycle_Day_ID | 5.0.0 | Longint | [From Calendar_Day] Cycle day unique ID. Indexed. |
ID | 5.0.0 | Longint | [From Attendance] Unique ID from the Attendance table. Indexed. |
InSession | 5.0.0 | Longint | [From Calendar_Day] In session flag from the Calendar_Day table. |
Presence_Status_CD | 5.0.0 | String10 | [From Attendance_Code] Presence status code from the Attendance_Code table. |
ProgramID | 5.0.0 | Longint | [From Attendance] The program ID located in the Attendance table. |
SchoolID | 5.0.0 | Longint | [From Attendance] ID Linked to the School_Number from the Schools table. Indexed. |
StudentID | 5.0.0 | Longint | [From Students] The internal number for the student this record is associated with. Indexed. |
Total_Minutes | 5.0.0 | Longint | [From Attendance] The total minutes from the Attendance table (Daily Mode). |
Track_A | 5.0.0 | Longint | [From Calendar_Day] Track A from Calendar_Day. |
Track_B | 5.0.0 | Longint | [From Calendar_Day] Track B from Calendar_Day. |
Track_C | 5.0.0 | Longint | [From Calendar_Day] Track C from Calendar_Day. |
Track_D | 5.0.0 | Longint | [From Calendar_Day] Track D from Calendar_Day. |
Track_E | 5.0.0 | Longint | [From Calendar_Day] Track E from Calendar_Day. |
Track_F | 5.0.0 | Longint | [From Calendar_Day] Track F from Calendar_Day. |