VC_ELIG_PRD_VW

(SQL View)
Index Back

VC Payout Period Prompt Table

VC Payout Period prompt table used in the Eligibility/Proration Process run control and the Prorate Periods online panel.

SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.PRD_BGN_DT , A.PRD_END_DT , A.VC_ORG_PERF_FACTOR FROM PS_VC_PAYPRD_TBL A WHERE A.VC_PLAN_ID NOT IN ( SELECT B.VC_PLAN_ID FROM PS_VC_ELIG_PRD1_VW B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID)

# 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_ORG_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Org Perf Factor