PSIBAPPMETHOD(SQL Table) |
Index Back |
|---|---|
IB App Methoids |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Application Service ID. (see PSIBAPPLDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Application Service Opr ID | |
| 3 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
| 4 | Character(10) | VARCHAR2(10) NOT NULL | REST Method | |
| 5 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
| 6 | PTIBCACHESUPPORT | Character(4) | VARCHAR2(4) NOT NULL |
Service Cache Support for a particular application service
NONE=No Cache SYS=System Level USER=User Level |
| 7 | IB_CACHETIME | Number(5,0) | INTEGER NOT NULL | Re-Cache Time (Hours) |
| 8 | PTMULTIROWINPUT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Row indicator
Y/N Table Edit Default Value: N |
| 9 | PTMULTIROWOUTPUT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Row indicator
Y/N Table Edit Default Value: N |
| 10 | PTIB_ASENDUSER | Character(1) | VARCHAR2(1) NOT NULL |
Flag to check whether the service should be run in end user scope or not.
N=No Y=Yes Default Value: Y |
| 11 | PTIB_AUTHOPTION | Character(1) | VARCHAR2(1) NOT NULL |
Authentication Option
B=Basic Auth O=oAuth2 |
| 12 | PTCBURLPARAMNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Service Name for chat bot services. |
| 13 | IBEXTERNALUSERID | Character(30) | VARCHAR2(30) NOT NULL | External User ID |
| 14 | IBEXTERNALPWD | Character(254) | VARCHAR2(254) NOT NULL | Integration Broker External Password |
| 15 | PTAPP_NAME | Character(100) | VARCHAR2(100) NOT NULL |
Application Name
Prompt Table: PSIBPSPTSEC_VW |