|
Name |
|
|
Dimensional Type |
Fact |
|
Comment |
Carleton's contributions to employee benefit plans, by day. |
|
CKT_MF_BENEFITCARLETONCONTRIBU |
|
Name |
Parent Table |
Foreign Key Columns |
|
Relationship_148 |
MD_CollPers_SurrogateKey |
|
|
Relationship_149 |
MD_Benefit_SurrogateKey |
|
|
Relationship_153 |
MD_Date_DateInteger |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_CollPers_SurrogateKey |
|
<None> |
numeric |
|
|
MD_Benefit_SurrogateKey |
|
<None> |
numeric |
|
|
MD_Date_DateInteger |
Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available. |
DW_DateInteger |
int |
|
|
MD_BenCarlCont_Amount |
|
<None> |
money |
|
|
MD_BenCarlCont_Count |
|
<None> |
int |
|
|
MD_BenCarlCont_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_BenCarlCont_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MF_BENEFITCARLETONCONTRIBUTION_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
Name |
|
Identifier_1 |
|
|
|