VC_PRD_GRP2_VW (SQL View)	Index Back
View on the Ind Dflt Goals Tbl This view is used as base record for the level 2 scroll in the Individual Default Goals panel. It shows all combinations of Plan, Period, Group in that table.

VC_PRD_GRP2_VW

(SQL View)

View on the Ind Dflt Goals Tbl

This view is used as base record for the level 2 scroll in the Individual Default Goals panel. It shows all combinations of Plan, Period, Group in that table.

SELECT DISTINCT VC_PLAN_ID , VC_PAYOUT_PRD_ID , GB_GROUP_ID FROM PS_VC_IND_DFT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
Prompt Table: VC_PLAN_TBL

2 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
Prompt Table: VC_PAYPRD_TBL

3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: VC_CHK_TPGRP_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID Prompt Table: VC_PLAN_TBL
2	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID Prompt Table: VC_PAYPRD_TBL
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: VC_CHK_TPGRP_VW