RDT_TMPL_OPT_VW(SQL View) |
Index Back |
|---|---|
Configured general optionsConfigured general options for the display template. |
| SELECT PNLGRPNAME , MARKET , DISP_TMPL_ID , RB_APPCLASS_EXT , ADAPTER_ID , VERSION_360 , LIC_PROD_CD , LIC_PROD_DESCR , SS_CONFIRM_FLG , RC_PREDEFN_ID , SEARCH_DEFN_NAME , EMAIL_FORMID_NOTE , EMAIL_FORMID_SOLN , PORTAL_NAME , PORTAL_OBJNAME , LINK_GROUP , CACHE_SEQ_NUMBER , TOOLBAR_ID FROM PS_RDT_TMPL_OPT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | DISP_TMPL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 4 | RB_APPCLASS_EXT | Character(15) | VARCHAR2(15) NOT NULL |
Application Class Set
Prompt Table: RB_APPSET_EXTVW |
| 5 | ADAPTER_ID | Character(20) | VARCHAR2(20) NOT NULL |
Adapter ID
Prompt Table: RBQ_ADPTR |
| 6 | 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 |
| 7 | LIC_PROD_CD | Character(18) | VARCHAR2(18) NOT NULL |
Licensed product code for the configurable component.
Prompt Table: LIC_PROD_CD_VW |
| 8 | LIC_PROD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Licensed product description for the configurable component. |
| 9 | 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 |
| 10 | 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 |
| 11 | SEARCH_DEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Search Definition Name
Prompt Table: RB_VRTY_PG_CFG |
| 12 | EMAIL_FORMID_NOTE | Character(20) | VARCHAR2(20) NOT NULL | Email Form ID to use for Emailing Case Notes |
| 13 | EMAIL_FORMID_SOLN | Character(20) | VARCHAR2(20) NOT NULL | email form id to use for emailing solutions |
| 14 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: RB_TD_PORTAL_VW |
| 15 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Object Name
Prompt Table: RB_TD_POBJ_VW |
| 16 | LINK_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Link Group setup table
Prompt Table: RC_LINK_GROUP |
| 17 | CACHE_SEQ_NUMBER | Number(20,0) | DECIMAL(20) NOT NULL | Sequence number to assign when expanding all the fields in a page including subpages |
| 18 | TOOLBAR_ID | Character(30) | VARCHAR2(30) NOT NULL | TOOLBAR_ID |