| TTExternalOperatorPaymentModelID |
primary key |
| TTExternalOperatorFrameContractID |
a connection to frame contract |
| TTExternalOperatorContractStatusID |
a connection to contract status |
| TTExternalOperatorBillingStartTypeID |
a connection to billing start type |
| PaymentmodelName |
Name of the bonusmodel |
| SpiltOnParticipant |
Spilt on or not the number of participants (1 = Yes, 0 = No) If Yes hen LimitNumber has to be filled |
| SpiltOnParticpantLimit |
Cutoff number of persons that divides the standard prize into two groups |
| SpiltOnTargetGroup |
If the payment model if split on different price on target groups or not 0 = not spilt (one price), 1 = split |
| ResultBonusExist |
If a resultbonus exists 1 = Yes, 0 = No |
| AdditionalBonusExist |
If a additional bonus exists 1 = Yes, 0 = No |
| DependingOnDuration |
If the bonus depends of the planed duration 1 = Yes, 0 = No If the bonis is dependen on planed duration then attribute DependingOnDurationPeriodType is mandatory |
| DependingOnDurationPeriodUnitType |
can have NULL value |
| StartDate |
First valid date |
| EndDate |
last valid date |
| TimeStamp |
Created timestamp |
| TTExternalOperatorEffortID |
FK toTTExternalOperatorEffort |