RC_LINK_DEF_VW (SQL View)	Index Back
Default links This view shows the default link for each category.

RC_LINK_DEF_VW

(SQL View)

Default links

This view shows the default link for each category.

SELECT LINK_CATEGORY , LINK_VERSION , RC_LINK FROM PS_RC_LINK_TBL WHERE DEFAULT_FLG = 'Y'

# 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
Default Value: RC_LINK_CAT_TBL.LINK_VERSION

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

#	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 Default Value: RC_LINK_CAT_TBL.LINK_VERSION
3	RC_LINK	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated