GPUS_BNK_RC1(SQL Table) |
Index Back |
|---|---|
GPUS Run Control for reportsRun control record used for several reports |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP8_VW |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPUS_CALRUN_VW |
| 6 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 7 | DEBIT_DT | Date(10) | DATE | Debit Date |
| 8 | PMT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type
01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction |
| 9 | GPUS_RPT_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the level of report details required in the reports
1=Detail 2=Summary Default Value: 1 |
| 10 | GPUS_RPT_PYMT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Field use in net payment report. It includes payment methods plus a value for prenote
1=All 2=Check 3=Prenote 4=Bank Transfer 5=Transfer and Prenote Default Value: 1 |