GPHK_IR56_AET(SQL Table) |
Index Back |
|---|---|
Temporary Table for GP HKGThis is a temporary table used by IR56 creation for Hong Kong global payroll. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | 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 |
| 5 | 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. |
| 6 | 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. |
| 7 | 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. |
| 8 | GPHK_TXYR_BDT | Date(10) | DATE | The field is used to store the beginning date value of the tax year |
| 9 | GPHK_TXYR_EDT | Date(10) | DATE | The field is used to store the End date value of the tax year. |
| 10 | GPHK_PRD_BGN_DT | Date(10) | DATE | The Begin date is required for the purpose of reporting. |
| 11 | GPHK_PRD_END_DT | Date(10) | DATE | The End date is required for the purpose of reporting. |
| 12 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 13 | CREATION_DT | Date(10) | DATE | Creation Date |
| 14 | 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. |
| 15 | 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. |
| 16 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 17 | GPHK_BLANK_FLD | Character(1) | VARCHAR2(1) NOT NULL | This field is used by the IR56 data creation process. |
| 18 | GPHK_EFL_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This field identifies if the electronic file generation process is a test run |
| 19 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 20 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 21 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 22 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 23 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 24 | RT_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | Market Rate |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | CURRENCY_CD_ER | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | GPHK_PER_ORG_FLD1 | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |
| 28 | GPHK_PER_ORG_FLD2 | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |