S_NC_PS_MEMBERSHIP_HOLD (ver 13.6.0)
This table is a stand alone table that stores information about a student's attendance.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACTUAL_ATT_MODE_CODE | 13.6.0 | VARCHAR2(13) | Indicates if the actual attendance mode of daily or meeting. |
| ACTUAL_MINUTES_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes absent. |
| ACTUAL_PERIODS_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates if the periods the student was absent. |
| ATTENDANCE_CONVERSION_ID | 13.6.0 | NUMBER(10,0) | Indicates the FTE Conversion ID for the attendance record. |
| ATT_CALCCNTPRESENTABSENT | 13.6.0 | VARCHAR2(7) | |
| ATT_INTERVALDURATION | 13.6.0 | VARCHAR2(30) | |
| BELL_SCHEDULE_ID | 13.6.0 | NUMBER(10,0) | The bell schedule ID for the period/bell schedule. |
| CALENDARDATE | 13.6.0 | DATE | The date the student was absent. |
| CALENDARMEMBERSHIP | 13.6.0 | FLOAT | Indicates if the calendar date is considered as in membership. |
| CYCLE_DAY_ID | 13.6.0 | NUMBER(10,0) | Indicates if the day code for the date and period. |
| DFLT_ATT_MODE_CODE | 13.6.0 | VARCHAR2(13) | Indicates the default attendance mode of daily or meeting. |
| DFLT_CONVERSION_MODE_CODE | 13.6.0 | VARCHAR2(11) | Indicates the default FTE Conversion ID for the attendance record. |
| EXCUSED_MINUTES_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the number of excused minutes absent. |
| FTEID | 13.6.0 | NUMBER(10,0) | Indicates the FTE ID for the attendance record. |
| GRADE_LEVEL | 13.6.0 | NUMBER(10,0) | Indicates the grade level for the student. |
| H1_MINUTES_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes absent for code H1. |
| MINUTES_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes absent. |
| OFFTRACK | 13.6.0 | NUMBER(10,0) | |
| ONTRACK | 13.6.0 | NUMBER(10,0) | |
| PERIODS_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the periods absent. |
| POTENTIAL_MINUTES_PRESENT | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes the student potentially could be present. |
| POTENTIAL_PERIODS_PRESENT | 13.6.0 | NUMBER(10,0) | Indicates the potential periods the student could be counted as present. |
| SCHOOLID | 13.6.0 | NUMBER(10,0) | The school id for the attendance record. |
| STUDENTID | 13.6.0 | NUMBER(10,0) | The student id for the attendance record. |
| STUDENTMEMBERSHIP | 13.6.0 | FLOAT | Indicates the student's membership for the calendar date. |
| STUDENT_TRACK | 13.6.0 | VARCHAR2(20) | The student's track. |
| TRACK_A | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| TRACK_B | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| TRACK_C | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| TRACK_D | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| TRACK_E | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| TRACK_F | 13.6.0 | NUMBER(10,0) | Indicates if the track is in-session for the calendar date. |
| UNEXCUSED_MINUTES_ABSENT | 13.6.0 | NUMBER(10,0) | Indicates the number of unexcused minutes absent. |
| YEARID | 13.6.0 | NUMBER(10,0) | Indicates the year id for the attendance record. |