HCB_APP_REC

(SQL Table)
 Index Back

ChatBot UI Configuration

ChatBot UI Configuration

  • Related Language Record: HCB_APP_REC_LNG

    • # 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_ACTN_TYPE_CHT Character(1) VARCHAR2(1) NOT NULL Action Types
    A=Ask Questions
    C=PeopleCode
    D=Delete
    O=Other
    U=Update
    V=Display
    5 HCB_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL GPCB Source Type
    Q=PSQuery
    R=Record

    Default Value: R

    6 HCB_DATA_SOURCE Character(30) VARCHAR2(30) NOT NULL Chatbot Data Source

    Prompt Table: %EDITTABLE

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 HCB_LAYOUT_TYPE Character(1) VARCHAR2(1) NOT NULL Chatbot Display Layout
    C=Card
    L=List

    Default Value: C

    9 HCB_LAYOUT Character(1) VARCHAR2(1) NOT NULL Chatbot Display Layout
    H=Horizontal
    V=Vertical

    Default Value: H

    10 HCB_BOTMSG_TYPE Character(1) VARCHAR2(1) NOT NULL Chatbot BotMsg type
    M=Message Catalog
    T=Text

    Default Value: M

    11 HCB_BOTMSG_TXT Character(250) VARCHAR2(250) NOT NULL Chatbot title text
    12 HCB_BOT_MSG_NBR Number(5,0) INTEGER NOT NULL This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,

    Prompt Table: PSMSGCATDEFN

    13 HCB_TITLE_TYPE Character(1) VARCHAR2(1) NOT NULL Chatbot title
    F=Field
    M=Message Catalog
    T=Text

    Default Value: M

    14 HCB_TITLE_TXT Character(250) VARCHAR2(250) NOT NULL Chatbot title text
    15 HCB_TITLE_MSG_NBR Number(5,0) INTEGER NOT NULL This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,

    Prompt Table: PSMSGCATDEFN

    16 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HCB_PSFIELD2_VW

    17 FIELDNAME0 Character(18) VARCHAR2(18) NOT NULL Name of Field

    Prompt Table: HCB_QRYFLD_VW

    18 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N