GPHK_I56_XML_RC (SQL Table)	Index Back
Run control record for GP HK This is the run control record for processing Inland Revenue reporting for Global Payroll Hong Kong.

GPHK_I56_XML_RC

(SQL Table)

Run control record for GP HK

This is the run control record for processing Inland Revenue reporting for Global Payroll Hong Kong.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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_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.
Prompt Table: GPHK_TAXREF_TBL

5 GPHK_RECREATE_YN Character(1) VARCHAR2(1) NOT NULL This field is used to control IR56 processing. Users need to be allowed recreate data for the purposes of reporting.
Y/N Table Edit
Default Value: N

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

7 GPHK_EFL_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL This field identifies if the electronic file generation process is a test run
Y/N Table Edit
Default Value: N

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

9 XML_SET Character(5) VARCHAR2(5) NOT NULL XML Set
Prompt Table: XML_SET_TBL

10 XML_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type
Prompt Table: XML_TEMPLT_TBL

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
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_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. Prompt Table: GPHK_TAXREF_TBL
5	GPHK_RECREATE_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to control IR56 processing. Users need to be allowed recreate data for the purposes of reporting. Y/N Table Edit Default Value: N
6	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
7	GPHK_EFL_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field identifies if the electronic file generation process is a test run Y/N Table Edit Default Value: N
8	SAMPLE_MESSAGE	Character(1)	VARCHAR2(1) NOT NULL	Sample Message
9	XML_SET	Character(5)	VARCHAR2(5) NOT NULL	XML Set Prompt Table: XML_SET_TBL
10	XML_TEMPLATE_ID	Character(3)	VARCHAR2(3) NOT NULL	Template type Prompt Table: XML_TEMPLT_TBL
11	FILE_PATH	Character(127)	VARCHAR2(127) NOT NULL	Input/Output file path
12	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name