CO_DED_INVLDTXN (SQL Table)	Index Back
Employee Deduction Data Table The table will contain a records for each employee who will have Supplier deductions taken when the Payroll runs. The data in this table will be used to create the outbound Supplier deduction data.

CO_DED_INVLDTXN

(SQL Table)

Employee Deduction Data Table

The table will contain a records for each employee who will have Supplier deductions taken when the Payroll runs. The data in this table will be used to create the outbound Supplier deduction data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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 SUPP_MSG_ID Character(10) VARCHAR2(10) NOT NULL The field contains information to denote if the XML message is inbound or outbound and the value is unqiue for each inbound or outbound XML message. The field also contains the first 3 characters of the MerchantID and the last message identifier number.

6 DEDN_INIT_DT Date(10) DATE Deduction Initialize Date

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

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

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

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

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

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

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

14 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

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

16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

17 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

18 DEDCD_ERROR Character(1) VARCHAR2(1) NOT NULL Denotes deduction code error for a Inbound deduction record from the Supplier.

19 EMPLID_ERROR Character(1) VARCHAR2(1) NOT NULL Denotes the employee id provided by the Supplier does not exist in PeopleSoft database.

20 EE_DEDCD_ERROR Character(1) VARCHAR2(1) NOT NULL Denotes an error pertaining to the emplyoee general deduction record when validating the deduction data from the Supplier.

21 CURR_ERROR Character(1) VARCHAR2(1) NOT NULL Denotes currency code error for a Inbound deduction record from the Supplier.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
3	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.
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	SUPP_MSG_ID	Character(10)	VARCHAR2(10) NOT NULL	The field contains information to denote if the XML message is inbound or outbound and the value is unqiue for each inbound or outbound XML message. The field also contains the first 3 characters of the MerchantID and the last message identifier number.
6	DEDN_INIT_DT	Date(10)	DATE	Deduction Initialize Date
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	MIDDLE_INIT	Character(1)	VARCHAR2(1) NOT NULL	The employee middle initial.
10	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
11	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department
12	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.
13	DEDUCT_AMOUNT	Number(11,2)	DECIMAL(10,2) NOT NULL	Deduction Amount for the Employee which is reported by the Supplier.
14	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
17	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
18	DEDCD_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Denotes deduction code error for a Inbound deduction record from the Supplier.
19	EMPLID_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Denotes the employee id provided by the Supplier does not exist in PeopleSoft database.
20	EE_DEDCD_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Denotes an error pertaining to the emplyoee general deduction record when validating the deduction data from the Supplier.
21	CURR_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Denotes currency code error for a Inbound deduction record from the Supplier.