S_CC_X (ver 19.8.2)
This table is an extension of the [CC] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CCDCID | 19.8.2 | Number(19,0) | A primary key that relates the extended table back to the CC 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. |
work_based_learning_type | 25.1.1.0 | Varchar2(10) | To categorize the type of work-based learning opportunity associated with a course enrollment. |