| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
|
| 2 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
COUNTRY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
GPSC_CNT_DVW_FL
|
| 5 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table:
BANK_EC_TBL
|
| 6 |
BRANCH_EC_CD |
Character(17) |
VARCHAR2(17) NOT NULL |
Bank Branch ID
Prompt Table:
%GP_EDIT_FLD1
|
| 7 |
ACCOUNT_EC_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Account Number used in banking.
|
| 8 |
CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: COUNTRY_CUR_TBL.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
ACCOUNT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Account Name
|
| 11 |
INTL_BANK_ACCT_NBR |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN International Bank Account Number
|
| 12 |
ROLL_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Roll Name
|
| 13 |
ROLL_NUMBER |
Character(20) |
VARCHAR2(20) NOT NULL |
Roll Number
|
| 14 |
IAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
International ACH Transaction Bank (or IAT) Indicator
Y/N Table Edit
Default Value: N
|
| 15 |
BANK_TRANSFER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Bank Transfer ID
|
| 16 |
FORM_ID_CHECK |
Character(6) |
VARCHAR2(6) NOT NULL |
Check Stock Form ID
Prompt Table:
PAY_OL_FORM_VW
|
| 17 |
FORM_ID_ADVICE |
Character(6) |
VARCHAR2(6) NOT NULL |
Advice Form ID
Prompt Table:
PAY_OL_FORM_VW
|
| 18 |
DEPOSIT_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Medium
D=Diskette
E=Electronic File Transfer
R=Report
T=Tape
Default Value: T
|
| 19 |
PRENOTE_WAIT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Prenote Wait Days (U.S.)
Default Value: 0
|
| 20 |
DD_ACCOUNT_NBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Direct Deposit Account Number
|
| 21 |
ROUTING_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Routing Format
A=Lead 0, Bank ID, Branch ID
B=Lead 0, Branch ID, Bank ID
C=Bank ID, Branch ID
D=Branch ID, Bank ID
Default Value: A
|
| 22 |
EFT_NAME_DOMESTIC |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Format Domestic
Prompt Table:
EFT_NAME
|
| 23 |
EFT_NAME_INTL |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Format International
Prompt Table:
EFT_NAME
|
| 24 |
ACCOUNT_NAME_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
This field stores the account name in an alternate character format
|
| 25 |
HSC_BANKACCCRYPT |
Character(100) |
VARCHAR2(100) NOT NULL |
Encrypted Bank Account
|
| 26 |
HSC_BANKACCCRYPT2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Encrypted Bank Account
|
| 27 |
HSC_BANKACCCRYPT3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Encrypted Bank Account
|