PSRELATCNTCT_VW (SQL View)	Index Back
Relationship Contact Details Integration Broker Relationship Specific Additional Contact Properties View

PSRELATCNTCT_VW

(SQL View)

Relationship Contact Details

Integration Broker Relationship Specific Additional Contact Properties View

SELECT RELATIONSHIPID ,MSGNODENAME ,COMPANYID ,AUTHOPTN ,IBPASSWORD ,CONTACTMNGR ,CONTACTEMAIL ,CONTACTPHONENBR , LASTUPDDTTM , LASTUPDOPRID FROM PSRELATCONTACT

# 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).

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