JOBINSTANCEI=In Process
N=New
P=Processed
X=No Data Extracted for Process
GP_PSLP_PRCSCTL(SQL Table) |
Index Back |
|---|---|
Payslip Process ControlThis record controls the payslip process for multiple users. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOBINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 2 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | LASTEXECDTTM | DateTime(26) | TIMESTAMP | DateTime of Last Execution. |
| 6 | GP_PSLP_PRCS_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Payslip Batch Pusrocess Sta
I=In Process N=New P=Processed X=No Data Extracted for Process |