RC_CATVER_VW

(SQL View)
 Index Back

Link Category View for Version

Link category prompt view for Version. It is used in Quick Code setup page.

SELECT LINK_CATEGORY , LINK_VERSION , LONG_DESC , RC_SHORT_DESCR FROM PS_RC_LINK_CAT_TBL WHERE ACTIVE_FLAG = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under
2 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
3 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.
4 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables