SAD_SL_SRCH_ADD (SQL Table)	Index Back
Search Add Parms SEARCH_ADD_PARM contains the processing parameters to be used based on the results of the Search/Match when no matches are found.

SAD_SL_SRCH_ADD

(SQL Table)

Search Add Parms

SEARCH_ADD_PARM contains the processing parameters to be used based on the results of the Search/Match when no matches are found.

Parent Record Of SAD_SL_SRCH_PRM

# 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 PER_ADD_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Add Criteria
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: S

3 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP NOT NULL Last Changed

#	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	PER_ADD_PARM	Character(1)	VARCHAR2(1) NOT NULL	Personal Info - Add Criteria A=Add I=Ignore S=Suspend U=Update Default Value: S
3	LAST_CHANGED_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Last Changed