PA_SP_STRSN_VW

(SQL View)
 Index Back

Pension Status Reason view


SELECT DISTINCT C.COMPONENT_NAME , A.STATUS_AVAIL , C.STATUS_REASON , C.DESCR FROM PS_PA_SP_STAT_MAP A , PS_PA_SP_STATUS B , PS_PA_SP_STAT_RESN C WHERE A.COMPONENT_NAME = B.COMPONENT_NAME AND A.STATUS_AVAIL = B.CURRENT_STATUS AND B.COMPONENT_NAME = C.COMPONENT_NAME AND B.CURRENT_STATUS = C.CURRENT_STATUS AND A.ACTIVE_INACTIVE = 'A' AND B.ACTIVE_INACTIVE = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPONENT_NAME Character(1) VARCHAR2(1) NOT NULL Component Name
E=Employment Verification
S=Service Purchase
2 STATUS_AVAIL Character(3) VARCHAR2(3) NOT NULL Available Status
3 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description