PA_RT_WARN_VW2

(SQL View)
 Index Back

Pension Payee Detail Payments

This is an employee table for Retiree Admin.

SELECT A.BENEFIT_PLAN, MAX(B.PA_RUN_ID_WARN_DT) FROM PS_PA_PEN_PLAN_VW A, PS_PA_RT_CALENDAR B WHERE B.BENEFIT_PLAN = ' ' GROUP BY A.BENEFIT_PLAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
2 PA_RUN_ID_WARN_DT Date(10) DATE Payment Warning