IB_SERVICENAMEPrompt Table: PSSERVICE
LANGUAGE_CDPrompt Table: PSOPERATION
PSPTIBOPERT_LVW(SQL View) |
Index Back |
|---|---|
IB rel. language view. |
| SELECT A.IB_SERVICENAME , c.LANGUAGE_CD , b.IB_OPERATIONNAME , b.DEFAULTVER , b.IB_ALIASNAME , b.DESCR , b.OBJECTOWNERID FROM PSSERVICEOPR a , PSOPERATION b , PSOPERATIONLANG c WHERE a.IB_OPERATIONNAME = b.IB_OPERATIONNAME AND B.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).
Prompt Table: PSSERVICE |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table: PSOPERATION |
| 4 | DEFAULTVER | Character(30) | VARCHAR2(30) NOT NULL | Default Application Message Version |
| 5 | IB_ALIASNAME | Character(128) | VARCHAR2(128) NOT NULL | Service Alias |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |