PSEXTNODE_VW

(SQL View)
Index Back

External Node Definition View

View of External Nodes

SELECT MSGNODENAME , DESCR , NODE_TYPE , AUTHOPTN , CONTACTURL , DESCRLONG FROM PSMSGNODEDEFN WHERE ACTIVE_NODE = '1' AND NODE_TYPE = 'EX'

  • Related Language Record: PSEXTNODE_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
    EX=External
    ICT=Pre-PeopleTools 8.4
    PIA=PeopleSoft
    4 AUTHOPTN Character(1) VARCHAR2(1) NOT NULL Integration Broker Authentication Option
    C=Certificate
    N=None
    P=Password
    5 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
    6 DESCRLONG Long Character CLOB Long Description