FACT_MEMBERSHIPRENEWALRULES_STAGE

Intermediate storage table for membership renewal rules.

Fields

Field	Field Type	Null	Notes	Description
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.
SEQUENCE	int	yes		Sequence of membership renewal rules partitioned by membership level and start date and ordered by date added.
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