PSRELTRX_CVW |
| Platform | View Text |
|---|---|
| Default | 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 | Description |
|---|---|
| RELATIONSHIPID | Integration Broker Relationship ID |
| EFFDT | Effective Date |
| SRCNODE | Integration Server Business Entity ID |
| SRCTRXTYPE | Integration Server Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| SRCRQSTMSGNAME | Integration Server Request Message Name |
| SRCRQSTMSGVER | Integration Broker Source Request Message Version |
| TGTNODE | Integration Server Business Entity ID |
| TGTRQSTMSGNAME | Integration Server Request Message Name |
| TGTRQSTMSGVER | Integration Broker Target Request Message Version |
| VERSION | Internal PeopleTools version to control reloading of objects in cache. |
| TGTTRXTYPE | Integration Server Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| ASYNCREPLYMSG | Integration Server Request Message Name |
| ASYNCREPLYVER | Integration Broker Asynchronous Reply Message Version |
| SEQNUM | Sequence Number |
| RQSTTRNSFRMNAME | Integration Server Transformation ID |
| RESPTRNSFRMNAME | Integration Server Transformation ID |
| USERIDTYPE | User ID Type CID=Company Identifier EID=Employee ID + Company ID EML=EMail Address OID=Operator ID + Company ID |
| EFF_STATUS | Effective Status A=Active I=Inactive |
| LASTUPDDTTM | 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. |
| LASTUPDOPRID | 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. |
| COMMENTS | Comment |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |