LINK_GROUPSEQNUMLINK_CATEGORYLINK_VERSION12.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
RC_LINK_CAT_VW(SQL View) |
Index Back |
|---|---|
Active Link CategoriesThis view is used on the case to display the link categories |
| SELECT DISTINCT G.LINK_GROUP , C.SEQNUM , C.LINK_CATEGORY , C.LINK_VERSION , C.RC_SHORT_DESCR FROM PS_RC_LINK_CAT_TBL C , PS_RC_LINK_GRP_CAT G WHERE C.ACTIVE_FLAG = 'A' AND G.LINK_CATEGORY = C.LINK_CATEGORY AND G.LINK_VERSION = C.LINK_VERSION |
| # | 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 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |