RC_CTD_CAT_F_VW

(SQL View)
Index Back

Active Case Categories

Only shows the Active Categories for Call Center.

SELECT DISTINCT A.SETID ,A.RC_CATEGORY ,RC_SS_IND ,RC_SHORT_DESCR ,RC_DESCR_SS ,LONG_DESC FROM PS_RC_CATEGORY_TBL A , PS_RC_CTD B WHERE A.SETID = B.SETID AND A.RC_CATEGORY = B.RC_CATEGORY AND B.START_DT <= %CurrentDateIn AND B.END_DT IS NULL

  • Related Language Record: RC_CTD_CAT_FVWL
  • Parent Record Of RC_CTD_TYP_F_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    2 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
    3 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.

    Default Value: Y

    4 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
    5 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages
    6 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.