...
| Element | Value Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|
| objectType | ObjectTypeEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/objectType | |||
| objectId | ObjectId | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/objectId | |||
| objectDescription | FeedTypeEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/objectDescription | |||
| updateTimestamp | dateTime | ISTAR | ISTAR_LOT | UPDATE_DATE | DATE | EagleML/warehouseTransaction/insuranceValuationLot/updateTimestamp |
| customElements | CustomElements | CustomElements reserved for customizations | EagleML/warehouseTransaction/insuranceValuationLot/customElements | |||
| sourceName | string | ISTAR | ISTAR_LOT | SOURCE_NUMBER | CHAR(15) | EagleML/warehouseTransaction/insuranceValuationLot/sourceName |
| updateSource | string | ISTAR | ISTAR_LOT | UPDATE_SOURCE | CHAR(8) | EagleML/warehouseTransaction/insuranceValuationLot/updateSource |
| Entity Common Id Model | EagleML/warehouseTransaction/insuranceValuationLot/ | |||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/insuranceValuationLot/ | |||||
| accountingBasis | string | RULESDBO | ENTITY | ACCOUNTING_BASIS | VARCHAR2(10) | EagleML/warehouseTransaction/insuranceValuationLot/accountingBasis |
| lotId | string | EagleML/warehouseTransaction/insuranceValuationLot/lotId | ||||
| entityIDLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/entityIDLookupSwitch | |||
| entityNameLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/entityNameLookupSwitch | |||
| securityQueryFlag | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/securityQueryFlag | |||
| sourceLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/sourceLookupSwitch | |||
| procedureMode | ProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/procedureMode | |||
| procedureFlag | ProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/procedureFlag | |||
| procedureFlag | ProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/insuranceValuationLot/procedureFlag | |||
| Asset Identifiers Model | EagleML/warehouseTransaction/insuranceValuationLot/ | |||||
| Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/insuranceValuationLot/ | |||||
| maturityDate | dateTime | ISTAR | ISTAR_LOT_VALUATION | CM_MAT_DATE | DATE | EagleML/warehouseTransaction/insuranceValuationLot/maturityDate |
| clientId | string | ISTAR | ISTAR_LOT_VALUATION | CLIENT_ID | EagleML/warehouseTransaction/insuranceValuationLot/clientId | |
| name | string | ISTAR | ISTAR_LOT_VALUATION | NAME | EagleML/warehouseTransaction/insuranceValuationLot/name | |
| longShortIndicator | string | ISTAR | ISTAR_LOT_VALUATION | LONG_SHORT | EagleML/warehouseTransaction/insuranceValuationLot/longShortIndicator | |
| baseCurrency | string | ISTAR | ISTAR_LOT_VALUATION | BASE_CURRENCY | EagleML/warehouseTransaction/insuranceValuationLot/baseCurrency | |
| localCurrency | string | ISTAR | ISTAR_LOT_VALUATION | LOCAL_CURRENCY | EagleML/warehouseTransaction/insuranceValuationLot/localCurrency | |
| monthEndDate | dateTime | ISTAR | ISTAR_LOT_VALUATION | MONTH_END_DATE | EagleML/warehouseTransaction/insuranceValuationLot/monthEndDate | |
| openEventId | string | ISTAR | ISTAR_LOT_VALUATION | OPEN_EVENT_ID | EagleML/warehouseTransaction/insuranceValuationLot/openEventId | |
| schdLineCode | string | ISTAR | ISTAR_LOT_VALUATION | SCHD_LINE_CODE | EagleML/warehouseTransaction/insuranceValuationLot/schdLineCode | |
| holdingTerm | decimal | ISTAR | ISTAR_LOT_VALUATION | HOLDING_TERM | EagleML/warehouseTransaction/insuranceValuationLot/holdingTerm | |
| discLineCode1 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE1 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode1 | |
| discLineCode2 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE2 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode2 | |
| discLineCode3 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE3 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode3 | |
| discLineCode4 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE4 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode4 | |
| discLineCode5 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE5 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode5 | |
| discLineCode6 | string | ISTAR | ISTAR_LOT_VALUATION | DISK_LINE_CODE6 | EagleML/warehouseTransaction/insuranceValuationLot/discLineCode6 | |
| valRunDate | dateTime | ISTAR | ISTAR_LOT_VALUATION | VAL_RUN_DATE | EagleML/warehouseTransaction/insuranceValuationLot/valRunDate | |
| bookValueBase | decimal | ISTAR | ISTAR_LOT_VALUATION | BOOK_VALUE_B | EagleML/warehouseTransaction/insuranceValuationLot/bookValueBase | |
| marketValueBase | decimal | ISTAR | ISTAR_LOT_VALUATION | MARKET_VALUE_B | EagleML/warehouseTransaction/insuranceValuationLot/marketValueBase | |
| marketValueInd | string | ISTAR | ISTAR_LOT_VALUATION | MARKET_VALUE_IND | EagleML/warehouseTransaction/insuranceValuationLot/marketValueInd | |
| designation | dateTime | ISTAR | ISTAR_LOT_VALUATION | NAIC_DESIGNATION | EagleML/warehouseTransaction/insuranceValuationLot/designation | |
| naicDesignationPreffix | dateTime | ISTAR | ISTAR_LOT_VALUATION | NAIC_DESIGNATION_PREFIX | EagleML/warehouseTransaction/insuranceValuationLot/naicDesignationPreffix | |
| naicDesignationSuffix | dateTime | ISTAR | ISTAR_LOT_VALUATION | NAIC_DESIGNATION_SUFFIX | EagleML/warehouseTransaction/insuranceValuationLot/naicDesignationSuffix | |
| statementValue | decimal | ISTAR | ISTAR_LOT_VALUATION | STATEMENT_VALUE | EagleML/warehouseTransaction/insuranceValuationLot/statementValue | |
| statementValueIndicator | string | ISTAR | ISTAR_LOT_VALUATION | STATEMENT_VALUE_IND | EagleML/warehouseTransaction/insuranceValuationLot/statementValueIndicator | |
| unrealGlFxLtd | decimal | ISTAR | ISTAR_LOT_VALUATION | UNREAL_GL_FX_LTD | EagleML/warehouseTransaction/insuranceValuationLot/unrealGlFxLtd | |
| unrealGlMktYtd | decimal | ISTAR | ISTAR_LOT_VALUATION | UNREAL_GL_MKT_YTD | EagleML/warehouseTransaction/insuranceValuationLot/unrealGlMktYtd | |
| valSpotRate | decimal | ISTAR | ISTAR_LOT_VALUATION | VAL_SPOT_RATE | EagleML/warehouseTransaction/insuranceValuationLot/valSpotRate | |
| reclasifyPartyLot | string | ISTAR | ISTAR_LOT_VALUATION | RECLASIFY_PARTY_LOT | EagleML/warehouseTransaction/insuranceValuationLot/reclasifyPartyLot | |
| addPartyLot | string | ISTAR | ISTAR_LOT_VALUATION | ADD_PARTY_LOT | EagleML/warehouseTransaction/insuranceValuationLot/addPartyLot | |
| resCalcBalanceLot | string | ISTAR | ISTAR_LOT_VALUATION | RES_CALC_BALANCE_LOT | EagleML/warehouseTransaction/insuranceValuationLot/resCalcBalanceLot | |
| resCalcBalanceLot | string | ISTAR | ISTAR_LOT_VALUATION | RES_CALC_BALANCE_LOT | EagleML/warehouseTransaction/insuranceValuationLot/resCalcBalanceLot | |
| unrealGlMktChange | decimal | ISTAR | ISTAR_LOT_VALUATION | UNREAL_GL_MKT_CHANGE | EagleML/warehouseTransaction/insuranceValuationLot/unrealGlMktChange | |
| unrealGlFxChange | decimal | ISTAR | ISTAR_LOT_VALUATION | UNREAL_GL_FX_CHANGE | EagleML/warehouseTransaction/insuranceValuationLot/unrealGlFxChange | |
| scheduleDCode | string | ISTAR | ISTAR_LOT_VALUATION | SCHD_D_CODE | EagleML/warehouseTransaction/insuranceValuationLot/scheduleDCode | |
| groupCode | string | ISTAR | ISTAR_LOT_VALUATION | GROUP_CODE | EagleML/warehouseTransaction/insuranceValuationLot/groupCode | |
| variationMargin | decimal | ISTAR | ISTAR_LOT_VALUATION | VARIATION_MARGIN | EagleML/warehouseTransaction/insuranceValuationLot/variationMargin | |
| dueAccruedLtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | DUE_ACCRUED_LTD_B | EagleML/warehouseTransaction/insuranceValuationLot/dueAccruedLtdB | |
| shortValSpotRate | decimal | ISTAR | ISTAR_LOT_VALUATION | SHORT_VAL_SPOT_RATE | EagleML/warehouseTransaction/insuranceValuationLot/shortValSpotRate | |
| valPriceSource | string | ISTAR | ISTAR_LOT_VALUATION | VAL_PRICE_SOURCE | EagleML/warehouseTransaction/insuranceValuationLot/valPriceSource | |
| valPriceDate | dateTime | ISTAR | ISTAR_LOT_VALUATION | VAL_PRICE_DATE | EagleML/warehouseTransaction/insuranceValuationLot/valPriceDate | |
| incomeEarned | decimal | ISTAR | ISTAR_LOT_VALUATION | INCOME_EARNED | EagleML/warehouseTransaction/insuranceValuationLot/incomeEarned | |
| dueAccruedLtdBDef | string | ISTAR | ISTAR_LOT_VALUATION | DUE_ACCRUED_LTD_B_DEF | EagleML/warehouseTransaction/insuranceValuationLot/dueAccruedLtdBDef | |
| incDecAdj | decimal | ISTAR | ISTAR_LOT_VALUATION | INC_DEC_ADJ | EagleML/warehouseTransaction/insuranceValuationLot/incDecAdj | |
| writedownLtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | WRITEDOWN_LTD_B | EagleML/warehouseTransaction/insuranceValuationLot/writedownLtdB | |
| writedownYtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | WRITEDOWN_YTD_B | EagleML/warehouseTransaction/insuranceValuationLot/writedownYtdB | |
| iptActualCostB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_ACTUAL_COST_B | EagleML/warehouseTransaction/insuranceValuationLot/iptActualCostB | |
| iptIntDivRecdHld | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_INT_DIV_RECD_HLD | EagleML/warehouseTransaction/insuranceValuationLot/iptIntDivRecdHld | |
| iptIncDecAdj | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_INC_DEC_ADJ | EagleML/warehouseTransaction/insuranceValuationLot/iptIncDecAdj | |
| iptUnrealGlFxChg | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_UNREAL_GL_FX_CHG | EagleML/warehouseTransaction/insuranceValuationLot/iptUnrealGlFxChg | |
| iptUnrealGlMktChg | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_UNREAL_GL_MKT_CHG | EagleML/warehouseTransaction/insuranceValuationLot/iptUnrealGlMktChg | |
| iptAmortYtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_AMORT_YTD_B | EagleML/warehouseTransaction/insuranceValuationLot/iptAmortYtdB | |
| iptWritedownYtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_WRITEDOWN_YTD_B | EagleML/warehouseTransaction/insuranceValuationLot/iptWritedownYtdB | |
| revPyCurrQuantity | decimal | ISTAR | ISTAR_LOT_VALUATION | REV_PY_CURR_QUANTITY | EagleML/warehouseTransaction/insuranceValuationLot/revPyCurrQuantity | |
| pyAmortPosB | decimal | ISTAR | ISTAR_LOT_VALUATION | PY_AMORT_POS_B | EagleML/warehouseTransaction/insuranceValuationLot/pyAmortPosB | |
| dueAdmitSwitch | string | ISTAR | ISTAR_LOT_VALUATION | DUE_ADMIT_SWITCH | EagleML/warehouseTransaction/insuranceValuationLot/dueAdmitSwitch | |
| iptTipsYtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_TIPS_YTD_B | EagleML/warehouseTransaction/insuranceValuationLot/iptTipsYtdB | |
| lineNumber | decimal | ISTAR | ISTAR_LOT_VALUATION | LINE_NUMBER | EagleML/warehouseTransaction/insuranceValuationLot/lineNumber | |
| pyeBacv | decimal | ISTAR | ISTAR_LOT_VALUATION | PYE_BACV | EagleML/warehouseTransaction/insuranceValuationLot/pyeBacv | |
| iptPyeBacv | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_PYE_BACV | EagleML/warehouseTransaction/insuranceValuationLot/iptPyeBacv | |
| ambLineNumber | decimal | ISTAR | ISTAR_LOT_VALUATION | AMB_LINE_NUMBER | EagleML/warehouseTransaction/insuranceValuationLot/ambLineNumber | |
| valPrice | decimal | ISTAR | ISTAR_LOT_VALUATION | VAL_PRICE | EagleML/warehouseTransaction/insuranceValuationLot/valPrice | |
| iptDueAccruedLtdB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_DUE_ACCRUED_LTD_B | EagleML/warehouseTransaction/insuranceValuationLot/iptDueAccruedLtdB | |
| iptDueAccruedLtdBdef | string | ISTAR | ISTAR_LOT_VALUATION | IPT_DUE_ACCRUED_LTD_B_DEF | EagleML/warehouseTransaction/insuranceValuationLot/iptDueAccruedLtdBdef | |
| iptAccrIntPurchCurrB | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_ACCR_INT_PURCH_CURR_B | EagleML/warehouseTransaction/insuranceValuationLot/iptAccrIntPurchCurrB | |
| unrealLossMonths | decimal | ISTAR | ISTAR_LOT_VALUATION | UNREAL_LOSS_MONTHS | EagleML/warehouseTransaction/insuranceValuationLot/unrealLossMonths | |
| iptUnrealLossMonths | decimal | ISTAR | ISTAR_LOT_VALUATION | IPT_UNREAL_LOSS_MONTHS | EagleML/warehouseTransaction/insuranceValuationLot/iptUnrealLossMonths | |
| valFactor | decimal | ISTAR | ISTAR_LOT_VALUATION | VAL_FACTOR | EagleML/warehouseTransaction/insuranceValuationLot/valFactor | |
| rateOfAction | decimal | ISTAR | ISTAR_LOT_VALUATION | RATE_OF_ACTION | EagleML/warehouseTransaction/insuranceValuationLot/rateOfAction | |
| iLUserNum1 | decimal | ISTAR | ISTAR_LOT_VALUATION | USER_NUM1 | EagleML/warehouseTransaction/insuranceValuationLot/iLUserNum1 | |
| iLUserNum2 | decimal | ISTAR | ISTAR_LOT_VALUATION | USER_NUM2 | EagleML/warehouseTransaction/insuranceValuationLot/iLUserNum2 | |
| iLUserNum3 | decimal | ISTAR | ISTAR_LOT_VALUATION | USER_NUM3 | EagleML/warehouseTransaction/insuranceValuationLot/iLUserNum3 | |
| initNaicDesig | string | ISTAR | ISTAR_LOT_VALUATION | INIT_NAIC_DESIG | EagleML/warehouseTransaction/insuranceValuationLot/initNaicDesig | |
| naicReviewDate | date | ISTAT | ISTAR_XREFERENCE | NAIC_REVIEW_DT | EagleML/warehouseTransaction/insuranceValuationLot/xreference/naikReviewDate | |