RC_CTD_DET_LVW2

(SQL View)
Index Back

Detail Prompt

Detail prompt table based on Short Description

SELECT SETID ,RC_DETAIL ,LANGUAGE_CD , RC_SHORT_DESCR ,LONG_DESC FROM PS_RC_DET_LANG

  • Related Language Record for RC_CTD_DET_VW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_WRK Character(5) VARCHAR2(5) NOT NULL SetID
    2 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

    Default Value: DERIVED_RC_CTD.DET_DESCR

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