GPHK_DEPART_DTL (SQL Table)	Index Back
Departure Details of Employees For the purposes of IR Statutory reporting, we need to capture departure from Hong Kong details. This information applies only to employees who are not citizens of the country. The information is required when an overseas employee is terminated.

GPHK_DEPART_DTL

(SQL Table)

Departure Details of Employees

For the purposes of IR Statutory reporting, we need to capture departure from Hong Kong details. This information applies only to employees who are not citizens of the country. The information is required when an overseas employee is terminated.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPHK_CNTRY_DPRT_DT Date(10) DATE The date on which an employee is expected to depart the country. This field applies mainly to employees who come into the country for work purposes and leave after a specified duration.

3 GPHK_DEPART_RSN Character(1) VARCHAR2(1) NOT NULL The reason for which an overseas employee is leaving the country.
0=Other
1=Move to Another Country
2=Expatriate - Returning Home
3=Expatriate - Move
Default Value: 0

4 GPHK_RETURN_DATE Date(10) DATE The expected date of return to Hong Kong incase the employee will return.

5 GPHK_CNTRY_MOVE_TO Character(3) VARCHAR2(3) NOT NULL The country to which the employee is departing.
Prompt Table: COUNTRY_TBL

6 GPHK_DPRT_OTH_RSN Character(30) VARCHAR2(30) NOT NULL Reasons for departure other than those specified by IRD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	GPHK_CNTRY_DPRT_DT	Date(10)	DATE	The date on which an employee is expected to depart the country. This field applies mainly to employees who come into the country for work purposes and leave after a specified duration.
3	GPHK_DEPART_RSN	Character(1)	VARCHAR2(1) NOT NULL	The reason for which an overseas employee is leaving the country. 0=Other 1=Move to Another Country 2=Expatriate - Returning Home 3=Expatriate - Move Default Value: 0
4	GPHK_RETURN_DATE	Date(10)	DATE	The expected date of return to Hong Kong incase the employee will return.
5	GPHK_CNTRY_MOVE_TO	Character(3)	VARCHAR2(3) NOT NULL	The country to which the employee is departing. Prompt Table: COUNTRY_TBL
6	GPHK_DPRT_OTH_RSN	Character(30)	VARCHAR2(30) NOT NULL	Reasons for departure other than those specified by IRD