RC_LNKCAT_SS_VW (SQL View)	Index Back
Embedded Action LInk Prompt table for embedded action links in solutions

RC_LNKCAT_SS_VW

(SQL View)

Embedded Action LInk

Prompt table for embedded action links in solutions

SELECT DISTINCT A.SOLUTION_SETID , B.LINK_CATEGORY , C.RC_SHORT_DESCR FROM PS_RC_LINK_GROUP A , PS_RC_LINK_GRP_CAT B , PS_RC_LINK_CAT_TBL C WHERE A.LINK_GROUP = B.LINK_GROUP AND C.LINK_CATEGORY = B.LINK_CATEGORY AND C.LINK_VERSION = B.LINK_VERSION AND A.SOLUTION_SETID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under

3 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	LINK_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	This identifies the category that the link will be displayed under
3	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables