REL_TYPE_IDPrompt Table: BO_REL_TYPE_VW
RDH_MAPTYPEB=BO Search
O=Object
R=Rowset
RDH_GUID_MAPRDH_MATREMAP_VW(SQL View) |
Index Back |
|---|---|
Role Based MappingRole Based mapping defined in match rule mapping. |
| SELECT A.REL_TYPE_ID ,B.RDH_MAPTYPE ,A.RDH_GUID ,A.RDH_MAPID FROM PS_RDH_MATRULMAP A , PS_RDH_MATRULMAPTP B WHERE B.RDH_GUID = A.RDH_GUID AND A.REL_TYPE_ID <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Relationship Type ID
Prompt Table: BO_REL_TYPE_VW |
| 2 | RDH_MAPTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Mapping Type
B=BO Search O=Object R=Rowset |
| 3 | RDH_GUID_MAP |
Character(20) | VARCHAR2(20) NOT NULL | Unique Identifier |
| 4 | RDH_MAPID | Character(30) | VARCHAR2(30) NOT NULL | Mapping Identifier |