BEN_BI_CHARGE (SQL Table)	Index Back
Charges BEN_BI_CHARGE holds non-accounting information about Benefits Billing charges. This table has equivalent status with BEN_BI_PAYMENT and BEN_BI_ADJSTMNT. These three tables together hold all the information on accounting entries and are joined through BEN_BI_DETAIL. BEN_BI_CHARGE does not hold any charge accounting information. This information is held on BEN_BI_DETAIL. BEN_BI_CHG_VW totals the accounting information and ties it to the charges. Warning! For technical reasons, this record's schema shows that it is keyed by EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

BEN_BI_CHARGE

(SQL Table)

Charges

BEN_BI_CHARGE holds non-accounting information about Benefits Billing charges. This table has equivalent status with BEN_BI_PAYMENT and BEN_BI_ADJSTMNT. These three tables together hold all the information on accounting entries and are joined through BEN_BI_DETAIL. BEN_BI_CHARGE does not hold any charge accounting information. This information is held on BEN_BI_DETAIL. BEN_BI_CHG_VW totals the accounting information and ties it to the charges. Warning! For technical reasons, this record's schema shows that it is keyed by EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

Parent record: BEN_BI_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: EMPLMT_SRCH_GBL.EMPLID
Prompt Table: BEN_BI_ENR_SRCH

2 BILL_PER_CD Character(4) VARCHAR2(4) NOT NULL Billing Period
Default Value: BEN_BI_CALENDAR.BILL_PER_CD
Prompt Table: BEN_BI_CALENDAR

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
Prompt Table: BEN_BI_CHARGE

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: EMPLMT_SRCH_GBL.EMPL_RCD
Prompt Table: BEN_BI_BRN_SRCH

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.
Prompt Table: BEN_DEFN_PGM

8 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: BEN_PROG_BENPLN

9 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
Prompt Table: BEN_PROG_BENCVC

10 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: BEN_PROG_BENDED

11 BILLING_REASON Character(1) VARCHAR2(1) NOT NULL Billing Reason
A=Arrears
B=Benefits Administration
C=COBRA
M=Manual Entry
Default Value: A

12 DATE_DUE Date(10) DATE NOT NULL Date Due

13 DATE_OVERDUE Date(10) DATE Date Overdue

14 BILL_PROCESS_DT Date(10) DATE Date Entered
Default Value: %date

15 PRINT_PERIOD Character(4) VARCHAR2(4) NOT NULL Print Period
Prompt Table: BEN_BI_CALENDAR

16 BILL_SOURCE Character(1) VARCHAR2(1) NOT NULL Billing Source
A=Automated
M=Manual
Default Value: M

17 PROCESS_PERIOD Character(4) VARCHAR2(4) NOT NULL Processing Period

18 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

19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

20 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: EMPLMT_SRCH_GBL.EMPLID Prompt Table: BEN_BI_ENR_SRCH
2	BILL_PER_CD	Character(4)	VARCHAR2(4) NOT NULL	Billing Period Default Value: BEN_BI_CALENDAR.BILL_PER_CD Prompt Table: BEN_BI_CALENDAR
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 Prompt Table: BEN_BI_CHARGE
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: EMPLMT_SRCH_GBL.EMPL_RCD Prompt Table: BEN_BI_BRN_SRCH
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. Prompt Table: BEN_DEFN_PGM
8	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: BEN_PROG_BENPLN
9	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Prompt Table: BEN_PROG_BENCVC
10	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_BENDED
11	BILLING_REASON	Character(1)	VARCHAR2(1) NOT NULL	Billing Reason A=Arrears B=Benefits Administration C=COBRA M=Manual Entry Default Value: A
12	DATE_DUE	Date(10)	DATE NOT NULL	Date Due
13	DATE_OVERDUE	Date(10)	DATE	Date Overdue
14	BILL_PROCESS_DT	Date(10)	DATE	Date Entered Default Value: %date
15	PRINT_PERIOD	Character(4)	VARCHAR2(4) NOT NULL	Print Period Prompt Table: BEN_BI_CALENDAR
16	BILL_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Billing Source A=Automated M=Manual Default Value: M
17	PROCESS_PERIOD	Character(4)	VARCHAR2(4) NOT NULL	Processing Period
18	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
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
20	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province