GP_PSLP_PRCS_VW (SQL View)	Index Back
Payslip Process Control This record controls the payslip process for multiple users.

GP_PSLP_PRCS_VW

(SQL View)

Payslip Process Control

This record controls the payslip process for multiple users.

SELECT a.cal_run_id ,a.jobinstance ,a.run_cntl_id ,a.oprid ,a.lastexecdttm ,a.gp_pslp_prcs_stat FROM PS_GP_PSLP_PRCSCTL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
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