Home > Technical > Table Definitions > REWARD

REWARD

Lists the various rewards available to members.

Column Type Description

LINTCODE

INT(4)

A unique number assigned by the system.

STRDESCRIPTION

VARCHAR(50)

A description about the reward.

STRPRIZE

VARCHAR(30)

A description about the prize.

DTMPROBABILITY

DECIMAL9(19,4)

For prizes which are to be assigned randomly, this is the probability that a member has won a reward.

LINTPOINTS

INT(4)

The number of points given to the user as part of this reward.

LINTMEDIACLIP

INT(4)

A media clip can be assigned to a reward. If the reward is won when the user card swipes a boothplayer, the media clip will be played.

link.gif (858 bytes) MEDIACLP.ctrCode

YSNBIRTHDAY

VARCHAR(1)

‘T’ if the reward is to be won when it is a member’s birthday.

YSNENTRY

VARCHAR(1)

‘T’ if a reward is to be won when the user card swipes a boothplayer.

INTPRIORITY

INT(4)

When a reward is to be ‘won’, the system looks through the list of available rewards. The priority allows you to control the order in which rewards will be checked.

LINTITEMNUMBER

INT(4)

The item won as part of the reward. If no item is used for the price, this will be zero.

link.gif (858 bytes) ITEM.lintItemNumber

YSNNEW

VARCHAR(1)

‘T’ if a new reward.

YSNCHANGED

VARCHAR(1)

‘T’ if a changed reward.

INTREDEEMPOINTS

INT(4)

The number of points to be redeemed to win this prize.

DTMVALIDFROM

DATETIME(8)

The reward can only be given after this date (inclusive).

DTMVALIDTO

DATETIME(8)

The reward can only be given before this date (inclusive).

DTMVALIDFROMTIME

DATETIME(8)

The reward can only be given after this time.

DTMVALIDTOTIME

DATETIME(8)

The reward can only be given before this time.

YSNSUNDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Sunday, 'F' otherwise.

YSNMONDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Monday, 'F' otherwise.

YSNTUESDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Tuesday, 'F' otherwise.

YSNWEDNESDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Wednesday, 'F' otherwise.

YSNTHURSDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Thursday, 'F' otherwise.

YSNFRIDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Friday, 'F' otherwise.

YSNSATURDAY

VARCHAR(1)

If 'T' then the extra points can be given on a Saturday, 'F' otherwise.

YSNMULTIPLESALLOWED

VARCHAR(1)

'T' indicates the reward can only be won once by each customer, otherwise 'F'.

YSNPRINTREWARD

VARCHAR(1)

'T' indicates the reward should be printed. This will produce a text file which can be used by DynaPOSPrinter.exe.

DBLINCREASEPROB

DECIMAL9(19,4)

Not currently used. Set to 0.

INTINCREASEPROBDAYS

INT(4)

Not currently used. Set to 0.

STRCATEGORY1

VARCHAR(10)

Only customers with this category will get this reward. If empty then no check is done.

STRCATEGORY2

VARCHAR(10)

Only customers with this category will get this reward. If empty then no check is done.

STRCATEGORY3

VARCHAR(10)

Only customers with this category will get this reward. If empty then no check is done.

STRCATEGORY4

VARCHAR(10)

Only customers with this category will get this reward. If empty then no check is done.

STRCATEGORY5

VARCHAR(10)

Only customers with this category will get this reward. If empty then no check is done.

 

Primary Key: LINTCODE

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