RC_LINK_CATV_LA

(SQL View)
 Index Back

Active Link Categories

This view is used on the case to display the link categories

SELECT G.LINK_GROUP , A.SEQNUM , B.LINK_CATEGORY , B.LINK_VERSION , B.LANGUAGE_CD , B.RC_SHORT_DESCR FROM PS_RC_LINK_CAT_TBL A , PS_RC_LINK_CAT_LAN B , PS_RC_LINK_GRP_CAT G WHERE A.ACTIVE_FLAG = 'A' AND G.LINK_CATEGORY = A.LINK_CATEGORY AND G.LINK_VERSION = A.LINK_VERSION AND A.LINK_CATEGORY = B.LINK_CATEGORY AND A.LINK_VERSION = B.LINK_VERSION

  • Related Language Record for RC_LINK_CAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LINK_GROUP Character(5) VARCHAR2(5) NOT NULL Link Group setup table
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under
    4 LINK_VERSION Character(4) VARCHAR2(4) NOT NULL Version of Human Resource Management System application.
    12.1=EBS 12.1
    8.0=8.0 SP1
    8.3=8.3
    8.8=8.8
    8.9=8.9
    9.0=9.0
    9.1=9.1
    9.2=9.2
    OTH=Other
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables