MIN_SERVICES_VW(SQL View) |
Index Back |
---|---|
IB services prompt view . |
SELECT DISTINCT B.IB_SERVICENAME , A.IB_OPERATIONNAME , C.VERSIONNAME , A.DESCR FROM PSSERVICEOPR B , PSOPERATION A , PSOPRVERDFN C WHERE B.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = C.IB_OPERATIONNAME |
# | 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 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |