EOEP_SRCH_VW

(SQL View)
 Index Back

EOEP Search Work View

This view is used for the customized search page and doesn't return any rows. It is used just as a derived record but it was created so that it could possibly be used in a grid later.

SELECT 'SO' , ' ' , ' ' , ' ' , ' ' , ' ' FROM %Table(INSTALLATION) WHERE 1 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: %EDITTABLE2

3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

Prompt Table: %EDITTABLE3
Set Control Field: SETID

4 EOEP_SRCH_VALUE Character(254) VARCHAR2(254) NOT NULL field used to hold the search condition value.
5 EOEP_SRCH_PROMPT Character(254) VARCHAR2(254) NOT NULL field used to display the prompt button.

Prompt Table: %EDITTABLE

6 EOEP_SRCH_COND Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in

Default Value: =