PSIBWRELATRXVW

Platform	View Text
Default	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

PeopleSoft Field Name	Description
RELATIONSHIPID	Integration Broker Relationship ID
EFFDT	Effective Date Default: %date
SRCNODE	Integration Server Business Entity ID Prompt Table: PSRELATNODEVW
SRCTRXTYPE	Integration Server Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous Prompt Table: PSRELSRCTYPVW
SRCRQSTMSGNAME	Integration Server Request Message Name Prompt Table: PSRELSRCTRXVW
SRCRQSTMSGVER	Integration Broker Source Request Message Version Prompt Table: PSSRCMSGVERVW
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