OPRIDRUN_CNTL_IDPrompt Table: GPJP_BA_CAL_VW
Prompt Table: GP_RUN_TYPE
Prompt Table:
GPJP_BA_SRC_VW
Set Control Field: CAL_RUN_ID
Default Value: %Date
Prompt Table: GPJP_FILE_HANDL
11=Salary
12=Bonus
Default Value: 11
GPJP_RC_BA01(SQL Table) |
Index Back |
|---|---|
Banking Run Control RecordTracks run control information for AE program GPJP_BA01_AE and SQR BA01. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPJP_BA_CAL_VW |
| 4 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPE |
| 5 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
GPJP_BA_SRC_VW
|
| 6 | DEPOSIT_DATE | Date(10) | DATE NOT NULL |
Deposit Date
Default Value: %Date |
| 7 | FILE_HANDLE | Character(2) | VARCHAR2(2) NOT NULL |
File Handle
Prompt Table: GPJP_FILE_HANDL |
| 8 | GPJP_EFT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type.
11=Salary 12=Bonus Default Value: 11 |