VC_GRP_PERS_VW(SQL View) |
Index Back |
|---|---|
Plan member viewsVariable 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 |
| # | 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 Rcd Nbr
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 |