DIM_SITE_STAGE
Intermediate storage table for sites
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SITESYSTEMID | uniqueidentifier | yes | [dbo].[SITE].[ID] | |
| SITENAME | nvarchar(250) | yes | [dbo].[SITE].[NAME] | |
| SITEDESCRIPTION | nvarchar(500) | yes | [dbo].[SITE].[DESCRIPTION] | |
| HIERARCHYPATH_TEXT | nvarchar(500) | yes | [dbo].[SITE].[HIERARCHYPATH] converted to nvarchar(500) | |
| SHORTNAME | nvarchar(100) | yes | [dbo].[SITE].[SHORTNAME] | |
| ACRONYM | nvarchar(100) | yes | [dbo].[SITE].[ACRONYM] | |
| SITEID | nvarchar(100) | yes | [dbo].[SITE].[SITEID] | |
| SITETYPE | nvarchar(100) | yes | [dbo].[SITETYPECODE].[DESCRIPTION] | |
| 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. |