PSDOCTPLCONT_VW(SQL View) | 
Index Back | 
|---|---|
Document Template Containers | 
| SELECT IB_DOCTMPLNAME , IB_CNTCLASS_NAME , IB_STYLE , IB_THEME , IB_MEDIA_CLASS_NM , IB_MAIN_CONTAINER , IB_MEDIA_QUERY , IB_COMMENTS FROM PSDOCTPLCONT WHERE IB_MEDIA_QUERY = 1 | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Template Name (see PSDOCTPLDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Container Class Name | |
| 3 | IB_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Content Style | 
| 4 | IB_THEME | Character(3) | VARCHAR2(3) NOT NULL | 
Content Theme
 A=a B=b  | 
| 5 | IB_MEDIA_CLASS_NM | Character(30) | VARCHAR2(30) NOT NULL | Media Class Name | 
| 6 | IB_MAIN_CONTAINER | Number(3,0) | SMALLINT NOT NULL | Main Container | 
| 7 | IB_MEDIA_QUERY | Number(3,0) | SMALLINT NOT NULL | Media Queries | 
| 8 | IB_COMMENTS | Character(200) | VARCHAR2(200) NOT NULL | Comments |