GPHK_MPF_R_HST

(SQL Table)
Index Back

GP HKG - MPF Result

This is the Archive(shadow) table used in Data Archiving for the record: GPHK_MPF_RSLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 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)
11 GPHK_PERIOD_TYPE Character(3) VARCHAR2(3) NOT NULL Period type for MPF
12 START_DT Date(10) DATE Start Date
13 END_DATE Date(10) DATE End Date
14 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
15 GPHK_BASE_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Amount
16 GPHK_TRUSTEE_DATE Date(10) DATE Trustee date