CF_DSP_COMP_VW

(SQL View)
 Index Back

CF Disp Templ Componnents

CF Display Template assigned by Component, Template Type, Role, Permission List and or User

SELECT A.PNLGRPNAME , A.SEQUENCE_5 , A.SEQ_NBR , B.CF_DSP_TEMPLATE , A.TMPLT_TYPE , A.OPRCLASS , A.OPRID , A.CF_DSP_HIDE_FLG , A.DEFAULT_TEMPL_FLG , A.ACTIVE_FLAG , A.SYSTEM_MAINTAINED FROM PS_CF_DSP_COMP A , PS_CF_DSP_TMPL_HDR B WHERE A.default_templ_flg = 'Y' AND B.default_templ_flg = 'Y' UNION SELECT PNLGRPNAME , SEQUENCE_5 , SEQ_NBR , CF_DSP_TEMPLATE , TMPLT_TYPE , OPRCLASS , OPRID , CF_DSP_HIDE_FLG , DEFAULT_TEMPL_FLG , ACTIVE_FLAG , SYSTEM_MAINTAINED FROM PS_CF_DSP_COMP WHERE default_templ_flg <> 'Y' UNION SELECT PG.PNLGRPNAME , A.SEQUENCE_5 , A.SEQ_NBR , A.CF_DSP_TEMPLATE , A.TMPLT_TYPE , A.OPRCLASS , A.OPRID , A.CF_DSP_HIDE_FLG , A.DEFAULT_TEMPL_FLG , A.ACTIVE_FLAG , A.SYSTEM_MAINTAINED FROM PS_CF_DSP_COMP A , PSAUTHITEM AI , PSCLASSDEFN CD , PSPNLGROUP PG , PSMENUITEM MI , PSPNLGRPDEFN PD WHERE A.default_templ_flg <> 'Y' AND A.TMPLT_TYPE = 'C' AND A.SEQUENCE_5 <> 0 AND AI.MENUNAME = MI.MENUNAME AND AI.BARNAME = MI.BARNAME AND AI.BARITEMNAME = MI.ITEMNAME AND MI.PNLGRPNAME = PG.PNLGRPNAME AND MI.MARKET = PG.MARKET AND CD.CLASSID = AI.CLASSID AND PD.PNLGRPNAME = PG.PNLGRPNAME AND PD.MARKET = PG.MARKET AND PD.FLUIDMODE <> 0 AND A.OPRCLASS = AI.CLASSID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: CF_DSP_PNL_GRP

2 SEQUENCE_5 Number(5,0) INTEGER NOT NULL Sequnece Number of Length 5
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 CF_DSP_TEMPLATE Character(20) VARCHAR2(20) NOT NULL ChartField Display Template name

Prompt Table: CF_DSP_TMPL_HDR

5 TMPLT_TYPE Character(1) VARCHAR2(1) NOT NULL Template Type
A=All
C=Permission
O=User ID
6 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: OPRCLASS_VW

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

8 CF_DSP_HIDE_FLG Character(1) VARCHAR2(1) NOT NULL Used to hide link from Fluid Approval page to CF DisplayFramework CF grid.
9 DEFAULT_TEMPL_FLG Character(1) VARCHAR2(1) NOT NULL Default Template
Y=Default Template
10 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Y/N Table Edit

11 SYSTEM_MAINTAINED Character(1) VARCHAR2(1) NOT NULL System Maintained

Y/N Table Edit