| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
GPMY_BANK_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank Code
|
| 2 |
GPMY_BRANCH_CD |
Character(17) |
VARCHAR2(17) NOT NULL |
Branch Code
|
| 3 |
GPMY_ACCOUNT_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank Account Number
|
| 4 |
GPMY_ACCOUNT_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Bank Account Name
|
| 5 |
GPMY_TRANS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Bank Transaction Code
|
| 6 |
GPMY_AMT_CHAR11 |
Character(11) |
VARCHAR2(11) NOT NULL |
Payment Amount
|
| 7 |
GPMY_BLANKS_38 |
Character(38) |
VARCHAR2(38) NOT NULL |
Filler of size 38.
|
| 8 |
GPMY_PARTICULARS |
Character(12) |
VARCHAR2(12) NOT NULL |
Particulars field used in EFT file detail
|
| 9 |
GPMY_REFERENCE |
Character(12) |
VARCHAR2(12) NOT NULL |
Reference field used in EFT detail file
|
| 10 |
GPMY_EFT_RECTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
EFT Record Type
|
| 11 |
GPMY_EMPL_BNK_AC |
Character(17) |
VARCHAR2(17) NOT NULL |
Employee Bank Account Used for EFT Purposes
|
| 12 |
GPMY_DEPOSIT_AMT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Deposit Amount
|
| 13 |
GPMY_IC_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 14 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 15 |
GPMY_BLANKS_24 |
Character(24) |
VARCHAR2(24) NOT NULL |
Filler of size 24.
|