OPRVERDFN_VW

(SQL View)
Index Back

IB Service Versions vw (trans)

IB service version view (trans)

SELECT V.IB_OPERATIONNAME , V.VERSIONNAME , V.VERSION , O.IB_SERVICENAME , V.DESCR , V.DESCRLONG FROM PSOPRVERDFN V , PSOPERATION O WHERE V.IB_OPERATIONNAME = O.IB_OPERATIONNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default Value: 1

4 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRLONG Long Character CLOB Long Description