SCC_SM_FLD_VW (SQL View)	Index Back
External S/M Search fields The Search fields that make up the External Search/Match request message

SCC_SM_FLD_VW

(SQL View)

External S/M Search fields

The Search fields that make up the External Search/Match request message

SELECT PS_HCR_SM_ORDR_TBL.SM_TYPE , PS_HCR_SM_ORDR_TBL.SM_PARM_CD , PS_HCR_SM_ORDR_TBL.SM_RULE_CD , PS_HCR_SM_CRIT_TBL.SEQNO , PS_HCR_SM_CRIT_TBL.SM_RULE , PS_HCR_SM_CRIT_TBL.SM_REQUIRED , PS_HCR_SM_CRIT_TBL.SM_USAGE , PS_HCR_SM_CRIT_TBL.SM_STARTPOS , PS_HCR_SM_CRIT_TBL.SM_LENGTH , ' ' FROM PS_HCR_SM_ORDR_TBL INNER JOIN PS_HCR_SM_CRIT_TBL ON PS_HCR_SM_ORDR_TBL.SM_TYPE = PS_HCR_SM_CRIT_TBL.SM_TYPE AND PS_HCR_SM_ORDR_TBL.SM_RULE_CD = PS_HCR_SM_CRIT_TBL.SM_RULE_CD

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

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

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

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

7 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

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

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

10 SCC_SM_DATA Character(254) VARCHAR2(254) NOT NULL Search Match Data

#	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	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.
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	SM_RULE	Character(30)	VARCHAR2(30) NOT NULL	Search Match Rule. This field holds the search property rule for the database field.
6	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.
7	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
8	SM_STARTPOS	Number(3,0)	SMALLINT NOT NULL	Search Match Starting Position field. This field identifies the starting position of a substring search.
9	SM_LENGTH	Number(3,0)	SMALLINT NOT NULL	Search Match Length field. This field identifies the length of a substring search.
10	SCC_SM_DATA	Character(254)	VARCHAR2(254) NOT NULL	Search Match Data