JOB_EARNS_VW

(SQL View)
 Index Back

View Job Earns Distrib w/o PC

JOB_EARNS_VW is a view of the Job Earnings Distribution record, which screens out most PeopleCode for the Position Management application. All text, numeric, and required date fields are included. This record is in a work scroll on the Position Data 1 panel, and is used to control the cross-update to Job Earnings Distributions from Position_Data. Please note: if you modify the Job Earnings Distribution record to add columns, this view will need to be changed to include the new fields if Position Management is used.

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,POSITION_NBR ,BUSINESS_UNIT ,DEPTID ,JOBCODE ,GL_PAY_TYPE ,ACCT_CD ,SHIFT ,LOCATION ,ERNCD ,COMPRATE ,DIST_PCT ,STD_HOURS FROM PS_JOB_EARNS_DIST

  • Parent record: JOB

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

    Prompt Table: PERSON

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

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: ACCT_CD_TBL

    11 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

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

    Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS

    Prompt Table: ERN_PROG_DESCR

    14 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    15 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    16 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours