INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SM_PARM_CDSEARCH_ORDER_NBRPrompt Table: SEARCH_ORDR_TBL
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: S
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: S
SFA_LN_SRCH_PM(SQL Table) |
Index Back |
|---|---|
Search Order ParmsSEARCH_ORDR_PRM contains the processing parameters to be used based on the results of the Search/Match when one or multiple matches are found. |
| # | 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. |
| 3 | SEARCH_ORDER_NBR |
Number(3,0) | SMALLINT NOT NULL |
This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
Prompt Table: SEARCH_ORDR_TBL |
| 4 | PER_UPDATE_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Update Criteri
A=Add I=Ignore S=Suspend U=Update Default Value: S |
| 5 | PER_MULTIPLE_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Multiples Crit
A=Add I=Ignore S=Suspend U=Update Default Value: S |