PSRELTRX_CVW(SQL View) |
Index Back |
|---|
| SELECT RELATIONSHIPID , EFFDT , SRCNODE , SRCTRXTYPE , SRCRQSTMSGNAME , SRCRQSTMSGVER , TGTNODE , TGTRQSTMSGNAME , TGTRQSTMSGVER , VERSION , TGTTRXTYPE , ASYNCREPLYMSG , ASYNCREPLYVER , SEQNUM , RQSTTRNSFRMNAME , RESPTRNSFRMNAME , USERIDTYPE , EFF_STATUS , LASTUPDDTTM , LASTUPDOPRID , COMMENTS FROM PSRELATIONTRX A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PSRELATIONTRX B WHERE A.RELATIONSHIPID=B.RELATIONSHIPID AND A.SRCNODE=B.SRCNODE AND A.SRCTRXTYPE=B.SRCTRXTYPE AND A.SRCRQSTMSGNAME=B.SRCRQSTMSGNAME AND A.SRCRQSTMSGVER=B.SRCRQSTMSGVER AND A.TGTNODE=B.TGTNODE AND A.TGTRQSTMSGNAME=B.TGTRQSTMSGNAME AND A.TGTRQSTMSGVER=B.TGTRQSTMSGVER AND B.EFFDT<=%CurrentDateIn AND B.EFF_STATUS = 'A' ) |
| # | 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 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | SRCNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| 4 | SRCTRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Server Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| 5 | SRCRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 6 | SRCRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Source Request Message Version |
| 7 | TGTNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| 8 | TGTRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 9 | TGTRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Target Request Message Version |
| 10 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 11 | TGTTRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Server Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| 12 | ASYNCREPLYMSG | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 13 | ASYNCREPLYVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Asynchronous Reply Message Version |
| 14 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 15 | RQSTTRNSFRMNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Transformation ID |
| 16 | RESPTRNSFRMNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Transformation ID |
| 17 | USERIDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
User ID Type
CID=Company Identifier EID=Employee ID + Company ID EML=EMail Address OID=Operator ID + Company ID |
| 18 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 19 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 20 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 21 | COMMENTS | Long Character | CLOB | Comment |