HCR_SM_USERDFLT (SQL Table)	Index Back
SearchMatch User Defaults This table holds user default information for defaulting a Result Code on the manual SearchMatch criteria page.

HCR_SM_USERDFLT

(SQL Table)

SearchMatch User Defaults

This table holds user default information for defaulting a Result Code on the manual SearchMatch criteria page.

# 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 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person

3 SM_RSLT_CD Character(15) VARCHAR2(15) NOT NULL Search Match Result Code.
Prompt Table: %EDITTABLE2

#	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	SM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Type: This field identifies the domain of core data to be searched. A=Applicant O=Organization P=Person
3	SM_RSLT_CD	Character(15)	VARCHAR2(15) NOT NULL	Search Match Result Code. Prompt Table: %EDITTABLE2