PSOPERATION2_VW

index back

IB Non-default versions.

View of default versions for all Service Operations.
SELECT A.IB_OPERATIONNAME , A.VERSIONNAME , A.ACTIVE_FLAG , B.IB_SERVICENAME FROM PSOPRVERDFN A , PSSERVICEOPR B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME

PeopleSoft Field NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
A=Active
I=Inactive
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19