CO_DED_VLDTXN (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_VLDTXN

(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 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

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 EMP_GROUP_NBR Character(12) VARCHAR2(12) NOT NULL Employee group number which is provided on the deduction header record from the Supplier.

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

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

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

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

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

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

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

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

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

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

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

#	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	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
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	EMP_GROUP_NBR	Character(12)	VARCHAR2(12) NOT NULL	Employee group number which is provided on the deduction header record from the Supplier.
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
10	MIDDLE_INIT	Character(1)	VARCHAR2(1) NOT NULL	The employee middle initial.
11	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
12	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department
13	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.
14	DEDUCT_AMOUNT	Number(11,2)	DECIMAL(10,2) NOT NULL	Deduction Amount for the Employee which is reported by the Supplier.
15	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.
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
18	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group