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 Name Field Type Column Type Description
RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

SRCNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

SRCRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

SRCRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Source Request Message Version

Prompt Table: PSSRCMSGVERVW

SRCTRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELSRCTYPVW

TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

TGTRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELTGTTRXVW

TGTRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Target Request Message Version

Prompt Table: PSTGTMSGVERVW

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

Prompt Table: PSRELTGTTYPVW

ASYNCREPLYMSG Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

ASYNCREPLYVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Asynchronous Reply Message Version

Prompt Table: ASYNCREPLYVERVW

SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
RQSTTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

RESPTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20