SM_TYPEA=Applicant
O=Organization
P=Person
Default Value: P
SM_PARM_CDPrompt Table: HCR_SM_PARM_TBL
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
HCR_SM_PARMA_VW(SQL View) |
Index Back |
|---|---|
Search Match ParameterSearch Match ParameterTable. This table stores parent record information for Search Match Parameter settings as they pertain to a grouping of specific Search Match Rules. |
| SELECT SM_TYPE ,SM_PARM_CD ,STATUS ,SM_ADHOC_FLG ,SM_ACCESS_FLG ,DESCR FROM PS_HCR_SM_PARM_TBL WHERE STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 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_PARM_TBL |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | SM_ADHOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Add Hoc flag. This flag identifies a Rule or Parameter as an Add Hoc search.
Y/N Table Edit Default Value: N |
| 5 | SM_ACCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Parameters Full Access flag. This flag identifies a Parameter as having Full Access for prompting.
Y/N Table Edit Default Value: N |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |