PSRELATCNTCT_VW

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 NameField TypeColumn TypeDescription
RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
COMPANYIDCharacter(15)VARCHAR2(15) NOT NULLCompany ID
AUTHOPTNCharacter(1)VARCHAR2(1) NOT NULLIntegration Broker Authentication Option
C=Certificate
N=None
P=Password

Default: N

IBPASSWORDCharacter(88)VARCHAR2(88) NOT NULLIntegration Broker Password
CONTACTMNGRCharacter(50)VARCHAR2(50) NOT NULLIntegration Server Business Entity Contact Manager
CONTACTEMAILCharacter(70)VARCHAR2(70) NOT NULLIntegration Server Business Entity Contact Email
CONTACTPHONENBRCharacter(24)VARCHAR2(24) NOT NULLIntegration Server Business Entity Contact Phone Number
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19