VC_GGRP_PRMPLNG

(SQL View)
 Index Back

Group prompt view

Variable Comp: This view is used as a prompt in the run control panel of the process Approve award by group.

SELECT A.GB_OPRID , A.PNLGRPNAME , B.MANAGER_ID , A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID , B2.LANGUAGE_CD , B2.DESCR FROM PS_VC_CHK_CPGRP_VW A , PS_GB_GROUP_TBL B , PS_GB_GROUPTBL_LNG B2 WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_GROUP_TBL WHERE GB_GROUP_ID = A.GB_GROUP_ID AND EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.GB_GROUP_ID = B2.GB_GROUP_ID AND B.EFFDT = B2.EFFDT

  • Related Language Record for VC_GGRP_PRMP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    3 APPROVER_ID Character(11) VARCHAR2(11) NOT NULL Approver EmplID
    4 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    5 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
    6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description