v_DIM_MEMBERSHIPSTATUS
The membership status dimension contains information about the status of a membership.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPSTATUSDIMID | int | BBDW.[DIM_MEMBERSHIPSTATUS].[MEMBERSHIPSTATUSDIMID] | |
| MEMBERSHIPSTATUSCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPSTATUS].[MEMBERSHIPSTATUSCODE] |
| MEMBERSHIPSTATUS | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPSTATUS].[MEMBERSHIPSTATUS] |
Definition
Copy
create view [BBDW].[v_DIM_MEMBERSHIPSTATUS] as
select
[MEMBERSHIPSTATUSDIMID],
[MEMBERSHIPSTATUSCODE],
[MEMBERSHIPSTATUS]
from
BBDW.[DIM_MEMBERSHIPSTATUS]