v_FACT_MEMBERSHIPRENEWALRULES
Contains information about membership renewal rules.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPRENEWALRULESFACTID | int | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[MEMBERSHIPRENEWALRULESFACTID] | |
| MEMBERSHIPRENEWALRULESSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[MEMBERSHIPRENEWALRULESSYSTEMID] |
| MEMBERSHIPLEVELSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[MEMBERSHIPLEVELSYSTEMID] |
| BEFOREEXPIRATION | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[BEFOREEXPIRATION] |
| AFTEREXPIRATION | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[AFTEREXPIRATION] |
| RENEWALRULESTARTDATE | datetime | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[RENEWALRULESTARTDATE] |
| RENEWALRULEENDDATE | datetime | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[RENEWALRULEENDDATE] |
| BEFOREEXPIRATIONMEMBERSHIPSTATUSDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[BEFOREEXPIRATIONMEMBERSHIPSTATUSDIMID] |
| BEFOREEXPIRATIONMEMBERSHIPACTIONDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[BEFOREEXPIRATIONMEMBERSHIPACTIONDIMID] |
| AFTEREXPIRATIONMEMBERSHIPSTATUSDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[AFTEREXPIRATIONMEMBERSHIPSTATUSDIMID] |
| AFTEREXPIRATIONMEMBERSHIPACTIONDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[AFTEREXPIRATIONMEMBERSHIPACTIONDIMID] |
| INTERVALCODE1 | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVALCODE1] |
| INTERVAL1MEMBERSHIPSTATUSDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL1MEMBERSHIPSTATUSDIMID] |
| INTERVAL1MEMBERSHIPACTIONDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL1MEMBERSHIPACTIONDIMID] |
| INTERVALCODE2 | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVALCODE2] |
| INTERVAL2MEMBERSHIPSTATUSDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL2MEMBERSHIPSTATUSDIMID] |
| INTERVAL2MEMBERSHIPACTIONDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL2MEMBERSHIPACTIONDIMID] |
| INTERVALCODE3 | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVALCODE3] |
| INTERVAL3MEMBERSHIPSTATUSDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL3MEMBERSHIPSTATUSDIMID] |
| INTERVAL3MEMBERSHIPACTIONDIMID | int | yes | BBDW.[FACT_MEMBERSHIPRENEWALRULES].[INTERVAL3MEMBERSHIPACTIONDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_MEMBERSHIPRENEWALRULES] as
select
[MEMBERSHIPRENEWALRULESFACTID],
[MEMBERSHIPRENEWALRULESSYSTEMID],
[MEMBERSHIPLEVELSYSTEMID],
[BEFOREEXPIRATION],
[AFTEREXPIRATION],
[RENEWALRULESTARTDATE],
[RENEWALRULEENDDATE],
[BEFOREEXPIRATIONMEMBERSHIPSTATUSDIMID],
[BEFOREEXPIRATIONMEMBERSHIPACTIONDIMID],
[AFTEREXPIRATIONMEMBERSHIPSTATUSDIMID],
[AFTEREXPIRATIONMEMBERSHIPACTIONDIMID],
[INTERVALCODE1],
[INTERVAL1MEMBERSHIPSTATUSDIMID],
[INTERVAL1MEMBERSHIPACTIONDIMID],
[INTERVALCODE2],
[INTERVAL2MEMBERSHIPSTATUSDIMID],
[INTERVAL2MEMBERSHIPACTIONDIMID],
[INTERVALCODE3],
[INTERVAL3MEMBERSHIPSTATUSDIMID],
[INTERVAL3MEMBERSHIPACTIONDIMID]
from [BBDW].[FACT_MEMBERSHIPRENEWALRULES];