HCB_APP_RCFLD(SQL Table) |
Index Back |
---|---|
ChatBot UI ConfigurationChatBot UI Configuration |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID | |
2 | Character(15) | VARCHAR2(15) NOT NULL | Module ID | |
3 | Character(12) | VARCHAR2(12) NOT NULL | Transaction ID | |
4 | Character(1) | VARCHAR2(1) NOT NULL |
GPCB Source Type
Q=PSQuery R=Record Default Value: Q |
|
5 | Character(1) | VARCHAR2(1) NOT NULL |
Action Types
A=Ask Questions C=PeopleCode D=Delete O=Other U=Update V=Display |
|
6 | Character(15) | VARCHAR2(15) NOT NULL | Scroll Name | |
7 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HCB_QRYFLD_VW |
|
8 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
9 | Number(3,0) | SMALLINT NOT NULL | Key Position | |
10 | HCB_CNTRL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Control Type
A=Attachment B=Button C=Call D=End Columns E=Email L=Line M=Message O=Start Columns P=Postback T=Text U=URL Default Value: L |
11 | HCB_DATA_SOURCE | Character(30) | VARCHAR2(30) NOT NULL |
Chatbot Data Source
Prompt Table: PSRECDEFNPVW |
12 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EOAW_RECNAME_VW |
13 | HCB_IS_ITERATIVE | Character(1) | VARCHAR2(1) NOT NULL |
HCB Iterative Field Indicator
N=No Y=Yes |
14 | HCB_LABEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GP Chatbot Label Type
L=Long M=Message S=Short T=Text Default Value: L |
15 | MSG_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: HCB_MSG_NBR_VW |
16 | HCB_SELECT_FLG_CH | Character(1) | VARCHAR2(1) NOT NULL |
Flag Changed
Y/N Table Edit Default Value: Y |
17 | HCB_MODIFY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Modify Flag
Y/N Table Edit Default Value: Y |
18 | HCB_DISP_COND | Character(15) | VARCHAR2(15) NOT NULL | Display Condition |
19 | HCB_DESCR | Character(100) | VARCHAR2(100) NOT NULL | HCB Description |
20 | HCB_EOCB_OPER1 | Character(2) | VARCHAR2(2) NOT NULL |
Field used in user interface for defining a formula element.
<=Is Less Than <==Is Less Than or equal to ==Equals >=Is Greater Than >==Is Greater Than or equal to LI=Like |
21 | HCB_PROP_STRING | Character(100) | VARCHAR2(100) NOT NULL | EOCB String value |
22 | PROMPT_TABLE | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: PSRECDEFN |
23 | PROMPT_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
This defines what field should be used when forming a prompt for a Configurable Matrix item.
Prompt Table: HCB_RECFLD_VW |
24 | PROMPTVIEW_ELEM | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Via Element
Prompt Table: HCB_RECFLD_VW |
25 | OK_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | OK... |
26 | CANCEL_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Cancel Button |
27 | HCB_NEWLINE | Character(1) | VARCHAR2(1) NOT NULL |
Chatbot UI Config- New Line
N=No Y=Yes Default Value: N |
28 | HCB_DISPLAYLABEL | Character(1) | VARCHAR2(1) NOT NULL |
Display Label
N=No Y=Yes Default Value: N |
29 | HCB_LABEL_BOLD | Character(1) | VARCHAR2(1) NOT NULL |
Label Bold Indicator
N=No Y=Yes Default Value: N |
30 | HCB_DISPLAYVALUE | Character(1) | VARCHAR2(1) NOT NULL |
Display value
N=No Y=Yes Default Value: N |
31 | HCB_VALUE_BOLD | Character(1) | VARCHAR2(1) NOT NULL |
Value Bold indicator
N=No Y=Yes Default Value: N |
32 | HCB_DISP_CURR | Character(1) | VARCHAR2(1) NOT NULL |
Display Currency Symbol
C=Currency Code N=No Symbol S=Currency Symbol Default Value: N |
33 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |
34 | HCB_CHAR | Character(30) | VARCHAR2(30) NOT NULL | Chat Bot Char |
35 | HCB_EXPRESSION | Long Character | CLOB | HCB Description |
36 | FLDEXPNUM | Number(3,0) | SMALLINT NOT NULL | Field Expression Number |