OPRIDRUN_CNTL_IDCAL_RUN_IDPrompt Table: GPIT_BNK_CALVW
PAY_ENTITYPrompt Table: GP_PYENT
1=Generic Bank Tranfer
2=Emolumenti
3=Salary
Default Value: 3
2=Employee ID
3=Fiscal Code
Default Value: 2
GPIT_RC_EFT(SQL Table) |
Index Back |
|---|---|
Banking Run ControlContains fields that are used as input parameters for banking report and EFT generation. Input data is retrieved from this record when a report is requested from the Process Scheduler. |
| # | 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: GPIT_BNK_CALVW |
| 4 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 5 | GPIT_PAYMENT_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Payment Description
1=Generic Bank Tranfer 2=Emolumenti 3=Salary Default Value: 3 |
| 6 | GPIT_FIXED_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Fixed Description |
| 7 | GPIT_PAYMENT_DT | Date(10) | DATE | Payment Date |
| 8 | GPIT_TODAY_DT | Date(10) | DATE | Today Date |
| 9 | GPIT_EXECUTION_DT | Date(10) | DATE | Execution Date |
| 10 | GPIT_BK_FILE_ID | Character(20) | VARCHAR2(20) NOT NULL | File ID |
| 11 | GPIT_VALUE_DT | Date(10) | DATE | Value Date |
| 12 | GPIT_BK_PYE_ID_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Payee ID Type
2=Employee ID 3=Fiscal Code Default Value: 2 |