PNLGRPNAMEPrompt Table: RDT_PNLGRP_VW
MARKETROLE_TYPE_IDLANGUAGE_CDRDH_MATCTPNLLVW(SQL View) |
Index Back |
|---|---|
View to return all the roleview to return all the roles that are mapped for a given component and market. This is the matching context mapping |
| SELECT A.PNLGRPNAME , A.MARKET , B.ROLE_TYPE_ID , C.LANGUAGE_CD , C.DESCR FROM PS_RDH_MATCTXT A , PS_RDH_MATCTRLMAP B , PS_BO_ROLE_TYP_LNG C WHERE C.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND B.RDH_GUID = A.RDH_GUID AND A.PNLGRPNAME <> ' ' AND A.MARKET <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: RDT_PNLGRP_VW |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |