EOPCDEFN_IDC=Component
E1=Email Rich Text HTML
E2=Email HTML Page
HT=Stand-Alone HTML Area
EOPC_DEFN_VW2(SQL View) |
Index Back |
|---|---|
EOPCMIG_DEFNEOPCMIG_DEFN - EOPC Migration Definition; top record that contains user selection at the top level for export. |
| SELECT EOPCDEFN_ID , EOPCSOURCE_CD , %Upper(EOPCDEFN_NAME) , EOPCDEFN_DESCR , EOPCAPPOBJ_TYPE , EOPCAPP_OBJ , OWNERID FROM PS_EOPC_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
| 3 | EOPCDEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Definition Name |
| 4 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 5 | 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 |
| 6 | EOPCAPP_OBJ | Character(30) | VARCHAR2(30) NOT NULL | EOPC Application Object Name |
| 7 | OWNERID | Character(8) | VARCHAR2(8) NOT NULL | SQL Owner ID |