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 NameField TypeColumn TypeDescription
RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
EFFDTDate(10)DATEEffective Date
SRCNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID
SRCTRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
SRCRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name
SRCRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Source Request Message Version
TGTNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID
TGTRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name
TGTRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Target Request Message Version
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
TGTTRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
ASYNCREPLYMSGCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name
ASYNCREPLYVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Asynchronous Reply Message Version
SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
RQSTTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID
RESPTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID
USERIDTYPECharacter(3)VARCHAR2(3) NOT NULLUser ID Type
CID=Company Identifier
EID=Employee ID + Company ID
EML=EMail Address
OID=Operator ID + Company ID
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
COMMENTSLong CharacterCLOBComment
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19