S_IA_CRS_X (ver 17.2.0)
This table is an extension of the Courses table, and holds fields used for Iowa state reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 17.2.0 | Number (10,0) | System generated primary key. |
| AP_Indicator | 17.2.0 | Varchar2(1) | Indication if the course is an AP course; not currently used for state reporting. Migrated from [Courses]IA_CRDC_AP_Indicator. |
| Accreditation_Program_Area | 22.7.1 | Varchar2(2) | The accreditation program area for the course. Migrated from [Courses]IA_AccreditationProgramArea. Updated length from 1 to 2 characters for the 2022-23 school year. |
| Common_Course_Number | 17.2.0 | Varchar2(6) | The state assigned course number. Migrated from [Courses]IA_Cmn_Crs_Num. |
| Course_Origination | 17.2.0 | Varchar2(2) | The origination of the course curriculum. Migrated from [Courses]IA_CourseType. |
Credit_Recovery | 14.7.2 | Number(11,0) | Is this a credit recovery course? |
| Embedded_WBL | 23.7.1 | Varchar2(2) | Indicates the predominant Embedded Work-Based Learning experience for the course. |
| FTE_Supplemental_Weight | 17.2.0 | Double | The course section FTE for supplementary weighting. Migrated from [Courses]IA_SecFTEForSuppWgt. |
| Homeroom | 17.2.0 | Number(1,0) | Indication of whether the course is a homeroom course. Migrated from [Courses]IA_Homeroom. |
| NCES_Course_Code | 17.2.0 | Varchar2(13) | No longer used by application. This field may still be referenced on custom reports and/or custom pages. Migrated from [Courses]IA_NCESCourseCode. |
| PK_Program_1_Hours | 18.1.0 | Double | The number of hours the preschool student attends Preschool Program 1. |
| PK_Program_2_Hours | 18.1.0 | Double | The number of hours the preschool student attends Preschool Program 2. |
| PK_Program_1_Type | 18.1.0 | Varchar2(2) | The program type for Preschool Program 1. |
| PK_Program_2_Type | 18.1.0 | Varchar2(2) | The program type for Preschool Program 2. |
| PSEOA_District | 17.2.0 | Varchar2(8) | The district providing the course section. Migrated from [Courses]IA_PSEOADistrict. |
| PSEOA _Provider | 17.2.0 | Varchar2(8) | The institution providing the course section. Migrated from [Courses]IA_PSEOAProvider. |
| SCED_Course_Code | 17.2.0 | Varchar2(11) | The SCED course code for the local course. Migrated from [Courses]IA_SCED_Course_Code. |