HR_EC_MVC_VW

(SQL View)
 Index Back

Compensation History

Use in fluid Compensation History to retrieve monetary information from VC_AWARD.

SELECT A.EMPLID , A.EMPL_RCD , A.VC_PLAN_ID , A.VC_AWARD_DT , A.VC_AWARD_DT , A.VC_AWARD_VALUE , A.CURRENCY_CD , B.DESCR50 , B.VC_PLAN_TYPE , A.VC_PERF_FACTOR FROM PS_VC_AWARD A , PS_VC_PLAN_TBL B , PS_HREC_CFG_AWD_FL CFG WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND VC_PLAN_TYPE IN ('D', 'G','O','P') AND A.VC_AWARD_STATUS = CFG.VC_AWARD_STATUS AND CFG.HREC_INCLUDE_STS = 'Y'

  • Related Language Record: HR_EC_MVC_LV

    • # 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 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

    Prompt Table: VC_PLAN_TBL

    4 VC_AWARD_DT Date(10) DATE Award Date
    5 VC_SS_AWARD_DT Date(10) DATE Award Date
    6 VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: VC_PLAN_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    8 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    9 VC_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL VC Plan Type
    D=Discretionary Bonus
    G=Goal Sharing
    I=Stock - ISO
    K=Stock - NSAR
    N=Non-Monetary
    O=Other
    P=Profit Sharing
    Q=Stock - NQ
    R=Stock - RSA
    S=Stock- ISAR
    10 VC_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Performance Factor