GPHK_IR56_REP (SQL Table)	Index Back
Table for IR56 Monetary record The table is used to store the results of the data generated by the data creation process. This data will be used for viewing and generating electronic file and / or hard copy reports. Monetary values are associated to specific report elements. Users have the ability to link 1 or more payroll accumulators to a report element. This table holds the high-level report element id.

GPHK_IR56_REP

(SQL Table)

Table for IR56 Monetary record

The table is used to store the results of the data generated by the data creation process. This data will be used for viewing and generating electronic file and / or hard copy reports. Monetary values are associated to specific report elements. Users have the ability to link 1 or more payroll accumulators to a report element. This table holds the high-level report element id.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPHK_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL A single process is used to create data for various reports. The report type is used to differentiate employee records residing in the temporary table.
0=Select Report To Process
E=Annual Return for Employees
F=Notifying Terminating Employee
G=Notify Employee Departing HKG
N=Annual Return for Non-Employee
W=Notifying New Employee

2 GPHK_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax year is the year for which statutory reports have to be submitted. For the purposes of reporting this field is required on the run control page.

3 GPHK_SERIAL_NUM Number(2,0) SMALLINT NOT NULL Serial Number is needed by the data creation process to store multiple copies of information for the same employee for a given tax year.

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 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.
Prompt Table: GPHK_REPT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPHK_REPORT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A single process is used to create data for various reports. The report type is used to differentiate employee records residing in the temporary table. 0=Select Report To Process E=Annual Return for Employees F=Notifying Terminating Employee G=Notify Employee Departing HKG N=Annual Return for Non-Employee W=Notifying New Employee
2	GPHK_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax year is the year for which statutory reports have to be submitted. For the purposes of reporting this field is required on the run control page.
3	GPHK_SERIAL_NUM	Number(2,0)	SMALLINT NOT NULL	Serial Number is needed by the data creation process to store multiple copies of information for the same employee for a given tax year.
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	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. Prompt Table: GPHK_REPT_TBL