RS_SRCH_CFG_VW

(SQL View)
 Index Back

SELECT A.SRCH_TYPE_CD , B.RECNAME , B.FIELDNAME , C.FIELDTYPE , D.EDITTABLE ,A.ORDERNO , A.MTCH_COL_ID , A.SRCH_SHOW_IN_SRCH , A.SRCH_SHOW_IN_LIST , A.SRCH_FREE_FORM , A.VERITY_FIELD , A.DEFAULT_DESCR FROM PS_RS_SRCH_FIELD A , PS_RS_SRCH_REC_FLD B , PSDBFIELD C , PSRECFIELDDB D WHERE A.SRCH_TYPE_CD = B.SRCH_TYPE_CD AND A.SRCH_CATEGORY = B.SRCH_CATEGORY AND A.MTCH_COL_ID = B.MTCH_COL_ID AND B.FIELDNAME = C.FIELDNAME AND B.RECNAME = D.RECNAME AND B.FIELDNAME = D.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRCH_TYPE_CD Character(5) VARCHAR2(5) NOT NULL Search Type
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
6 ORDERNO Number(5,0) INTEGER NOT NULL Sort Order
7 MTCH_COL_ID Character(30) VARCHAR2(30) NOT NULL Column
8 SRCH_SHOW_IN_SRCH Character(1) VARCHAR2(1) NOT NULL Show in Search

Y/N Table Edit

9 SRCH_SHOW_IN_LIST Character(1) VARCHAR2(1) NOT NULL Show In Results

Y/N Table Edit

10 SRCH_FREE_FORM Character(1) VARCHAR2(1) NOT NULL Free Form

Y/N Table Edit

11 VERITY_FIELD Character(1) VARCHAR2(1) NOT NULL Field - Comparable

Y/N Table Edit

12 DEFAULT_DESCR Character(30) VARCHAR2(30) NOT NULL Default Asset Description