EOPCDEFN_IDC=Component
E1=Email Rich Text HTML
E2=Email HTML Page
HT=Stand-Alone HTML Area
N=No
Y=Yes
Y/N Table Edit
Default Value: N
EOPC_DEFN(SQL Table) |
Index Back |
|---|---|
DefinitionPage Composer Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | EOPCADDL_ADDVW | Character(15) | VARCHAR2(15) NOT NULL | Multiple Compositions Add |
| 3 | EOPCADDL_SRCHVW | Character(15) | VARCHAR2(15) NOT NULL | Multiple Compositions Search |
| 4 | EOPCDEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Definition Name |
| 5 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 6 | EOPCAPPOBJ_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Page Composer application object type
C=Component E1=Email Rich Text HTML E2=Email HTML Page HT=Stand-Alone HTML Area |
| 7 | EOPCAPP_OBJ | Character(30) | VARCHAR2(30) NOT NULL | EOPC Application Object Name |
| 8 | EOPCADDL_FLDS | Character(1) | VARCHAR2(1) NOT NULL |
Has Multiple Compositions
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
| 10 | EOPCSRCCD_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Source Code Fieldname |
| 11 | OWNERID | Character(8) | VARCHAR2(8) NOT NULL | SQL Owner ID |
| 12 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
| 13 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
| 14 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
| 15 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |