S_NC_RPT_SAR_COURSE (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report view particularly the course information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACADEMIC_LEVEL_CODE | 13.6.0 | VARCHAR2(4) | Indicates the academic level of the course which is the 5th digit of the course number. |
| ACADEMIC_LEVEL_DESC | 13.6.0 | VARCHAR2(35) | The description of the the academic level based on the 5th digit of the course number. Values are: 0 - Modified Curriculum; 1 - Abridged/Adapted (Remedial); 2 - Standard Version; 3 - Applied/Technical; 4 - Advanced Placement/NCVPS; 5 - Honors/Advanced/Academically Gifted; 6 - Co-op Education; 7 - Advanced Placement; 8 - International Baccalaureate; 9 - Non-Classroom Activity |
| CLASSROOM_MIN | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes this section meets. |
| COURSE_CODE_LEN_COURSE | 13.6.0 | NUMBER(10,0) | The code for the length of time this course is typically taught. These values are found in the Gen table where cat='course_lengths', name field is the code and value is the description. |
| COURSE_GRADE_LEVEL | 13.6.0 | VARCHAR2(2) | Indicates if this is a PK course (P), High School Grades 9-13 (X), Middle School 6-8 (Y) or Elementary (Z). This is the 6th digit of the course number. |
| COURSE_LEVEL_HIGH | 13.6.0 | NUMBER(11,0) | The highest grade level for students that can take this course. |
| COURSE_LEVEL_LOW | 13.6.0 | NUMBER(11,0) | The lowest grade level for students that can take this course. |
| COURSE_NAME | 13.6.0 | VARCHAR2(50) | The course name for this section. |
| COURSE_NUMBER | 13.6.0 | VARCHAR2(11) | The course number for this section. |
| CREDITS_TOWARD_GRAD | 13.6.0 | FLOAT | Indicates the number of credits for graduation are awarded for this course |
| CREDIT_COURSE_FLAG | 13.6.0 | VARCHAR2(2) | Indicates if the course credit flag is Yes or No. |
| CRS_COURSE_EXTERNAL_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course external provider. Gen table: cat='external_prov' where value is the description |
| CRS_COURSE_EXTERNAL_PROVIDER | 13.6.0 | VARCHAR2(1) | Indicates the course external provider attribute. Gen table: cat='external_prov' where name field is the code. |
| CRS_COURSE_LENGTH_CODE | 13.6.0 | NUMBER(11,0) | Indicates the course length attribute. Gen table: cat='course_lengths' where name field is the code. |
| CRS_COURSE_LENGTH_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course length. Gen table: cat='course_lengths' where value is the description |
| CRS_COURSE_THIRDPARTY_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course third party provider. Gen table: cat='thirdparty_prov' where value is the description |
| CRS_COURSE_THIRDPARTY_PROVIDER | 13.6.0 | VARCHAR2(30) | Indicates the course third party provider attribute. Gen table: cat='thirdparty_prov' where name field is the code. |
| CRS_DELIVERY_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course delivery mode. Gen table: cat='delivery_mode' where value is the description |
| CRS_DELIVERY_MODE | 13.6.0 | VARCHAR2(1) | Indicates the course delivery mode attribute. Gen table: cat='delivery_mode' where name field is the code. |
| CRS_HOW_TAKEN_CODE | 13.6.0 | NUMBER(11,0) | Indicates the course how taken attribute. Gen table: cat='How_taken' where name field is the code. |
| CRS_HOW_TAKEN_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course how taken attribute. Gen table: cat='how_taken' where value is the description |
| CRS_INSTITUTION_CODE | 13.6.0 | VARCHAR2(5) | Indicates the course post-secondary institution attribute. Gen table: cat='postsecinst' where name field is the code. |
| CRS_INSTITUTION_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course post-secondary attribute. Gen table: cat='postsecinst' where value is the description |
| CRS_SELECT_CREDIT_RECOVERY | 13.6.0 | VARCHAR2(1) | Indicates if this course is a credit recovery course. |
| DAY_NUMBER | 13.6.0 | NUMBER(10,0) | Indicates the day number that this section meets. |
| GRADE_LEVEL | 13.6.0 | VARCHAR2(2) | Indicates the grade level that is used for this section record. |
| GRADE_RANGE | 13.6.0 | VARCHAR2(5) | Indicates the grade range for this section based on grades of students in the class. |
| MATRIX_MEETING_CODE | 13.6.0 | VARCHAR2(80) | Indicates the expression for this section. |
| MAX_ENROLL | 13.6.0 | NUMBER(10,0) | Indicates the maximum number of students allowed to be scheduled in this section. |
| MIN_MATRIX_ENTRY | 13.6.0 | NUMBER(10,0) | Indicates the number of minutes this class meets each time it meets. |
| NUM_OVER | 13.6.0 | NUMBER(10,0) | Indicates the number of students enrolled over the maximum in this section. |
| PERIOD_DAY | 13.6.0 | VARCHAR2(80) | Indicates the period number and day that this section meets. |
| PERIOD_NUMBER | 13.6.0 | NUMBER(10,0) | Indicates the period number that this section meets. |
| 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) | Indicates the school number where this section is taught. |
| SECTION_ID | 13.6.0 | NUMBER(10,0) | Indicates the internal section id for this section. |
| SECTION_NUMBER | 13.6.0 | VARCHAR2(10) | Indicates the section number for this section. |
| SEC_COURSE_EXTERNAL_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course external provider for the section if different from the course. Gen table: cat='external_prov' where value is the description |
| SEC_COURSE_EXTERNAL_PROVIDER | 13.6.0 | VARCHAR2(1) | Indicates the course external provider for the section if different from the course. Gen table: cat='external_prov' where name field is the code. |
| SEC_COURSE_LENGTH_CODE | 13.6.0 | NUMBER(11,0) | Indicates the course length attribute for the section if different from the course. Gen table: cat='course_lengths' where name field is the code. |
| SEC_COURSE_LENGTH_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course length for the section if different from the course. Gen table: cat='course_lengths' where value is the description |
| SEC_COURSE_THIRDPARTY_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course third party provider for the section if different from the course. Gen table: cat='thirdparty_prov' where value is the description |
| SEC_COURSE_THIRDPARTY_PROVIDER | 13.6.0 | VARCHAR2(30) | Indicates the course third party provider attribute for the section if different from the course. Gen table: cat='thirdparty_prov' where name field is the code. |
| SEC_DELIVERY_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course delivery mode for the section if different from the course. Gen table: cat='delivery_mode' where value is the description |
| SEC_DELIVERY_MODE | 13.6.0 | VARCHAR2(1) | Indicates the course delivery mode attribute for the section if different from the course. Gen table: cat='delivery_mode' where name field is the code. |
| SEC_HOW_TAKEN_CODE | 13.6.0 | NUMBER(11,0) | Indicates the course how taken attribute for the section if different from the course. Gen table: cat='how_taken' where name field is the code. |
| SEC_HOW_TAKEN_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course how taken attribute for the section if different from the course. Gen table: cat='how_taken' where value is the description |
| SEC_INSTITUTION_CODE | 13.6.0 | VARCHAR2(5) | Indicates the course post-secondary institution attribute for the section if different from the course. Gen table: cat='postsecinst' where name field is the code. |
| SEC_INSTITUTION_DESC | 13.6.0 | VARCHAR2(100) | Indicates the description of the course post-secondary institution attribute for the section if different from the course. Gen table: cat='postsecinst' where value is the description |
| SEC_SELECT_CREDIT_RECOVERY | 13.6.0 | VARCHAR2(1) | Indicates if this section is a credit recovery section. |
| STATE_GRADE_CODE | 13.6.0 | VARCHAR2(2) | Indicates the converted state grade level for this section record. |
| SUBJ_AREA | 13.6.0 | VARCHAR2(4) | Indicates the subject area of the course which is the first 4 digits of the course number. |
| TEACHER_ID | 13.6.0 | NUMBER(10,0) | Indicates the teacher number of the teacher. |
| TERM | 13.6.0 | VARCHAR2(6) | Indicates the description of the term for the termid that this section is taught. |
| TERMID | 13.6.0 | NUMBER(10,0) | Indicates the term id that this section is taught. |
| TOTAL_STUDENTS | 13.6.0 | NUMBER(10,0) | Indicates the total number of students in this section. |
| TOT_NUM_STU_ACTIVITY | 13.6.0 | NUMBER(10,0) | Indicates the total number of active students. |