DIM_IDSETREGISTER
Contains information about selections.
Primary Key
| Primary Key | Field Type |
|---|---|
| IDSETREGISTERDIMID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| IDSETREGISTERSYSTEMID | uniqueidentifier | yes | [dbo].[IDSETREGISTER].[ID] | |
| IDSETREGISTERNAME | nvarchar(300) | yes | [dbo].[IDSETREGISTER].[NAME] | |
| IDSETREGISTERDESCRIPTION | nvarchar(1024) | yes | [dbo].[IDSETREGISTER].[DESCRIPTION] | |
| RECORDTYPESYSTEMID | uniqueidentifier | yes | [dbo].[IDSETREGISTER].[RECORDTYPEID] | |
| RECORDTYPE | nvarchar(50) | yes | [dbo].[RECORDTYPE].[NAME] | |
| DBOBJECTNAME | nvarchar(128) | yes | [dbo].[IDSETREGISTER].[DBOBJECTNAME] | |
| DBOBJECTNAMEWITHASOFDATE | nvarchar(255) | yes | dbo.[IDSETREGISTER].[DBOBJECTNAMEWITHASOFDATE] | |
| DBTABLENAME | nvarchar(128) | yes | If the selection is static and the object type is 1 then [dbo].[UFN_ADHOCQUERY_MAKEIDSETSTATICTABLENAME](aq.[ID]), if the selection is static and the object type is 0 then [dbo].[IDSETREGISTER].[DBOBJECTNAME] | |
| PRIMARYKEYTYPENAME | nvarchar(128) | yes | [dbo].[QUERYVIEWCATALOG].[PRIMARYKEYTYPENAME] | |
| OBJECTTYPE | tinyint | yes | [dbo].[IDSETREGISTER].[OBJECTTYPE] | |
| ISSTATIC | bit | yes | dbo.[IDSETREGISTER].[STATIC] | |
| NUMROWS | int | yes | dbo.[IDSETREGISTER].[NUMROWS] | |
| USEINQUERYDESIGNER | bit | yes | [dbo].[IDSETREGISTER].[USEINQUERYDESIGNER] | |
| SITEDIMID | int | yes | Reference key to the site dimension, derived from [dbo].[IDSETREGISTER].[SITEID] | |
| SITESYSTEMID | uniqueidentifier | yes | [dbo].[IDSETREGISTER].[SITEID] | |
| GROUPNAME | nvarchar(200) | yes | [dbo].[IDSETREGISTER].[GROUPNAME] | |
| ISACTIVE | bit | yes | [dbo].[IDSETREGISTER].[ACTIVE] | |
| CATEGORY | nvarchar(1024) | yes | [dbo].[dbo.[IMPORTSELECTIONPROCESS].[DESCRIPTION] or [QUERYCATEGORYCODE].[DESCRIPTION] | |
| CURRENTASOFDATEDIMID | int | yes | Reference key to the date dimension, derived from [dbo].[IDSETREGISTER].[DATECHANGED] | |
| CURRENTASOFDATE | datetime | yes | [dbo].[IDSETREGISTER].[DATECHANGED] | |
| POPULATE | bit | yes | Flag indicating if the ETL needs to populate the selection. | |
| 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. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_DIM_IDSETREGISTER_CURRENTASOFDATEDIMID | CURRENTASOFDATEDIMID | |||
| IX_DIM_IDSETREGISTER_IDSETREGISTERSYSTEMID | IDSETREGISTERSYSTEMID | |||
| IX_DIM_IDSETREGISTER_SITEDIMID | SITEDIMID | |||
| IX_DIM_IDSETREGISTER_SOURCEDIMID | SOURCEDIMID | |||
| PK_DIM_IDSETREGISTER | IDSETREGISTERDIMID | yes | yes | yes |