FO_SRCH_TYPE_VW

(SQL View)
 Index Back

Staffing Search Types


SELECT A.SRCH_TYPE_CD , CASE WHEN A.SRCH_TYPE_CD = 'PLSRC' THEN A.DESCR ELSE %Substring(B.MESSAGE_TEXT , 1 , 30) END FROM PS_RS_SRCH_HDR A , PSMSGCATDEFN B WHERE A.SRCH_TYPE_CD IN ('PLSRC','ORDSR') AND B.MESSAGE_SET_NBR = 18071 AND B.MESSAGE_NBR = 410

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRCH_TYPE_CD Character(5) VARCHAR2(5) NOT NULL Search Type
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description