PSSERVOPERM_VW

index back

SELECT DISTINCT S.IB_SERVICENAME , O.IB_OPERATIONNAME , V.VERSIONNAME , S.IB_PSOFTSERVICE , V.IB_VALIDATION , V.IB_EXPORTSTATUS , P.MSGNAME , P.IB_MSGVERSION FROM PSSERVICE S , PSSERVICEOPR O , PSOPRVERDFN V , PSOPRVERDFNPARM P WHERE S.IB_SERVICENAME = O.IB_SERVICENAME AND O.IB_OPERATIONNAME = V.IB_OPERATIONNAME AND V.IB_OPERATIONNAME = P.IB_OPERATIONNAME AND V.VERSIONNAME = P.VERSIONNAME

PeopleSoft Field Name Field Type Column Type Description
IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service
IB_VALIDATION Character(1) VARCHAR2(1) NOT NULL Runtime Schema Validation
IB_EXPORTSTATUS Character(1) VARCHAR2(1) NOT NULL Export Status
C=Changed After Export
E=Exported
N=Not Exported
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19