GPHK_IR56_QTR

#	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_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.
3	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.
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.
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	GPHK_QTR_NUM	Number(2,0)	SMALLINT NOT NULL	A running serial number to allow users to enter multiple quarters information for a single employee.
7	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
8	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
9	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
10	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
11	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
14	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
15	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
16	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
17	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
18	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
19	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
21	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
22	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
23	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
24	GPHK_QTR_DESC	Character(20)	VARCHAR2(20) NOT NULL	A descriptive text of the housing quarters provided to the employee.
25	GPHK_QTR_BGN_DT	Date(10)	DATE	The date on which an employee started occupying the quarter.
26	GPHK_QTR_END_DT	Date(10)	DATE	The date until when an employee started occupying the quarter.
27	GPHK_QTR_ER2L_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid by an Employer to a Landlord for an employee occupying a housing quarter
28	GPHK_QTR_EE2L_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid by an Employee to a Landlord for occupying a housing quarter
29	GPHK_QTR_ER2EE_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid to an Employee by the employer for occupying a housing quarter. This could be a rent refunded to the employee.
30	GPHK_QTR_EE2ER_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid to an Employer by the employee for occupying a housing quarter. This could be a rent refunded to the employer.
31	GPHK_RFND_RENT	Character(1)	VARCHAR2(1) NOT NULL	Refund of rent Y/N Table Edit
32	GPHK_QTR_ER2L_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employer to Landlord total
33	GPHK_QTR_EE2L_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employee to Landlord Total
34	GPHK_QTR_ER2EE_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employer to Employee Total
35	GPHK_QTR_EE2ER_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employee to Employer Total