SFA_NSLDS_SMADD (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_NSLDS_SMADD

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
Prompt Table: SFA_NSLDS_SCDVW

2 INSTIT_OE_BR Character(2) VARCHAR2(2) NOT NULL Branch Code

3 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

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

5 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP NOT NULL Last Changed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code Prompt Table: SFA_NSLDS_SCDVW
2	INSTIT_OE_BR	Character(2)	VARCHAR2(2) NOT NULL	Branch Code
3	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
4	PER_ADD_PARM	Character(1)	VARCHAR2(1) NOT NULL	Personal Info - Add Criteria A=Add I=Ignore S=Suspend U=Update Default Value: S
5	LAST_CHANGED_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Last Changed