S_NC_PS_POTENTIAL (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 |
---|---|---|---|
ADA_CODE | 13.6.0 | NUMBER(10,0) | Indicates the ADA code for absence code. |
BELL_SCHEDULE_ID | 13.6.0 | NUMBER(10,0) | Indicates the bell schedule for the attendance record. |
CALENDARDATE | 13.6.0 | DATE | Indicates the calendar date of the attendance record. |
CYCLE_DAY_ID | 13.6.0 | NUMBER(10,0) | Indicates the day in the rotation for the attendance record. |
LETTER | VARCHAR2(2) | ||
MEMBERSHIPVALUE | 13.6.0 | VARCHAR2(100) | Indicates the membership value for the student for the date. |
POTENT_MIN | 13.6.0 | NUMBER(,) | Indicates the potential number of minutes present for the date. |
POTENT_PERIOD | 13.6.0 | NUMBER(,) | Indicates the potential number of minutes present for the period for the date. |
PREF_VALUE | 13.6.0 | NUMBER(,) | |
SCHOOLID | 13.6.0 | NUMBER(10,0) | Indicates the school id of the attendance record. |
STUDENTID | 13.6.0 | NUMBER(10,0) | Indicates if the day code for the date and period. |
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. |
YEAR_ID | 13.6.0 | NUMBER(10,0) | Indicates the year id for the attendance record. |