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

GPHK_NRP_PED_VW

(SQL View)

GPHK Packager View

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

SELECT GPHK_PAYSLIP_ID ,EFFDT ,SEQ_NUM ,SEQ_NUM5 ,PIN_NUM +50000000 ,GPHK_DESC_TYPE ,DESCR ,GPHK_BSE_COMP_YN ,GPHK_PCT_COMP_YN ,GPHK_RTE_COMP_YN ,GPHK_UNT_COMP_YN ,GPHK_YTD_AC_AMT +50000000 ,GPHK_YTD_AC_UNITS +50000000 ,GPHK_YTD_AC_AMT_YN ,GPHK_YTD_AC_UNT_YN FROM PS_GPHK_PSLP_ED

Parent record: GPHK_PSLP_SECT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPHK_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 GPHK_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
Default Value: 10

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

8 GPHK_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 GPHK_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 GPHK_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 GPHK_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 GPHK_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 GPHK_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 GPHK_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 GPHK_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	GPHK_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	GPHK_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 Default Value: 10
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	GPHK_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	GPHK_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	GPHK_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	GPHK_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	GPHK_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	GPHK_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	GPHK_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	GPHK_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