EMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMPIN_CODEGPHK_MPF_RSLT(SQL Table) |
Index Back |
|---|---|
GP HKG - MPF ResultHong Kong Mandatory Provident Fund result table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 7 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | PIN_CODE |
Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 9 | GPHK_PERIOD_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Period type for MPF |
| 10 | START_DT | Date(10) | DATE | Start Date |
| 11 | END_DATE | Date(10) | DATE | End Date |
| 12 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 13 | GPHK_BASE_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Base Amount |
| 14 | GPHK_TRUSTEE_DATE | Date(10) | DATE | Trustee date |