Name |
|
Comment |
The Billing Provisional Directions Payment Amount for Directed/Affected/Eligible participants |
Name |
BILLRUNNO |
COMPENSATION_TYPE |
CONTRACTYEAR |
DIRECTION_ID |
PARTICIPANTID |
WEEKNO |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
COMPENSATION_TYPE |
VARCHAR2(40) |
X |
The Direction Payment Type, Directed_Comp, Affected_Comp, Eligible_Comp |
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
The Direction Payment Amount |
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
|
|