PSSIS_AdaAdm_Daily_Ttod (ver5.0.0)
This view may be used for gathering Daily Attendance records (using Time to Day conversion).
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From PSSIS_Membership_Reg] The Student's last, first name. |
Student_Number | 5.0.0 | Real | [From PSSIS_Membership_Reg] The Student's number. |
Current_Grade_Level | 5.0.0 | Longint | [From PSSIS_Membership_Reg] The Student's current grade level. |
Current_School_Abbreviation | 5.0.0 | String20 | [From PSSIS_Membership_Reg] The School's abbreviation. |
Gender | 5.0.0 | String2 | [From PSSIS_NCLB_Fields] The Student's gender (M, F). |
Ethnicity_Name | 5.0.0 | String50 | [From PSSIS_NCLB_Fields] The Student's Ethnicity Name. |
Ethnicity_Code | 5.0.0 | String20 | [From PSSIS_NCLB_Fields] The Student's Ethnicity Code. |
Special_Ed_Student | 5.0.0 | String3 | [From PSSIS_NCLB_Fields] Flag to show whether or not this Student is a Special Ed Student. |
Attendance_School_Abbreviation | 5.0.0 | String20 | [From Schools] The School's abbreviation. |
StudentID | 5.0.0 | Longint | [From PSSIS_Membership_Reg] The internal number for the student this record is associated. Indexed. |
SchoolID | 5.0.0 | Longint | [From PSSIS_Membership_Reg] The unique School identifier. Indexed. |
CalendarDate | 5.0.0 | Date | [From PSSIS_Membership_Reg] The Calendar date. |
FTEID | 5.0.0 | Longint | [From PSSIS_Membership_Reg] Key to the FTE table. Indexed. |
Attendance_Conversion_ID | 5.0.0 | Longint | [From PSSIS_Membership_Reg] Key to the Attendance_Conversion table. Indexed. |
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). |
MembershipValue | 5.0.0 | Real | [Derived] Student membership derived from the PSSIS_Membership_Reg view. |
Grade_Level | 5.0.0 | Longint | [From PSSIS_Membership_Reg] Student Grade Level. |
OnTrack | 5.0.0 | Longint | [Derived] The value is determined from the track information returned by the PSSIS_Membership_Reg view and the Calendar_Day track values. |
OffTrack | 5.0.0 | Longint | [Derived] The value is determined from the track information returned by the PSSIS_Membership_Reg view and the Calendar_Day track values. |
Student_Track | 5.0.0 | String20 | [From PSSIS_Membership_Reg] Represents the calendar days during the year when the Student goes to school. |
Potential_AttendanceValue | 5.0.0 | Real | [Derived] Total attendance possible for a student for a day. |