OPRIDCONNGATEWAYIDPTPPB_IBGAT_PVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT E.OPRID ,A.CONNGATEWAYID FROM PS_PTPPB_IBCON_TBL A , PSGATEWAY B , PS_PTPPB_IBCON_DFT C , PS_PTPPB_IBCON_SEC D , PSUSERCLASSVW E WHERE (A.ACTIVE_FLAG='A' AND A.CONNGATEWAYID=B.CONNGATEWAYID AND A.CONNGATEWAYID=C.CONNGATEWAYID AND A.PTPPB_DEF_SECURITY='Y' AND C.PERMLISTID=E.CLASSID ) OR ( A.ACTIVE_FLAG='A' AND A.CONNGATEWAYID=B.CONNGATEWAYID AND A.CONNGATEWAYID=D.CONNGATEWAYID AND A.CONNID=D.CONNID AND A.PTPPB_DEF_SECURITY='N' AND D.PERMLISTID=E.CLASSID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | CONNGATEWAYID |
Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit |