BEN_BI_PYMNT_VW(SQL View) |
Index Back |
|---|---|
Bill Payment ViewBEN_BI_PYMNT_VW shows unpaid charges. It is used on the payment entry panel so that only open charges are shown. |
| SELECT EMPLID ,BILL_PER_CD ,PLAN_TYPE ,BILL_CHARGE_ID ,EMPL_RCD ,COBRA_EVENT_ID ,BENEFIT_PROGRAM ,BENEFIT_PLAN ,COVRG_CD ,DEDCD ,BILLING_REASON ,CHARGE ,CHRG_ADJUST ,TOTAL_CHARGE ,DATE_DUE ,DATE_OVERDUE ,BILL_PROCESS_DT ,AMOUNT_PAID ,PMT_ADJUST ,PRINT_PERIOD ,BILL_SOURCE ,AMOUNT_DUE ,DED_SLSTX_CLASS FROM PS_BEN_BI_CHG_VW WHERE AMOUNT_DUE <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BILL_PER_CD |
Character(4) | VARCHAR2(4) NOT NULL | Billing Period |
| 3 | PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 4 | BILL_CHARGE_ID |
Number(7,0) | INTEGER NOT NULL | Billing Charge ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | COBRA_EVENT_ID | Number(3,0) | SMALLINT NOT NULL | Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated. |
| 7 | BENEFIT_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Defines a collection of benefit plans and their associated rate and calculation rules. |
| 8 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 9 | COVRG_CD | Character(2) | VARCHAR2(2) NOT NULL | Coverage Code |
| 10 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 11 | BILLING_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Billing Reason
A=Arrears B=Benefits Administration C=COBRA M=Manual Entry |
| 12 | CHARGE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Original Charge |
| 13 | CHRG_ADJUST | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Charge Adjustments |
| 14 | TOTAL_CHARGE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Total Charge |
| 15 | DATE_DUE | Date(10) | DATE NOT NULL | Date Due |
| 16 | DATE_OVERDUE | Date(10) | DATE | Date Overdue |
| 17 | BILL_PROCESS_DT | Date(10) | DATE | Date Entered |
| 18 | AMOUNT_PAID | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Total Payments For Charge |
| 19 | PMT_ADJUST | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Payment Adjustments |
| 20 | PRINT_PERIOD | Character(4) | VARCHAR2(4) NOT NULL | Print Period |
| 21 | BILL_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Billing Source
A=Automated M=Manual |
| 22 | AMOUNT_DUE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Amount Due |
| 23 | DED_SLSTX_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Type
B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax |