CPS_SCHOOL_CODEINSTIT_OE_BRSM_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_NSLDS_SMPRM(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 | CPS_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 2 | INSTIT_OE_BR |
Character(2) | VARCHAR2(2) NOT NULL | Institution OE Branch |
| 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. |
| 4 | 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 |
| 5 | PER_UPDATE_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Update Criteri
A=Add I=Ignore S=Suspend U=Update Default Value: S |
| 6 | PER_MULTIPLE_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Multiples Crit
A=Add I=Ignore S=Suspend U=Update Default Value: S |