HCB_COND_FRML_D

(SQL Table)
Index Back

Condition formula

ChatBot conditional formula

  • Parent record: HCB_APP_RCFLD
  • # 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
    6 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HCB_QRYFLD_VW

    8 INDEXCOUNT Number(2,0) SMALLINT NOT NULL Index Count
    9 SCROLL_NAME Character(15) VARCHAR2(15) NOT NULL Scroll Name
    10 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: HCB_PSFIELD2_VW

    11 HCB_DATA_SOURCE Character(30) VARCHAR2(30) NOT NULL Chatbot Data Source
    12 HCB_FLD_FMT1 Number(2,0) SMALLINT NOT NULL Field format for types
    1=Character
    2=Date
    3=Monetary
    4=Decimal
    5=Element Pointer
    6=Not Applicable
    13 HCB_FM_OPERATOR Character(1) VARCHAR2(1) NOT NULL FM Operator
    1=Null
    2=Not Null
    3=>
    4=<
    5=>=
    6=<=
    7==
    14 HCB_FRML_TYPE Character(1) VARCHAR2(1) NOT NULL Type
    C=Character
    D=Date
    F=Field
    N=Number
    15 HCB_NUM Number(6,0) INTEGER NOT NULL Chat bot Number
    16 HCB_CHAR Character(30) VARCHAR2(30) NOT NULL Chat Bot Char
    17 HCB_DATE Date(10) DATE Chat Bot Date
    18 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Field Name 2

    Prompt Table: HCB_PSFIELD2_VW

    19 HCB_FLD_FMT2 Number(2,0) SMALLINT NOT NULL Field format for types
    20 OK_BUTTON Character(1) VARCHAR2(1) NOT NULL OK...
    21 CANCEL_BUTTON Character(1) VARCHAR2(1) NOT NULL Cancel Button
    22 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data