HCR_SM_RULE_VW1 (SQL View)	Index Back
Search Match Rule view1 Search Match Rule view1. This view selects Search/Match Rules that are setup as NON-Adhoc rules.

HCR_SM_RULE_VW1

(SQL View)

Search Match Rule view1

Search Match Rule view1. This view selects Search/Match Rules that are setup as NON-Adhoc rules.

SELECT SM_TYPE ,SM_RULE_CD ,SM_ADHOC_FLG ,DESCR FROM PS_HCR_SM_RULE_TBL WHERE SM_ADHOC_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 SM_RULE_CD Character(15) VARCHAR2(15) NOT NULL Search Match Rule Code. This field stores the high level key for a Search Match Rule definition.

3 SM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Add Hoc flag. This flag identifies a Rule or Parameter as an Add Hoc search.
Y/N Table Edit
Default Value: N

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	SM_RULE_CD	Character(15)	VARCHAR2(15) NOT NULL	Search Match Rule Code. This field stores the high level key for a Search Match Rule definition.
3	SM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Search Match Add Hoc flag. This flag identifies a Rule or Parameter as an Add Hoc search. Y/N Table Edit Default Value: N
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description