RC_LINK_GRP_VW

(SQL View)
 Index Back

Define Links for a Case

Define the links to be shown on a case

SELECT A.LINK_GROUP , B.LINK_CATEGORY , B.LINK_VERSION , B.RC_LINK , B.LINK_DEFN_NAME , B.LONG_DESC , B.PORTAL_NAME , B.PORTAL_OBJNAME , B.PAGE_NAME , B.PNLGRP_ACTION , B.USAGE_COUNT , B.DEFAULT_FLG , B.SOLVABLE_FLG , B.OPEN_NEW_PAGE , B.INTERNAL_TRANSFER , B.SETID_ENABLED , B.LINK_MODE , B.APPCLASSID , B.APPCLASS_PATH , B.FUNCTION_NAME , B.STATUS , B.RB_TRANSACTION_ID , B.MARKET , B.STATUS_MODE , B.APPCLASSID_EXT , B.APPCLASS_PATH_EXT , B.FUNCTION_NAME_EXT , B.STATIC_STATUS , B.RC_DESCR_SS , B.RC_SS_IND FROM PS_RC_LINK_GRP_CAT A , PS_RC_LINK_TBL B WHERE A.LINK_CATEGORY = B.LINK_CATEGORY AND A.LINK_VERSION = B.LINK_VERSION AND A.RC_LINK = B.RC_LINK

  • Related Language Record: RC_LINK_GRP_LNG

    • # 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 LINK_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Short Description. Used on may CallCenter set-up tables
    6 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.
    7 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: PORTAL_NAME_VW

    8 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

    Prompt Table: RC_CREF_VW

    9 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
    10 PNLGRP_ACTION Character(4) VARCHAR2(4) NOT NULL Actions to open a component
    ADD=Add
    COR=Correction
    L=Update/Display All
    UPD=Update/Display
    11 USAGE_COUNT Number(8,0) INTEGER NOT NULL Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.
    12 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N

    13 SOLVABLE_FLG Character(1) VARCHAR2(1) NOT NULL Solvable Flag indicates if the associated Action can resolve a case.

    Y/N Table Edit

    Default Value: N

    14 OPEN_NEW_PAGE Character(1) VARCHAR2(1) NOT NULL Y/N flag indicating whether to open a new page/window

    Y/N Table Edit

    Default Value: N

    15 INTERNAL_TRANSFER Character(1) VARCHAR2(1) NOT NULL Internal transfer checkbox used in Action Link definition

    Y/N Table Edit

    Default Value: N

    16 SETID_ENABLED Character(1) VARCHAR2(1) NOT NULL New field for fixing the security for BO Search
    17 LINK_MODE Character(1) VARCHAR2(1) NOT NULL Specifies the transfer mode for the Action link. It can be either "Portal CREF" or "PeopleCode"
    C=Portal CREF
    P=PeopleCode
    18 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: RBC_APPCLASS_VW

    19 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: RBC_APPRTPATH_V

    20 FUNCTION_NAME Character(30) VARCHAR2(30) NOT NULL Function Name
    21 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    22 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID

    Prompt Table: RB_TXN_DEFN

    23 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Prompt Table: RB_TD_TXNMKT_VW

    24 STATUS_MODE Character(1) VARCHAR2(1) NOT NULL Field for capturing the retrieval mechanism of Status of a related object
    P=PeopleCode
    S=Static Value
    25 APPCLASSID_EXT Character(30) VARCHAR2(30) NOT NULL Application Class ID
    26 APPCLASS_PATH_EXT Character(167) VARCHAR2(167) NOT NULL Application Class Full Path
    27 FUNCTION_NAME_EXT Character(30) VARCHAR2(30) NOT NULL Method Name extension used by Action framework of Call Center.
    28 STATIC_STATUS Character(4) VARCHAR2(4) NOT NULL Statis Status value for the related object
    COMP=Completed
    EMAI=Sent Email
    INPR=In Progress
    PERF=Performed
    29 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages
    30 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.