CO_DED_DTLM_PUB (SQL Table)	Index Back
Deduction detail publish table Used to publish the XML message to the Supplier. The table contains deduction detail data to the Supplier.

CO_DED_DTLM_PUB

(SQL Table)

Deduction detail publish table

Used to publish the XML message to the Supplier. The table contains deduction detail data to the Supplier.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 DEDN_INIT_DT Date(10) DATE Deduction Initialize Date

4 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.

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

7 MIDDLE_INIT Character(1) VARCHAR2(1) NOT NULL The employee middle initial.

8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

9 DEPARTMENT Character(10) VARCHAR2(10) NOT NULL Department

10 DEDUCT_AMOUNT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Amount for the Employee which is reported by the Supplier.

11 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.

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 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

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	DEDN_INIT_DT	Date(10)	DATE	Deduction Initialize Date
4	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.
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	MIDDLE_INIT	Character(1)	VARCHAR2(1) NOT NULL	The employee middle initial.
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department
10	DEDUCT_AMOUNT	Number(11,2)	DECIMAL(10,2) NOT NULL	Deduction Amount for the Employee which is reported by the Supplier.
11	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.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	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
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance