GP_SS_PSLP_AET (SQL Table)	Index Back
State Record for process State Record for process

GP_SS_PSLP_AET

(SQL Table)

State Record for process

# 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 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

5 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.

6 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

7 GP_PSLP_SPLIT_IND Character(1) VARCHAR2(1) NOT NULL Indicate if ePay is being asked to split the source pdf into payslip files.

8 GP_PSLP_ATCH_IND Character(1) VARCHAR2(1) NOT NULL indicate to ePay Payslip process that payslips should be attached to the URL ID.

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

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

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

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

13 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.

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

15 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.

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

17 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

18 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

19 GP_PSLP_ISSUEHDCPY Character(1) VARCHAR2(1) NOT NULL Issue Hard Copy of payslip posed in the form of to Suppress the paper copy or to print it. Y means to suppress (do not print). N means to not suppress (print it).
N=Do Not Issue Paper Copies
Y=Issue Paper Copies
Default Value: Y

20 GP_PSLP_XFERMETHOD Character(4) VARCHAR2(4) NOT NULL field is used to trigger epay ae code to transfer payslip files using either bulkftp - 0000 (default), split to destination 0001 or file by file put attachment 0002.

#	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	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
5	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.
6	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
7	GP_PSLP_SPLIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicate if ePay is being asked to split the source pdf into payslip files.
8	GP_PSLP_ATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	indicate to ePay Payslip process that payslips should be attached to the URL ID.
9	GP_PSLP_CTLFILE	Character(254)	VARCHAR2(254) NOT NULL	name of flat file containing guide data for ePay payslips.
10	GP_PSLP_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of payslip PDF to be split and/or attached by the ePay payslip process.
11	GP_PSLP_SOURCELOC	Character(254)	VARCHAR2(254) NOT NULL	Location where source PDF is stored for ePay payslips to split and or attach.
12	GP_PSLP_WORKINGLOC	Character(254)	VARCHAR2(254) NOT NULL	Working Location (directory) for ePay Payslip process
13	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.
14	GP_PSLP_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve payslip pdfs.
15	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.
16	GP_OSPLATFORM	Character(4)	VARCHAR2(4) NOT NULL	Operating System Platform. Valid Values are: UNIX, MSFT
17	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
18	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
19	GP_PSLP_ISSUEHDCPY	Character(1)	VARCHAR2(1) NOT NULL	Issue Hard Copy of payslip posed in the form of to Suppress the paper copy or to print it. Y means to suppress (do not print). N means to not suppress (print it). N=Do Not Issue Paper Copies Y=Issue Paper Copies Default Value: Y
20	GP_PSLP_XFERMETHOD	Character(4)	VARCHAR2(4) NOT NULL	field is used to trigger epay ae code to transfer payslip files using either bulkftp - 0000 (default), split to destination 0001 or file by file put attachment 0002.