VC_PLNMEMGRP_VW

(SQL View)
 Index Back

Plan member view

Variable Comp: this view is used for scroll bars in plan members with group panel.

SELECT DISTINCT GB_OPRID , PNLGRPNAME , VC_PLAN_ID , VC_PAYOUT_PRD_ID , GB_GROUP_ID , DESCR FROM PS_VC_CHK_CPGRP_VW

  • Related Language Record: VC_PLNMEMGRPLNG

    • # 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 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    4 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
    5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description