SM_TYPEA=Applicant
O=Organization
P=Person
SM_RSLT_CDSM_RSLT_FLDPrompt Table: HCR_SM_RFLD_TBL
LANGUAGE_CDHCR_SM_RCRT_LNG(SQL View) |
Index Back |
|---|---|
Search Match Rslt Criteria VWSearch Match Result Criteria View. This view pulls together the result criteria and record.table relationships. |
| SELECT A.SM_TYPE , B.SM_RSLT_CD , A.SM_RSLT_FLD , A.LANGUAGE_CD , A.DESCR FROM PS_HCR_SM_RFLD_LNG A ,PS_HCR_SM_RSLT_CRT B WHERE A.SM_TYPE = B.SM_TYPE AND A.SM_RSLT_FLD = B.SM_RSLT_FLD |
| # | 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_CD |
Character(15) | VARCHAR2(15) NOT NULL | Search Match Result Code. |
| 3 | SM_RSLT_FLD |
Character(30) | VARCHAR2(30) NOT NULL |
Search Match Result Field. This field relates the search result record.field relationships.
Prompt Table: HCR_SM_RFLD_TBL |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |