RC_SS_CAT_VW

(SQL View)
Index Back

HR and Campus Shortcuts

View for displaying Categories for Action Links in the HR Shortcuts pagelet and the Campus Shortcuts pagelet.

SELECT DISTINCT DISP_TMPL_FAM_CD , LINK_CATEGORY , LINK_VERSION , INCLUDE_LINK , CATEGORY_ORDER FROM PS_RC_SS_CATEGORY WHERE INCLUDE_LINK = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
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
4 INCLUDE_LINK Character(1) VARCHAR2(1) NOT NULL Include Link in Quick Links pagelets

Y/N Table Edit

5 CATEGORY_ORDER Number(10,0) DECIMAL(10) NOT NULL Category Order for Link Category in Services Home Page setup.