Custom Benchmark Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

Required

Required

objectType

 

not stored in DB

 

EagleML/entityTransaction/customBenchmark/objectType

objectId

 

 

objectId

 

not stored in DB

 

EagleML/entityTransaction/customBenchmark/objectId

objectDescription

 

 

objectDescription

 

not stored in DB

 

EagleML/entityTransaction/customBenchmark/objectDescription

updateTimestamp

 

 

dateTime

 

 

 

 

 

EagleML/entityTransaction/customBenchmark/updateTimestamp

updateSource

 

 

string

 

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

Update_sourc

 

EagleML/entityTransaction/customBenchmark/updateSource

 

CUSTOM_INDEX_ATTR_DETAIL

Update_user

 

accountingValidationFlag

 

 

YesNoOptionEnum

 

not stored in DB, manages logic for the load

 

EagleML/entityTransaction/customBenchmark/accountingValidationFlag

Entity Common Id Model

EagleML/entityTransaction/customBenchmark/Entity Id Model/

procedureMode

 

 

ProcedureModeTypeEnum

in_process_type

 

 

 

 

EagleML/entityTransaction/customBenchmark/procedureMode

sourceName

 

 

string

in_short_desc

 

 

 

 

EagleML/entityTransaction/customBenchmark/sourceName

effectiveDate

 

 

date

in_effective_date

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

EFFECTIVE_DATE

 

EagleML/entityTransaction/customBenchmark/effectiveDate

baseCurrency

 

 

CurrencyCode

in_base_currency

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

BASE_CURRENCY

 

EagleML/entityTransaction/customBenchmark/baseCurrency

customIndexType

 

Required

string

in_custom_index_type

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

CUST_INDX_TYPE

 

EagleML/entityTransaction/customBenchmark/customIndexType

dictionarySource

 

Required

string

in_dictionary_source

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

SOURCE_DICT_ID

 

EagleML/entityTransaction/customBenchmark/dictionarySource

dictionaryTarget

 

Required

string

in_dictionary_target

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

TARGET_DICT_ID

 

EagleML/entityTransaction/customBenchmark/dictionaryTarget

dictionaryTargetLevel

 

Required

integer

in_target_dict_level

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

DICT_LEVEL

 

EagleML/entityTransaction/customBenchmark/dictionaryTargetLevel

dictionaryTargetLevelValue

 

Required

string

in_target_dict_level_value

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

DICT_LEVEL_VALUE

 

EagleML/entityTransaction/customBenchmark/dictionaryTargetLevelValue

weight

 

 

decimal

in_weight

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

WEIGHT

 

EagleML/entityTransaction/customBenchmark/weight

resetDateId

 

Required for 'FLTB'

string

in_reset_date_id

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

RESET_DATE_ID

 

EagleML/entityTransaction/customBenchmark/resetDateId

resetFlag

 

 

string

in_reset_flag

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

RESET_FLAG

 

EagleML/entityTransaction/customBenchmark/resetFlag

fxSourceRuleId

 

Required for 'CONV' and 'HEDG'

integer

in_fx_source_rule_id

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

FX_SOURCE_RULE_ID

 

EagleML/entityTransaction/customBenchmark/fxSourceRuleId

buildSecurityLevel

 

 

string

in_build_security_level

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

BUILD_SECURITY_LEVEL

 

EagleML/entityTransaction/customBenchmark/buildSecurityLevel

dictionarySourceItemId

 

 

integer

in_src_dict_item_id

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

SRC_DICT_ITEM_ID

 

EagleML/entityTransaction/customBenchmark/dictionarySourceItemId

buildAssignLevelOnly

 

 

integer

in_bld_assgn_level_only

RULESDBO

CUSTOM_INDEX_ATTRIBUTES

BLD_ASSGN_LEVEL_ONLY

 

EagleML/entityTransaction/customBenchmark/buildAssignLevelOnly

constrainAsset

Asset Identifiers Model

EagleML/entityTransaction/customBenchmark/constrainAsset/

constrainFlag

 

Required for 'CNST'

string

in_constrain_flag

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

CONSTRAIN_FLAG

 

EagleML/entityTransaction/customBenchmark/constrainFlag

constrainWeight

 

Required for 'CNST'

decimal

in_constrained_weight

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

WEIGHT

 

EagleML/entityTransaction/customBenchmark/constrainWeight

constrainLevel

 

Required for 'CNST'

integer

in_constrained_level

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

DICT_LEVEL

 

EagleML/entityTransaction/customBenchmark/constrainLevel

constrainDescription

 

Required for 'CNST'

string

in_constrained_desc

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

PERF_ROLLUP_RETURNS_ID

 

EagleML/entityTransaction/customBenchmark/constrainDescription

exclusionAsset

Asset Identifiers Model

EagleML/entityTransaction/customBenchmark/exclusionAsset/

exclusionLevel

 

Required for 'EXCL'

integer

in_exclusion_level

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

DICT_LEVEL

 

EagleML/entityTransaction/customBenchmark/exclusionLevel

exclusionDescription

 

Required for 'EXCL'

string

in_exclusion_desc

RULESDBO

CUSTOM_INDEX_ATTR_DETAIL

PERF_ROLLUP_RETURNS_ID

 

EagleML/entityTransaction/customBenchmark/exclusionDescription

processType

Required

Required

string

in_process_type

not stored in DB

 

EagleML/entityTransaction/customBenchmark/processType

entityStatus

 

 

YesNoOptionEnum

in_active_status

RULESDBO

ENTITY

ACTIVE_STATUS

 

EagleML/entityTransaction/customBenchmark/entityStatus

entityDetail

Entity Common Id Model

EagleML/entityTransaction/customBenchmark/entityDetail/

Â