PTPPB_IBCON_PVW

index back

SELECT DISTINCT E.OPRID , A.CONNGATEWAYID , A.CONNID 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).
PTPPB_CHAR_1Character(97)VARCHAR2(97) NOT NULLCharacter Field 1
CONNIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Connector ID

Prompt Table: PSCONNIDVW

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19