PA_EMP_PEN_STAT

#	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	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