JOBINSTANCE11=Salary
12=Bonus
Default Value: 11
1=Regular
2=Checking
GPJP_BA_HEADER(SQL Table) |
Index Back |
|---|---|
Banking Header RecordTracks information used to generate the header of the EFT file. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOBINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 2 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 3 | GPJP_EFT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type.
11=Salary 12=Bonus Default Value: 11 |
| 4 | GPJP_COMPANY_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tracks a company identifier assigned by the banking institution. |
| 5 | ACCOUNT_NAME_AC | Character(40) | VARCHAR2(40) NOT NULL | This field stores the account name in an alternate character format |
| 6 | GPJP_CHARDATE | Character(4) | VARCHAR2(4) NOT NULL | This field stores dates in a character format, specifically in the format of MMDD. |
| 7 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 8 | BANK_NAME_AC | Character(15) | VARCHAR2(15) NOT NULL | This field stores the bank name in an alternate character format |
| 9 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 10 | BRANCH_NAME_AC | Character(15) | VARCHAR2(15) NOT NULL | This field stores the branch name in an alternate character format |
| 11 | GPJP_ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to inform the Bank receiving the EFT file whether the Source Bank is a regular account or a checking account.
1=Regular 2=Checking |
| 12 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 13 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL | Country Code |