GPHK_I56_DT_TMP (SQL Table)	Index Back
Temp tbl IR56 Monetary record The TEMPORARY table is used to store the results of the data generated by the data creation process. The table is necessary for loading data that has been written so that subsequent rows to be inserted can be verified before copying.

GPHK_I56_DT_TMP

(SQL Table)

Temp tbl IR56 Monetary record

The TEMPORARY table is used to store the results of the data generated by the data creation process. The table is necessary for loading data that has been written so that subsequent rows to be inserted can be verified before copying.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 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

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

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

7 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

8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPHK_YTD_ACM_VW

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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
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	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.
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	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
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPHK_YTD_ACM_VW
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code