CO_DED_DTL_PUB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
2	SITE_NBR	Character(6)	VARCHAR2(6) NOT NULL	This field is edused to group employee based on their paygroup and pay frequency. The value for this field is assigned by the Supplier.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	MIDDLE_INIT	Character(1)	VARCHAR2(1) NOT NULL	The employee middle initial.
7	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
8	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department
9	DEDUCT_AMT_TAKEN	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction amount taken from the employee pay check for a Discount and Perks Supplier deduction.
10	TRANS_CD	Character(1)	VARCHAR2(1) NOT NULL	This field contains the transaction value for each deduction record sent by the Supplier i.e. new, change, or delete.
11	CHECK_DT	Date(10)	DATE	Check date.
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
14	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
15	SUPP_DEDCD	Character(6)	VARCHAR2(6) NOT NULL	This fiels contains the Supplier deduction code for a deduction which is being provided to an employee.
16	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
17	COMPANY_ALT	Character(3)	VARCHAR2(3) NOT NULL	Company
18	PAYGROUP_ALT	Character(3)	VARCHAR2(3) NOT NULL	This field is an alternate field for the paygroup.
19	FREQUENCY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates the type of a frequency ID. A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly
20	SITE_NBR_ALT	Character(6)	VARCHAR2(6) NOT NULL	This field is an alternate to the site number field. THe field will contain the employee new site number vs the site number sent by the Supplier.
21	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
23	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process