|
Name |
|
|
Dimensional Type |
Dimension |
|
Comment |
This dimension holds academic concentrations. Academic "concentrations" are the Carleton equivalent of minors (as opposed to majors), and in fact are implemented as minors in Colleague. |
|
CKT_MD_CONCENTRATION |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_Conc_SurrogateKey |
|
<None> |
numeric |
|
|
MD_Conc_Abbreviation |
Short name or code for a concentration. In Colleague this is the primary key. The actual name of the concentration is just a 'description' in Colleague, and is more volatile than the code. |
DW_Colleague5CharCode |
char(5) |
5 |
|
MD_Conc_Name |
Colleague "description" corresponding to a concentration's abbreviation. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_Conc_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_Conc_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MD_CONCENTRATION_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
MD_CONCENTRATION_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
Name |
|
Identifier_1 |
|
AltKey |
|
|
|