POSN_EARNS_DIST

(SQL Table)
 Index Back

Position 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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: ACCT_CD_TBL

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

    Prompt Table: LOCATION_TBL

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

    Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS

    Prompt Table: ERN_PROG_DESCR

    10 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    11 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours