IB_SERVICENAMEIB_OPERATIONNAMEVERSIONNAMEPSSERVICEOP_VW3(SQL View) |
Index Back |
|---|
| SELECT S.IB_SERVICENAME , S.IB_OPERATIONNAME , V.VERSIONNAME , V.IB_EXCLUDE_TOKEN FROM PSSERVICEOPR S , PSOPRVERDFN V , PSOPERATION A WHERE S.IB_OPERATIONNAME = V.IB_OPERATIONNAME AND S.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.PTIBAPPLNAME = ' ' |
| # | 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 | IB_EXCLUDE_TOKEN | Character(1) | VARCHAR2(1) NOT NULL | Exclude PSFT Auth Token |