WCS_VC_HIST_VW

(SQL View)
 Index Back

VC History View

View of varable compensation award data used in the Variable Compensation History grid on the MSS Individual Details page (WCS_ECM_MSS_DET).

SELECT A.EMPLID , A.EMPL_RCD , A.VC_AWARD_DT , A.VC_PLAN_ID , B.VC_PLAN_TYPE , B.DESCR50 , A.VC_AWARD_VALUE , A.CURRENCY_CD , A.VC_ACTUAL_AWD_UNIT , D.VC_VALUE_AMOUNT , A.GB_GROUP_ID FROM PS_VC_AWARD A , PS_VC_PLAN_TBL B , PS_VC_PLAN_EFFDT C , PS_VC_VALUE_TBL D WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_AWARD_STATUS IN ('A','D','P','T','S') AND B.VC_PLAN_ID = C.VC_PLAN_ID AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT C1 WHERE C1.VC_PLAN_ID = C.VC_PLAN_ID AND C1.EFFDT <= %CurrentDateIn) AND C.VC_VALUATION_ID = D.VC_VALUATION_ID UNION SELECT A.EMPLID , A.EMPL_RCD , A.VC_AWARD_DT , A.VC_PLAN_ID , B.VC_PLAN_TYPE , B.DESCR50 , A.VC_AWARD_VALUE , A.CURRENCY_CD , 0 , 0 , A.GB_GROUP_ID FROM PS_VC_AWARD A , PS_VC_PLAN_TBL B , PS_VC_PLAN_EFFDT C WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_AWARD_STATUS IN ('A','D','P','T','S') AND B.VC_PLAN_ID = C.VC_PLAN_ID AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT C1 WHERE C1.VC_PLAN_ID = C.VC_PLAN_ID AND C1.EFFDT <= %CurrentDateIn) AND C.VC_VALUATION_ID = ' '

  • Related Language Record: WCS_VC_HIST_VLN

    • # 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_AWARD_DT Date(10) DATE Award Date
    4 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    5 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
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 VC_ACTUAL_AWD_UNIT Number(15,6) DECIMAL(14,6) NOT NULL Actual Award
    10 VC_VALUE_AMOUNT Number(19,6) DECIMAL(18,6) NOT NULL Amount
    11 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.