MSGNAMEPSIBMSGDEFN_VW(SQL View) |
Index Back |
|---|---|
Message Name ViewMessage Name View that excludes messages containing JSON schemas. |
| SELECT DISTINCT MSGNAME FROM PSMSGVER A WHERE NOT EXISTS (SELECT 'X' from PSIBSCMADFN B where A.MSGNAME = B.MSGNAME and A.APMSGVER = B.APMSGVER and B.PT_SCHEMATYPE = 1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |