VC_PRD_GRP8_VW (SQL View)	Index Back
Tree Groups Security View Variable Comp: this view returns Trees/groups for a given VC Plan ID. The current plan is used (the last one processed by the eligibility process). GB_OPRID and PNLGRPNAME allow to check if the row is accessible for the current operator and panelgroup.

VC_PRD_GRP8_VW

(SQL View)

Tree Groups Security View

Variable Comp: this view returns Trees/groups for a given VC Plan ID. The current plan is used (the last one processed by the eligibility process). GB_OPRID and PNLGRPNAME allow to check if the row is accessible for the current operator and panelgroup.

SELECT DISTINCT A.GB_OPRID ,A.PNLGRPNAME ,A.VC_PLAN_ID ,A.VC_PAYOUT_PRD_ID ,A.GB_GROUP_ID ,A.DESCR FROM PS_VC_CHK_TPGRP_VW A ,PS_VC_IND_GOAL B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID AND A.GB_GROUP_ID = B.GB_GROUP_ID

# 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

#	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