| # |
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
Default Value: E
|
| 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.
Prompt Table:
GPHK_TAXREF_TBL
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 6 |
GPHK_PRD_BGN_DT |
Date(10) |
DATE |
The Begin date is required for the purpose of reporting.
|
| 7 |
GPHK_PRD_END_DT |
Date(10) |
DATE |
The End date is required for the purpose of reporting.
|
| 8 |
GPHK_ISSUE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Issue status describes the level of the report. A level is whether a report has been issued (by printing) or Not Issued or On Hold (Awaiting further action).
0=On Hold
1=Issued
2=Not Issued
Default Value: 2
|
| 9 |
GPHK_IR56_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The status is used to identify if the employee record for IR56 is original or Replacement.
O=Original
R=Replacement
|
| 10 |
GPHK_SHEET_NUM |
Number(6,0) |
INTEGER NOT NULL |
Sheet Number is a system-generated number to identify a sequential record in the IR56B printout.
|
| 11 |
GPHK_IR56_REMARKS |
Character(60) |
VARCHAR2(60) NOT NULL |
A brief description of the IR56 record.
|
| 12 |
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
Prompt Table:
GPHK_OVS_CNCRN
|
| 13 |
GPHK_OVSEAS_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
This field is used to display overseas amount for an employee.
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
CURRENCY_CD_ER |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
GPHK_PD_LTR_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
This field is used by Global payroll Hong Kong. The purpose of this field is to capture the amount that will be paid at a later date to the employee (and not within the tax period)
|
| 17 |
GPHK_WITHHELD_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
The amount withheld from employee salary for tax purposes.
|
| 18 |
GPHK_WTHELD_RSN |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used by Global payroll Hong Kong. The purpose pf this field is to capture the reason for withhold holding from employees.
|
| 19 |
GPHK_EMPLR_PD_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
The amount of taxes paid by employer for an employee. This information is needed for IR56 reporting.
|
| 20 |
GPHK_NEW_ER_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Name of the new employer where the employee is likely to join
|
| 21 |
GPHK_NEW_ER_ADR |
Character(60) |
VARCHAR2(60) NOT NULL |
Address of the new employer where the employee is likely to join
|
| 22 |
GPHK_FLUCTE_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
GPHK - Fluctuating Emoluments paid to the employee by the company and that must be reported on the IR56 documents
|
| 23 |
GPHK_MTH_ALW_RT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Monthly allowances paid to the employee and not maintiained by payroll system, but must be reported on the ir56 documents
|
| 24 |
GPHK_EF_SENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a flag to identify if a record has been used in the electronic file
C=Not Submitted
S=Data Submitted in File
U=Supplementary
|
| 25 |
GPHK_ER_TX_PD_CY |
Character(1) |
VARCHAR2(1) NOT NULL |
GPHK - Will employer bear the tax amount for the current year
Y/N Table Edit
|
| 26 |
GPHK_EE_FUTURE_ADR |
Character(90) |
VARCHAR2(90) NOT NULL |
A brief description of the IR56 record.
|
| 27 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 28 |
GPHK_STPD_BDT |
Date(10) |
DATE |
This field is used by global payroll Hong Kong. The purpose of this field is to capture the Begin date of Salaries tax paid by employer.
|
| 29 |
GPHK_STPD_EDT |
Date(10) |
DATE |
This field is used by global payroll Hong Kong. The purpose of this field is to capture the End date of Salaries tax paid by employer.
|
| 30 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 31 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table:
NID_TYPE_TBL
|
| 32 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 33 |
PASSPORT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Passport Number
|
| 34 |
GPHK_SHARE_GRANTED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field holds a user entered value to indicate whether share options have been granted to the employee..
Y/N Table Edit
|
| 35 |
GPHK_SHARE_EXER |
Number(8,0) |
INTEGER NOT NULL |
Total Share quantity that has not been exercised by the employee
|
| 36 |
GRANT_DT |
Date(10) |
DATE |
Grant Date
|