GPHK_ABS_R_HST

(SQL Table)
 Index Back

Payslip Absence result values

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

  • Related Language Record: GPHK_ABS_RL_HST

    • # 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    9 GPHK_ACUM_VAL1 Signed Number(16,2) DECIMAL(14,2) NOT NULL This field will be used to store the value of accumulator 1 used for on-line and hard-copy payslips.
    10 GPHK_ACUM_VAL2 Signed Number(16,2) DECIMAL(14,2) NOT NULL This field will be used to store the value of accumulator 2 used for on-line and hard-copy payslips.
    11 GPHK_ACUM_VAL3 Signed Number(16,2) DECIMAL(14,2) NOT NULL This field will be used to store the value of accumulator 3 used for on-line and hard-copy payslips.
    12 GPHK_ACUM_VAL4 Signed Number(16,2) DECIMAL(14,2) NOT NULL This field will be used to store the value of accumulator 4 used for on-line and hard-copy payslips
    13 GPHK_DESC_TYPE Character(2) VARCHAR2(2) NOT NULL This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered).
    10=Description
    20=Custom
    30=Element Name
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description