EOPC_DEFN_VW

(SQL View)
 Index Back

EOPC_DEFN_VW

EOPC_DEFN_VW

SELECT EOPCDEFN_ID , EOPCADDL_ADDVW , EOPCADDL_SRCHVW , EOPCDEFN_NAME , EOPCDEFN_DESCR , EOPCAPPOBJ_TYPE , EOPCAPP_OBJ , EOPCADDL_FLDS , EOPCSOURCE_CD , EOPCSRCCD_FLDNAME , OWNERID , EOPCDTTM_ADDED , EOPCOPRID_ADDED , EOPCLASTUPDDTTM , EOPCLASTOPRID FROM PS_EOPC_DEFN

  • Related Language Record: EOPC_DEFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    2 EOPCADDL_ADDVW Character(15) VARCHAR2(15) NOT NULL Multiple Compositions Add

    Prompt Table: EOPC_RECNAME_VW

    3 EOPCADDL_SRCHVW Character(15) VARCHAR2(15) NOT NULL Multiple Compositions Search

    Prompt Table: EOPC_RECNAME_VW

    4 EOPCDEFN_NAME Character(30) VARCHAR2(30) NOT NULL Definition Name
    5 EOPCDEFN_DESCR Character(254) VARCHAR2(254) NOT NULL EOPC Definition Description
    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

    Default Value: C

    7 EOPCAPP_OBJ Character(30) VARCHAR2(30) NOT NULL EOPC Application Object Name

    Prompt Table: %EDITTABLE4

    8 EOPCADDL_FLDS Character(1) VARCHAR2(1) NOT NULL Has Multiple Compositions
    N=No
    Y=Yes

    Default Value: Y

    9 EOPCSOURCE_CD Character(4) VARCHAR2(4) NOT NULL EOPC Source Code
    10 EOPCSRCCD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Source Code Fieldname
    11 OWNERID Character(8) VARCHAR2(8) NOT NULL SQL Owner ID
    12 EOPCDTTM_ADDED DateTime(26) TIMESTAMP Datetime Added
    13 EOPCOPRID_ADDED Character(30) VARCHAR2(30) NOT NULL OprID Added
    14 EOPCLASTUPDDTTM DateTime(26) TIMESTAMP Last Updated
    15 EOPCLASTOPRID Character(30) VARCHAR2(30) NOT NULL Last Updated By