VC_COMP_JOB_VW

(SQL View)
 Index Back

VC Current Comp View

Variable Compensation current compensation view from JOB.

SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.EFFSEQ ,J.BUSINESS_UNIT ,J.DEPTID ,J.LOCATION ,J.SAL_ADMIN_PLAN ,J.GRADE ,J.COMPRATE ,J.CURRENCY_CD ,J.COMP_FREQUENCY ,J.ANNUAL_RT ,J.JOBCODE ,C.DESCRSHORT FROM PS_JOB J , PS_JOBCODE_TBL C WHERE J.EFFDT = ( SELECT MAX (J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX (J3.EFFSEQ) FROM PS_JOB J3 WHERE J3.EMPLID = J.EMPLID AND J3.EMPL_RCD = J.EMPL_RCD AND J3.EFFDT = J.EFFDT) AND C.EFFDT = ( SELECT MAX (C2.EFFDT) FROM PS_JOBCODE_TBL C2 WHERE C2.SETID = C.SETID AND C2.JOBCODE = C.JOBCODE AND C2.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND J.JOBCODE = C.JOBCODE AND J.SETID_JOBCODE = C.SETID

  • Related Language Record: VC_C_JOB_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 JOB_EFFDT Date(10) DATE Job Effective Date
    4 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    8 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    12 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    13 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    14 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description