VC_MTX_COL_VW (SQL View)	Index Back
View for matrix columns. This view is used for reading the nr of matrix columns for a specific plan and period from the plan effdt table. It is used on the panels for defining matrix goals. It compares the effdt of the plan definition against the end date of the period for which the matrix has to be defined.

VC_MTX_COL_VW

(SQL View)

View for matrix columns.

This view is used for reading the nr of matrix columns for a specific plan and period from the plan effdt table. It is used on the panels for defining matrix goals. It compares the effdt of the plan definition against the end date of the period for which the matrix has to be defined.

SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , B.VC_MTX_COLUMN FROM PS_VC_PAYPRD_TBL A , PS_VC_PLAN_EFFDT B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT C WHERE C.VC_PLAN_ID = B.VC_PLAN_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_MTX_COLUMN Character(2) VARCHAR2(2) NOT NULL Nbr Matrix Columns
3=Three
5=Five
7=Seven

#	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_MTX_COLUMN	Character(2)	VARCHAR2(2) NOT NULL	Nbr Matrix Columns 3=Three 5=Five 7=Seven