HP_PAYCHKERN_WK

(SQL Table)
 Index Back

Pay Check Earnings

This table contains earnings information created during the payroll calculation process. A separate record will be created for each earnings code.

  • Parent record: PAY_CHECK

    • # 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

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    10 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    13 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    14 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    15 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    16 EARNINGS Signed Number(15,2) DECIMAL(13,2) NOT NULL Earnings
    17 REVERSED Character(1) VARCHAR2(1) NOT NULL Reversed

    Y/N Table Edit

    Default Value: N

    18 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
    N=No
    Y=Yes
    19 BUDGET_DEPTID Character(10) VARCHAR2(10) NOT NULL Budget with Department
    20 DIST_PRORATE_OPTN Character(1) VARCHAR2(1) NOT NULL Distribution Prorate Option
    C=Calendar Days
    I=For Internal System Use Only
    N=Not Applicable
    W=Work Days
    21 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID

    Default Value: 1

    22 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type

    Default Value: 2

    23 EX_LINE_NBR Number(5,0) INTEGER NOT NULL Expense Line #

    Default Value: 3

    24 DIST_CHECK_STATUS Character(1) VARCHAR2(1) NOT NULL PayCheck Distribution Status
    F=Rev Check - Release Fund Req
    N=Regular Check
    R=Rev Check - Release Fund Comp
    X=Same Pay Period Reversal / Adj

    Default Value: N

    25 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
    26 EARNS_END_DT Date(10) DATE Earnings End Date