RF_AG_SRCH_CFG (SQL Table)	Index Back
Agreement Search Configuration This record stores configuration options to determine how the agreement search should operate

RF_AG_SRCH_CFG

(SQL Table)

Agreement Search Configuration

This record stores configuration options to determine how the agreement search should operate

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 EXT_AG_CASE_OPT Character(1) VARCHAR2(1) NOT NULL External Customer Agreement Search option for Case
1=User Selects From All Matches
2=Autoselect Shortest Response
3=Autoselect Longest Response
Default Value: 2

3 EXT_AG_SO_OPT Character(1) VARCHAR2(1) NOT NULL External Customer Agreement Search option for Service Order
1=User Selects From All Matches
2=Autoselect Shortest Response
3=Autoselect Longest Response
Default Value: 2

4 INT_AG_CASE_OPT Character(1) VARCHAR2(1) NOT NULL Internal Customer Agreement Search option for Case
1=User Selects From All Matches
2=Autoselect Shortest Response
3=Autoselect Longest Response
4=Autoselect Based on Rules
Default Value: 2

5 USE_EXT_RULES Character(1) VARCHAR2(1) NOT NULL Flag to designate whether or not external criteria (rules) are to be used in agreement matching logic.
Y/N Table Edit

6 USE_INT_RULES Character(1) VARCHAR2(1) NOT NULL Flag to designate whether or not internal criteria (rules) are to be used in agreement matching logic.
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	EXT_AG_CASE_OPT	Character(1)	VARCHAR2(1) NOT NULL	External Customer Agreement Search option for Case 1=User Selects From All Matches 2=Autoselect Shortest Response 3=Autoselect Longest Response Default Value: 2
3	EXT_AG_SO_OPT	Character(1)	VARCHAR2(1) NOT NULL	External Customer Agreement Search option for Service Order 1=User Selects From All Matches 2=Autoselect Shortest Response 3=Autoselect Longest Response Default Value: 2
4	INT_AG_CASE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Internal Customer Agreement Search option for Case 1=User Selects From All Matches 2=Autoselect Shortest Response 3=Autoselect Longest Response 4=Autoselect Based on Rules Default Value: 2
5	USE_EXT_RULES	Character(1)	VARCHAR2(1) NOT NULL	Flag to designate whether or not external criteria (rules) are to be used in agreement matching logic. Y/N Table Edit
6	USE_INT_RULES	Character(1)	VARCHAR2(1) NOT NULL	Flag to designate whether or not internal criteria (rules) are to be used in agreement matching logic. Y/N Table Edit