PY_CAT_CODE_TBL

(SQL Table)
Index Back

Chat Category Code selection

Chat Category Code selection

  • Related Language Record: PY_CAT_CODE_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_CATGRY_TYPE Character(3) VARCHAR2(3) NOT NULL Category type for Chatbot category setup
    D=Deductions
    E=Earnings
    G=Garnishment
    S=Employee Status
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 PY_CTGRY_USED_BY Character(1) VARCHAR2(1) NOT NULL Category Used By
    C=Chatbot
    K=Insights

    Default Value: C

    4 PY_CATEGORY_ID Character(6) VARCHAR2(6) NOT NULL Category ID used specifically for Chatbot category setup
    5 CODE_SEL Character(6) VARCHAR2(6) NOT NULL Code Selection

    Prompt Table: PY_CODESEL_DVW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description