| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
DEDN_INIT_DT |
Date(10) |
DATE |
Deduction Initialize Date
|
| 6 |
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.
|
| 7 |
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.
|
| 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 |
DEDUCT_AMOUNT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Deduction Amount for the Employee which is reported by the Supplier.
|
| 14 |
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.
|
| 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 |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 19 |
DEDCD_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Denotes deduction code error for a Inbound deduction record from the Supplier.
|
| 20 |
EMPLID_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Denotes the employee id provided by the Supplier does not exist in PeopleSoft database.
|
| 21 |
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.
|
| 22 |
CURR_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Denotes currency code error for a Inbound deduction record from the Supplier.
|