EOCF_FILTER_USR

(SQL Table)
 Index Back

Filter User

Filter User

# 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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
4 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 EOCF_FLT_FILL_OPT Character(1) VARCHAR2(1) NOT NULL Filter Options
D=Default
L=Last
N=No
7 EOCF_FLT_BUTON_OPT Character(1) VARCHAR2(1) NOT NULL Search Button Position
B=Bottom
T=Top
X=Both Top and Bottom
8 EOCF_FILTER_NAME Character(50) VARCHAR2(50) NOT NULL Filter Name

Prompt Table: EOCF_FLTR_SAVED

9 EOCF_COLLAPSED Character(1) VARCHAR2(1) NOT NULL Collapsed
10 EOCF_ADV_BASLKPDFL Character(1) VARCHAR2(1) NOT NULL Default Lookup Type
A=Advanced Lookup
B=Basic Lookup
11 EOCF_ADV_BASLKPOPT Character(1) VARCHAR2(1) NOT NULL Lookup Type
A=Advanced Lookup
B=Basic Lookup
12 CASEINSSEARCH Character(1) VARCHAR2(1) NOT NULL Case Insensitive seach option in PSOPTIONS
N=Off
S=On - CaseSensitive Default On
Y=On - CaseSensitive Default Off

Y/N Table Edit

Default Value: Y

13 EOCF_LST_USED_CRIT Character(254) VARCHAR2(254) NOT NULL Last Used Filter Criteria
14 EOCF_LST_USED_DIST Character(254) VARCHAR2(254) NOT NULL Last Used Distibution Policies
15 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
16 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
17 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
18 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
19 EOCF_FLT_CRITERIA Long Character CLOB Filter Criteria