Insurance Valuation Lot Data Map Table

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