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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19