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 NameField TypeColumn TypeDescription
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
IB_PSOFTSERVICECharacter(1)VARCHAR2(1) NOT NULLRestricted Service
IB_VALIDATIONCharacter(1)VARCHAR2(1) NOT NULLRuntime Schema Validation
IB_EXPORTSTATUSCharacter(1)VARCHAR2(1) NOT NULLExport Status
C=Changed After Export
E=Exported
N=Not Exported
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
IB_MSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLMessage Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19