RC_LINK_GRP_LNG

(SQL View)
 Index Back

Link Groups - Language

Related Language Record for Link Groups

SELECT A.LINK_GROUP , B.LINK_CATEGORY , B.LINK_VERSION , B.RC_LINK , C.LANGUAGE_CD , C.LINK_DEFN_NAME , C.LONG_DESC FROM PS_RC_LINK_GRP_CAT A , PS_RC_LINK_TBL B , PS_RC_LINK_TBL_LAN C WHERE A.LINK_CATEGORY = B.LINK_CATEGORY AND A.LINK_VERSION = B.LINK_VERSION AND A.RC_LINK = B.RC_LINK AND B.LINK_CATEGORY = C.LINK_CATEGORY AND B.LINK_VERSION = C.LINK_VERSION AND B.RC_LINK = C.RC_LINK

  • Related Language Record for RC_LINK_GRP_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 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under
    3 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

    Default Value: RC_LINK_CAT_TBL.LINK_VERSION

    4 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LINK_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Short Description. Used on may CallCenter set-up tables
    7 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.