BEN_DEFN_COST (SQL Table)	Index Back
Benefit Opt Cost Definition BEN_DEFN_COST is a record that defines the costs associated with each benefit option and is used for processing in Payroll and Benefit Administration. The costs are defined as the rate type, rate table ID, earnings code (for credits), and calculation rules.

BEN_DEFN_COST

(SQL Table)

Benefit Opt Cost Definition

BEN_DEFN_COST is a record that defines the costs associated with each benefit option and is used for processing in Payroll and Benefit Administration. The costs are defined as the rate type, rate table ID, earnings code (for credits), and calculation rules.

Parent record: BEN_DEFN_OPTN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 EFFDT Date(10) DATE NOT NULL Effective Date

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 OPTION_ID Number(4,0) SMALLINT NOT NULL Option ID

5 COST_ID Number(4,0) SMALLINT NOT NULL Cost Identification

6 COST_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that indicates how the employee-paid portion of a benefit plan is paid, either as Cost (C) or Price (P). 'Price' indicates that the benefit is paid from an employee payroll deduction. 'Credit' specifies that the system calculates additional earnings which are used as credit to pay for a benefit.
C=Credit
P=Price

7 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: EARNINGS_TBL

8 RATE_TYPE Character(4) VARCHAR2(4) NOT NULL This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.
Prompt Table: BN_RATE_TYPE

9 RATE_TBL_ID Character(6) VARCHAR2(6) NOT NULL This is used as the record key that identifies a specific set of benefit rates.
Prompt Table: %RECNAME_EDIT

10 CALC_RULES_ID Character(4) VARCHAR2(4) NOT NULL Calculation Rules Table ID
Prompt Table: CALC_RULES_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
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	OPTION_ID	Number(4,0)	SMALLINT NOT NULL	Option ID
5	COST_ID	Number(4,0)	SMALLINT NOT NULL	Cost Identification
6	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates how the employee-paid portion of a benefit plan is paid, either as Cost (C) or Price (P). 'Price' indicates that the benefit is paid from an employee payroll deduction. 'Credit' specifies that the system calculates additional earnings which are used as credit to pay for a benefit. C=Credit P=Price
7	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL
8	RATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves. Prompt Table: BN_RATE_TYPE
9	RATE_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	This is used as the record key that identifies a specific set of benefit rates. Prompt Table: %RECNAME_EDIT
10	CALC_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Calculation Rules Table ID Prompt Table: CALC_RULES_TBL