VC_WRD_PLAN_LNG

(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 , A2.LANGUAGE_CD , A2.DESCR50 FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_LANG A2 , PS_VC_ELIGSTAT_TBL B , PS_VC_PLAN_EFFDT C , PS_VC_PAYPRD_TBL D WHERE B.VC_PRCS_COMPLETE = 'Y' AND A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PLAN_ID = A2.VC_PLAN_ID AND B.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 B.VC_PAYOUT_PRD_ID = D.VC_PAYOUT_PRD_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 = B.VC_PLAN_ID AND AV.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID)

  • Related Language Record for VC_WRD_PLAN_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50