UPG_EARNS_DIST

(SQL Table)
 Index Back

EE Job Earnings Distribution

JOB_EARNS_DIST is a subordinate record to JOB. Use this record to specify how an employee's earnings should be posted for accounting purposes. For example, earnings can be posted to a job code, a department, a location, a General Ledger account, a position, or distributed among several categories.

  • Parent record: JOB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: JOB.EFFDT

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    8 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    9 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: %EDITTABLE

    10 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

    11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    12 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS

    Prompt Table: ERN_PROG_DESCR

    13 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    14 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    15 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR