GPHK_NRP_I56_VW (SQL View)	Index Back
View for GP Packager This view is used as an export view for the GP packager.

GPHK_NRP_I56_VW

(SQL View)

View for GP Packager

This view is used as an export view for the GP packager.

SELECT GPHK_REPORT_TYPE ,GPHK_TAX_REF_NUM ,GPHK_TAX_YEAR ,GPHK_SERIAL_NUM ,EMPLID ,GPHK_REPORT_ELM ,PIN_NUM +50000000 ,CURRENCY_CD ,GPHK_MTRY_VALUE ,GPHK_MTRY_ADJST ,GPHK_CALC_RSLT_VAL ,GPHK_PRD_BGN_DT ,GPHK_PRD_END_DT 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

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

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

9 GPHK_MTRY_VALUE Signed Number(16,2) DECIMAL(14,2) NOT NULL The amount paid against a specific report element is stored

10 GPHK_MTRY_ADJST Signed Number(16,2) DECIMAL(14,2) NOT NULL Users need to have the ability to override an amount calculated by the process. Instead of modifying the generated amount, they can enter an adjustment that will be used to recalculate the amount to be reported.

11 GPHK_CALC_RSLT_VAL Signed Number(16,2) DECIMAL(14,2) NOT NULL GPHK Calculation Numeric Result - Set decimals to 2 places

12 GPHK_PRD_BGN_DT Date(10) DATE The Begin date is required for the purpose of reporting.

13 GPHK_PRD_END_DT Date(10) DATE The End date is required for the purpose of reporting.

#	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
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GP_PIN_NM_VW
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	GPHK_MTRY_VALUE	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	The amount paid against a specific report element is stored
10	GPHK_MTRY_ADJST	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Users need to have the ability to override an amount calculated by the process. Instead of modifying the generated amount, they can enter an adjustment that will be used to recalculate the amount to be reported.
11	GPHK_CALC_RSLT_VAL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	GPHK Calculation Numeric Result - Set decimals to 2 places
12	GPHK_PRD_BGN_DT	Date(10)	DATE	The Begin date is required for the purpose of reporting.
13	GPHK_PRD_END_DT	Date(10)	DATE	The End date is required for the purpose of reporting.