VC_GRP_PRD_VW (SQL View)	Index Back
VC Group Payout Period View This view is used as the Level 1 Payout Period on the Group Goals Attainment panel. This view selects a distinct payout period from the payout period table and the group goals table.

VC_GRP_PRD_VW

(SQL View)

VC Group Payout Period View

This view is used as the Level 1 Payout Period on the Group Goals Attainment panel. This view selects a distinct payout period from the payout period table and the group goals table.

SELECT DISTINCT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.PRD_BGN_DT , A.PRD_END_DT FROM PS_VC_PAYPRD_TBL A , PS_VC_GRP_GOAL B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID

# 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

3 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date

4 PRD_END_DT Date(10) DATE NOT NULL Pay Period End Date

#	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
3	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
4	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date