GP_SS_PSLP_RCTL (SQL Table)	Index Back
epay process run control epay process run control

GP_SS_PSLP_RCTL

(SQL Table)

epay process run control

# 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 GP_PSLP_PROCNAME Character(12) VARCHAR2(12) NOT NULL ePay Procedure Name
COPY=Reprint Payslip Copy
GEN=Generate Payslip
RGEN=Regenerate Payslip
RNUM=Renumber Payslip

4 GP_PSLP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL This field is the job or process instance used internally by the processes in the Payslip Job Definition and ePay.

5 GP_PSLP_DATAINST Number(10,0) DECIMAL(10) NOT NULL This field is the job instance used internally by the processes in the Payslip Job Definition

6 GP_PSLP_SPLIT_IND Character(1) VARCHAR2(1) NOT NULL Indicate if ePay is being asked to split the source pdf into payslip files.
Y/N Table Edit
Default Value: Y

7 GP_PSLP_ATCH_IND Character(1) VARCHAR2(1) NOT NULL indicate to ePay Payslip process that payslips should be attached to the URL ID.
Y/N Table Edit
Default Value: Y

8 GP_PSLP_CTLFILE Character(254) VARCHAR2(254) NOT NULL name of flat file containing guide data for ePay payslips.

9 GP_PSLP_SOURCEFILE Character(254) VARCHAR2(254) NOT NULL Filename of payslip PDF to be split and/or attached by the ePay payslip process.

10 GP_PSLP_SOURCELOC Character(254) VARCHAR2(254) NOT NULL Location where source PDF is stored for ePay payslips to split and or attach.

11 GP_PSLP_WORKINGLOC Character(254) VARCHAR2(254) NOT NULL Working Location (directory) for ePay Payslip process

12 GP_PSLP_FILELAYOUT Character(30) VARCHAR2(30) NOT NULL file layout used to read guide data if payslip process provided guide data to ePay Payslip process using a flat file.

13 GP_PSLP_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve payslip pdfs.

14 GP_PSLP_CLEANUP Character(1) VARCHAR2(1) NOT NULL indicate to ePay Payslip process what level of cleanup should be performed after it is complete.

15 GP_OSPLATFORM Character(4) VARCHAR2(4) NOT NULL Operating System Platform. Valid Values are: UNIX, MSFT

#	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	GP_PSLP_PROCNAME	Character(12)	VARCHAR2(12) NOT NULL	ePay Procedure Name COPY=Reprint Payslip Copy GEN=Generate Payslip RGEN=Regenerate Payslip RNUM=Renumber Payslip
4	GP_PSLP_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	This field is the job or process instance used internally by the processes in the Payslip Job Definition and ePay.
5	GP_PSLP_DATAINST	Number(10,0)	DECIMAL(10) NOT NULL	This field is the job instance used internally by the processes in the Payslip Job Definition
6	GP_PSLP_SPLIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicate if ePay is being asked to split the source pdf into payslip files. Y/N Table Edit Default Value: Y
7	GP_PSLP_ATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	indicate to ePay Payslip process that payslips should be attached to the URL ID. Y/N Table Edit Default Value: Y
8	GP_PSLP_CTLFILE	Character(254)	VARCHAR2(254) NOT NULL	name of flat file containing guide data for ePay payslips.
9	GP_PSLP_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of payslip PDF to be split and/or attached by the ePay payslip process.
10	GP_PSLP_SOURCELOC	Character(254)	VARCHAR2(254) NOT NULL	Location where source PDF is stored for ePay payslips to split and or attach.
11	GP_PSLP_WORKINGLOC	Character(254)	VARCHAR2(254) NOT NULL	Working Location (directory) for ePay Payslip process
12	GP_PSLP_FILELAYOUT	Character(30)	VARCHAR2(30) NOT NULL	file layout used to read guide data if payslip process provided guide data to ePay Payslip process using a flat file.
13	GP_PSLP_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve payslip pdfs.
14	GP_PSLP_CLEANUP	Character(1)	VARCHAR2(1) NOT NULL	indicate to ePay Payslip process what level of cleanup should be performed after it is complete.
15	GP_OSPLATFORM	Character(4)	VARCHAR2(4) NOT NULL	Operating System Platform. Valid Values are: UNIX, MSFT