VC_PAYFORM_VW (SQL View)	Index Back
Prompt view for payout formula This view is used for prompting the payout formulas on the matrix goals panels. It compares the effdt of the goal definition against the end date of the period for which it is to be used.

VC_PAYFORM_VW

(SQL View)

Prompt view for payout formula

This view is used for prompting the payout formulas on the matrix goals panels. It compares the effdt of the goal definition against the end date of the period for which it is to be used.

SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , B.VC_PAYFORMULA_ID , B.DESCR50 FROM PS_VC_PAYPRD_TBL A , PS_VC_PAYFORM_TBL B WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PAYFORM_TBL C WHERE C.VC_PAYFORMULA_ID = B.VC_PAYFORMULA_ID AND C.EFFDT <= A.PRD_END_DT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

2 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

3 VC_PAYFORMULA_ID Character(10) VARCHAR2(10) NOT NULL Payout Formula ID

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
2	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
3	VC_PAYFORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Formula ID
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50