PA_PEN_VAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: PA_BEN_PLAN_VW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
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
4	VAL_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Valuation Category A=Active B=Both (Active and Inactive) D=Done (no liability remaining) I=Inactive N=No Record Exist