v_DIM_IDSETREGISTER
Contains information about selections.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| IDSETREGISTERDIMID | int | BBDW.[DIM_IDSETREGISTER].[IDSETREGISTERDIMID] | |
| IDSETREGISTERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_IDSETREGISTER].[IDSETREGISTERSYSTEMID] |
| IDSETREGISTERNAME | nvarchar(300) | yes | BBDW.[DIM_IDSETREGISTER].[IDSETREGISTERNAME] |
| IDSETREGISTERDESCRIPTION | nvarchar(1024) | yes | BBDW.[DIM_IDSETREGISTER].[IDSETREGISTERDESCRIPTION] |
| RECORDTYPESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_IDSETREGISTER].[RECORDTYPESYSTEMID] |
| RECORDTYPE | nvarchar(50) | yes | BBDW.[DIM_IDSETREGISTER].[RECORDTYPE] |
| DBOBJECTNAME | nvarchar(128) | yes | BBDW.[DIM_IDSETREGISTER].[DBOBJECTNAME] |
| DBOBJECTNAMEWITHASOFDATE | nvarchar(255) | yes | BBDW.[DIM_IDSETREGISTER].[DBOBJECTNAMEWITHASOFDATE] |
| DBTABLENAME | nvarchar(128) | yes | BBDW.[DIM_IDSETREGISTER].[DBTABLENAME] |
| PRIMARYKEYTYPENAME | nvarchar(128) | yes | BBDW.[DIM_IDSETREGISTER].[PRIMARYKEYTYPENAME] |
| OBJECTTYPE | tinyint | yes | BBDW.[DIM_IDSETREGISTER].[OBJECTTYPE] |
| ISSTATIC | bit | yes | BBDW.[DIM_IDSETREGISTER].[ISSTATIC] |
| NUMROWS | int | yes | BBDW.[DIM_IDSETREGISTER].[NUMROWS] |
| USEINQUERYDESIGNER | bit | yes | BBDW.[DIM_IDSETREGISTER].[USEINQUERYDESIGNER] |
| SITEDIMID | int | yes | BBDW.[DIM_IDSETREGISTER].[SITEDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_IDSETREGISTER].[SITESYSTEMID] |
| GROUPNAME | nvarchar(200) | yes | BBDW.[DIM_IDSETREGISTER].[GROUPNAME] |
| ISACTIVE | bit | yes | BBDW.[DIM_IDSETREGISTER].[ISACTIVE] |
| CATEGORY | nvarchar(1024) | yes | BBDW.[DIM_IDSETREGISTER].[CATEGORY] |
| CURRENTASOFDATEDIMID | int | yes | BBDW.[DIM_IDSETREGISTER].[CURRENTASOFDATEDIMID] |
| CURRENTASOFDATE | datetime | yes | BBDW.[DIM_IDSETREGISTER].[CURRENTASOFDATE] |
Definition
Copy
create view [BBDW].[v_DIM_IDSETREGISTER] as
select
i.[IDSETREGISTERDIMID],
i.[IDSETREGISTERSYSTEMID],
i.[IDSETREGISTERNAME],
i.[IDSETREGISTERDESCRIPTION],
i.[RECORDTYPESYSTEMID],
i.[RECORDTYPE],
i.[DBOBJECTNAME],
i.[DBOBJECTNAMEWITHASOFDATE],
i.[DBTABLENAME],
i.[PRIMARYKEYTYPENAME],
i.[OBJECTTYPE],
i.[ISSTATIC],
i.[NUMROWS],
i.[USEINQUERYDESIGNER],
i.[SITEDIMID],
i.[SITESYSTEMID],
i.[GROUPNAME],
i.[ISACTIVE],
i.[CATEGORY],
i.[CURRENTASOFDATEDIMID],
i.[CURRENTASOFDATE]
from BBDW.[DIM_IDSETREGISTER] i