EOPCMAIN_DISP(SQL Table) |
Index Back |
---|---|
Page Composer SectionPage Composer Section |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOPCMAIN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
2 | DISP_OBJ_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
EOPC Display Object Type - main display
E=Email HT=Stand-Alone HTML P=Page Default Value: P |
3 | DISP_OBJ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Display Object Name |
4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
5 | EOPCDEFN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
6 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
7 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
8 | HTMLDISPLAY | Long Character | CLOB | HTML Display |
9 | EOPCOBJ_PF_ID | Character(10) | VARCHAR2(10) NOT NULL | EOPC Page Field Object ID |
10 | EOPCOBJ_BASE_HT_ID | Character(10) | VARCHAR2(10) NOT NULL | EOPC Base HTML Object Id |
11 | EOPCIMAGE_ID | Character(30) | VARCHAR2(30) NOT NULL | Image |
12 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
13 | EOPCFORM_SM | Character(1) | VARCHAR2(1) NOT NULL |
Small
Y/N Table Edit Default Value: N |
14 | EOPCFORM_MED | Character(1) | VARCHAR2(1) NOT NULL |
Medium
Y/N Table Edit Default Value: N |
15 | EOPCFORM_LG | Character(1) | VARCHAR2(1) NOT NULL |
Large
Y/N Table Edit Default Value: N |
16 | EOPCFORM_XLG | Character(1) | VARCHAR2(1) NOT NULL |
X-Large
Y/N Table Edit Default Value: Y |
17 | EOPCMAIN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Page Description |
18 | EOPCMAIN_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Page Description |
19 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
20 | OWNERID | Character(8) | VARCHAR2(8) NOT NULL | SQL Owner ID |
21 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
22 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
23 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
24 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
25 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |