EOPC_DEFN_SVW

(SQL View)
Index Back

Definition Search View

EOPC_DEFN search view

SELECT EOPCDEFN_ID , EOPCDEFN_NAME , EOPCDEFN_DESCR , EOPCAPPOBJ_TYPE , EOPCAPP_OBJ 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 EOPCDEFN_NAME Character(30) VARCHAR2(30) NOT NULL Definition Name
3 EOPCDEFN_DESCR Character(254) VARCHAR2(254) NOT NULL Description
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