RDT_COMP_VW (SQL View)	Index Back
View on RDT_TMPL_COMP record. This view is used for the structure to cache the display templates.

RDT_COMP_VW

(SQL View)

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 , B.TRANSACTION_RECORD , B.TRANSACTION_FIELD FROM PS_RDT_TMPL_COMP A , PS_RDT_CFG_COMP 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 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.

5 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.

#	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	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.
5	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.