W3EB_SMRY_OPTN2 (SQL Table)	Index Back
Employee Ben Options Record used to generate the review and confirm, and the file layout for the .pdf benefit summary report. Options here are: PLAN_TYPE LIKE '4%', '5%', '7%', '8%'

W3EB_SMRY_OPTN2

(SQL Table)

Employee Ben Options

Record used to generate the review and confirm, and the file layout for the .pdf benefit summary report. Options here are: PLAN_TYPE LIKE '4%', '5%', '7%', '8%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

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

5 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.
Default Value: 01

6 OPTION_ID Number(4,0) SMALLINT NOT NULL Option ID

7 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

8 EVENT_DT Date(10) DATE NOT NULL Event Date

9 OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL Option Type
D=General Deduction
G=General Credit
O=Option
P=Program
W=Waive Option
Default Value: O

10 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

11 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
Default Value: 1
Prompt Table: COVRG_CD_TBL

12 OPTION_CD Character(3) VARCHAR2(3) NOT NULL Option Code

13 PLAN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Plan Type Description

14 OPTION_NAME Character(10) VARCHAR2(10) NOT NULL Option Name

15 DESCR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Description

16 FLAT_DED_AMT Number(9,2) DECIMAL(8,2) NOT NULL Flat Deduction Amount

17 FLAT_DED_AMT_ATAX Number(9,2) DECIMAL(8,2) NOT NULL Flat Deduction Amt After-Tax

18 PENSION_BASE Number(11,2) DECIMAL(10,2) NOT NULL Salary for Pension Calculation

19 VOLUNTARY_AMT Number(11,2) DECIMAL(10,2) NOT NULL Voluntary Contribution Amount

20 VOLUNTARY_PCT Number(7,3) DECIMAL(6,3) NOT NULL Voluntary Contrib Pct

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
4	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
5	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. Default Value: 01
6	OPTION_ID	Number(4,0)	SMALLINT NOT NULL	Option ID
7	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
8	EVENT_DT	Date(10)	DATE NOT NULL	Event Date
9	OPTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Option Type D=General Deduction G=General Credit O=Option P=Program W=Waive Option Default Value: O
10	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
11	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Default Value: 1 Prompt Table: COVRG_CD_TBL
12	OPTION_CD	Character(3)	VARCHAR2(3) NOT NULL	Option Code
13	PLAN_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Plan Type Description
14	OPTION_NAME	Character(10)	VARCHAR2(10) NOT NULL	Option Name
15	DESCR_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Category Description
16	FLAT_DED_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Flat Deduction Amount
17	FLAT_DED_AMT_ATAX	Number(9,2)	DECIMAL(8,2) NOT NULL	Flat Deduction Amt After-Tax
18	PENSION_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Salary for Pension Calculation
19	VOLUNTARY_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Voluntary Contribution Amount
20	VOLUNTARY_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Voluntary Contrib Pct