GPTH_NRP_PED_VW (SQL View)	Index Back
GPTH Packager View Packager view for earnings and deductions pin nums associated with payslip tempalte

GPTH_NRP_PED_VW

(SQL View)

GPTH Packager View

Packager view for earnings and deductions pin nums associated with payslip tempalte

SELECT GPTH_PAYSLIP_ID ,EFFDT ,SEQ_NUM ,SEQ_NUM5 ,PIN_NUM +50000000 ,GPTH_DESC_TYPE ,DESCR ,GPTH_BSE_COMP_YN ,GPTH_PCT_COMP_YN ,GPTH_RTE_COMP_YN ,GPTH_UNT_COMP_YN ,GPTH_YTD_AC_AMT +50000000 ,GPTH_YTD_AC_UNITS +50000000 ,GPTH_YTD_AC_AMT_YN ,GPTH_YTD_AC_UNT_YN FROM PS_GPTH_PSLP_ED

Parent record: GPHK_PSLP_SECT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPTH_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL This field is used to uniquely identify a payslip template.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

6 GPTH_DESC_TYPE Character(2) VARCHAR2(2) NOT NULL This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered).
10=Description
20=Custom
30=Element Name

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

8 GPTH_BSE_COMP_YN Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the base component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit
Default Value: Y

9 GPTH_PCT_COMP_YN Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the percent component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit
Default Value: Y

10 GPTH_RTE_COMP_YN Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the rate component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit
Default Value: Y

11 GPTH_UNT_COMP_YN Character(1) VARCHAR2(1) NOT NULL This field is used to specify if the unit component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit
Default Value: Y

12 GPTH_YTD_AC_AMT Number(8,0) INTEGER NOT NULL This field will be used to store the pin num of the year-to-date amount accumulator that will be included on the on-line and hard-copy payslips.

13 GPTH_YTD_AC_UNITS Number(8,0) INTEGER NOT NULL This field will be used to store the pin num of the year-to-date unit accumulator that will be included on the on-line and hard-copy payslips.

14 GPTH_YTD_AC_AMT_YN Character(1) VARCHAR2(1) NOT NULL This field is used to control the display of YTD Amount on the payslip
Y/N Table Edit
Default Value: Y

15 GPTH_YTD_AC_UNT_YN Character(1) VARCHAR2(1) NOT NULL This field is used to control the display of YTD Units on the payslip
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPTH_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	This field is used to uniquely identify a payslip template.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
6	GPTH_DESC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered). 10=Description 20=Custom 30=Element Name
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	GPTH_BSE_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the base component of an earning or deduction will be included on the on-line and hard-copy payslips. Y/N Table Edit Default Value: Y
9	GPTH_PCT_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the percent component of an earning or deduction will be included on the on-line and hard-copy payslips. Y/N Table Edit Default Value: Y
10	GPTH_RTE_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the rate component of an earning or deduction will be included on the on-line and hard-copy payslips. Y/N Table Edit Default Value: Y
11	GPTH_UNT_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the unit component of an earning or deduction will be included on the on-line and hard-copy payslips. Y/N Table Edit Default Value: Y
12	GPTH_YTD_AC_AMT	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin num of the year-to-date amount accumulator that will be included on the on-line and hard-copy payslips.
13	GPTH_YTD_AC_UNITS	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin num of the year-to-date unit accumulator that will be included on the on-line and hard-copy payslips.
14	GPTH_YTD_AC_AMT_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to control the display of YTD Amount on the payslip Y/N Table Edit Default Value: Y
15	GPTH_YTD_AC_UNT_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to control the display of YTD Units on the payslip Y/N Table Edit Default Value: Y