IB_SERVICENAMEPSSERVPACKGE_VW(SQL View) |
Index Back |
|---|---|
Service REST Package info. |
| SELECT S.IB_SERVICENAME , M.IB_PACKAGEID , M.IB_SCHEMANAME , M.IB_VARIANTNAME FROM PSSERVICEOPR S , PSOPERATION P , PSMSGVER M WHERE S.IB_OPERATIONNAME = P.IB_OPERATIONNAME AND P.MSGNAME = M.MSGNAME AND P.IB_MSGVERSION = M.APMSGVER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). |
| 2 | IB_PACKAGEID | Character(100) | VARCHAR2(100) NOT NULL | Referenced Package |
| 3 | IB_SCHEMANAME | Character(100) | VARCHAR2(100) NOT NULL | Document Name |
| 4 | IB_VARIANTNAME | Character(30) | VARCHAR2(30) NOT NULL | Version Name |