HCR_SM_SRCHFLDV (SQL View)	Index Back
Search Match Search Match

HCR_SM_SRCHFLDV

(SQL View)

Search Match

SELECT SM_TYPE , SM_PARM_CD , SEARCH_RULE_NBR , SM_RULE , SEQNO FROM PS_HCR_SM_CRIT_VW

# 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 Character(30) VARCHAR2(30) NOT NULL Search Match Rule. This field holds the search property rule for the database field.

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

#	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	Character(30)	VARCHAR2(30) NOT NULL	Search Match Rule. This field holds the search property rule for the database field.
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number