CF_DSP_ATTR_VW

(SQL View)
 Index Back

CF Template Attributes

CF Template Attributes

SELECT A.CF_DSP_TEMPLATE , B.CF_ORDER , A.FIELDNAME , A.CF_DSP_TMPLT_OPT , A.CF_DSP_TMPLT_REQD , d.cf_dsp_cf_opt FROM PS_CF_DSP_TEMPLATE A , PS_FS_CF_TEMPLATE B , PS_CF_DSP_TMPL_HDR D WHERE A.FIELDNAME=B.FIELDNAME AND D.CF_DSP_TEMPLATE = A.CF_DSP_TEMPLATE AND B.CF_ACTIVE_STATUS = 'A' AND B.CF_ORDER <> 99 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 , d.cf_dsp_cf_opt FROM PS_CF_DSP_TEMPLATE A , PS_ACCT_ATTRIB_TBL B , PS_CF_DSP_TMPL_HDR D WHERE A.FIELDNAME=B.FIELDNAME AND D.CF_DSP_TEMPLATE = A.CF_DSP_TEMPLATE AND B.FIELDNAME = 'BOOK_CODE' 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_CF_OPT Character(1) VARCHAR2(1) NOT NULL ChartField Display Template display option
B=Both Value and Description
C=ChartField Values
D=ChartField Descriptions