RC_LINK_KEY_VW

(SQL View)
 Index Back

Terms for Active Links

This view contians the terms for active links.

SELECT A.LINK_CATEGORY , A.LINK_VERSION , A.RC_LINK , A.SEQ_NUM , A.LINK_FIELD FROM PS_RC_LINK_KEY_TBL A ,PS_RC_LINK_TBL B WHERE B.STATUS = 'A' AND B.LINK_CATEGORY = A.LINK_CATEGORY AND B.LINK_VERSION = A.LINK_VERSION AND B.RC_LINK = A.RC_LINK

# 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 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 LINK_FIELD Character(50) VARCHAR2(50) NOT NULL Link Field.