Generic SMF - Real Estate Model Data Map

REAL_ESTATE table is available only in environments v13.0 and higher.

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

reAddressLine1

 

 

string

11655

in_re_address_line1

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

ADDRESS_LINE1

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reAddressLine1

reAddressLine2

 

 

string

11656

in_re_address_line2

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

ADDRESS_LINE2

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reAddressLine2

reCity

 

 

string

11657

in_re_city

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

CITY

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reCity

impairedFlag

 

 

string

11658

in_re_impaired

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

IMPAIRED

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/realEstateModel/impairedFlag

netLeasableArea

 

 

string

11659

in_re_net_leasable_area

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

NET_LEASABLE_AREA

NUMBER

EagleML/referenceTransaction/genericSMF/realEstateModel/netLeasableArea

propertyType

 

 

string

11660

in_re_property_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROPERTY_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/propertyType

reState

 

 

string

11670

in_re_state

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

STATE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/reState

statisticalDivision

 

 

string

11671

in_re_statistical_div

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

STATISTICAL_DIV

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/statisticalDivision

numberOfUnits

 

 

decimal

11672

in_re_unit_of_measure

N

realestate_model.inc

SECURITYDBO

REAL_ESTATE

UNITS

NIMBER(38,12)

EagleML/referenceTransaction/genericSMF/realEstateModel/numberOfUnits

unitOfMeasure

 

 

string

11673

in_re_units

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

UNIT_OF_MEASURE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/unitOfMeasure

propertySubType

 

 

string

17570

in_re_property_sub_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROPERTY_SUB_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/propertySubType

metro

 

 

string

17571

in_re_metro

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

METRO

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/metro

msa

 

 

string

17572

in_re_msa

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

MSA

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/msa

projectType

 

 

string

17573

in_re_project_type

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

PROJECT_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/projectType

yearBuilt

 

 

string

17574

in_re_year_built

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

YEAR_BUILT

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/yearBuilt

riskProfile

 

 

string

17575

in_re_risk_profile

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

RISK_PROFILE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/riskProfile

lifecycle

 

 

string

17576

in_re_lifecycle

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

LIFECYCLE

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/lifecycle

renovated

 

 

string

17577

in_re_renovated

S

realestate_model.inc

SECURITYDBO

REAL_ESTATE

RENOVATED

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/realEstateModel/renovated