GPHK_OVS_CNCRN (SQL Table)	Index Back
GPHK - Overseas Concern This table stores the overseas Concern details that pays employees an additional amount

GPHK_OVS_CNCRN

(SQL Table)

GPHK - Overseas Concern

This table stores the overseas Concern details that pays employees an additional amount

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPHK_OVS_CNC_CD Character(8) VARCHAR2(8) NOT NULL This is a unique code to identify the Overseas concern that made some payment to the employee

2 GPHK_OVSEAS_ADR Character(60) VARCHAR2(60) NOT NULL The address of an overseas concern making payment to an employee should be reported in the statutory reports.

3 GPHK_OVSEAS_CMPNY Character(60) VARCHAR2(60) NOT NULL When an employee is paid by an overseas concern, the company making the payment should be reported in the statutory reports.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPHK_OVS_CNC_CD	Character(8)	VARCHAR2(8) NOT NULL	This is a unique code to identify the Overseas concern that made some payment to the employee
2	GPHK_OVSEAS_ADR	Character(60)	VARCHAR2(60) NOT NULL	The address of an overseas concern making payment to an employee should be reported in the statutory reports.
3	GPHK_OVSEAS_CMPNY	Character(60)	VARCHAR2(60) NOT NULL	When an employee is paid by an overseas concern, the company making the payment should be reported in the statutory reports.