MATCH_RULE_IDLANGUAGE_CDMTCH_MSG_VWLANG(SQL View) |
Index Back |
|---|---|
Match Messages |
| SELECT A.MATCH_RULE_ID , C.LANGUAGE_CD , C.DESCRLONG FROM PS_AP_MTCH_RULES A , PSMSGCATDEFN B , PSMSGCATLANG C WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR AND B.MESSAGE_SET_NBR = C.MESSAGE_SET_NBR AND B.MESSAGE_NBR = C.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |