RDT_TXN_OPT_VW

(SQL View)
 Index Back

View on RDT_TMPL_COMP record.

This view is used for the structure to cache the display templates.

SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , C.CACHE_SEQ_NUMBER , B.TRANSACTION_RECORD , B.TRANSACTION_FIELD , D.RB_APPCLASS_SET , C.RB_APPCLASS_EXT , D.TB_APPCLASSREF , C.ADAPTER_ID , C.VERSION_360 , C.LIC_PROD_CD , C.LIC_PROD_DESCR , C.SS_CONFIRM_FLG , C.RC_PREDEFN_ID , C.EMAIL_FORMID_NOTE , C.EMAIL_FORMID_SOLN , C.SEARCH_DEFN_NAME , C.LINK_GROUP , C.SITE_ONLY , C.ASSET_INT_FLAG , C.TOOLBAR_ID FROM PS_RDT_TMPL_COMP A , PS_RDT_CFG_COMP B , PS_RDT_TMPL_OPT C , PS_RDT_CFG_OPT D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.DISP_TMPL_ID = C.DISP_TMPL_ID AND A.PNLGRPNAME = C.PNLGRPNAME AND A.MARKET = C.MARKET AND A.PNLGRPNAME = D.PNLGRPNAME AND A.MARKET = D.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 CACHE_SEQ_NUMBER Number(20,0) DECIMAL(20) NOT NULL Sequence number to assign when expanding all the fields in a page including subpages
5 TRANSACTION_RECORD Character(15) VARCHAR2(15) NOT NULL Transaction record to check for references when the display template is deleted or replaced with another display template.
6 TRANSACTION_FIELD Character(18) VARCHAR2(18) NOT NULL Transaction field to check for references when the display template is deleted or replaced with another display template.
7 RB_APPCLASS_SET Character(15) VARCHAR2(15) NOT NULL Application Class Set
8 RB_APPCLASS_EXT Character(15) VARCHAR2(15) NOT NULL Application Class Set
9 TB_APPCLASSREF Character(30) VARCHAR2(30) NOT NULL As part of the display template system data, this field contains the Toolbar Application Reference.
10 ADAPTER_ID Character(20) VARCHAR2(20) NOT NULL Adapter ID
11 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
12 LIC_PROD_CD Character(18) VARCHAR2(18) NOT NULL Licensed product code for the configurable component.

Prompt Table: LIC_PROD_CD_VW

13 LIC_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Licensed product description for the configurable component.
14 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

15 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

16 EMAIL_FORMID_NOTE Character(20) VARCHAR2(20) NOT NULL Email Form ID to use for Emailing Case Notes
17 EMAIL_FORMID_SOLN Character(20) VARCHAR2(20) NOT NULL email form id to use for emailing solutions
18 SEARCH_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Search Definition Name
19 LINK_GROUP Character(5) VARCHAR2(5) NOT NULL Link Group setup table
20 SITE_ONLY Character(1) VARCHAR2(1) NOT NULL Site Only Case
N=No
Y=Yes
21 ASSET_INT_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No Flag used to indicate if integration to Asset management system is turned on or off
N=No
Y=Yes
22 TOOLBAR_ID Character(30) VARCHAR2(30) NOT NULL TOOLBAR_ID

Prompt Table: RB_TOOLBAR_DEFN