PSDOCLOPAGE(SQL Table) | 
Index Back | 
|---|---|
Document Layout Page | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | Layout Name (see PSDOCLODEFN). | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Page Index | |
| 3 | IB_DOCPAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Document Layout Page Name | 
| 4 | IB_DOC_LBL_ID | Character(35) | VARCHAR2(35) NOT NULL | Field Layout Type | 
| 5 | IB_CONT_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | 
Container Class Name
 Prompt Table: PSDOCCONT_VW  | 
| 6 | IB_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | 
Content Class
 Prompt Table: PSDOCCONT2_VW  | 
| 7 | IB_CONT_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Main Style | 
| 8 | IB_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Content Style | 
| 9 | IB_DOCTMPLNAME | Character(30) | VARCHAR2(30) NOT NULL | 
Template Name (see PSDOCTPLDEFN).
 Prompt Table: PSDOCTPLDEFN_VW  | 
| 10 | IB_EXTERNAL_PAGE | Number(1,0) | SMALLINT NOT NULL | External Page | 
| 11 | PNLTYPE | Number(1,0) | SMALLINT NOT NULL | Panel Type | 
| 12 | FIELDCOUNT | Number(4,0) | SMALLINT NOT NULL | Field Count | 
| 13 | IB_FORM_TRANSITION | Number(2,0) | SMALLINT NOT NULL | Form Transition | 
| 14 | IB_CONT_THEME | Character(3) | VARCHAR2(3) NOT NULL | 
Main Theme
 A=a B=b C=c D=d E=e  | 
| 15 | IB_THEME | Character(3) | VARCHAR2(3) NOT NULL | 
Content Theme
 A=a B=b  | 
| 16 | IB_TRANSITIONS | Number(2,0) | SMALLINT NOT NULL | Transitions | 
| 17 | IB_PRELOAD | Number(1,0) | SMALLINT NOT NULL | Pre-Load | 
| 18 | IB_CLIENT_CACHE | Number(1,0) | SMALLINT NOT NULL | Cache Page | 
| 19 | IB_CUST_INDICATOR | Number(2,0) | SMALLINT NOT NULL | cust ind | 
| 20 | IB_SUBPAGE | Number(3,0) | SMALLINT NOT NULL | Optional Sub Page Num | 
| 21 | IB_RESTBASE_URL | Character(254) | VARCHAR2(254) NOT NULL | REST Base URL |