S_NC_RPT_SAR_TEACHDUTY (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report views and is collected from the Staff Duty page.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| FRI_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Friday. |
| MON_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Monday. |
| RPT_RUN_ID | 13.6.0 | NUMBER(,) | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
| SAT_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Saturday. |
| SCHOOL_ID | 13.6.0 | NUMBER(10,0) | The school number for this record. |
| STAFF_DUTY_CODE | 13.6.0 | VARCHAR2(6) | The code for the staff duty assigned to this person. Codes are in Gen table where cat ='staff_duty' and Name is the code. |
| STAFF_DUTY_CODE_DESC | 13.6.0 | VARCHAR2(100) | The description of the code for the staff duty assigned to this person. Codes are in Gen table where cat ='staff_duty' and Value is the description.. |
| STAFF_DUTY_DURATION_PERCENT | 13.6.0 | NUMBER(11,0) | The percent of the day that the staff performs this duty. |
| STAFF_DUTY_DURATION_TIME | 13.6.0 | VARCHAR2(6) | The number of minutes that the staff performs this duty |
| STAFF_DUTY_FRI | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Friday. |
| STAFF_DUTY_MON | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Monday. |
| STAFF_DUTY_SAT | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Saturday. |
| STAFF_DUTY_SUN | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Sunday. |
| STAFF_DUTY_THU | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Thursday. |
| STAFF_DUTY_TUE | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Tuesday. |
| STAFF_DUTY_WED | 13.6.0 | VARCHAR2(1) | This is set to Y if this duty is performed on Wednesday. |
| SUN_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Sunday. |
| TEACHER_USERS_DCID | 13.6.0 | NUMBER(10,0) | Foreign key that links to the Users table. |
| THU_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Thursday. |
| TUE_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Tuesday. |
| WED_PERIOD | 13.6.0 | NUMBER(11,0) | This indicates the number of periods this duty is performed on Wednesday. |