CO_DED_OUTD_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TYPE_1	Character(2)	VARCHAR2(2) NOT NULL	Type_1
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	MIDDLE_INIT	Character(1)	VARCHAR2(1) NOT NULL	The employee middle initial.
6	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
7	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department
8	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.
9	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.
10	CHECK_DT	Date(10)	DATE	Check date.
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
13	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
14	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.
15	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
16	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.
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.