RB_TT_PERS_VW

(SQL View)
 Index Back

Personal Text Tray view

View for Personal Text Tray Quick keys. Used by Text Tray feature.

SELECT A.OPRID , B.QK_ID , B.CATEGORY , C.CATEGORY_DESCR , B.QUICK_KEY , B.QK_TYPE , B.QK_TEXT FROM PS_RB_TT_PERSONAL A , PS_RB_TT_QKEYS B , PS_RB_TT_CATEGORY C WHERE A.QK_ID = B.QK_ID AND B.CATEGORY = C.CATEGORY

  • Related Language Record: RB_TT_PERSV_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 QK_ID Character(20) VARCHAR2(20) NOT NULL Quick Key Identifier. Used in Text Tray
    3 CATEGORY Character(4) VARCHAR2(4) NOT NULL Text Tray Category field.
    4 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray
    5 QUICK_KEY Character(30) VARCHAR2(30) NOT NULL Quick Key field. Used in Text Tray
    6 QK_TYPE Character(1) VARCHAR2(1) NOT NULL Quick Key Type. Used in Text Tray.
    D=Dynamic
    S=Static
    7 QK_TEXT Long Character CLOB NOT NULL Quick key text field. Used in Text Tray.