S_NC_RPT_SAR_TEACHCOURSE (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Detail view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CLASS_STAFF_ROLE | 13.6.0 | VARCHAR2(10) | The id number for the class role for this teacher which links to the ID in the RoleDef table. |
| CORE_EXC_REQ | 13.6.0 | VARCHAR2(20) | This is obsolete. It was created to hold imported information about a teacher's highly qualified status. |
| CORE_SUB_REQ | 13.6.0 | VARCHAR2(20) | This is obsolete. It was created to hold imported information about a teacher's highly qualified status. |
| COURSE_NUMBER | 13.6.0 | VARCHAR2(11) | The course number for this section. |
| DAY_NUMBER | 13.6.0 | NUMBER(10,0) | The day number of the section |
| END_DATE | 13.6.0 | DATE | The end date of the teacher's assignment to this section. |
| MATRIX_MEETING_CODE | 13.6.0 | VARCHAR2(80) | The expression of when this section meets (periods and days) |
| NONCORE_EXC_REQ | 13.6.0 | VARCHAR2(20) | This is obsolete. It was created to hold imported information about a teacher's highly qualified status. |
| NONCORE_SUB_REQ | 13.6.0 | VARCHAR2(20) | This is obsolete. It was created to hold imported information about a teacher's highly qualified status. |
| PERIOD_NUMBER | 13.6.0 | NUMBER(10,0) | The period number for this section. |
| 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. |
| SCHOOL_ID | 13.6.0 | NUMBER(10,0) | The school number where the section is taught. |
| SECTION_NUMBER | 13.6.0 | VARCHAR2(10) | The section number of this section. |
| START_DATE | 13.6.0 | DATE | The start date of the teacher's assignment to this section. |
| TEACHER_ID | 13.6.0 | NUMBER(10,0) | Indicates the internal teacher id for this staff person. |
| TEACHER_USERS_DCID | 13.6.0 | NUMBER(10,0) | Foreign key that links to the Users table. |