|
Name |
|
|
Dimensional Type |
Dimension |
|
Comment |
Academic subject dimension. Courses are assigned subjects for curricular and academic coverage purposes. "Subjects" are often the same as departments, but not invariably. |
|
CKT_MD_SUBJECT |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_Subj_SurrogateKey |
|
<None> |
numeric |
|
|
MD_Subj_Abbreviation |
The short name or code for a subject in Colleague. In Colleague this is the primary key for subjects. An unknown subject abbreviation will be coded as '????'. |
DW_Colleague5CharCode |
char(5) |
5 |
|
MD_Subj_Name |
The full name or description of a subject in Colleague. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Subj_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_Subj_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MD_SUBJECT_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
MD_SUBJECT_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
Name |
|
Identifier_1 |
|
AltKey |
|
|
|