EOPCMIG_DEF_TMP(SQL Table) | 
Index Back | 
|---|---|
Data Mover TemporaryPage Composer Data Mover Temporary | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 |