GP_SS_PSLP_OPT(SQL Table) |
Index Back |
---|---|
Payslip Options by CountryPayslip 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. |