RDT_OPT_VW(SQL View) |
Index Back |
|---|---|
View on RDT_TMPL_OPT record.This view is used for the structure to cache the display templates. |
| SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , B.RB_APPCLASS_SET , A.RB_APPCLASS_EXT , B.TB_APPCLASSREF , A.ADAPTER_ID , A.VERSION_360 , A.LIC_PROD_CD , A.LIC_PROD_DESCR , A.SS_CONFIRM_FLG , A.RC_PREDEFN_ID , A.EMAIL_FORMID_NOTE , A.EMAIL_FORMID_SOLN , A.SEARCH_DEFN_NAME , A.LINK_GROUP , A.PORTAL_NAME , A.PORTAL_OBJNAME , A.TOOLBAR_ID FROM PS_RDT_TMPL_OPT A , PS_RDT_CFG_OPT B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 2 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 3 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 4 | RB_APPCLASS_SET | Character(15) | VARCHAR2(15) NOT NULL | Application Class Set |
| 5 | RB_APPCLASS_EXT | Character(15) | VARCHAR2(15) NOT NULL | Application Class Set |
| 6 | TB_APPCLASSREF | Character(30) | VARCHAR2(30) NOT NULL | As part of the display template system data, this field contains the Toolbar Application Reference. |
| 7 | ADAPTER_ID | Character(20) | VARCHAR2(20) NOT NULL | Adapter ID |
| 8 | VERSION_360 | Character(4) | VARCHAR2(4) NOT NULL |
Corresponding 360 version to be used for the configurable component.
CUST=Customer HIED=Constituent HRHD=HRHD Worker PART=Partner WORK=Worker |
| 9 | LIC_PROD_CD | Character(18) | VARCHAR2(18) NOT NULL |
Licensed product code for the configurable component.
Prompt Table: LIC_PROD_CD_VW |
| 10 | LIC_PROD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Licensed product description for the configurable component. |
| 11 | SS_CONFIRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to display the confirmation page upon save. (applicable for call center self-service case pages)
N=No Y=Yes Default Value: N |
| 12 | RC_PREDEFN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pre-defined search definition to be used for the configurable component. (applicable for call center self-service case components)
Prompt Table: RC_DEFNSRCH_HDR |
| 13 | EMAIL_FORMID_NOTE | Character(20) | VARCHAR2(20) NOT NULL | Email Form ID to use for Emailing Case Notes |
| 14 | EMAIL_FORMID_SOLN | Character(20) | VARCHAR2(20) NOT NULL | email form id to use for emailing solutions |
| 15 | SEARCH_DEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Search Definition Name |
| 16 | LINK_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Link Group setup table |
| 17 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: RB_TD_PORTAL_VW |
| 18 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Object Name
Prompt Table: RB_TD_POBJ_VW |
| 19 | TOOLBAR_ID | Character(30) | VARCHAR2(30) NOT NULL |
TOOLBAR_ID
Prompt Table: RB_TOOLBAR_DEFN |