SETIDLINK_CATEGORYRC_LINKRC_LNK_SS_VW(SQL View) |
Index Back |
|---|---|
Embedded Action LInkPrompt table for embedded action links in solutions |
| SELECT DISTINCT A.SOLUTION_SETID , B.LINK_CATEGORY , B.RC_LINK , C.LINK_DEFN_NAME FROM PS_RC_LINK_GROUP A , PS_RC_LINK_GRP_CAT B , PS_RC_LINK_TBL C WHERE A.LINK_GROUP = B.LINK_GROUP AND C.LINK_CATEGORY = B.LINK_CATEGORY AND C.LINK_VERSION = B.LINK_VERSION AND C.RC_LINK = B.RC_LINK 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_LINK |
Character(5) | VARCHAR2(5) NOT NULL | Case Source How this case origianated |
| 4 | LINK_DEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Short Description. Used on may CallCenter set-up tables |