GPHK_I56_ELM_VW (SQL View)	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. The contents of this table are monetary in nature. 1 employee could have more than 1 record existing in the table.

GPHK_I56_ELM_VW

(SQL View)

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. The contents of this table are monetary in nature. 1 employee could have more than 1 record existing in the table.

SELECT DISTINCT GPHK_REPORT_TYPE ,GPHK_TAX_REF_NUM ,GPHK_TAX_YEAR ,GPHK_SERIAL_NUM ,EMPLID ,GPHK_REPORT_ELM FROM PS_GPHK_IR56_DTL

# 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_REF_NUM Character(20) VARCHAR2(20) NOT NULL This field will contain the tax reference number that Hong Kong Pay entities are associated with.

3 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.

4 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.

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

6 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_REF_NUM	Character(20)	VARCHAR2(20) NOT NULL	This field will contain the tax reference number that Hong Kong Pay entities are associated with.
3	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.
4	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.
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	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