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 |