VC_WRD_PLAN_VW

(SQL View)
 Index Back

VC Plan prompt view

Variable Comp: this view returns VC Plan for a given approver. (Ad-hoc and EE-VC plan types)

SELECT C.APPROVER_ID , A.VC_PLAN_ID , A.DESCR50 , C.VC_APPROVAL_IND FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_EFFDT C , PS_VC_PAYPRD_TBL D WHERE A.VC_PLAN_ID = C.VC_PLAN_ID AND %EffdtCheck(VC_PLAN_EFFDT, C, D.PRD_END_DT) AND C.EFF_STATUS = 'A' AND C.VC_APPROVAL_IND = 'Y' AND C.VC_PLAN_ID = D.VC_PLAN_ID AND A.VC_PLAN_MEM_CRIT IN ('A','E') AND EXISTS ( SELECT 'X' FROM PS_VC_AWARD_VW AV WHERE AV.VC_PLAN_ID = D.VC_PLAN_ID AND AV.VC_PAYOUT_PRD_ID = D.VC_PAYOUT_PRD_ID)

  • Related Language Record: VC_WRD_PLAN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPROVER_ID Character(11) VARCHAR2(11) NOT NULL Approver EmplID
    2 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 VC_APPROVAL_IND Character(2) VARCHAR2(2) NOT NULL Approve Awards