SFA_CRC_SRCH_AD (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.

SFA_CRC_SRCH_AD

(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 SFA_CRC_SRCH_PM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

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

3 PER_ADD_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Add Criteria
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: S

4 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP NOT NULL Last Changed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
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. Prompt Table: SCC_SM_PARM_VW
3	PER_ADD_PARM	Character(1)	VARCHAR2(1) NOT NULL	Personal Info - Add Criteria A=Add I=Ignore S=Suspend U=Update Default Value: S
4	LAST_CHANGED_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Last Changed