PSRELATCNTCT_VW

(SQL View)
Index Back

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.