GP_SS_PSLP_OPT

(SQL Table)
Index Back

Payslip Options by Country

Payslip Options by Country

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRYSS_VW

2 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

Y/N Table Edit

Default Value: N

3 GP_PSLP_HDCPYOPTN Character(1) VARCHAR2(1) NOT NULL Enable Print Option in Self Service Y/N This option indicates whether or not the payee will be able to control the printing of their payslips (checks are always printed). If this option is set to yes, the ePay View Payslip page will display controls for the payee to turn on or off the printing of their payslips.

Y/N Table Edit

Default Value: N

4 GP_PSLP_BGNSSDFLT Signed Number(3,0) DECIMAL(2) NOT NULL Days After Payment Date Payslip becomes Available Online. ePay View Payslip page will read this value prior to displaying which payslips are available for viewing and only show payslips that meet the criteria entered here (in days).
5 GP_PSLP_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve payslip pdfs.

Default Value: GP_SS_PSLP_FTP

Prompt Table: GP_PSLP_URL_VW

6 GP_SS_MPSLP_ENABLE Character(1) VARCHAR2(1) NOT NULL mobile payslip

Y/N Table Edit

Default Value: N

7 GP_SS_MBSLP_GRIDCN Number(3,0) SMALLINT NOT NULL Mobile Epay

Default Value: 6

8 GP_SS_MHIST_RETR Number(2,0) SMALLINT NOT NULL Mobile Epay

Default Value: 24

9 GP_SS_MPSLP_BAL Character(1) VARCHAR2(1) NOT NULL balance

Y/N Table Edit

Default Value: Y

10 GP_SS_MPSLP_PDF Character(1) VARCHAR2(1) NOT NULL pdf link

Y/N Table Edit

Default Value: Y

11 GP_SS_MPSLP_NET Character(1) VARCHAR2(1) NOT NULL net pay

Y/N Table Edit

Default Value: Y

12 GP_SS_MPSLP_ABAL Character(1) VARCHAR2(1) NOT NULL absence balance

Y/N Table Edit

Default Value: Y

13 GP_SS_MPSLP_ALRT Character(1) VARCHAR2(1) NOT NULL Mobile Epay

Y/N Table Edit

Default Value: Y

14 GP_SS_MPSLP_DATA Character(4) VARCHAR2(4) NOT NULL Mobile Epay
CUST=Custom
DFLT=ePay Default
UDTC=Call Using ePay Default

Default Value: DFLT

15 GP_AE_APPLID Character(12) VARCHAR2(12) NOT NULL Application engine Prompt

Default Value: GP_SS_PSLP

Prompt Table: GP_AE_VW

16 GP_MPSLP_LST_CNT Character(3) VARCHAR2(3) NOT NULL list set country

Prompt Table: GP_COUNTRY

17 GP_MPSLP_LIST_SET Character(15) VARCHAR2(15) NOT NULL Mobile Epay

Default Value: MOBILE EPAY

Prompt Table: GP_MPSLP_LST_VW

18 GP_SS_MPSLP_MSG Character(1) VARCHAR2(1) NOT NULL Payslip Message

Y/N Table Edit

Default Value: Y

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.