S_NC_PS_MEMBERSHIP_DEFAULTS (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. |