v_FACT_CONSTITUENTSECURITYGROUPASSIGNMENT
Contains information about constituent security group assignments
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTSECURITYGROUPASSIGNMENTFACTID | int | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTSECURITYGROUPASSIGNMENTFACTID] | |
| CONSTITUENTSECURITYGROUPASSIGNMENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTSECURITYGROUPASSIGNMENTSYSTEMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID] |
| CONSTITUENTSECURITYGROUPSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTSECURITYGROUPSYSTEMID] |
| CONSTITUENTSECURITYGROUPDIMID | int | yes | BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTSECURITYGROUPDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTSECURITYGROUPASSIGNMENT] as
select
[CONSTITUENTSECURITYGROUPASSIGNMENTFACTID],
[CONSTITUENTSECURITYGROUPASSIGNMENTSYSTEMID],
[CONSTITUENTSYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSECURITYGROUPSYSTEMID],
[CONSTITUENTSECURITYGROUPDIMID]
from [BBDW].[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT];