CO_DED_EXT1_TAO(SQL Table) |
Index Back |
---|---|
Deduction temp tableTemp 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. |