| MEMBERSHIPPROGRAMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[MEMBERSHIP].[MEMBERSHIPPROGRAMID] |
| MEMBERSHIPLEVELSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[MEMBERSHIP].[MEMBERSHIPLEVELID] |
| MEMBERSHIPTERMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[MEMBERSHIP].[MEMBERSHIPLEVELTERMID] |
| MEMBERSHIPTYPECODESYSTEMID |
uniqueidentifier |
yes |
|
dbo.[MEMBERSHIPLEVELTYPE].[LEVELTYPECODEID] |
| MEMBERSHIPPROGRAM |
nvarchar(100) |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[NAME] |
| MEMBERSHIPPROGRAMDESCRIPTION |
nvarchar(255) |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[DESCRIPTION] |
| MEMBERSHIPPROGRAMISACTIVE |
bit |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[ISACTIVE] |
| MEMBERSHIPLEVEL |
nvarchar(100) |
yes |
|
dbo.[MEMBERSHIPLEVEL].[NAME] |
| MEMBERSHIPLEVELDESCRIPTION |
nvarchar(255) |
yes |
|
dbo.[MEMBERSHIPLEVEL].[DESCRIPTION] |
| MEMBERSHIPLEVELSEQUENCE |
int |
yes |
|
dbo.[MEMBERSHIPLEVEL].[SEQUENCE] |
| MEMBERSHIPLEVELISACTIVE |
bit |
yes |
|
dbo.[MEMBERSHIPLEVEL].[ISACTIVE] |
| NUMBERMEMBERSALLOWED |
smallint |
yes |
|
dbo.[MEMBERSHIPLEVEL].[MEMBERSALLOWED] |
| NUMBERCHILDRENALLOWED |
smallint |
yes |
|
dbo.[MEMBERSHIPLEVEL].[CHILDRENALLOWED] |
| MEMBERSHIPTERMAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[ORGANIZATIONAMOUNT] |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[MEMBERSHIPLEVELTERM].[BASECURRENCYID] |
| BASEMEMBERSHIPTERMAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[AMOUNT] |
| MEMBERSHIPTYPE |
nvarchar(100) |
yes |
|
dbo.[MEMBERSHIPLEVELTYPECODE].[DESCRIPTION] |
| SITEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[MEMBERSHIPPROGRAM].[SITEID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| MEMBERSHIPREPORTINGGROUP |
nvarchar(100) |
yes |
|
dbo.[TIERCODE].[DESCRIPTION] |
| MEMBERSHIPREPORTINGGROUPISACTIVE |
bit |
yes |
|
dbo.[TIERCODE].[ACTIVE] |
| MEMBERSHIPPROGRAMTYPECODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[PROGRAMTYPECODE] |
| MEMBERSHIPPROGRAMTYPE |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[PROGRAMTYPE] |
| MEMBERSHIPPROGRAMBASEDONCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[PROGRAMBASEDONCODE] |
| MEMBERSHIPPROGRAMBASEDON |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[PROGRAMBASEDON] |
| MEMBERSHIPPROGRAMCATEGORYCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[CATEGORYCODE] |
| MEMBERSHIPPROGRAMCATEGORY |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPPROGRAM].[CATEGORY] |
| ANNUALTERMTIMELENGTH |
smallint |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[TERMTIMELENGTH] |
| ANNUALTERMLENGTHCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[TERMLENGTHCODE] |
| ANNUALTERMLENGTH |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[TERMLENGTH] |
| ANNUALLOWPRICEAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[ORGANIZATIONLOWAMOUNT] |
| BASEANNUALLOWPRICEAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[LOWAMOUNT] |
| RECURRINGPAYMENTOPTIONCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[RECURRINGPAYMENTOPTIONCODE] |
| RECURRINGPAYMENTOPTION |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[RECURRINGPAYMENTOPTION] |
| LIFETIMEPAYMENTOPTIONCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[LIFETIMEPAYMENTOPTIONCODE] |
| LIFETIMEPAYMENTOPTION |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[LIFETIMEPAYMENTOPTION] |
| LIFETIMENUMBEROFPAYMENTS |
smallint |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[LIFETIMENUMBEROFPAYMENTS] |
| LIFETIMEHIGHPRICEAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[ORGANIZATIONLOWAMOUNT] |
| BASELIFETIMEHIGHPRICEAMOUNT |
money |
yes |
|
dbo.[MEMBERSHIPLEVELTERM].[LOWAMOUNT] |
| MEMBERSHIPLEVELOBTAINEDBYCODE |
tinyint |
yes |
|
dbo.[MEMBERSHIPLEVEL].[OBTAINLEVELCODE] |
| MEMBERSHIPLEVELOBTAINEDBY |
nvarchar(50) |
yes |
|
dbo.[MEMBERSHIPLEVEL].[OBTAINLEVEL] |
| SITESYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MEMBERSHIPPROGRAM].[SITEID] |