GP_PSLP_TMPL (SQL Table)	Index Back
Payslip Template Definition Payslip Template Definition

GP_PSLP_TMPL

(SQL Table)

Payslip Template Definition

Related Language Record: GP_PSLP_TPL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_CNTRY_PSLP_TMPL Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_PSLP_CTRY_VW

2 GP_PSLP_TMPL Character(12) VARCHAR2(12) NOT NULL This field is used to uniquely identify a payslip template.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 GP_PSLP_PAGETYPE Character(4) VARCHAR2(4) NOT NULL Payslip Page Type
A4=A4
LTR=Letter

6 DEFN_ASOFDT_OPTN Character(1) VARCHAR2(1) NOT NULL DEFN_ASOFDT_OPTN
B=Calendar Period Begin Date
E=Calendar Period End Date
N=Not Applicable
P=Payment Date
R=Process Begin Date
S=Process End Date
Default Value: P
Prompt Table: GP_DEFASOFDT_VW

7 GP_CNTRY_PSLP_ELN Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY

8 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
Prompt Table: GP_PSLP_ELN1_VW

9 GP_PSLP_NET_ZERO Character(1) VARCHAR2(1) NOT NULL Generate Payslip when Net Zero
Y/N Table Edit
Default Value: Y

10 GP_PSLP_NET_NEG Character(1) VARCHAR2(1) NOT NULL Generate Payslip when Net Negative
Y/N Table Edit
Default Value: Y

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_CNTRY_PSLP_TMPL	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_PSLP_CTRY_VW
2	GP_PSLP_TMPL	Character(12)	VARCHAR2(12) NOT NULL	This field is used to uniquely identify a payslip template.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	GP_PSLP_PAGETYPE	Character(4)	VARCHAR2(4) NOT NULL	Payslip Page Type A4=A4 LTR=Letter
6	DEFN_ASOFDT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	DEFN_ASOFDT_OPTN B=Calendar Period Begin Date E=Calendar Period End Date N=Not Applicable P=Payment Date R=Process Begin Date S=Process End Date Default Value: P Prompt Table: GP_DEFASOFDT_VW
7	GP_CNTRY_PSLP_ELN	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY
8	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set Prompt Table: GP_PSLP_ELN1_VW
9	GP_PSLP_NET_ZERO	Character(1)	VARCHAR2(1) NOT NULL	Generate Payslip when Net Zero Y/N Table Edit Default Value: Y
10	GP_PSLP_NET_NEG	Character(1)	VARCHAR2(1) NOT NULL	Generate Payslip when Net Negative Y/N Table Edit Default Value: Y
11	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.
12	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.