R_BEN_BI_HIST(SQL Table) |
Index Back |
|---|---|
Billing History Work RecordR_BEN_BI_HIST is a work record for the Billing Statement and Billing History SQRs. This table lets the SQRs easily merge and sort data from three different tables; BEN_BI_CHARGE, BEN_BI_PAYMENT and BEN_BI_ADJSTMNT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | POSTING_DATE |
Date(10) | DATE | Posting Date |
| 3 | DETAIL_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Action Type
CADJ=Adjust Charge CHRG=Charge EXCS=Excess Cash PADJ=Adjust Payment PMNT=Payment |
| 4 | BILLING_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Billing Reason
A=Arrears B=Benefits Administration C=COBRA M=Manual Entry |
| 5 | DATE_DUE | Date(10) | DATE | Date Due |
| 6 | AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Dollar Amount |
| 7 | BENEFIT_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Defines a collection of benefit plans and their associated rate and calculation rules. |
| 8 | 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. |
| 9 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 10 | COVRG_CD | Character(2) | VARCHAR2(2) NOT NULL | Coverage Code |
| 11 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 12 | BILL_CHARGE_ID | Number(7,0) | INTEGER NOT NULL | Billing Charge ID |
| 13 | BILL_PAY_ID | Number(7,0) | INTEGER NOT NULL | Payment ID |
| 14 | BILL_ADJ_ID | Signed Number(8,0) | DECIMAL(7) NOT NULL | Billing Adjustment ID |
| 15 | 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 Default Value: B |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 17 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |