RC_SS_LINKS_VW

(SQL View)
Index Back

HR and Campus Shortcuts

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

SELECT DISP_TMPL_FAM_CD , LINK_CATEGORY , LINK_VERSION , RC_LINK , INCLUDE_LINK , LINK_ORDER FROM PS_RC_SS_LINKS 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 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
5 INCLUDE_LINK Character(1) VARCHAR2(1) NOT NULL Include Link in Quick Links pagelets

Y/N Table Edit

6 LINK_ORDER Number(10,0) DECIMAL(10) NOT NULL Link Order for Action Links in Services Home Page setup.