PSOPERATION(SQL Table) |
Index Back |
|---|---|
IB Services |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation |
| 2 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
Default Value: 1 |
| 3 | DEFAULTVER | Character(30) | VARCHAR2(30) NOT NULL | Default Application Message Version |
| 4 | RTNGTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Routing Type
A=Asynchronous - One Way N=Synchronous Non-Blocking R=Asynch Request/Response S=Synchronous X=Asynch to Synch |
| 5 | IB_USERPWDREQ | Character(1) | VARCHAR2(1) NOT NULL |
User/Password Required
Y/N Table Edit Default Value: N |
| 6 | IB_REQUESTSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Req Verification
A=Digital Sign or SSL B=Encrypt and Digitally Sign C=Encrypt/Digital Sign or SSL D=Digitally Signed E=Encrypt H=SSL K=Encrypt or SSL N=None Default Value: N |
| 7 | IB_ACTIVEDATAGUARD | Number(1,0) | SMALLINT NOT NULL | Active Data Guard |
| 8 | IB_THINKTIME | Number(1,0) | SMALLINT NOT NULL | Used with Think Time Methods |
| 9 | IB_CONNAV | Number(1,0) | SMALLINT NOT NULL | Conditional Navigation |
| 10 | IB_READONLY_PERM | Number(1,0) | SMALLINT NOT NULL | Read Only Permission List |
| 11 | IB_RESTMETHOD | Character(10) | VARCHAR2(10) NOT NULL | REST Method |
| 12 | IB_REST_SERVICE | Number(1,0) | SMALLINT NOT NULL | REST Service Type |
| 13 | IB_RESTBASE_URL | Character(254) | VARCHAR2(254) NOT NULL | REST Base URL |
| 14 | IB_REST_OVERRIDE | Number(1,0) | SMALLINT NOT NULL | REST Override |
| 15 | IB_SERVICENAME | Character(30) | VARCHAR2(30) NOT NULL |
Service (see PSSERVICE).
Prompt Table: PSSERVICE |
| 16 | PTIBAPPLNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Service ID. (see PSIBAPPLDEFN). |
| 17 | IB_ALIASNAME | Character(128) | VARCHAR2(128) NOT NULL | Service Alias |
| 18 | MSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
Prompt Table: PSMSGDEFN |
| 19 | IB_MSGVERSION | Character(30) | VARCHAR2(30) NOT NULL |
Message Version
Prompt Table: PSSRVMSGVER_VW |
| 20 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 21 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 22 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 23 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 24 | DESCRLONG | Long Character | CLOB | Long Description |