| # |
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 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
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.
|
| 6 |
FILE_IN_DIR |
Character(64) |
VARCHAR2(64) NOT NULL |
Output Directory Name for Flat File Interfaces.
|
| 7 |
FILE_IN_NAME |
Character(33) |
VARCHAR2(33) NOT NULL |
The name of the inbound deduction flat file from the Supplier.
|
| 8 |
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.
|
| 9 |
TOTAL_DED_CNT |
Number(6,0) |
INTEGER NOT NULL |
The field contains the total count of the number of deduction records sent by the Supplier.
|
| 10 |
TOTAL_DEDAMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
This field contains the total deduction amount sent by the SUpplier.
|
| 11 |
LAST_FILE_ID |
Number(6,0) |
INTEGER NOT NULL |
Denotes the last file identifer number used for the Supplier. This identifer number is appended to the generated file identifier.
|
| 12 |
MERCH_CHAR3 |
Character(3) |
VARCHAR2(3) NOT NULL |
This field contains the first three characters of the Merchantid for a Supplier.
|