PA_PRTC_PRTN_VW

(SQL View)
Index Back

Plan Participation History

This is an employee for Plan Participation History, limited by Eligibility.

SELECT DISTINCT PS_PA_PRTC_PRTPN.emplid , PS_PA_PRTC_PRTPN.benefit_plan , PS_PA_PRTC_PRTPN.effdt , PS_PA_PRTC_PRTPN.part_status FROM ps_pa_pelg_hist , PS_PA_PRTC_PRTPN WHERE ps_pa_pelg_hist.emplid = PS_PA_PRTC_PRTPN.emplid AND ps_pa_pelg_hist.benefit_plan = PS_PA_PRTC_PRTPN.benefit_plan

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
3 EFFDT Date(10) DATE Effective Date
4 PART_STATUS Character(1) VARCHAR2(1) NOT NULL Participation Status
N=Not Participating
Y=Participating