v_DIM_MEMBERSHIP
The membership dimension contains information about memberships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPDIMID | int | BBDW.[DIM_MEMBERSHIP].[MEMBERSHIPDIMID] | |
| MEMBERSHIPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIP].[MEMBERSHIPSYSTEMID] |
| MEMBERSHIPLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_MEMBERSHIP].[MEMBERSHIPLOOKUPID] |
| MEMBERSHIPPROGRAMDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[MEMBERSHIPPROGRAMDIMID] |
| MEMBERSHIPSTATUSDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[MEMBERSHIPSTATUSDIMID] |
| JOINDATEDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[JOINDATEDIMID] |
| JOINDATE | datetime | yes | BBDW.[DIM_MEMBERSHIP].[JOINDATE] |
| EXPIRATIONDATEDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[EXPIRATIONDATEDIMID] |
| EXPIRATIONDATE | datetime | yes | BBDW.[DIM_MEMBERSHIP].[EXPIRATIONDATE] |
| LASTRENEWEDONDATEDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[LASTRENEWEDONDATEDIMID] |
| LASTRENEWEDONDATE | datetime | yes | BBDW.[DIM_MEMBERSHIP].[LASTRENEWEDONDATE] |
| ISGIFTMEMBERSHIP | bit | yes | BBDW.[DIM_MEMBERSHIP].[ISGIFTMEMBERSHIP] |
| GIVENBYCONSTITUENTDIMID | int | yes | BBDW.[DIM_MEMBERSHIP].[GIVENBYCONSTITUENTDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_MEMBERSHIP] as
select
[MEMBERSHIPDIMID],
[MEMBERSHIPSYSTEMID],
[MEMBERSHIPLOOKUPID],
[MEMBERSHIPPROGRAMDIMID],
[MEMBERSHIPSTATUSDIMID],
[JOINDATEDIMID],
[JOINDATE],
[EXPIRATIONDATEDIMID],
[EXPIRATIONDATE],
[LASTRENEWEDONDATEDIMID],
[LASTRENEWEDONDATE],
[ISGIFTMEMBERSHIP],
[GIVENBYCONSTITUENTDIMID]
from
BBDW.[DIM_MEMBERSHIP]