EOPCMIG_DEFN_IDPrompt Table: EOPC_DEFN_VW2
C=Component
E1=Email Rich Text HTML
E2=Email HTML Page
HT=Stand-Alone HTML Area
EOPCMIG_DEFN(SQL Table) |
Index Back |
|---|---|
Data Mover DefinitionPage Composer Data Mover Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCMIG_DEFN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Mover Definition |
| 2 | EOPCDEFN_ID | Character(20) | VARCHAR2(20) NOT NULL |
EOPC Definition ID
Prompt Table: EOPC_DEFN_VW2 |
| 3 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
| 4 | 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 |
| 5 | EOPCAPP_OBJ | Character(30) | VARCHAR2(30) NOT NULL | EOPC Application Object Name |
| 6 | EOPCDEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Definition Name |
| 7 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 8 | OWNERID | Character(8) | VARCHAR2(8) NOT NULL | SQL Owner ID |
| 9 | EOPCDTTM_ADDED | DateTime(26) | TIMESTAMP | Datetime Added |
| 10 | EOPCOPRID_ADDED | Character(30) | VARCHAR2(30) NOT NULL | OprID Added |
| 11 | EOPCLASTUPDDTTM | DateTime(26) | TIMESTAMP | Last Updated |
| 12 | EOPCLASTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |