S_CRS_X (ver 19.8.2)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 19.8.2 | Number(19,0) | A primary key that relates the extended table back to the [Courses] table. |
| WhoCreated | 19.8.2 | VarChar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 19.8.2 | TimeStamp(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 19.8.2 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 19.8.2 | TimeStamp(6) | The date and time the record was modified. Defaults to system date. |
| SCED_AP_Type | 19.8.2 | Varchar2(30) | This indicates the SCED AP type. |
| SCED_Carnegie_Credit | 19.8.2 | Varchar2(4) | This indicates the available carnegie unit credit when a secondary course. |
| SCED_CompleteCourseCode | 19.8.2 | Varchar2(12) | This indicates the entire completed SCED course code. |
| SCED_Course_Code | 19.8.2 | Varchar2(5) | This indicates the SCED course code. |
| SCED_Course_Level | 19.8.2 | Varchar2(1) | This indicates the SCED course level. |
| SCED_Grade_Span | 19.8.2 | Varchar2(4) | This indicates the grade span when prior to the secondary course. |
| SCED_Sequence | 19.8.2 | Varchar2(2) | This indicates the sequence of the course. |
| SCED_Subject_Type | 19.8.2 | Varchar2(30) | This indicates the SCED subject type of course. |