BN_BEN110_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	ASOFDATE	Date(10)	DATE	As of Date
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	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.
8	PAY_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Pay Frequency A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly
9	RUNDATE	Date(10)	DATE	Process Scheduler Run Date
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
12	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.
13	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
14	COVERED_PERSON_TYP	Character(2)	VARCHAR2(2) NOT NULL	Covered Person Type: Added fields for Benefits ERISA implementation. Groups relationship codes into categories, i.e. Son, Daughter => Child AC=Adult Child CH=Child DP=Domestic Partner EE=Employee NQ=Non-Qualified Dependent OD=Other Qualified Dependent SP=Spouse SS=US Same-Sex Spouse XS=ExSpouse
15	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker
18	SERVICE_DT	Date(10)	DATE	Service Date
19	TERMINATION_DT	Date(10)	DATE	Termination Date
20	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
21	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
22	COVERAGE_ELECT	Character(1)	VARCHAR2(1) NOT NULL	Coverage Election E=Elect T=Terminate W=Waive
23	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Prompt Table: COVRG_CD_TBL
24	SUM_DEP_COVG	Character(1)	VARCHAR2(1) NOT NULL	This Field determines the if need to sum the dependent coverage amount or not.
25	PREMIUM_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Premium Base
26	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
27	CALC_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Calculation Rules Table ID Prompt Table: CALC_RULES_TBL