EOCF_PHRASE_DFN

(SQL Table)
Index Back

phrase definition

phrase definition

  • Related Language Record: EOCF_PHRASE_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_PHRASE_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)
    2 EOCF_PHRASE_NAME Character(80) VARCHAR2(80) NOT NULL the user identifier for a phrase
    3 EOCF_PHRASE_STATUS Character(1) VARCHAR2(1) NOT NULL data library term status, possible values are Active, Inactive, Under Construction
    A=Active
    I=Inactive
    U=In Design

    Default Value: U

    4 EOCF_CODE_PTR Number(31,0) DECIMAL(31) NOT NULL unique id value pointing to compiled form of expression code
    5 EOCF_IS_NAMED_FLAG Character(1) VARCHAR2(1) NOT NULL does this object have a user-defined name

    Y/N Table Edit

    Default Value: N

    6 EOCF_IS_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Do Actions of this Action Type need to be configured

    Y/N Table Edit

    Default Value: N

    7 EOCF_DYNLINK_FLAG Character(1) VARCHAR2(1) NOT NULL does this object have a user-defined name

    Y/N Table Edit

    Default Value: N

    8 EOCF_CODE_NAME Character(18) VARCHAR2(18) NOT NULL code name for terms and phrases
    9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    10 EOCF_TEXT Long Character CLOB User-friendly Text
    11 EOCF_REF_PHRASE_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)
    12 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    13 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    14 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    15 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.