HCR_SM_RSLT_CRT(SQL Table) |
Index Back |
|---|---|
Search Match Result CriteriaSearch Match Result Criteria. This table stores Search Match result fields. |
| # | 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 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | SM_RSLT_DSPLY | Character(2) | VARCHAR2(2) NOT NULL |
Search/Match Result Display options
DE=Display Entire Field DF=Display First DL=Display Last DP=Display Partial Date ME=Mask Entire Field Default Value: DE |
| 6 | SM_LENGTH | Number(3,0) | SMALLINT NOT NULL | Search Match Length field. This field identifies the length of a substring search. |
| 7 | SM_DAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Result Day of Month display flag.
Y/N Table Edit Default Value: N |
| 8 | SM_MONTH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Result Calendar Month display flag.
Y/N Table Edit Default Value: N |
| 9 | SM_YEAR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Result - Calander Year display flag.
Y/N Table Edit Default Value: N |