SM_TYPEA=Applicant
O=Organization
P=Person
SM_RULE_CDSM_RULEPrompt Table: HCR_SM_PROP_TBL
Y/N Table Edit
Default Value: Y
B=Begins With
C=Contains
E=Equals
N=Not Used
Default Value: E
Default Value: 1
Default Value: 0
HCR_SM_CRIT_TBL(SQL Table) |
Index Back |
|---|---|
Search Match Rule CriteriaSearch Match Rule Criteria Table. This table stores information for Search Match Criteria settings as they pertain to a specific Search Match Rule. |
| # | 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_RULE_CD |
Character(15) | VARCHAR2(15) NOT NULL | Search Match Rule Code. This field stores the high level key for a Search Match Rule definition. |
| 3 | SM_RULE |
Character(30) | VARCHAR2(30) NOT NULL |
Search Match Rule. This field holds the search property rule for the database field.
Prompt Table: HCR_SM_PROP_TBL |
| 4 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | SM_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Required field. This field identifies a Search Match Rule element as being required or not.
Y/N Table Edit Default Value: Y |
| 6 | SM_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Usage field. This field controls the usage parameters for the Search Match Rule for Character fieldtypes.
B=Begins With C=Contains E=Equals N=Not Used Default Value: E |
| 7 | SM_STARTPOS | Number(3,0) | SMALLINT NOT NULL |
Search Match Starting Position field. This field identifies the starting position of a substring search.
Default Value: 1 |
| 8 | SM_LENGTH | Number(3,0) | SMALLINT NOT NULL |
Search Match Length field. This field identifies the length of a substring search.
Default Value: 0 |