OPRIDRUN_CNTL_IDESTABIDPrompt Table: ESTB_PIS_VW_BRA
10=File - Employees for Payment
20=File - Cancelation of Empls
30=PIS - Payment Process
40=PIS - Reversal Process
Y/N Table Edit
Default Value: Y
Prompt Table: GPBR_MONTH_VW
GPBR_RC_PIS_PRO(SQL Table) |
Index Back |
|---|---|
PIS RC ProcessingPIS Run Control Processing |
| # | 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 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTB_PIS_VW_BRA |
| 4 | GPBR_YEAR_REFER | Character(4) | VARCHAR2(4) NOT NULL | Reference Year |
| 5 | GPBR_FILE_NAME | Character(250) | VARCHAR2(250) NOT NULL | Name of a file, with full path, according to the process scheduler server. |
| 6 | GPBR_PIS_OPER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
PIS Operation Type
10=File - Employees for Payment 20=File - Cancelation of Empls 30=PIS - Payment Process 40=PIS - Reversal Process |
| 7 | GPBR_PIS_DT | Date(10) | DATE | PIS Emission Date |
| 8 | GPBR_REV_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Reversal Report Option
Y/N Table Edit Default Value: Y |
| 9 | GPBR_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month 2 digit code
Prompt Table: GPBR_MONTH_VW |