PA_RVWPMNT_VW (SQL View)	Index Back
Pension Payee Detail Payments This is an employee table for Retiree Admin. SELECT DISTINCT A.PA_RUN_ID ,B.PROCESS_INSTANCE ,A.BENEFIT_PLAN FROM PS_PA_RT_PAY_DETL A , PS_PA_RT_SUMRY B WHERE A.BENEFIT_PLAN = B.BENEFIT_PLAN

PA_RVWPMNT_VW

(SQL View)

Pension Payee Detail Payments

This is an employee table for Retiree Admin. SELECT DISTINCT A.PA_RUN_ID ,B.PROCESS_INSTANCE ,A.BENEFIT_PLAN FROM PS_PA_RT_PAY_DETL A , PS_PA_RT_SUMRY B WHERE A.BENEFIT_PLAN = B.BENEFIT_PLAN

SELECT DISTINCT PA_RUN_ID FROM PS_PA_RT_SUM_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID