GPHK_I56_RUNCTL(SQL Table) |
Index Back |
|---|---|
Run control record for GP HKThis 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 | 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: 0 |
| 7 | GPHK_REPRINT_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field allows users to reprint an IR56 report.
Y/N Table Edit Default Value: N |
| 8 | GPHK_IR56B_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field is required to identify if the report to be generated is a hardcopy output or a simple listing that is required IR56B as a supporting document.
1=Hardcopy Report 2=Control List Default Value: 1 |
| 9 | GPHK_TXYR_BDT | Date(10) | DATE | The field is used to store the beginning date value of the tax year |
| 10 | GPHK_TXYR_EDT | Date(10) | DATE | The field is used to store the End date value of the tax year. |
| 11 | GPHK_PRD_BGN_DT | Date(10) | DATE | The Begin date is required for the purpose of reporting. |
| 12 | GPHK_PRD_END_DT | Date(10) | DATE | The End date is required for the purpose of reporting. |
| 13 | PRINT_DATE | Date(10) | DATE |
Print Date
Default Value: %date |
| 14 | CREATION_DT | Date(10) | DATE |
Creation Date
Default Value: %date |
| 15 | 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 |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 17 | GPHK_56B_MANUAL_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field allows users to reprint an IR56B report for all manual submission only.
Y/N Table Edit |