|
Name |
|
|
Dimensional Type |
Fact |
|
Comment |
Contributions to benefit plans by employees (day grain). |
|
CKT_MF_BENEFITEMPLOYEECONTRIBU |
|
Name |
Parent Table |
Foreign Key Columns |
|
Relationship_146 |
MD_Benefit_SurrogateKey |
|
|
Relationship_147 |
MD_CollPers_SurrogateKey |
|
|
Relationship_152 |
MD_Date_DateInteger |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_Benefit_SurrogateKey |
|
<None> |
numeric |
|
|
MD_CollPers_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 |
|
|
MF_BenEmpCont_Amount |
|
<None> |
money |
|
|
MF_BenEmpCont_Count |
|
<None> |
int |
|
|
MF_BenEmpCont_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MF_BenEmpCont_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MF_BENEFITEMPLOYEECONTRIBUTION_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
Name |
|
Identifier_1 |
|
|
|