PA_SP_NEXTST_VW

(SQL View)
 Index Back

Next Status View


SELECT A.COMPONENT_NAME , A.CURRENT_STATUS , A.STATUS_AVAIL , B.DESCR FROM PS_PA_SP_STAT_MAP A , PS_PA_SP_STATUS B WHERE A.COMPONENT_NAME = B.COMPONENT_NAME AND A.STATUS_AVAIL = B.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 CURRENT_STATUS Character(3) VARCHAR2(3) NOT NULL Current Status
3 STATUS_AVAIL Character(3) VARCHAR2(3) NOT NULL Status
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description