RI_SETUP_TBL (SQL Table)	Index Back
Setup Table for CIC 04-10-2001 - JBE - Setup Table for CIC to filter selected rows of data. The buffer could load many rows that would cause a long wait for user. This will limit the rows loaded into the buffer.

RI_SETUP_TBL

(SQL Table)

Setup Table for CIC

04-10-2001 - JBE - Setup Table for CIC to filter selected rows of data. The buffer could load many rows that would cause a long wait for user. This will limit the rows loaded into the buffer.

Related Language Record: RI_SETUP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VIEW_NAME Character(30) VARCHAR2(30) NOT NULL View Name

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: RI_RECNAME_VW

4 MAX_ROWS_SCROLL Number(5,0) INTEGER NOT NULL Max Number of Rows in Scrolls

5 RI_CRITERIA Character(4) VARCHAR2(4) NOT NULL Search Criteria
<=Less Than
==Equal To
>=Greater Than
DATE=Last n Days
ROWS=Row Amount
STAT=Status =

6 CRITERIA_VALUE Character(50) VARCHAR2(50) NOT NULL A value for criteria code that will be used to match people with Service Orders or Call Center Cases.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VIEW_NAME	Character(30)	VARCHAR2(30) NOT NULL	View Name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RI_RECNAME_VW
4	MAX_ROWS_SCROLL	Number(5,0)	INTEGER NOT NULL	Max Number of Rows in Scrolls
5	RI_CRITERIA	Character(4)	VARCHAR2(4) NOT NULL	Search Criteria <=Less Than ==Equal To >=Greater Than DATE=Last n Days ROWS=Row Amount STAT=Status =
6	CRITERIA_VALUE	Character(50)	VARCHAR2(50) NOT NULL	A value for criteria code that will be used to match people with Service Orders or Call Center Cases.