FACT_FINANCIALTRANSACTIONLINEITEMSITE_STAGE
Intermediate storage table for FACT_FINANCIALTRANSACTIONLINEITEMSITE
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SITEDIMID | int | yes | Reference key to the site dimension, derived from [dbo].[SITE].[ID] | |
| SITESYSTEMID | uniqueidentifier | yes | [dbo].[SITE].[ID] | |
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | uniqueidentifier | yes | [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SITESOURCESYSTEMID | uniqueidentifier | yes | Reference to the source record that contains the site information. | |
| SOURCEDIMID | int | yes | Source system used. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. |