PSCONPROPVALVW

(SQL View)
Index Back

SELECT DISTINCT CONNGATEWAYID , CONNID , PROPID , PROPNAME , PROPVALUE FROM PSCONNPROP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONNGATEWAYID Character(30) VARCHAR2(30) NOT NULL Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit
2 CONNID Character(30) VARCHAR2(30) NOT NULL Integration Server Connector ID
3 PROPID Character(30) VARCHAR2(30) NOT NULL Integration Server Property ID
HDR=HTTP Header
QP=Query Parm
4 PROPNAME Character(30) VARCHAR2(30) NOT NULL Property Name
5 PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value