PROCESS_INSTANCEA=Current Account
B=Building Society Roll Number
C=Checking
G=Giro Account
R=Regular
S=Savings
T=Salary Account
GPBR_PMT_AET(SQL Table) |
Index Back |
|---|---|
Process to fill in PAYMENTThe purpose of this record is to temporary store values we need in our Application Engine Process to fill in GPBR_PAYMENT record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | STRM_NUM | Number(4,0) | SMALLINT NOT NULL | Stream Number |
| 6 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
| 7 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 10 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 11 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 12 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 13 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 14 | ACCOUNT_TYPE_PYE | Character(1) | VARCHAR2(1) NOT NULL |
Payee Bank Account Type
A=Current Account B=Building Society Roll Number C=Checking G=Giro Account R=Regular S=Savings T=Salary Account |
| 15 | CHECK_DIGIT | Character(2) | VARCHAR2(2) NOT NULL | Check Digit |
| 16 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 17 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 18 | GPBR_ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account BRA |
| 19 | GPBR_ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name BRA |
| 20 | GPBR_BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank Code BRA |
| 21 | GPBR_BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Branch Bank for BRA |
| 22 | GPBR_CHECK_DIGIT | Character(2) | VARCHAR2(2) NOT NULL | Check Digit BRA |
| 23 | BANK_TRANSFER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bank Transfer ID |
| 24 | DELETE_DATA | Character(1) | VARCHAR2(1) NOT NULL | Clear Data in Temp Table |
| 25 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 26 | RECIPIENT_TAG | Number(3,0) | SMALLINT NOT NULL | Used to identify recipients for E/D, PI |
| 27 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
| 28 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 29 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 30 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 31 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 32 | ACCOUNT_ID | Number(3,0) | SMALLINT NOT NULL | Account ID |