PSRELTRX_SRCH

index back

Relationship Transactions

Integration Broker Relationship Transactions
SELECT RELATIONSHIPID , EFFDT , SRCNODE , SRCRQSTMSGNAME , SRCRQSTMSGVER , SRCTRXTYPE , TGTNODE , TGTRQSTMSGNAME , TGTRQSTMSGVER , VERSION , TGTTRXTYPE , ASYNCREPLYMSG , ASYNCREPLYVER , SEQNUM , RQSTTRNSFRMNAME , RESPTRNSFRMNAME , USERIDTYPE , EFF_STATUS , LASTUPDDTTM , LASTUPDOPRID , COMMENTS FROM PSRELATIONTRX

PeopleSoft Field NameField TypeColumn TypeDescription
RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

SRCNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID

Prompt Table: PSRELATNODEVW

SRCRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

SRCRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Source Request Message Version

Prompt Table: PSSRCMSGVERVW

SRCTRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELSRCTYPVW

TGTNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID

Prompt Table: PSRELATNODEVW

TGTRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELTGTTRXVW

TGTRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Target Request Message Version

Prompt Table: PSTGTMSGVERVW

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

Prompt Table: PSRELTGTTYPVW

ASYNCREPLYMSGCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

ASYNCREPLYVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Asynchronous Reply Message Version

Prompt Table: ASYNCREPLYVERVW

SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
RQSTTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

RESPTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

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