PTPPB_IBGAT_PVW

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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CONNGATEWAYIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19