|
Name |
|
|
Dimensional Type |
Dimension |
|
Comment |
Captures the relationship between advisor and academic advisee. Typically Colleague has this value as NULL (which we convert to 'Not specified' here). But there are other types of advisement, such as 'Major'. |
|
CKT_MD_ADVISEMENTTYPE |
|
Name |
Child Table |
Foreign Key Columns |
|
Relationship_242 |
MD_AdviseType_SurrogateKey |
|
Name |
Code |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_AdviseType_SurrogateKey |
|
<None> |
numeric |
|
|
MD_AdviseType_Abbrev |
|
DW_CodeDescShort |
varchar(16) |
16 |
|
MD_AdviseType_Name |
|
DW_CodeDesc |
varchar(32) |
32 |
|
MD_AdviseType_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_AdviseType_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MD_ADVISEMENTTYPE_PK |
TRUE |
FALSE |
TRUE |
FALSE |
FALSE |
|
|
MD_ADVISEMENTTYPE_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
Name |
|
Identifier_1 |
|
AltKey |
|
|
|