GPHK_56_XML_AET (SQL Table)	Index Back
Temporary Table for GP HKG This is a temporary table used by IR56 creation for Hong Kong global payroll.

GPHK_56_XML_AET

(SQL Table)

Temporary Table for GP HKG

This is a temporary table used by IR56 creation for Hong Kong global payroll.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 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

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

7 GPHK_TXYR_EDT Date(10) DATE The field is used to store the End date value of the tax year.

8 GPHK_EFL_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL This field identifies if the electronic file generation process is a test run

9 XML_SET Character(5) VARCHAR2(5) NOT NULL XML Set

10 XML_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type

11 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path

12 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

13 SAMPLE_MESSAGE Character(1) VARCHAR2(1) NOT NULL Sample Message

14 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

15 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	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
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	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.
7	GPHK_TXYR_EDT	Date(10)	DATE	The field is used to store the End date value of the tax year.
8	GPHK_EFL_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field identifies if the electronic file generation process is a test run
9	XML_SET	Character(5)	VARCHAR2(5) NOT NULL	XML Set
10	XML_TEMPLATE_ID	Character(3)	VARCHAR2(3) NOT NULL	Template type
11	FILE_PATH	Character(127)	VARCHAR2(127) NOT NULL	Input/Output file path
12	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
13	SAMPLE_MESSAGE	Character(1)	VARCHAR2(1) NOT NULL	Sample Message
14	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
15	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine