S_MN_CRS_CollegeCourse_C (Version 17.9.0)
This table is a child table of the COURSES table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.9.0 | Number (10,0) | Primary Key. |
| CoursesDCID | 17.9.0 | Number (10,0) | Foreign key used to link back to the COURSES table. |
ForeignKey | 17.9.0 | Number (11,0) | COURSES table ID. |
ForeignKey_Alpha | 17.9.0 | Varchar2 (31) | The course number from the COURSES table. |
| Unique_ID | 17.9.0 | Number (11,0) | Primary key from the virtual table. |
| College_Code | 17.9.0 | Varchar2 (6) | Federal code representing post-secondary institution. |
| College_Course_Code | 17.9.0 | Varchar2 (20) | The course code assigned by the post-secondary institution. |
| College_Course_Credits | 17.9.0 | Number (25,10) | The number of post-secondary credits or hours assigned to the course. |
| College_Course_Level | 17.9.0 | Varchar2 (6) | A code indicating the college level of the course. |
| College_Code_Ed_Fi | 23.8.2.0 | Varchar2 (19) | College Code for Ed-Fi publishing. |
| SchoolID | 17.9.0 | Number (11,0) | The state assigned school number associated with this college course. |