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 Name Field Type Column Type Description
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20