CO_DED_FTPT_TAO (SQL Table)	Index Back
Deduction temp table Temp Table is used in the process to recreate the flat file for the Discounts and Perks integration with Payroll.

CO_DED_FTPT_TAO

(SQL Table)

Deduction temp table

Temp Table is used in the process to recreate the flat file for the Discounts and Perks integration with Payroll.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TYPE_1 Character(2) VARCHAR2(2) NOT NULL Type_1

2 TOTAL_DED_CNT Number(6,0) INTEGER NOT NULL The field contains the total count of the number of deduction records sent by the Supplier.

3 TOTAL_DEDAMT Number(10,2) DECIMAL(9,2) NOT NULL This field contains the total deduction amount sent by the SUpplier.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TYPE_1	Character(2)	VARCHAR2(2) NOT NULL	Type_1
2	TOTAL_DED_CNT	Number(6,0)	INTEGER NOT NULL	The field contains the total count of the number of deduction records sent by the Supplier.
3	TOTAL_DEDAMT	Number(10,2)	DECIMAL(9,2) NOT NULL	This field contains the total deduction amount sent by the SUpplier.