GPHK_PSLP (SQL Table)	Index Back
GP HKG - Payslip Definition GP HKG - Payslip definition record

GPHK_PSLP

(SQL Table)

GP HKG - Payslip Definition

GP HKG - Payslip definition record

Related Language Record: GPHK_PSLP_LANG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: HKG

6 GPHK_EXCL_PRNT Character(2) VARCHAR2(2) NOT NULL This field will be used to identify if there will be any exclusions (department or location) when generating the hard-copy payslips.
10=None
20=Department
30=Location
Default Value: 10

7 GPHK_DEL_OPT Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the delivery address for the payslip.
20=Department
30=Location
50=Home Address
60=Mail Address
Default Value: 50

8 GPHK_LBL_ACUM1 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips.

9 GPHK_LBL_ACUM2 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips.

10 GPHK_LBL_ACUM3 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips.

11 GPHK_LBL_ACUM4 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips.

12 GPHK_LBL_ACUM5 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips.

13 GPHK_LBL_ACUM6 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips.

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: HKG
6	GPHK_EXCL_PRNT	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify if there will be any exclusions (department or location) when generating the hard-copy payslips. 10=None 20=Department 30=Location Default Value: 10
7	GPHK_DEL_OPT	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify the delivery address for the payslip. 20=Department 30=Location 50=Home Address 60=Mail Address Default Value: 50
8	GPHK_LBL_ACUM1	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips.
9	GPHK_LBL_ACUM2	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips.
10	GPHK_LBL_ACUM3	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips.
11	GPHK_LBL_ACUM4	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips.
12	GPHK_LBL_ACUM5	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips.
13	GPHK_LBL_ACUM6	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips.