GPHK_56B_XML_BD(SQL Table) |
Index Back |
|---|---|
Temp Record for IR56B detailsThis record is used as a structure for the IR56B XML file Detail record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPHK_FL_TAX_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 2 | 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. |
| 3 | GPHK_FL_SHEET_NO |
Character(6) | VARCHAR2(6) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | GPHK_FL_CREATE_DT | Character(8) | VARCHAR2(8) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 6 | GPHK_FL_EE_IC_NO | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 7 | 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 |
| 8 | GPHK_FL_EE_SURNAME | Character(20) | VARCHAR2(20) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 9 | GPHK_FL_EE_OTHNAME | Character(55) | VARCHAR2(55) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 10 | GPHK_FL_CHINESE_NM | Character(50) | VARCHAR2(50) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 11 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 12 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 13 | GPHK_FL_EE_PSP_DTL | Character(40) | VARCHAR2(40) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 14 | GPHK_FL_EE_SPS_NM | Character(50) | VARCHAR2(50) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 15 | GPHK_FL_EESP_ID_NO | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 16 | GPHK_FL_SPS_PP_DTL | Character(40) | VARCHAR2(40) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 17 | GPHK_FL_EE_RES_ADR | Character(90) | VARCHAR2(90) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 18 | GPHK_FL_EE_RES_ACD | Character(1) | VARCHAR2(1) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 19 | GPHK_FL_EE_COR_ADR | Character(60) | VARCHAR2(60) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 20 | GPHK_FL_JOB_DESCR | Character(40) | VARCHAR2(40) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 21 | GPHK_FL_PT_EMPR_NM | Character(30) | VARCHAR2(30) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 22 | GPHK_FL_EM_STRT_DT | Character(8) | VARCHAR2(8) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 23 | GPHK_FL_EM_END_DT | Character(8) | VARCHAR2(8) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 24 | GPHK_FL_SALWGE_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 25 | GPHK_FL_SALWGE_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 26 | GPHK_FL_LVEPAY_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 27 | GPHK_FL_LVEPAY_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 28 | GPHK_FL_DIRFEE_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 29 | GPHK_FL_DIRFEE_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 30 | GPHK_FL_CMNFEE_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 31 | GPHK_FL_CMNFEE_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 32 | GPHK_FL_BONUS_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 33 | GPHK_FL_BONUS_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 34 | GPHK_FL_TAGRT_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 35 | GPHK_FL_TAGRT_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 36 | GPHK_FL_RETIRE_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 37 | GPHK_FL_RETIRE_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 38 | GPHK_FL_TXPAID_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 39 | GPHK_FL_TXPAID_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 40 | GPHK_FL_EDUCTN_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 41 | GPHK_FL_EDUCTN_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 42 | GPHK_FL_SHROPT_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 43 | GPHK_FL_SHROPT_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 44 | GPHK_FL_ALW_DESCR1 | Character(35) | VARCHAR2(35) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 45 | GPHK_FL_ALLOW1_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 46 | GPHK_FL_ALLOW1_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 47 | GPHK_FL_ALW_DESCR2 | Character(35) | VARCHAR2(35) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 48 | GPHK_FL_ALLOW2_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 49 | GPHK_FL_ALLOW2_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 50 | GPHK_FL_ALW_DESCR3 | Character(35) | VARCHAR2(35) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 51 | GPHK_FL_ALLOW3_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 52 | GPHK_FL_ALLOW3_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 53 | GPHK_FL_PENSN_PRD | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 54 | GPHK_FL_PENSN_AMT | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 55 | GPHK_FL_TOT_INCOME | Character(9) | VARCHAR2(9) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 56 | GPHK_FL_QTR_IND | Character(1) | VARCHAR2(1) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 57 | GPHK_FL_QTR1_ADR | Character(110) | VARCHAR2(110) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 58 | GPHK_FL_QTR1_DESCR | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 59 | GPHK_FL_QTR1_PRD | Character(26) | VARCHAR2(26) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 60 | GPHK_FL_QTR1_ER2LL | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 61 | GPHK_FL_QTR1_EE2LL | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 62 | GPHK_FL_QTR1_ER2EE | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 63 | GPHK_FL_QTR1_EE2ER | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 64 | GPHK_FL_QTR2_ADR | Character(110) | VARCHAR2(110) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 65 | GPHK_FL_QTR2_DESCR | Character(19) | VARCHAR2(19) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 66 | GPHK_FL_QTR2_PRD | Character(26) | VARCHAR2(26) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 67 | GPHK_FL_QTR2_ER2LL | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 68 | GPHK_FL_QTR2_EE2LL | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 69 | GPHK_FL_QTR2_ER2EE | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 70 | GPHK_FL_QTR2_EE2ER | Character(7) | VARCHAR2(7) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 71 | GPHK_FL_OVSEAS_IND | Character(1) | VARCHAR2(1) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 72 | GPHK_FL_OVS_PD_AMT | Character(20) | VARCHAR2(20) NOT NULL | This is a unique code to identify the Overseas concern that made some payment to the employee |
| 73 | 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. |
| 74 | 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. |
| 75 | GPHK_FL_REMARKS | Character(60) | VARCHAR2(60) NOT NULL | This field is used for the purpose of IR56B electronic file creation. |