PSCONPROPDATAVW

(SQL View)
Index Back

SELECT DISTINCT CONNGATEWAYID , CONNID , PROPID , PROPNAME , DATATYPEDESCR 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 DATATYPEDESCR Character(15) VARCHAR2(15) NOT NULL Data Type Description