RDH_MATCTXT_VW

(SQL View)
 Index Back

Context Matching View

This record maintains the context matching information based on the bo search role / component / application engine or just on a user defined key

SELECT A.RDH_GUID , A.RDH_CONTEXT_TYPE , B.DESCR , A.PNLGRPNAME , A.MARKET , A.AE_APPLID , A.RDH_OTHERS FROM PS_RDH_MATCTXT A ,PS_RBQ_SRCHRL B WHERE A.SRCHRL_ID = B.SRCHRL_ID UNION SELECT A.RDH_GUID , A.RDH_CONTEXT_TYPE , ' ' , A.PNLGRPNAME , A.MARKET , A.AE_APPLID , A.RDH_OTHERS FROM PS_RDH_MATCTXT A WHERE A.SRCHRL_ID = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RDH_GUID Character(20) VARCHAR2(20) NOT NULL Unique Identifier
2 RDH_CONTEXT_TYPE Character(1) VARCHAR2(1) NOT NULL Context Type
A=Application Engine
B=BO Search
C=Component
O=Others
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: RDT_PNLGRP_VW

5 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Prompt Table: RBQ_PNLMKT_VW

6 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Prompt Table: RDH_APPLENG_VW

7 RDH_OTHERS Character(100) VARCHAR2(100) NOT NULL Others Matching Context key