VC_AWDALC_SRCH

(SQL View)
 Index Back

Award Allocation w/o Groups

Search Record to Award Allocations panel

SELECT DISTINCT A.VC_PLAN_ID , B.VC_PAYOUT_PRD_ID , B.PRD_END_DT FROM PS_VC_PLAN_TBL A , PS_VC_PAYPRD_TBL B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND EXISTS ( SELECT 'X' FROM PS_VC_PLAN_MEM D WHERE D.VC_PLAN_ID = A.VC_PLAN_ID AND D.VC_PAYOUT_PRD_ID=B.VC_PAYOUT_PRD_ID AND D.GB_GROUP_ID = 'NOGROUP') AND (( A.VC_PLAN_MEM_CRIT = 'E' AND EXISTS ( SELECT 'X' FROM PS_VC_GRP_AWARD C WHERE C.VC_PLAN_ID = A.VC_PLAN_ID AND C.VC_PAYOUT_PRD_ID=B.VC_PAYOUT_PRD_ID AND C.GB_GROUP_ID = 'NOGROUP') ) OR A.VC_PLAN_MEM_CRIT ='A')

# 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_END_DT Date(10) DATE Pay Period End Date