PSRELTRX_SRCH

Platform	View Text
Default	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 Name	Description
RELATIONSHIPID	Integration Broker Relationship ID
EFFDT	Effective Date Default: %date
SRCNODE	Integration Server Business Entity ID Prompt Table: PSRELATNODEVW
SRCRQSTMSGNAME	Integration Server Request Message Name Prompt Table: PSRELSRCTRXVW
SRCRQSTMSGVER	Integration Broker Source Request Message Version Prompt Table: PSSRCMSGVERVW
SRCTRXTYPE	Integration Server Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous Prompt Table: PSRELSRCTYPVW
TGTNODE	Integration Server Business Entity ID Prompt Table: PSRELATNODEVW
TGTRQSTMSGNAME	Integration Server Request Message Name Prompt Table: PSRELTGTTRXVW
TGTRQSTMSGVER	Integration Broker Target Request Message Version Prompt Table: PSTGTMSGVERVW
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 Prompt Table: PSRELTGTTYPVW
ASYNCREPLYMSG	Integration Server Request Message Name Prompt Table: PSRELSRCTRXVW
ASYNCREPLYVER	Integration Broker Asynchronous Reply Message Version Prompt Table: ASYNCREPLYVERVW
SEQNUM	Sequence Number
RQSTTRNSFRMNAME	Integration Server Transformation ID Prompt Table: PSRELTRNSFRMVW
RESPTRNSFRMNAME	Integration Server Transformation ID Prompt Table: PSRELTRNSFRMVW
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