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

PY_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 PY_PSLP_PROCNAME Character(12) VARCHAR2(12) NOT NULL Process Names: US Checks = 'USCHECKS' US Manual checks = 'USMANCHK' CAN Cheques = 'CNCHEQUE' CAN Manual cheques = 'CNMANCHQ' US Deposit Advice = 'USADVICE' CAN Deposit Advice = 'CNADVICE'

5 PY_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 PY_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 PY_PSLP_SPLIT_IND Character(1) VARCHAR2(1) NOT NULL Indicate if ePay is being asked to split the source pdf into payslip files.

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

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

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

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

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

13 PY_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 PY_PSLP_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve payslip pdfs.

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

20 PY_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	PY_PSLP_PROCNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Names: US Checks = 'USCHECKS' US Manual checks = 'USMANCHK' CAN Cheques = 'CNCHEQUE' CAN Manual cheques = 'CNMANCHQ' US Deposit Advice = 'USADVICE' CAN Deposit Advice = 'CNADVICE'
5	PY_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	PY_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	PY_PSLP_SPLIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicate if ePay is being asked to split the source pdf into payslip files.
8	PY_PSLP_ATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	indicate to ePay Payslip process that payslips should be attached to the URL ID.
9	PY_PSLP_CTLFILE	Character(254)	VARCHAR2(254) NOT NULL	name of flat file containing guide data for ePay payslips.
10	PY_PSLP_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of payslip PDF to be split and/or attached by the ePay payslip process.
11	PY_PSLP_SOURCELOC	Character(254)	VARCHAR2(254) NOT NULL	Location where source PDF is stored for ePay payslips to split and or attach.
12	PY_PSLP_WORKINGLOC	Character(254)	VARCHAR2(254) NOT NULL	Working Location (directory) for ePay Payslip process
13	PY_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	PY_PSLP_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve payslip pdfs.
15	PY_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	PY_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	PY_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
20	PY_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.