TL_DU_ST_TCD_VW(SQL View) |
Index Back |
|---|---|
TCD Setup verification |
| SELECT A.RQSTMSGNAME ,A.MSGNODENAME ,B.MSGSTATUS , C.XLATSHORTNAME ,A.EFF_STATUS FROM PSNODETRX A ,PSMSGDEFN B , XLATTABLE_VW C WHERE A.RQSTMSGNAME=B.MSGNAME AND C.FIELDNAME='TRXTYPE' AND C.FIELDVALUE=A.TRXTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 2 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 3 | MSGSTATUS | Number(1,0) | SMALLINT NOT NULL | Message Status |
| 4 | TRANSACTION_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Transaction Title |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |