Table: BILLING_WDR

BILLING_WDR

Name

BILLING_WDR

Comment

Billing WDR Transaction Weekly Summary


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Contract year of the Billing run

WEEKNO

NUMBER(3,0)

X

Week number of the Billing run

BILLRUNNO

NUMBER(3,0)

X

Billing run number identifier

PARTICIPANTID

VARCHAR2(20)

X

DRSP or FRMP Participant Identifier

WDR_CREDIT_AMOUNT

NUMBER(18,8)

 

WDR credit transaction amount

WDR_DEBIT_AMOUNT

NUMBER(18,8)

 

WDR debit transaction amount