PA_RT_WARN_VW1 (SQL View)	Index Back
Pension Payee Detail Payments This is an employee table for Retiree Admin.

PA_RT_WARN_VW1

(SQL View)

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 A.BENEFIT_PLAN = 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

#	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