BEN_BI_ENR_EFDT (SQL Table)	Index Back
Billing Enrollment - Effdt BEN_BI_ENR_EFDT is the bottom table in the BEN_BI_ENR_PLAN, BEN_BI_ENR_CBR and BEN_BI_ENR_EFDT construct that holds the billing enrollments. This is the table that really holds the enrollments. The other two tables are mechanical constructs that allow multiple scroll bars on the enrollment panel. BEN_BI_ENR_EFDT holds the information on billing enrollments; when billing starts, when it ends, what plan type to bill, and how to manipulate the "normal" charge calculation. This table is updated manually through the billing enrollment panel and automatically through Benefits Administration event maintenance and COBRA enrollments. 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_ENR_EFDT

(SQL Table)

Billing Enrollment - Effdt

BEN_BI_ENR_EFDT is the bottom table in the BEN_BI_ENR_PLAN, BEN_BI_ENR_CBR and BEN_BI_ENR_EFDT construct that holds the billing enrollments. This is the table that really holds the enrollments. The other two tables are mechanical constructs that allow multiple scroll bars on the enrollment panel. BEN_BI_ENR_EFDT holds the information on billing enrollments; when billing starts, when it ends, what plan type to bill, and how to manipulate the "normal" charge calculation. This table is updated manually through the billing enrollment panel and automatically through Benefits Administration event maintenance and COBRA enrollments. 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_ENR_CBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW

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

4 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
Prompt Table: BEN_BI_ENR_CBR

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 BILLING_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
A=Active
H=Hold Billing
I=Inactive
Default Value: A

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

8 PERCENT_CALC Character(1) VARCHAR2(1) NOT NULL Percent Calculation
Y/N Table Edit
Default Value: Y

9 FLAT_CALC Character(1) VARCHAR2(1) NOT NULL Flat Amount of
Y/N Table Edit
Default Value: N

10 RATE_PERCENT Number(3,0) SMALLINT NOT NULL Rate Percent

11 RATE_QUALIFIER Character(1) VARCHAR2(1) NOT NULL Rate Qualifier
E=Employee Rate
T=Total Rate
Default Value: E

12 RATE_AMOUNT Signed Number(9,2) DECIMAL(7,2) NOT NULL Rate Amount

13 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN_VW
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. Prompt Table: BEN_BI_ENR_PLAN
4	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated. Prompt Table: BEN_BI_ENR_CBR
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	BILLING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Status A=Active H=Hold Billing I=Inactive Default Value: A
7	BILLING_REASON	Character(1)	VARCHAR2(1) NOT NULL	Billing Reason A=Arrears B=Benefits Administration C=COBRA M=Manual Entry Default Value: M
8	PERCENT_CALC	Character(1)	VARCHAR2(1) NOT NULL	Percent Calculation Y/N Table Edit Default Value: Y
9	FLAT_CALC	Character(1)	VARCHAR2(1) NOT NULL	Flat Amount of Y/N Table Edit Default Value: N
10	RATE_PERCENT	Number(3,0)	SMALLINT NOT NULL	Rate Percent
11	RATE_QUALIFIER	Character(1)	VARCHAR2(1) NOT NULL	Rate Qualifier E=Employee Rate T=Total Rate Default Value: E
12	RATE_AMOUNT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Rate Amount
13	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification