VC_PRD_GRP7_VW

(SQL View)
Index Back

View on the Ind Goals Tbl

This view is used as base record for the level 2 scroll in the Individual 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_GOAL

# 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