PSMAPLAYOUT_VW(SQL View) |
Index Back |
---|---|
MAP Layouts |
SELECT IB_STORELAYOUTNAME , IB_DOC_LBL_ID , ib_docpage_index , ib_doclayoutgrp , IB_CLASSNAME , IB_STYLE , IB_APP_INDICATOR , DESCR , DESCRLONG FROM PSMAPSDEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IB_STORELAYOUTNAME | Character(20) | VARCHAR2(20) NOT NULL | Layout Name |
2 | IB_DOC_LBL_ID | Character(35) | VARCHAR2(35) NOT NULL | Field Layout Type |
3 | IB_DOCPAGE_INDEX | Number(3,0) | SMALLINT NOT NULL | Page Index |
4 | IB_DOCLAYOUTGRP | Character(30) | VARCHAR2(30) NOT NULL | Document Layout Group |
5 | IB_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Content Class |
6 | IB_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Content Style |
7 | IB_APP_INDICATOR | Number(3,0) | SMALLINT NOT NULL | App Location |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | DESCRLONG | Long Character | CLOB | Long Description |