OPRIDRUN_CNTL_IDSCC_TRANSAC_CDSM_PARM_CDSEARCH_ORDER_NBRPrompt Table: SEARCH_ORDR_TBL
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: U
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: S
SCC_SL_SRCHORDR(SQL Table) |
Index Back |
|---|---|
SnL run controlSCC_SRCHORDPARM 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 4 | 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. |
| 5 | 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 |
| 6 | SCC_PER_UPD_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Update Criteri
A=Add I=Ignore S=Suspend U=Update Default Value: U |
| 7 | SCC_PER_MULT_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Multiples Crit
A=Add I=Ignore S=Suspend U=Update Default Value: S |