VC_PRT_RULE_VW (SQL View)	Index Back
Effective dated Prorate Rule This view is used on the prorate period panel against the prorate rule ID field. The purpose of the view is to retrieve the correct effective dated row from the Proration rule table (which is effective dated). The Period End Dates on the prorate period table are to be used as the criteria to identify the correct rule IDs to be selected.

VC_PRT_RULE_VW

(SQL View)

Effective dated Prorate Rule

This view is used on the prorate period panel against the prorate rule ID field. The purpose of the view is to retrieve the correct effective dated row from the Proration rule table (which is effective dated). The Period End Dates on the prorate period table are to be used as the criteria to identify the correct rule IDs to be selected.

SELECT DISTINCT PR.VC_PRT_RULE_ID , PR.EFFDT , PR.DESCR FROM PS_VC_PAYPRD_TBL PP , PS_VC_PRORATE_RULE PR WHERE PR.EFFDT = ( SELECT MAX(PR1.EFFDT) FROM PS_VC_PRORATE_RULE PR1 WHERE PR1.VC_PRT_RULE_ID = PR.VC_PRT_RULE_ID AND PR1.EFFDT <= PP.PRD_END_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_PRT_RULE_ID Character(8) VARCHAR2(8) NOT NULL Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan.

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_PRT_RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description