HCR_SM_CRIT_VW (SQL View)	Index Back
Search Match Rule Criteria Search Match Rule Criteria Table. This table stores information for Search Match Criteria settings as they pertain to a specific Search Match Rule.

HCR_SM_CRIT_VW

(SQL View)

Search Match Rule Criteria

Search Match Rule Criteria Table. This table stores information for Search Match Criteria settings as they pertain to a specific Search Match Rule.

SELECT A.SM_TYPE ,A.SM_PARM_CD ,B.SEARCH_RULE_NBR ,C.SM_RULE_CD ,C.SM_RULE ,C.SEQNO ,C.SM_REQUIRED ,C.SM_USAGE ,C.SM_STARTPOS ,C.SM_LENGTH FROM PS_HCR_SM_PARM_TBL A , PS_HCR_SM_ORDR_TBL B , PS_HCR_SM_CRIT_TBL C WHERE A.SM_TYPE = B.SM_TYPE AND A.SM_PARM_CD = B.SM_PARM_CD AND B.SM_TYPE = C.SM_TYPE AND B.SM_RULE_CD = C.SM_RULE_CD AND A.STATUS = 'A' AND (C.SM_USAGE <> 'N' OR A.SM_ADHOC_FLG = 'Y')

# 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_PARM_CD Character(15) VARCHAR2(15) NOT NULL Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.

3 SEARCH_RULE_NBR Number(3,0) SMALLINT NOT NULL Search Match Rule Number. This field identifies the Search Order for a specific Search Match Rule within the Search Parameters.

4 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.

5 SM_RULE Character(30) VARCHAR2(30) NOT NULL Search Match Rule. This field holds the search property rule for the database field.
Prompt Table: HCR_SM_PROP_TBL

6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

7 SM_REQUIRED Character(1) VARCHAR2(1) NOT NULL Search Match Required field. This field identifies a Search Match Rule element as being required or not.
Y/N Table Edit
Default Value: Y

8 SM_USAGE Character(1) VARCHAR2(1) NOT NULL Search Match Usage field. This field controls the usage parameters for the Search Match Rule for Character fieldtypes.
B=Begins With
C=Contains
E=Equals
N=Not Used
Default Value: E

9 SM_STARTPOS Number(3,0) SMALLINT NOT NULL Search Match Starting Position field. This field identifies the starting position of a substring search.

10 SM_LENGTH Number(3,0) SMALLINT NOT NULL Search Match Length field. This field identifies the length of a substring search.

#	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_PARM_CD	Character(15)	VARCHAR2(15) NOT NULL	Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
3	SEARCH_RULE_NBR	Number(3,0)	SMALLINT NOT NULL	Search Match Rule Number. This field identifies the Search Order for a specific Search Match Rule within the Search Parameters.
4	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.
5	SM_RULE	Character(30)	VARCHAR2(30) NOT NULL	Search Match Rule. This field holds the search property rule for the database field. Prompt Table: HCR_SM_PROP_TBL
6	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
7	SM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Search Match Required field. This field identifies a Search Match Rule element as being required or not. Y/N Table Edit Default Value: Y
8	SM_USAGE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Usage field. This field controls the usage parameters for the Search Match Rule for Character fieldtypes. B=Begins With C=Contains E=Equals N=Not Used Default Value: E
9	SM_STARTPOS	Number(3,0)	SMALLINT NOT NULL	Search Match Starting Position field. This field identifies the starting position of a substring search.
10	SM_LENGTH	Number(3,0)	SMALLINT NOT NULL	Search Match Length field. This field identifies the length of a substring search.