EOPCDEFN_IDC=Component
E1=Email Rich Text HTML
E2=Email HTML Page
HT=Stand-Alone HTML Area
N=No
Y=Yes
EOPC_DEFN_SRCH2(SQL View) |
Index Back |
|---|---|
EOPC_DEFN_SRCH2EOPC_DEFN_SRCH2 |
| SELECT A.EOPCDEFN_ID , %Upper(A.EOPCDEFN_NAME) , A.EOPCDEFN_DESCR , X.XLATLONGNAME , A.EOPCSOURCE_CD , A.EOPCAPPOBJ_TYPE , A.EOPCAPP_OBJ , A.EOPCADDL_FLDS , A.EOPCADDL_ADDVW , A.EOPCADDL_SRCHVW FROM PSXLATITEM X , PS_EOPC_DEFN A WHERE X.FIELDNAME = 'EOPCAPPOBJ_TYPE' AND X.FIELDVALUE = A.EOPCAPPOBJ_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | EOPCDEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Definition Name |
| 3 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 4 | EOPCTYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Object Type |
| 5 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | Source |
| 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 |
| 9 | EOPCADDL_ADDVW | Character(15) | VARCHAR2(15) NOT NULL | Multiple Compositions Add |
| 10 | EOPCADDL_SRCHVW | Character(15) | VARCHAR2(15) NOT NULL | Multiple Compositions Search |