Home > Technical > Table Definitions > MEMBERUPGRADE

MEMBERUPGRADE

This contains the rules to determine how to upgrade/downgrade a member.

Column Type Description
STRGUID VARCHAR(38) A unique code assigned by the system.
STRMEMBERTYPE VARCHAR(10) The type of customer to which this rule belong.
INTTYPE INT The type of check being performed.
1   Specific Points Level   The activity value is taken from the current account balance. This is compared to DBLTHRESHOLD.

2

Points Earnt Over x Days 

The activity value is calculated based on INTDAYS and compred to DBLTHRESHOLD.

3

Points To Date

The activity value is the number of points earned since the last time the member was upgrade, downgraded or retained.

DBLTHRESHOLD DECIMAL(19,4) The limit to which the calculated activity value is compared. If the value >= this amount, the rule can pass.
INTDAYS INT The number of days activity to be checked.

STRNEWMEMBERTYPE

VARCHAR(10)

The customer type the member will be changed to if this rule passes.

STRGROUP

VARCHAR

 

INTCARDADDMONTHS

INT

 

STRREFERENCE

VARCHAR(10)

A user reference for the rule. Info purposes only.

INTUPGRADETYPE

INTEGER

Indicates the purpose of the rule. Is it used to upgrade or downgrade? For info purposes only. Doesn't effect actual processing.

0=Upgrade

1=Downgrade

2=Retain (keep current level).

YSNENDOFMONTH

VARCHAR(1)

If 'T' then any new expiry date will be calculated as of the end of the month.

INTWHENTYPE

INTEGER

Indicates if the rule is applied at any time (usually when doing upgraded) or when the card is expired (for downgrades or retaining current level).

0=Anytime

1=Card Expired

 

Primary Key: STRGUID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)