PA_EMP_STAT_VW

(SQL View)
 Index Back

Pension Status Employee Table


select emplid, benefit_plan, pension_status from PS_PA_EMP_PEN_STAT a where effdt = (select max(effdt) from PS_PA_EMP_PEN_STAT b where a.emplid=b.emplid and a.benefit_plan=b.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 PENSION_STATUS Character(3) VARCHAR2(3) NOT NULL Pension Status
A70=Active-Over Age 70 1/2
ANP=Active-Not Yet Participating
ANS=Active-Not Accruing Service
APR=Active Participant
AVS=Active-Accrue Vesting Only
BDF=Beneficiary-Deferred Benefit
BPY=Beneficiary-In Pay Status
BST=Beneficiary-Payment Complete
DDF=Disability Retire-Deferred
DPY=Disability Retire-In PayStatus
DST=Disabiltiy Retire-Pmt Complete
QDF=Alt Payee - Deferred Benefit
QPY=Alt Payee - In PayStatus
QST=Alt Payee - Payment Complete
RDF=Retired-Deferred Benefit
RPY=Retired-In Pay Status
RST=Retired-Payment Complete
TDF=Terminated-Deferred Benefit
TNV=Terminated-Not Vested
TPY=Terminated-In Pay Status
TST=Terminated-Payment Complete
XBP=Deceased-With Beneficiary
XNB=Deceased-No Benefit/Benefic