RDH_MATCH_RULE_IDD=Expanded
S=Search
RDH_MATRUL_A_VW(SQL View) |
Index Back |
|---|---|
Active match rules.This view returns all the active match rules |
| SELECT RDH_MATCH_RULE_ID ,RDH_MATCH_RULE ,DESCR254 ,RDH_RULE_PURPOSE FROM PS_RDH_MATCH_RULE WHERE RDH_RULE_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RDH_MATCH_RULE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Match Rule Identifier |
| 2 | RDH_MATCH_RULE | Character(200) | VARCHAR2(200) NOT NULL | Match rule name. |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | RDH_RULE_PURPOSE | Character(1) | VARCHAR2(1) NOT NULL |
Rule usage. Weather rule is being used for searching or duplicate prevention.
D=Expanded S=Search |