EOCF_TERMD_VW

(SQL View)
 Index Back

Term definition

CLAF Data Library term definition

SELECT EOCF_LIB_TERM_ID , EOCF_LIB_TERM_NAME , EOCF_TERM_TYPE , EOCF_TERM_LABEL , EOCF_CODE_NAME , EOCF_TERM_DATATYPE , EOCF_NUM_OF_VALUES , EOCF_DATA_SOURCE , EOCF_TERM_STATUS , DESCR50 , EOCF_OPERSET_ID , EOCF_IS_CFG_FLAG , EOCF_CONSTANT_VAL , EOCF_DIMENSION , DESCRLONG FROM PS_EOCF_TERM_DEFN

  • Related Language Record: EOCF_TERMD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 EOCF_LIB_TERM_NAME Character(80) VARCHAR2(80) NOT NULL the name of the Term in the library
    3 EOCF_TERM_TYPE Character(3) VARCHAR2(3) NOT NULL data library term type, possible values are constant,variable
    CON=Constant
    VAR=Variable
    4 EOCF_TERM_LABEL Character(254) VARCHAR2(254) NOT NULL Term Label (display) field used in Term Definition
    5 EOCF_CODE_NAME Character(18) VARCHAR2(18) NOT NULL code name for terms and phrases
    6 EOCF_TERM_DATATYPE Character(4) VARCHAR2(4) NOT NULL data library term return data type, possible values are scalar,composite
    DATE=Date
    DTTM=Datetime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    7 EOCF_NUM_OF_VALUES Character(1) VARCHAR2(1) NOT NULL Data Library - This field would identify whether a term would return a list of values or single value.
    1=One
    2=Many
    8 EOCF_DATA_SOURCE Character(4) VARCHAR2(4) NOT NULL which product line the source comes from
    CRM=Customer Relationship Mgmt
    EPM=Enterprise Performance Mgmt
    FSM=Financial Services Mgmt
    HCM=Human Capital Mgmg
    SCM=Supply Chain Mgmt
    9 EOCF_TERM_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
    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 EOCF_OPERSET_ID Number(31,0) DECIMAL(31) NOT NULL operator specifier

    Prompt Table: EOCF_OPER_SET

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

    Y/N Table Edit

    13 EOCF_CONSTANT_VAL Character(250) VARCHAR2(250) NOT NULL If Term Type is Constant then Constant Value would be defined.
    14 EOCF_DIMENSION Character(15) VARCHAR2(15) NOT NULL dimension field
    15 DESCRLONG Long Character CLOB Long Description