EMPL_DED_PROC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	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.
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.
6	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: BEN_PROG_BENPLN
7	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: %RECNAME_EDIT
8	PAY_PERIOD1	Character(1)	VARCHAR2(1) NOT NULL	First Pay Period Y/N Table Edit Default Value: Y
9	PAY_PERIOD2	Character(1)	VARCHAR2(1) NOT NULL	Second Pay Period Y/N Table Edit
10	PAY_PERIOD3	Character(1)	VARCHAR2(1) NOT NULL	Third Pay Period Y/N Table Edit
11	PAY_PERIOD4	Character(1)	VARCHAR2(1) NOT NULL	Fourth Pay Period Y/N Table Edit
12	PAY_PERIOD5	Character(1)	VARCHAR2(1) NOT NULL	Fifth Pay Period Y/N Table Edit
13	MAX_PAYBACK	Character(1)	VARCHAR2(1) NOT NULL	Maximum Arrears Payback F=Factor x Regular Deduction N=No Maximum Y=Flat Maximum for Payback Default Value: N
14	MAX_ARREARS_PAYBK	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Arrears Payback