PSRELTRX_CVW |
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 | Field Type | Column Type | Description |
|---|---|---|---|
| RELATIONSHIPID | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Relationship ID (see PSRELATIONSHIP). |
| EFFDT | Date(10) | DATE | Effective Date |
| SRCNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| SRCTRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Server Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| SRCRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| SRCRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Source Request Message Version |
| TGTNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| TGTRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| TGTRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Target Request Message Version |
| VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| TGTTRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Server Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| ASYNCREPLYMSG | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| ASYNCREPLYVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Asynchronous Reply Message Version |
| SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| RQSTTRNSFRMNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Transformation ID |
| RESPTRNSFRMNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Transformation ID |
| 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 |
| EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 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. |
| 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. |
| COMMENTS | Long Character | CLOB | Comment |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |