CO_DED_EXTR_TBL (SQL Table)	Index Back
DEDUCTION EXTRCT TBL Table contains employee deduction data from the Supplier inbound deduction data and the employee payroll deduction record.

CO_DED_EXTR_TBL

(SQL Table)

DEDUCTION EXTRCT TBL

Table contains employee deduction data from the Supplier inbound deduction data and the employee payroll deduction record.

# 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 NOT NULL Pay Period End Date

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

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

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

8 CHECK_DT Date(10) DATE Check date.

9 DEDUCT_AMT_TAKEN Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction amount taken from the employee pay check for a Discount and Perks Supplier deduction.

10 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

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

13 DISBURSE_STATUS Character(1) VARCHAR2(1) NOT NULL The status of an employee deduction record i.e. extracted or sent to the Supplier.
E=Extract
S=Sent

14 COMPANY_ALT Character(3) VARCHAR2(3) NOT NULL Company

15 PAYGROUP_ALT Character(3) VARCHAR2(3) NOT NULL This field is an alternate field for the paygroup.

16 FREQUENCY_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of a frequency ID.
A=Annual
B=Biweekly
C=Contract
D=Daily
F=Every Four Weeks
H=Hourly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly

17 SITE_NBR_ALT Character(6) VARCHAR2(6) NOT NULL This field is an alternate to the site number field. THe field will contain the employee new site number vs the site number sent by the Supplier.

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

#	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 NOT NULL	Pay Period End Date
5	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
6	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
7	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.
8	CHECK_DT	Date(10)	DATE	Check date.
9	DEDUCT_AMT_TAKEN	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction amount taken from the employee pay check for a Discount and Perks Supplier deduction.
10	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
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	SUPP_FILE_ID	Character(10)	VARCHAR2(10) NOT NULL	The field contains information to denote if the flat file is inbound or outbound and the value is unqiue for each inbound or outbound flat file. The field also contains the first 3 characters of the MerchantID and the last file identifier number.
13	DISBURSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The status of an employee deduction record i.e. extracted or sent to the Supplier. E=Extract S=Sent
14	COMPANY_ALT	Character(3)	VARCHAR2(3) NOT NULL	Company
15	PAYGROUP_ALT	Character(3)	VARCHAR2(3) NOT NULL	This field is an alternate field for the paygroup.
16	FREQUENCY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates the type of a frequency ID. A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly
17	SITE_NBR_ALT	Character(6)	VARCHAR2(6) NOT NULL	This field is an alternate to the site number field. THe field will contain the employee new site number vs the site number sent by the Supplier.
18	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.