SCED_Code_Mapping (ver7.6.0)
This table is to be used for state reporting. It identifies the federal SCED codes and maps the CRDC relevant codes to their course type. It also denotes all AP courses.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
APType | 7.6.0 | Varchar(10) | The type of AP course if the course qualifies as AP. Types are defined by the CRDC requirements. |
SCED_Code_MappingID | 7.6.0 | Number(10,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
SCEDCode | 7.6.0 | Varchar(10) | The federally assigned SCED code. Typically a five-digit numeric number with a leading 0. |
SubjectType | 7.6.0 | Varchar(30) | The subject type, such as Algebra I, Chemistry. Only courses with subject types relevant to CRDC are currently listed. |
WhenCreated | 7.6.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 7.6.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 7.6.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 7.6.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |