| MEMBERSHIPRENEWALRULESSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[ID] |
| MEMBERSHIPLEVELSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[MEMBERSHIPLEVELID] |
| BEFOREEXPIRATION |
int |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[BEFOREEXPIRATION] |
| AFTEREXPIRATION |
int |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[AFTEREXPIRATION] |
| RENEWALRULESTARTDATE |
datetime |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[STARTDATE] |
| RENEWALRULEENDDATE |
datetime |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWALRULES].[ENDDATE] |
| 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. |
| BEFOREEXPIRATIONMEMBERSHIPSTATUSDIMID |
int |
yes |
|
Reference key to the membership status dimension, derived using the membership status code of 99. |
| BEFOREEXPIRATIONMEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using the membership action code of 99. |
| AFTEREXPIRATIONMEMBERSHIPSTATUSDIMID |
int |
yes |
|
Reference key to the membership status dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[NONRENEWALACTIONTYPECODE] |
| AFTEREXPIRATIONMEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[NONRENEWALACTIONTYPECODE] |
| INTERVALCODE1 |
int |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWAL].[INTERVALCODE] |
| INTERVAL1MEMBERSHIPSTATUSDIMID |
int |
yes |
|
Reference key to the membership status dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] |
| INTERVAL1MEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] + 100 |
| INTERVALCODE2 |
int |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWAL].[INTERVALCODE] |
| INTERVAL2MEMBERSHIPSTATUSDIMID |
int |
yes |
|
Reference key to the membership status dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] |
| INTERVAL2MEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] + 100 |
| INTERVALCODE3 |
int |
yes |
|
[dbo].[MEMBERSHIPLEVELRENEWAL].[INTERVALCODE] |
| INTERVAL3MEMBERSHIPSTATUSDIMID |
int |
yes |
|
Reference key to the membership status dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] |
| INTERVAL3MEMBERSHIPACTIONDIMID |
int |
yes |
|
Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPLEVELRENEWALRULES].[STATUSCODE] + 100 |