PSRELTRX_SRCH

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

Default Value: %date

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

Prompt Table: PSRELATNODEVW

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

Prompt Table: PSRELSRCTRXVW

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

Prompt Table: PSSRCMSGVERVW

6 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

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

Prompt Table: PSRELATNODEVW

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

Prompt Table: PSRELTGTTRXVW

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

Prompt Table: PSTGTMSGVERVW

10 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
11 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

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

Prompt Table: PSRELSRCTRXVW

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

Prompt Table: ASYNCREPLYVERVW

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

Prompt Table: PSRELTRNSFRMVW

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

Prompt Table: PSRELTRNSFRMVW

17 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
18 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
19 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.
20 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.
21 COMMENTS Long Character CLOB Comment