PSDOCTPLCNFL_VW

(SQL View)
Index Back

Template Container Field Type


SELECT IB_DOCTMPLNAME , IB_CNTCLASS_NAME , FIELDTYPE , IB_CLASSNAME , IB_STYLE , IB_THEME FROM PSDOCTPLCONTFLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_DOCTMPLNAME Character(30) VARCHAR2(30) NOT NULL Template Name (see PSDOCTPLDEFN).
2 IB_CNTCLASS_NAME Character(30) VARCHAR2(30) NOT NULL Container Class Name
3 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
4 IB_CLASSNAME Character(254) VARCHAR2(254) NOT NULL Content Class
5 IB_STYLE Character(254) VARCHAR2(254) NOT NULL Content Style
6 IB_THEME Character(3) VARCHAR2(3) NOT NULL Content Theme
A=a
B=b