| MEMBERSHIPTRANSACTIONSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[ID] |
| MEMBERSHIPDIMID |
int |
yes |
|
Reference key to the membership dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPID] |
| MEMBERSHIPSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPID] |
| MEMBERSHIPSTATUSDIMID |
int |
yes |
|
[BBDW].[DIM_MEMBERSHIP].[MEMBERSHIPSTATUSDIMID] |
| MEMBERSHIPPROGRAMDIMID |
int |
yes |
|
Reference key to the membership program dimension, derived using [dbo].[MEMBERSHIPLEVEL].[MEMBERSHIPPROGRAMID], [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELID] ,[dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTERMID] , and [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTYPECODEID] |
| MEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[ACTIONCODE] |
| MEMBERSHIPTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE] |
| MEMBERSHIPTRANSACTIONDATE |
datetime |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE] |
| MEMBERSHIPEXPIRATIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[EXPIRATIONDATE] |
| MEMBERSHIPEXPIRATIONDATE |
datetime |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[EXPIRATIONDATE] |
| NEXTMEMBERSHIPTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE] for next transaction for the membership |
| NEXTMEMBERSHIPTRANSACTIONDATE |
datetime |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE] for the next transaction for the membership |
| REVENUEFACTID |
int |
yes |
|
Reference key to the revenue fact, derived using [dbo].[MEMBERSHIPTRANSACTION].[REVENUESPLITID] |
| ISGIFTMEMBERSHIP |
bit |
yes |
|
[dbo].[MEMBERSHIPTRANSACTION].[ISGIFT] |
| GIVENBYCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[DONORID] |
| PREVIOUSMEMBERSHIPPROGRAMDIMID |
int |
yes |
|
Reference key to the membership program dimension, derived using [dbo].[MEMBERSHIPLEVEL].[MEMBERSHIPPROGRAMID], [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELID] ,[dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTERMID] , and [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTYPECODEID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| GIVENBYCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[MEMBERSHIP].[GIVENBYID] |
| FINANCIALTRANSACTIONFACTID |
int |
yes |
|
Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID] |
| FINANCIALTRANSACTIONLINEITEMFACTID |
int |
yes |
|
Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID] |