BI_IM_SAVE_SRCH (SQL Table)	Index Back
Search/Change Parameters This table stores the operator's Search & Change parameters for Invoice Maintenance.

BI_IM_SAVE_SRCH

(SQL Table)

Search/Change Parameters

This table stores the operator's Search & Change parameters for Invoice Maintenance.

# 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 GRID_FLAG Character(1) VARCHAR2(1) NOT NULL Grid type indicator to distinguish Search parameters from Change parameters.
C=Change Grid
S=Search Grid

3 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 FIELD_VALUE100 Character(100) VARCHAR2(100) NOT NULL The value of a field. This could be used for Selecting a specific field value, or identifying the new value of the field.

#	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	GRID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Grid type indicator to distinguish Search parameters from Change parameters. C=Change Grid S=Search Grid
3	ROW_NUM	Number(3,0)	SMALLINT NOT NULL	Row Number
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	FIELD_VALUE100	Character(100)	VARCHAR2(100) NOT NULL	The value of a field. This could be used for Selecting a specific field value, or identifying the new value of the field.