RC_SS_CAT_VW(SQL View) |
Index Back |
---|---|
HR and Campus ShortcutsView 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. |