CONFIG_IDSM_RULE_CDPrompt Table: %EDITTABLE
A=Applicant
O=Organization
P=Person
Default Value: P
A=Add
S=Suspend
U=Update
Default Value: U
A=Add
S=Suspend
Default Value: S
RB_SM_ACTION(SQL Table) |
Index Back |
|---|---|
Search Match ActionsThis record holds the actions to be taken for each Search Match Rule related to a Configuration ID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONFIG_ID |
Character(20) | VARCHAR2(20) NOT NULL | Configuration ID |
| 2 | SM_RULE_CD |
Character(15) | VARCHAR2(15) NOT NULL |
Search Match Rule Code. This field stores the high level key for a Search Match Rule definition.
Prompt Table: %EDITTABLE |
| 3 | SM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant O=Organization P=Person Default Value: P |
| 4 | SEARCH_RULE_NBR | Number(3,0) | SMALLINT NOT NULL | Search Match Rule Number. This field identifies the Search Order for a specific Search Match Rule within the Search Parameters. |
| 5 | ONE_MATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
One Match Action
A=Add S=Suspend U=Update Default Value: U |
| 6 | MULTI_MATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Matches
A=Add S=Suspend Default Value: S |