|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_DStu_RowEnd |
Used to track type II SCDs. In lay terms: Use this column to restrict what you are looking at to some 'as-of' date. E.g., to look only at faculty information as of Nov 1, 2008, restrict rows you examine from this dimension to those whose RowStart <= 2008-12-31 <= RowEnd. |
DW_RowEnd |
datetime |
|
|
MD_DStu_RowIsCurrent |
|
DW_BooleanNoDefault |
bit |
|
|
MD_DStu_Type1Checksum |
|
DW_Checksum |
int |
|
|
MD_DStu_Type2Checksum |
|
DW_Checksum |
int |
|
|
MD_DStu_Timestamp |
|
<None> |
timestamp |
|
|
|
|