RB_UPPR_SRCH_VW

(SQL View)
 Index Back

Common application record

Used as Prompt Table by RB_FILTER_FIELD (Record) UPPER_SEARCH_FIELD (Field)

SELECT A.RECNAME , B.FIELDNAME FROM PSRECFIELD A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = 0 AND B.FORMAT = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME_ALT Character(15) VARCHAR2(15) NOT NULL Record Name
2 UPPER_SEARCH_FIELD Character(18) VARCHAR2(18) NOT NULL Uppercase Search Field