PSRELATCONTACT - Relationship Contact Details

PSRELATCONTACT	index back
Relationship Contact Details

Integration Broker Relationship Specific Additional Contact Properties

PeopleSoft Field Name Field Type Column Type Description

RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).

MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Default: PSRELATIONWRK.MSGNODENAME

COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

AUTHOPTN Character(1) VARCHAR2(1) NOT NULL Integration Broker Authentication Option
C=Certificate
N=None
P=Password
Default: N

IBPASSWORD Character(88) VARCHAR2(88) NOT NULL Integration Broker Password

CONTACTMNGR Character(50) VARCHAR2(50) NOT NULL Integration Server Business Entity Contact Manager

CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email

CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number

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.

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
RELATIONSHIPID	Character(30)	VARCHAR2(30) NOT NULL	Integration Broker Relationship ID (see PSRELATIONSHIP).
MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). Default: PSRELATIONWRK.MSGNODENAME
COMPANYID	Character(15)	VARCHAR2(15) NOT NULL	Company ID
AUTHOPTN	Character(1)	VARCHAR2(1) NOT NULL	Integration Broker Authentication Option C=Certificate N=None P=Password Default: N
IBPASSWORD	Character(88)	VARCHAR2(88) NOT NULL	Integration Broker Password
CONTACTMNGR	Character(50)	VARCHAR2(50) NOT NULL	Integration Server Business Entity Contact Manager
CONTACTEMAIL	Character(70)	VARCHAR2(70) NOT NULL	Integration Server Business Entity Contact Email
CONTACTPHONENBR	Character(24)	VARCHAR2(24) NOT NULL	Integration Server Business Entity Contact Phone Number
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.