EOTF_MAP_DEFN

(SQL Table)
 Index Back

TF Value Map Definitions

Defines a Value Map in the Enterprise Transformation Framework

  • Related Language Record: EOTF_MAP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name
    2 EOTF_MAP_TYPE Character(1) VARCHAR2(1) NOT NULL Map Type
    D=Cross-reference (dynamic)
    S=Domain Value Map (static)

    Default Value: S

    3 EOTF_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Active Flag
    N=Is Inactive
    Y=Is Active

    Y/N Table Edit

    Default Value: Y

    4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    8 EOTF_DATA_UPD_DTTM DateTime(26) TIMESTAMP Data Last Updated Datetime

    Default Value: %datetime

    9 EOTF_FILE_NAME Character(254) VARCHAR2(254) NOT NULL File Path & Name
    10 EOTF_TRANSLATE_FLD Character(18) VARCHAR2(18) NOT NULL Translate Field Name
    11 EOTF_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    12 DESCRLONG Long Character CLOB Long Description