GPHK_NRP_RPT_AD (SQL Table)	Index Back
Reporting elements definition The report table is a setup table that contains the various elements that appear in the statutory reports for Hong Kong. Peoplesoft will populate the contents of the table for the purpose of reporting. Users have the ability to associate one or more payroll accumulator(s) to the Key field (GPHK_REPORT_ELM) field.

GPHK_NRP_RPT_AD

(SQL Table)

Reporting elements definition

The report table is a setup table that contains the various elements that appear in the statutory reports for Hong Kong. Peoplesoft will populate the contents of the table for the purpose of reporting. Users have the ability to associate one or more payroll accumulator(s) to the Key field (GPHK_REPORT_ELM) field.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 GPHK_REPORT_ELM Character(2) VARCHAR2(2) NOT NULL Report elements are predetermined values that appear in a report. This field contains labels of various monetary informations' that should be reported on a statutory report.

3 EFFDT Date(10) DATE Effective Date

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

5 GPHK_MATH_OPR Character(1) VARCHAR2(1) NOT NULL Math Operation to perform on the Accumulator
0=Add
1=Subtract

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	GPHK_REPORT_ELM	Character(2)	VARCHAR2(2) NOT NULL	Report elements are predetermined values that appear in a report. This field contains labels of various monetary informations' that should be reported on a statutory report.
3	EFFDT	Date(10)	DATE	Effective Date
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	GPHK_MATH_OPR	Character(1)	VARCHAR2(1) NOT NULL	Math Operation to perform on the Accumulator 0=Add 1=Subtract