IB_SERVICENAMEPrompt Table: PSSERVICE
Prompt Table: PSOPERATION
PSPTIBOPERAT_VW(SQL View) |
Index Back |
|---|---|
IB view of service operations. |
| SELECT a.IB_SERVICENAME , b.IB_OPERATIONNAME , b.DEFAULTVER , b.IB_ALIASNAME , b.DESCR , b.OBJECTOWNERID FROM PSSERVICEOPR a , PSOPERATION b WHERE a.IB_OPERATIONNAME = b.IB_OPERATIONNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL |
Service (see PSSERVICE).
Prompt Table: PSSERVICE |
| 2 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table: PSOPERATION |
| 3 | DEFAULTVER | Character(30) | VARCHAR2(30) NOT NULL | Default Application Message Version |
| 4 | IB_ALIASNAME | Character(128) | VARCHAR2(128) NOT NULL | Service Alias |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |