SM_TYPEA=Applicant
O=Organization
P=Person
SM_RSLT_FLDPrompt Table: %EDITTABLE
Prompt Table: HCR_SM_RFDPRMPT
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
HCR_SM_RFLD_TBL(SQL Table) |
Index Back |
|---|---|
Search Match Result FieldsSearch Match Result Fields. This table stores system data as well as user defined data tied to each Search Match result field. Properties are separated by type (Person, Applicant, Organization). |
| # | 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 |
| 2 | SM_RSLT_FLD |
Character(30) | VARCHAR2(30) NOT NULL | Search Match Result Field. This field relates the search result record.field relationships. |
| 3 | SM_RECORD | Character(15) | VARCHAR2(15) NOT NULL |
Search Match Record. This field holds the search result database record name for the Search Match Rules definitions.
Prompt Table: %EDITTABLE |
| 4 | SM_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Search Match Field. This field holds the search property database field name for the Search Match Rules definitions.
Prompt Table: HCR_SM_RFDPRMPT |
| 5 | SM_SYSDATA | Character(1) | VARCHAR2(1) NOT NULL |
System Data flag
Y/N Table Edit Default Value: N |
| 6 | SM_EFFDT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search/Match Effective Dated
Y/N Table Edit Default Value: N |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |