PSDOCLOSRVOP_VW

(SQL View)
 Index Back

Service operation layouts.

Lists all the document layouts connected to a specific service.

SELECT A.IB_SERVICENAME , A.IB_OPERATIONNAME , B.IBDOCLAYOUTNAME FROM PSSERVICEOPR A , PSDOCLODEFN B WHERE A.IB_SERVICENAME = B.IB_SERVICENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
2 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
3 IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).