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