RC_CTD_CAT_VW

(SQL View)
 Index Back

CTD Category

Active Categories based on the CTD combination

SELECT SETID ,RC_CATEGORY ,RC_SHORT_DESCR ,STATUS ,LONG_DESC FROM PS_RC_CATEGORY_TBL

  • Related Language Record: RC_CTD_CAT_VW_L

    • # 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: RC_CTD_SEARCH.SETID

    Prompt Table: SP_SETID_NONVW
    Set Control Field: BUSINESS_UNIT

    2 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
    3 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

    Default Value: DERIVED_RC_CTD.CAT_DESCR

    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.