SCC_SM_BTCH_VW1 (SQL View)	Index Back
Search/Match Batch1 Search/Match Batch1 view selects Search Order Number data for Cobol/SQR interface to HCM Search/Match Service for "Persons".

SCC_SM_BTCH_VW1

(SQL View)

Search/Match Batch1

Search/Match Batch1 view selects Search Order Number data for Cobol/SQR interface to HCM Search/Match Service for "Persons".

SELECT B.SM_PARM_CD , B.SEARCH_RULE_NBR , A.DESCR FROM PS_HCR_SM_RULE_TBL A , PS_HCR_SM_ORDR_TBL B WHERE A.SM_TYPE='P' AND A.SM_TYPE=B.SM_TYPE AND A.SM_RULE_CD=B.SM_RULE_CD

# 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.
Prompt Table: SCC_SM_PARM_VW

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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. Prompt Table: SCC_SM_PARM_VW
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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description