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 | 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 | 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 |