PROCESS_INSTANCE10=File - Employees for Payment
20=File - Cancelation of Empls
30=PIS - Payment Process
40=PIS - Reversal Process
Default Value: Y
GPBR_PISP_AET(SQL Table) |
Index Back |
|---|---|
PIS RC Process AETPIR RC Process AET |
| # | 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 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 5 | GPBR_YEAR_REFER | Character(4) | VARCHAR2(4) NOT NULL | Reference Year |
| 6 | GPBR_FILE_NAME | Character(250) | VARCHAR2(250) NOT NULL | Name of a file, with full path, according to the process scheduler server. |
| 7 | GPBR_FILE_OUTPUT | Character(250) | VARCHAR2(250) NOT NULL | Name of a file, with full path, according to the process scheduler server. |
| 8 | 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 |
| 9 | GPBR_PIS_DT | Date(10) | DATE | PIS Emission Date |
| 10 | GPBR_REV_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Reversal Report Option
Default Value: Y |
| 11 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 12 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 13 | GPBR_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL | Month 2 digit code |