PSCBAPPLSVC_VW1(SQL View) |
Index Back |
|---|---|
Application Service DefnApplication Services for chat bots. |
| SELECT * FROM PSCBAPPLDEFN WHERE PTCBAPPLNAME NOt IN ('PT_CONFIGURATION') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTCBAPPLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Service ID for chat bot services. |
| 2 | PTCBAPPLTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field to denote whether a service is master or Alias
A=Alias Service M=Master Service Default Value: M |
| 3 | PTCBURLPARAMNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Service Name for chat bot services. |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSCBAPPCLS_VW |
| 6 | APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL | Application Class Method Name |
| 7 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSCBPKGCLS_VW |
| 8 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSCBPATH_VW |
| 9 | PTCBCACHESUPPORT | Character(4) | VARCHAR2(4) NOT NULL |
Service Cache Support for a particular application service
NONE=OAuth Authentication SYS=PS ODA Authentication Default Value: NONE |
| 10 | PTMULTIROWINPUT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Row indicator
Y/N Table Edit Default Value: N |
| 11 | PTMULTIROWOUTPUT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Row indicator
Y/N Table Edit Default Value: N |
| 12 | PTCB_ASENDUSER | Character(1) | VARCHAR2(1) NOT NULL |
Flag to check whether the service should be run in end user scope or not.
Y/N Table Edit Default Value: Y |
| 13 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 14 | PTCB_SRC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Source Type
APPL=Application Class CI=CI |