ENROLL_EXCEPTN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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. Prompt Table: BEN_RNBR_PRMT
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: SAV_PLNTYP_VW
4	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: SAV_PLN_EE_VW
5	ENROL_EXCPTN_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Enroll Exception Action for Benefits Enrollment. S=Suspend Enrollment Default Value: S
6	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
7	END_DATE	Date(10)	DATE NOT NULL	End Date
8	EXCEP_BTAX_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Action applied to Before Tax Flag. N=Do not Apply Before Tax Y=Apply Before Tax
9	EXCEP_ATAX_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Action applied to After Tax Flag. N=Do not Apply After Tax Y=Apply After Tax
10	EXCEP_PTAX_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Action applied to NonTaxable BTax Benefit Flag. N=Do not Apply Employer Y=Apply Employer
11	EXCEP_NTAX_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Action applied to NonTaxable Benefit Flag. N=Do not Apply Employer Y=Apply Employer
12	EXCEP_TTAX_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Action applied to Taxable Flag. N=Do not Apply Employer Y=Apply Employer