|
Attribute |
Description |
Example |
|---|---|---|
|
Calculator |
See Calculator. |
|
|
See Created Via. |
|
|
|
Creation Date |
See Creation Date. |
|
|
DT From |
Date when the record was added to the data warehouse. This is not necessarily the creation date of the record in the source system and should not be used to be reported on as such. |
|
|
DT To |
Date when a newer version of this record was added to the data warehouse. A record which has NULL in DT_To is the most recent version of this record. Avoid aggregations over records which have DT_To filled in to ensure correct results. |
|
|
DW Company Set ID |
ID for the combination of Multiple Databases. |
|
|
Estimate Description |
Estimate Description |
|
|
Estimate ID |
ID of the estimate |
|
|
Estimate Site |
Site of the estimate |
|
|
SK Customer |
Foreign key that links to the dimension "Customer" |
|
|
SK Estimate |
See SK Estimate. |
|
|
SK Representative |
Foreign key that links to the dimension "Representative". |
|
|
Source Company |
Reflects the original source of the data found in the record. Only useful within multi-site DataMarts. |
|