PA_PENSION_STAT

(SQL Table)
Index Back

Status Code Assignment

This is a setup table containing the custom statement definition for each Pension Status Code.

# 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

Default Value: %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 CUSTOM_STMT_NAME Character(10) VARCHAR2(10) NOT NULL Custom Statement Name

Prompt Table: PA_CUSTOM8_VW