RC_CTD_DET_F_VW

(SQL View)
 Index Back

Case Detail

Active Detail data based on the CTD combination

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

  • Related Language Record: RC_CTD_DET_FVWL

  • Parent record: 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: RC_CASE.BUSINESS_UNIT

    Prompt Table: SP_SETID_NONVW
    Set Control Field: BUSINESS_UNIT

    2 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

    Default Value: RC_CASE.RC_CATEGORY

    3 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

    Default Value: RC_CASE.RC_TYPE

    4 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
    5 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.

    Y/N Table Edit

    Default Value: Y

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