VC_ELIG_PRD2_VW

(SQL View)
 Index Back

VC Payout Period Prompt Table

VC Payout Period prompt table used in the Prorate Periods online panel. Prompts only for periods for which the Prorate Indicator on Plan Effdt is set to Y.

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 , PS_VC_PLAN_EFFDT PE 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 ) AND PE.VC_PLAN_ID = A.VC_PLAN_ID AND PE.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT PE1 WHERE PE1.VC_PLAN_ID = PE.VC_PLAN_ID AND PE1.EFFDT <= A.PRD_END_DT ) AND PE.VC_PRORATION_IND = '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_ORG_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Org Perf Factor