VC_ORG_PRD_VW (SQL View)	Index Back
PayPrds with Org Goals defined All combinations of Plan/Period for which Org goals are defined to display payout periods on the Org Goal Attainment panels.

VC_ORG_PRD_VW

(SQL View)

PayPrds with Org Goals defined

All combinations of Plan/Period for which Org goals are defined to display payout periods on the Org Goal Attainment panels.

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_ORG_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