SCC_SM_BTCH_VW2 (SQL View)	Index Back
Search/Match Batch2 Search/Match Batch2 view selects Search Order Number and Compare Field data for Cobol/SQR interface to HCM Search/Match Service for "Persons".

SCC_SM_BTCH_VW2

(SQL View)

Search/Match Batch2

Search/Match Batch2 view selects Search Order Number and Compare Field data for Cobol/SQR interface to HCM Search/Match Service for "Persons".

SELECT A.SM_PARM_CD ,B.SEARCH_RULE_NBR ,C.SM_RECORD ,C.SM_FIELD ,C.FIELDTYPE ,D.SEQNO ,D.SM_REQUIRED ,D.SM_USAGE ,D.SM_STARTPOS ,D.SM_LENGTH FROM PS_HCR_SM_PARM_TBL A , PS_HCR_SM_ORDR_TBL B , PS_HCR_SM_PROP_VW C , PS_HCR_SM_CRIT_TBL D WHERE A.SM_TYPE = 'P' AND A.SM_TYPE = B.SM_TYPE AND A.SM_PARM_CD = B.SM_PARM_CD AND B.SM_TYPE = C.SM_TYPE AND C.SM_TYPE = D.SM_TYPE AND B.SM_RULE_CD = D.SM_RULE_CD AND C.SM_RULE = D.SM_RULE AND A.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 SM_RECORD Character(15) VARCHAR2(15) NOT NULL Search Match Record. This field holds the search result database record name for the Search Match Rules definitions.

4 SM_FIELD Character(18) VARCHAR2(18) NOT NULL Search Match Field. This field holds the search property database field name for the Search Match Rules definitions.

5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

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.

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

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_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.
2	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.
3	SM_RECORD	Character(15)	VARCHAR2(15) NOT NULL	Search Match Record. This field holds the search result database record name for the Search Match Rules definitions.
4	SM_FIELD	Character(18)	VARCHAR2(18) NOT NULL	Search Match Field. This field holds the search property database field name for the Search Match Rules definitions.
5	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
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.
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
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.