VC_GRP_PERS_VW

(SQL View)
 Index Back

Plan member views

Variable Comp: this view is used to display and manage plan members

SELECT C.GB_OPRID , C.PNLGRPNAME , A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID , A.EMPLID , A.EMPL_RCD , A.AS_OF_DATE , B.NAME , A.PRORATE_FACTOR , A.VC_ELIG_STATUS FROM PS_VC_PLAN_MEM A , PS_PERSON_NAME B , PS_VC_CHK_CPGRP_VW C WHERE A.EMPLID = B.EMPLID AND A.VC_PLAN_ID = C.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = C.VC_PAYOUT_PRD_ID AND A.GB_GROUP_ID = C.GB_GROUP_ID

  • Related Language Record: PERSON_NAME_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

    Default Value: DERIVED_HR_VC.GB_OPRID

    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Default Value: DERIVED_HR_VC.PNLGRPNAME

    3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

    Default Value: VC_PLNMEMGRP_VW.VC_PLAN_ID

    Prompt Table: VC_PLAN_TBL

    4 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

    Default Value: VC_PLNMEMGRP_VW.VC_PAYOUT_PRD_ID

    5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Default Value: VC_PLNMEMGRP_VW.GB_GROUP_ID

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: VC_ACT_PERS_VW

    8 AS_OF_DATE Date(10) DATE NOT NULL As of Date
    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 PRORATE_FACTOR Number(8,3) DECIMAL(7,3) NOT NULL Prorate Factor
    11 VC_ELIG_STATUS Character(2) VARCHAR2(2) NOT NULL Eligibility Status
    AE=Auto Eligible
    AI=Auto Ineligible
    EP=Eligible with Proration
    ME=Manual Eligible
    MI=Manual Ineligble

    Default Value: ME