EOSF_RCTSRC_DEF

(SQL Table)
Index Back

Recent Search definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EOSF_SEARCH_ID Character(65) VARCHAR2(65) NOT NULL Search ID
3 EOSF_RCNT_SRCH_CD Number(3,0) SMALLINT NOT NULL Recent Search Code
4 EOSF_SRCH_TYPE Character(1) VARCHAR2(1) NOT NULL Search Type
E=Search
S=Standard Search
5 EOSF_PREVIEW_YN Character(1) VARCHAR2(1) NOT NULL Search Filter - value yes no

Y/N Table Edit

Default Value: N

6 EOSF_SRCHDISP_OPTN Character(1) VARCHAR2(1) NOT NULL Search Type
A=Advanced
B=Basic
7 EOSF_SAVESRCH_CD Character(30) VARCHAR2(30) NOT NULL Saved Search Code
8 EOSF_CRITERIATEXT Long Character CLOB Criteria Text
9 EOSF_CRITFLD_COUNT Number(3,0) SMALLINT NOT NULL Criteria Count
10 EOSF_RCNT_SRCH_DTM DateTime(26) TIMESTAMP Recent Search Datetime
11 EOSF_RCNT_DISPLAY Character(1) VARCHAR2(1) NOT NULL Search Filter - value yes no

Default Value: N