CONFIG_IDPrompt Table: HCR_SM_PARMA_VW
A=Applicant
O=Organization
P=Person
Default Value: P
A=Add
S=Suspend
Default Value: A
SM_CONFIG_VW(SQL View) |
Index Back |
|---|---|
Search/Match ResultsView to retrieve the core details of the Results Action Configuration |
| SELECT CONFIG_ID ,SM_PARM_CD ,SM_TYPE , NO_MATCH_ACTN ,DESCR FROM PS_RB_SM_CONFIG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONFIG_ID |
Character(20) | VARCHAR2(20) NOT NULL | Configuration ID |
| 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.
Prompt Table: HCR_SM_PARMA_VW |
| 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 | NO_MATCH_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
No Match Action
A=Add S=Suspend Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |