MATCH_RULE_IDEM_MTCH_MSG_VW(SQL View) |
Index Back |
|---|---|
Match Messages |
| SELECT A.MATCH_RULE_ID , B.DESCRLONG FROM PS_AP_MTCH_RULES A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule ID |
| 2 | DESCRLONG | Long Character | CLOB | Long Description |