IBDOCLAYOUTNAMEIB_DOCPAGE_INDEXIB_DOCLAYOUT_IDA=a
B=b
C=c
D=d
E=e
A=a
B=b
PSDOCLOFIELD(SQL Table) |
Index Back |
|---|---|
Document layout Field table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IBDOCLAYOUTNAME |
Character(20) | VARCHAR2(20) NOT NULL | Layout Name (see PSDOCLODEFN). |
| 2 | IB_DOCPAGE_INDEX |
Number(3,0) | SMALLINT NOT NULL | Page Index |
| 3 | IB_DOCLAYOUT_ID |
Number(4,0) | SMALLINT NOT NULL | Document Layout ID |
| 4 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 5 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 6 | IB_DISPLAY_FORMAT | Number(3,0) | SMALLINT NOT NULL | Fixed Display Format |
| 7 | IB_CONT_THEME | Character(3) | VARCHAR2(3) NOT NULL |
Main Theme
A=a B=b C=c D=d E=e |
| 8 | IB_THEME | Character(3) | VARCHAR2(3) NOT NULL |
Content Theme
A=a B=b |
| 9 | IB_THEME_DIVIDER | Character(3) | VARCHAR2(3) NOT NULL | Theme Divider |
| 10 | IB_DOC_LBL_ID | Character(35) | VARCHAR2(35) NOT NULL | Field Layout Type |
| 11 | IB_DOC_LBL_ALT_ID | Character(35) | VARCHAR2(35) NOT NULL | Alt ID |
| 12 | IB_CONT_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Container Class Name |
| 13 | IB_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Content Class |
| 14 | IB_LBLTEXT | Character(100) | VARCHAR2(100) NOT NULL | Label Text |
| 15 | IB_GRP_LBLTEXT | Character(100) | VARCHAR2(100) NOT NULL | Group Label Text |
| 16 | IB_ACCESSTXT | Character(100) | VARCHAR2(100) NOT NULL | Accessibility |
| 17 | FIELDUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use |
| 18 | IB_CONT_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Main Style |
| 19 | IB_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Content Style |
| 20 | IB_LEVEL | Character(35) | VARCHAR2(35) NOT NULL | Layout Level |
| 21 | IB_FIELD_SIZE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Document Field Size |
| 22 | IB_TEXTAREA_ROW | Number(4,0) | SMALLINT NOT NULL | Text Area Row Size |
| 23 | IB_TEXTAREA_COL | Number(4,0) | SMALLINT NOT NULL | Text Area Column Size |
| 24 | GRDCOLUMNCOUNT | Number(3,0) | SMALLINT NOT NULL | Grid Column Count |
| 25 | IB_IMAGE_TYPE | Number(3,0) | SMALLINT NOT NULL | Image Type |
| 26 | IB_SPACE | Number(3,0) | SMALLINT NOT NULL | Space |
| 27 | IB_UPDATE_EVENT | Number(1,0) | SMALLINT NOT NULL | Trigger Update |
| 28 | IB_CUST_INDICATOR | Number(2,0) | SMALLINT NOT NULL | cust ind |
| 29 | IB_TMPLCONT | Character(30) | VARCHAR2(30) NOT NULL | Template Container Name |
| 30 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |