CO_DED_EXT1_TAO

(SQL Table)
Index Back

Deduction temp table

Temp Table is used in the extract process for the Discounts and Perks integration with Payroll.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
4 PAY_END_DT Date(10) DATE Pay Period End Date
5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
7 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
8 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
9 CHECK_DT Date(10) DATE Check date.