PA_HST_OTH_EARN

(SQL Table)
 Index Back

Historical Payroll Data

This is an employee table containing Historical Payroll Data. This is copied directly from the Payroll tables and retained within Pension.

  • Parent record: PAY_EARNINGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
    8 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: ERN_PROG_DESCR

    9 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    10 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other Hours
    11 OTH_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Earnings