CF_DSP_TMPLT_VW

(SQL View)
 Index Back

CF Display Template Table

ChartField Display Template table

SELECT A.CF_DSP_TEMPLATE , B.CF_ORDER , A.FIELDNAME , A.CF_DSP_TMPLT_OPT , A.CF_DSP_TMPLT_REQD , A.CF_DSP_TMPLT_SUMM FROM PS_CF_DSP_TEMPLATE A , PS_FS_CF_TEMPLATE B WHERE A.FIELDNAME=B.FIELDNAME UNION SELECT A.CF_DSP_TEMPLATE ,99 , A.FIELDNAME , 'H' , 'N' , A.CF_DSP_TMPLT_SUMM FROM PS_CF_DSP_TEMPLATE A , PS_ACCT_ATTRIB_TBL B WHERE A.FIELDNAME ='BOOK_CODE' AND A.FIELDNAME = B.FIELDNAME AND B.ACTIVE_FLAG <> 'Y' UNION SELECT A.CF_DSP_TEMPLATE , ( SELECT COUNT(CF_ORDER)+1 FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS = 'A') , A.FIELDNAME , A.CF_DSP_TMPLT_OPT , A.CF_DSP_TMPLT_REQD , A.CF_DSP_TMPLT_SUMM FROM PS_CF_DSP_TEMPLATE A , PS_ACCT_ATTRIB_TBL B WHERE A.FIELDNAME ='BOOK_CODE' AND A.FIELDNAME = B.FIELDNAME AND B.ACTIVE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CF_DSP_TEMPLATE Character(20) VARCHAR2(20) NOT NULL ChartField Display Template name
2 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 CF_DSP_TMPLT_OPT Character(1) VARCHAR2(1) NOT NULL ChartField Display Template display option
D=Display ChartField
H=Hide ChartField
N=Component Default

Default Value: N

5 CF_DSP_TMPLT_REQD Character(1) VARCHAR2(1) NOT NULL ChartField Display Template display option
N=Not Required
Y=Required

Default Value: N

6 CF_DSP_TMPLT_SUMM Character(1) VARCHAR2(1) NOT NULL ChartField Display Template Summary page display option
1=Exclude
2=Group 1
3=Group 2