PSRELATCONTACT (SQL Table)	Index Back
Relationship Contact Details Integration Broker Relationship Specific Additional Contact Properties

PSRELATCONTACT

(SQL Table)

Relationship Contact Details

Integration Broker Relationship Specific Additional Contact Properties

# 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 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Default Value: PSRELATIONWRK.MSGNODENAME

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

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

5 IBPASSWORD Character(254) VARCHAR2(254) NOT NULL Integration Broker Password

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

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

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

9 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.

10 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.

#	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	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). Default Value: PSRELATIONWRK.MSGNODENAME
3	COMPANYID	Character(15)	VARCHAR2(15) NOT NULL	Company ID
4	AUTHOPTN	Character(1)	VARCHAR2(1) NOT NULL	Integration Broker Authentication Option C=Certificate N=None P=Password Default Value: N
5	IBPASSWORD	Character(254)	VARCHAR2(254) NOT NULL	Integration Broker Password
6	CONTACTMNGR	Character(50)	VARCHAR2(50) NOT NULL	Integration Server Business Entity Contact Manager
7	CONTACTEMAIL	Character(70)	VARCHAR2(70) NOT NULL	Integration Server Business Entity Contact Email
8	CONTACTPHONENBR	Character(24)	VARCHAR2(24) NOT NULL	Integration Server Business Entity Contact Phone Number
9	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.
10	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.