RF_IPRDHIST_TRM

(SQL Table)
Index Back

Installed Product History

This record stores terms that are being used in installed product history descriptions.

  • Related Language Record: RF_IPRHIS_TM_LN
  • Parent record: RC_HIST_ACTION
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework Action ID field
    2 EOCF_TERM_ALIAS Character(30) VARCHAR2(30) NOT NULL Term Alias
    3 EOCF_IS_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Do Actions of this Action Type need to be configured
    4 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 EOCF_CONFIG_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)
    7 TERM_DISPLAY_TYPE Character(4) VARCHAR2(4) NOT NULL used for AAF terms to indicate how you would like that term to be displayed. (original value, current value)
    ORG=Original Value
    ORGD=Original Value - Description
    VAL=Current Value
    VALD=Current Value - Description

    Default Value: VALD

    8 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    9 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    10 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    11 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.