EOCF_UPPSRCH_VW

(SQL View)
 Index Back

Upper case search view


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 EOCF_RECNAME_ALT Character(15) VARCHAR2(15) NOT NULL Record Name
2 EOCF_UPPR_SRCH_FLD Character(18) VARCHAR2(18) NOT NULL Uppercase Search Field