IB_SERVICENAMEIB_OPERATIONNAMEVERSIONNAMELANGUAGE_CDPSSERVICEOP_LVW(SQL View) |
Index Back |
|---|---|
IB rel. language view. |
| SELECT T.IB_SERVICENAME , B.IB_OPERATIONNAME , B.VERSIONNAME , B.LANGUAGE_CD , B.DESCR FROM PSSERVICEOPR T , PSOPERATION A , PSOPRVERDFNLANG B WHERE T.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |