RDH_MATCTRL_VW

(SQL View)
Index Back

Role Based Context Mapping

Role Based Context Mapping view

SELECT A.RDH_GUID , A.RDH_CONTEXT_TYPE , B.ROLE_TYPE_ID , A.SRCHRL_ID , A.PNLGRPNAME , A.MARKET , A.AE_APPLID , A.RDH_OTHERS , A.ACTIVE_FLAG , B.RDH_GUID_MAP , B.RDH_MAPTYPE FROM PS_RDH_MATCTXT A , PS_RDH_MATCTRLMAP B WHERE B.RDH_GUID = A.RDH_GUID

# 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

Prompt Table: BO_ROLE_TYPE_VW

4 SRCHRL_ID Character(20) VARCHAR2(20) NOT NULL BO Search Role ID

Prompt Table: RBQ_SRCHRL

5 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: RDT_PNLGRP_VW

6 MARKET Character(3) VARCHAR2(3) NOT NULL Market
7 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Prompt Table: RDH_APPLENG_VW

8 RDH_OTHERS Character(100) VARCHAR2(100) NOT NULL Others Matching Context key
9 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Default Value: A

10 RDH_GUID_MAP Character(20) VARCHAR2(20) NOT NULL Unique Identifier

Prompt Table: RDH_MATRLMAP_VW

11 RDH_MAPTYPE Character(1) VARCHAR2(1) NOT NULL Mapping Type
B=BO Search
O=Object
R=Rowset