BILL_FREQA=Annually
B=Bi-Weekly
M=Monthly
Q=Quarterly
S=Semi-Monthly
W=Weekly
Default Value: M
BEN_BI_PARMS(SQL Table) |
Index Back |
|---|---|
Overall Billing ParametersBEN_BI_PARMS holds the high level information for the billing system. It is the "Installation" table for billing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BILL_FREQ |
Character(1) | VARCHAR2(1) NOT NULL |
Billing Frequency
A=Annually B=Bi-Weekly M=Monthly Q=Quarterly S=Semi-Monthly W=Weekly Default Value: M |
| 2 | BILL_DAYS_DUE | Signed Number(3,0) | DECIMAL(2) NOT NULL | Days Due |
| 3 | CBR_DAYS_DUE | Signed Number(3,0) | DECIMAL(2) NOT NULL | COBRA Days Due |
| 4 | BILL_DAYS_OVERDUE | Signed Number(3,0) | DECIMAL(2) NOT NULL | Days to Overdue |
| 5 | CBR_DAYS_OVERDUE | Signed Number(3,0) | DECIMAL(2) NOT NULL | Days to Overdue |