MSGNODENAMEMSGNAMEPSMSGDEFN_VW3(SQL View) |
Index Back |
|---|---|
Unstructured Message ViewUnstructured Message View |
| SELECT DISTINCT A.MSGNODENAME , B.MSGNAME , B.DESCR , B.CHNLNAME FROM PSNODETRX A , PSMSGDEFN B WHERE A.RQSTMSGNAME = B.MSGNAME AND A.RQSTMSGVER = B.DEFAULTVER AND A.EFFDT=( SELECT MAX(B.EFFDT) FROM PSNODETRX B WHERE B.MSGNODENAME=A.MSGNODENAME AND B.TRXTYPE=A.TRXTYPE AND B.RQSTMSGNAME=A.RQSTMSGNAME AND B.RQSTMSGVER=A.RQSTMSGVER AND B.EFF_STATUS='A' AND B.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 2 | MSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | CHNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Channel Name (see PSCHNLDEFN). |