S_PA_CRS_X (ver 14.11.0)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
CoursesDCID | 14.11.0 | Number(10,0) | Foreign Key to the Courses table. |
Subject_Area_Code | 14.11.0 | Varchar2(2) | Subject Area Code (Used for EWS) |
Eng_Lang_Learn_Indicator | 14.11.0 | Varchar2(1) | English Language Learner Indicator (Used for EWS) |
Remedial_Indicator | 14.11.0 | Varchar2(1) | Remedial Indicator (Used for EWS) |
Basic_Indicator | 14.11.0 | Varchar2(1) | Basic Indicator (Used for EWS) |
Special_Ed_Indicator | 14.11.0 | Varchar2(1) | Special Education Indicator (Used for EWS) |
Core_Indicator | 14.11.0 | Varchar2(1) | Core Indicator (Used for EWS) |
Number_Of_Parts | 14.11.0 | Integer | Number Of Parts (Used for EWS) |
CollegeLevel_indicator | 15.2.0 | Varchar2(1) | College Level Indicator (Used for EWS) |
Untracked_indicator | 15.2.0 | Varchar2(1) | Untracked Indicator (Used for EWS) |
Correspondence_Indicator | 14.11.0 | Varchar2(1) | Correspondence Indicator (Used for EWS) |
HS_Equivalen_Indicator | 14.11.0 | Varchar2(1) | Hs Equivalent Indicator (Used for EWS) |
Dist_Learning_Indicator | 14.11.0 | Varchar2(1) | Distance Learning Indicator (Used for EWS) |
Grad_Credit_Indicator | 14.11.0 | Varchar2(1) | Graduation Credit Indicator (Used for EWS) |
Magnet_Indicator | 14.11.0 | Varchar2(1) | Magnet Indicator (Used for EWS) |
Pre_Adv_Placement_Indicator | 14.11.0 | Varchar2(1) | Pre-Advanced Placement Indicator (Used for EWS) |
Pre_Intl_Bacc_Indicator | 14.11.0 | Varchar2(1) | Pre-International Baccalaureate Indicator (Used for EWS) |
Course_Sequence | 14.11.0 | Integer | Course Sequence (Used for EWS) |
KeySubTestIdentifier | 15.1.3 | Varchar2(20) | Keystone Subtest Identifier. |
PSSASubTestIdentifier | 15.1.3 | Varchar2(20) | PSSA Subtest Identifier. |
Exclude_from_EWS | 15.6.2 | Number(1,0) | Exclude Course from EWS reports |
BlockScheduledClass_TF | 16.4.0 | Number(1,0) | Is this a Block Scheduled Course? |
Advanced_Placement_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_AP_Ind. |
Alternate_Course_Code | 17.3.0 | Varchar2(12) | Migrated from [Courses]PA_Alt_Course_Cd. |
Course_Delivery_Model_Code | 17.3.0 | Varchar2(4) | Migrated from [Courses]PA_Course_Del_Mod_Cd. |
Dual_Credit_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_Dual_Credit. |
Gifted_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_Gifted_Ind. |
Honors_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_Honors_Ind. |
International_Baccalaureate_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_Inter_Bacc_Ind. |
Requirements_Code_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_Require_Ind. |
Semester_Code | 17.3.0 | Varchar2(2) | Migrated from[Courses]PA_Semester. |
Exclude_From_Pims_TF | 17.3.0 | Number(1,0) | Migrated from [Courses]PA_exclude_from_pims. |
KeyTestDate | 17.4.0 | Date | Migrated from [Courses]PA_KeyTestDate. |
PSSATestDate | 17.4.0 | Date | Migrated from [Courses]PA_PSSATestDate. |