RELATIONSHIPIDTGTNODERQSTMSGNAMEPSRELTGTTRXVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.RQSTMSGNAME FROM PSRELATIONSHIP A , PSNODETRX B WHERE A.NODE1 = B.MSGNODENAME OR A.NODE2 = B.MSGNODENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RELATIONSHIPID |
Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Relationship ID (see PSRELATIONSHIP). |
| 2 | TGTNODE |
Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| 3 | RQSTMSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |