W3EB_SMRY_OPTN1 (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 '0%', '1%', 'A%', '2%', '3%', '6%', 9%'

W3EB_SMRY_OPTN1

(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 '0%', '1%', 'A%', '2%', '3%', '6%', 9%'

# 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 CALCULATED_BASE Number(11,2) DECIMAL(10,2) NOT NULL Coverage Base

17 DEDN_AMT_A_TAX Signed Number(12,2) DECIMAL(10,2) NOT NULL This field holds the tax-class detail for an Option's per-pay-period cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.

18 DEDN_AMT_B_TAX Signed Number(12,2) DECIMAL(10,2) NOT NULL This field holds the tax-class detail for an Option's per-pay-period cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.

#	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	CALCULATED_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Coverage Base
17	DEDN_AMT_A_TAX	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field holds the tax-class detail for an Option's per-pay-period cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.
18	DEDN_AMT_B_TAX	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field holds the tax-class detail for an Option's per-pay-period cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.