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