HCB_APP_RCFLD

(SQL Table)
Index Back

ChatBot UI Configuration

ChatBot UI Configuration

  • Parent Record Of HCB_COND_FRML_D
  • # 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_ACTION_ID Character(12) VARCHAR2(12) NOT NULL Transaction ID
    4 HCB_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL GPCB Source Type
    Q=PSQuery
    R=Record

    Default Value: Q

    5 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
    6 SCROLL_NAME Character(15) VARCHAR2(15) NOT NULL Scroll Name
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HCB_QRYFLD_VW

    8 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    9 KEYPOSN 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