VC_MTX_PRD_VW (SQL View)	Index Back
Pay Prds with Goal Mtx defined All combinations Plan/Period for which a Goal Matrix has been defined. This view is uesd as a level 1 base record for the panels VC_MTX_GOAL_ATN and VC_MTX_GOAL_WG_ATN.

VC_MTX_PRD_VW

(SQL View)

Pay Prds with Goal Mtx defined

All combinations Plan/Period for which a Goal Matrix has been defined. This view is uesd as a level 1 base record for the panels VC_MTX_GOAL_ATN and VC_MTX_GOAL_WG_ATN.

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