RC_LINKGRP_VW

(SQL View)
 Index Back

Link Group Category table

Association table between Link Category and Link Group table

SELECT A.LINK_GROUP , A.LINK_CATEGORY , A.LINK_VERSION , A.RC_LINK 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 AND B.RC_SS_IND = 'Y'

# 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

Prompt Table: RC_LINKCAT_VW

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

Prompt Table: RC_CATVER_VW

4 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated

Prompt Table: RC_LINK_VW