GPNL_RC_PAYSLIP(SQL Table) |
Index Back |
|---|---|
Main SQR run control recordMain, level 0 SQR run control record, used in all SQRs. |
| # | 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: GPNL_PSLIP_R_VW |
| 4 | GPNL_RC_RETRO | Character(1) | VARCHAR2(1) NOT NULL |
Retro Processing
N=Current Period Only O=Retro Periods Only Y=Retro and Current Period Default Value: Y |
| 5 | GPNL_PAYSLIP_ID | Character(6) | VARCHAR2(6) NOT NULL |
Pay Slip Identification
Prompt Table: GPNL_PSLIP_HD |
| 6 | GPNL_RC_PS_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Payslip Generation Details
1=All 2=Negative first, positive last 3=Positive Only 4=Negative Only Default Value: 1 |