UPG_RB_FILT_AET

(SQL Table)
Index Back

Configurable Search state rec

State record for Configurable Search upgrade

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
3 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
7 MARKET Character(3) VARCHAR2(3) NOT NULL Market
8 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
10 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
12 RB_FILTER_CRITERIA Long Character CLOB Filter (Configurable Search) Criteria
13 RA_FILTER_NAME Character(50) VARCHAR2(50) NOT NULL Filter Name
14 ADV_BASIC_LKP_OPT Character(1) VARCHAR2(1) NOT NULL Hyperlink for Lookup Type(Advanced vs. Basic)
A=Advanced Lookup
B=Basic Lookup
15 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
16 PNLGRPNAME2 Character(18) VARCHAR2(18) NOT NULL Component Name
17 RB_MARKET Character(3) VARCHAR2(3) NOT NULL Definiton for Market used by self-service page
GBL=Global
18 PNLNAME_2 Character(30) VARCHAR2(30) NOT NULL Panel Name. This field uniquely identifies a page name.
19 RECNAME2 Character(15) VARCHAR2(15) NOT NULL Record Name
20 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
21 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence