VC_IND_EMPL_VW (SQL View)	Index Back
View of Empls in 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, Employee in that table.

VC_IND_EMPL_VW

(SQL View)

View of Empls in 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, Employee in that table.

SELECT DISTINCT VC_PLAN_ID , VC_PAYOUT_PRD_ID , GB_GROUP_ID , EMPLID , EMPL_RCD 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

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

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

#	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
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record