HCB_BT_APP_ACTN(SQL Table) |
Index Back |
---|---|
Chatbot ConfigurationChatbot Configuration |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HCB_APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
2 | HCB_MODULE_ID | Character(15) | VARCHAR2(15) NOT NULL | Module ID |
3 | HCB_APPID_NAME | Character(50) | VARCHAR2(50) NOT NULL | Application ID Name |
4 | HCB_INTENT_ID | Character(50) | VARCHAR2(50) NOT NULL | Chat Intent |
5 | HCB_ACTION_ID | Character(12) | VARCHAR2(12) NOT NULL | Transaction ID |
6 | HCB_ACTN_TYPE_CHT | Character(1) | VARCHAR2(1) NOT NULL |
Action Types
A=Ask Questions C=PeopleCode D=Delete O=Other U=Update V=Display |
7 | HCB_MODULE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Module Name |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | PARENT_TRANS_ID | Character(12) | VARCHAR2(12) NOT NULL | Parent Transaction ID |
10 | HCB_PARENT_TRANSID | Character(30) | VARCHAR2(30) NOT NULL |
Parent Transaction ID
Prompt Table: HCB_TRANSID_VW |
11 | HCB_METHOD_NAME | Character(100) | VARCHAR2(100) NOT NULL | Method Name |
12 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
13 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
14 | DETAILS_LINK | Character(1) | VARCHAR2(1) NOT NULL | Details |
15 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |