DIM_LETTER_STAGE
Staging table for the letter dimension
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| LETTERSYSTEMID | uniqueidentifier | yes | dbo.[LETTERCODE].[ID] | |
| LETTER | nvarchar(100) | yes | dbo.[LETTERCODE].[NAME] | |
| LETTERDESCRIPTION | nvarchar(255) | yes | dbo.[LETTERCODE].[DESCRIPTION] | |
| INCLUDESRECEIPT | bit | yes | dbo.[LETTERCODE].[INCLUDESRECEIPT] | |
| SITEDIMID | int | yes | Reference key to the Site dimension, derived from dbo.[LETTERCODE].[SITEID] | |
| SITESYSTEMID | uniqueidentifier | yes | dbo.[LETTERCODE].[SITEID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| SOURCEDIMID | int | yes | Source system used. |