RDH_MATCTRL_VW(SQL View) |
Index Back |
---|---|
Role Based Context MappingRole 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 | 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 |