VC_RUN_ELIG_VW (SQL View)	Index Back
Eligibility Run Date Prompt Vw This view is used as a prompt for the date at which the Eligibility/Proration process is being run as of.

VC_RUN_ELIG_VW

(SQL View)

Eligibility Run Date Prompt Vw

This view is used as a prompt for the date at which the Eligibility/Proration process is being run as of.

SELECT PD.VC_PLAN_ID , PD.VC_PAYOUT_PRD_ID , PD.PRD_BGN_DT , PD.PRD_END_DT , PD.VC_PRCS_COMPLETE FROM PS_VC_PRORATE_DT PD WHERE PD.PRD_END_DT = ( SELECT MIN(B.PRD_END_DT) FROM PS_VC_PRORATE_DT B WHERE B.VC_PLAN_ID = PD.VC_PLAN_ID AND B.VC_PAYOUT_PRD_ID = PD.VC_PAYOUT_PRD_ID) OR PRD_END_DT = ( SELECT MIN(C.PRD_END_DT) FROM PS_VC_PRORATE_DT C WHERE C.VC_PLAN_ID = PD.VC_PLAN_ID AND C.VC_PAYOUT_PRD_ID = PD.VC_PAYOUT_PRD_ID AND C.VC_PRCS_COMPLETE <> 'Y' )

# 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