VC_PRORATE_DT (SQL Table)	Index Back
VC Prorate Dates This record is used to store the proration period begin and end dates. This record also stores when eligibility has been run for access into the Plan Members panel.

VC_PRORATE_DT

(SQL Table)

VC Prorate Dates

This record is used to store the proration period begin and end dates. This record also stores when eligibility has been run for access into the Plan Members panel.

# 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 PRD_BGN_DT Date(10) DATE Period Begin Date

4 PRD_END_DT Date(10) DATE Pay Period End Date

5 VC_PRCS_COMPLETE Character(1) VARCHAR2(1) NOT NULL 27 July 1999 - Suki Binpal Field to indicate if Variable Comp eligibility process has been run. (Y/N)
Y/N Table Edit

#	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	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
4	PRD_END_DT	Date(10)	DATE	Pay Period End Date
5	VC_PRCS_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	27 July 1999 - Suki Binpal Field to indicate if Variable Comp eligibility process has been run. (Y/N) Y/N Table Edit