v_DIM_MEMBERSHIPPROGRAM
The membership program dimension contains information about membership programs.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPPROGRAMDIMID | int | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMDIMID] | |
| MEMBERSHIPPROGRAMSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMSYSTEMID] |
| MEMBERSHIPLEVELSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELSYSTEMID] |
| MEMBERSHIPTERMSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPTERMSYSTEMID] |
| MEMBERSHIPTYPECODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPTYPECODESYSTEMID] |
| MEMBERSHIPPROGRAM | nvarchar(100) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAM] |
| MEMBERSHIPPROGRAMDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMDESCRIPTION] |
| MEMBERSHIPPROGRAMISACTIVE | bit | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMISACTIVE] |
| MEMBERSHIPPROGRAMTYPECODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMTYPECODE] |
| MEMBERSHIPPROGRAMTYPE | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMTYPE] |
| MEMBERSHIPPROGRAMBASEDONCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMBASEDONCODE] |
| MEMBERSHIPPROGRAMBASEDON | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMBASEDON] |
| MEMBERSHIPPROGRAMCATEGORYCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMCATEGORYCODE] |
| MEMBERSHIPPROGRAMCATEGORY | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPPROGRAMCATEGORY] |
| MEMBERSHIPLEVEL | nvarchar(100) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVEL] |
| MEMBERSHIPLEVELDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELDESCRIPTION] |
| MEMBERSHIPLEVELSEQUENCE | int | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELSEQUENCE] |
| MEMBERSHIPLEVELOBTAINEDBYCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELOBTAINEDBYCODE] |
| MEMBERSHIPLEVELOBTAINEDBY | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELOBTAINEDBY] |
| MEMBERSHIPLEVELISACTIVE | bit | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPLEVELISACTIVE] |
| MEMBERSHIPREPORTINGGROUP | nvarchar(100) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPREPORTINGGROUP] |
| MEMBERSHIPREPORTINGGROUPISACTIVE | bit | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPREPORTINGGROUPISACTIVE] |
| NUMBERMEMBERSALLOWED | smallint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[NUMBERMEMBERSALLOWED] |
| NUMBERCHILDRENALLOWED | smallint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[NUMBERCHILDRENALLOWED] |
| MEMBERSHIPTERMAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPTERMAMOUNT] |
| BASEMEMBERSHIPTERMAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[BASEMEMBERSHIPTERMAMOUNT] |
| ANNUALTERMTIMELENGTH | smallint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[ANNUALTERMTIMELENGTH] |
| ANNUALTERMLENGTHCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[ANNUALTERMLENGTHCODE] |
| ANNUALTERMLENGTH | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[ANNUALTERMLENGTH] |
| ANNUALLOWPRICEAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[ANNUALLOWPRICEAMOUNT] |
| BASEANNUALLOWPRICEAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[BASEANNUALLOWPRICEAMOUNT] |
| RECURRINGPAYMENTOPTIONCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[RECURRINGPAYMENTOPTIONCODE] |
| RECURRINGPAYMENTOPTION | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[RECURRINGPAYMENTOPTION] |
| LIFETIMEPAYMENTOPTIONCODE | tinyint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[LIFETIMEPAYMENTOPTIONCODE] |
| LIFETIMEPAYMENTOPTION | nvarchar(50) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[LIFETIMEPAYMENTOPTION] |
| LIFETIMENUMBEROFPAYMENTS | smallint | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[LIFETIMENUMBEROFPAYMENTS] |
| LIFETIMEHIGHPRICEAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[LIFETIMEHIGHPRICEAMOUNT] |
| BASELIFETIMEHIGHPRICEAMOUNT | money | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[BASELIFETIMEHIGHPRICEAMOUNT] |
| MEMBERSHIPTYPE | nvarchar(100) | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[MEMBERSHIPTYPE] |
| BASECURRENCYDIMID | int | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[BASECURRENCYDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MEMBERSHIPPROGRAM].[SITESYSTEMID] |
Definition
Copy
CREATE view [BBDW].[v_DIM_MEMBERSHIPPROGRAM] as
select
[MEMBERSHIPPROGRAMDIMID],
[MEMBERSHIPPROGRAMSYSTEMID],
[MEMBERSHIPLEVELSYSTEMID],
[MEMBERSHIPTERMSYSTEMID],
[MEMBERSHIPTYPECODESYSTEMID],
[MEMBERSHIPPROGRAM],
[MEMBERSHIPPROGRAMDESCRIPTION],
[MEMBERSHIPPROGRAMISACTIVE],
[MEMBERSHIPPROGRAMTYPECODE],
[MEMBERSHIPPROGRAMTYPE],
[MEMBERSHIPPROGRAMBASEDONCODE],
[MEMBERSHIPPROGRAMBASEDON],
[MEMBERSHIPPROGRAMCATEGORYCODE],
[MEMBERSHIPPROGRAMCATEGORY],
[MEMBERSHIPLEVEL],
[MEMBERSHIPLEVELDESCRIPTION],
[MEMBERSHIPLEVELSEQUENCE],
[MEMBERSHIPLEVELOBTAINEDBYCODE],
[MEMBERSHIPLEVELOBTAINEDBY],
[MEMBERSHIPLEVELISACTIVE],
[MEMBERSHIPREPORTINGGROUP],
[MEMBERSHIPREPORTINGGROUPISACTIVE],
[NUMBERMEMBERSALLOWED],
[NUMBERCHILDRENALLOWED],
[MEMBERSHIPTERMAMOUNT],
[BASEMEMBERSHIPTERMAMOUNT],
[ANNUALTERMTIMELENGTH],
[ANNUALTERMLENGTHCODE],
[ANNUALTERMLENGTH],
[ANNUALLOWPRICEAMOUNT],
[BASEANNUALLOWPRICEAMOUNT],
[RECURRINGPAYMENTOPTIONCODE],
[RECURRINGPAYMENTOPTION],
[LIFETIMEPAYMENTOPTIONCODE],
[LIFETIMEPAYMENTOPTION],
[LIFETIMENUMBEROFPAYMENTS],
[LIFETIMEHIGHPRICEAMOUNT],
[BASELIFETIMEHIGHPRICEAMOUNT],
[MEMBERSHIPTYPE],
[BASECURRENCYDIMID],
[SITESYSTEMID]
from
BBDW.[DIM_MEMBERSHIPPROGRAM]