|
Name |
|
|
Comment |
BILLINGRUNTRK identifies the Statement type (i.e. Status of PRELIM, FINAL, REVISE) and date of the BillRunNo posted, per WeekNo. This provides a further extension of tracking data from the BILLINGDAYTRK table. |
|
BILLINGRUNTRK is public data, and is available to all participants. Source BILLINGRUNTRK is populated by the posting of a billing run. Volume An indicative maximum is one record inserted per billing run, or 11 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Year of the run |
|
WEEKNO |
NUMBER(3,0) |
X |
Week number of the run |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Sequential run number |
|
STATUS |
VARCHAR2(6) |
|
The billing run type, PRELIM, FINAL, REVISE or INTERIM |
|
ADJ_CLEARED |
VARCHAR2(1) |
|
Flag |
|
AUTHORISEDDATE |
DATE |
|
null, since not used |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
null, since not used |
|
POSTDATE |
DATE |
|
When the results were posted |
|
POSTBY |
VARCHAR2(10) |
|
Who posted the results |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
RECEIPTPOSTDATE |
DATE |
|
null, since not used |
|
RECEIPTPOSTBY |
VARCHAR2(10) |
|
null, since not used |
|
PAYMENTPOSTDATE |
DATE |
|
When the payment was posted |
|
PAYMENTPOSTBY |
VARCHAR2(10) |
|
Who posted the payment |
|
SHORTFALL |
NUMBER(16,6) |
|
Payment shortfall amount |
|
MAKEUP |
NUMBER(15,5) |
|
Not Used |
|
|
|