Entity Properties Model Data Map Table

This model is is extract-only and it is not extracted by default. To add it to your extract, you should have the IncludeExtendedDetails task parameter on your RTR. 

  • ​IncludeExtendedDetails=Y adds this model partially, only elements before the delimiter included.

  • ​IncludeExtendedDetails=ALL adds full model, including elements after the delimiter.

Entity Properties Model Data Map Table

Element

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

accountType

string

4056

in_ex_user_char3

RULESDBO

ENTITY_EXTENSION

USER_CHAR3

VARCHAR2(255)

../accountType

parentCompositeId

string

4054

in_ex_user_char1

RULESDBO

ENTITY_EXTENSION

USER_CHAR1

VARCHAR2(20)

../parentCompositeId

parentCompositeName

string

 

 

RULESDBO

ENTITY

ENTITY_NAME

CHAR (30)

../parentCompositeName

counterpartyId

string

4065

in_ex_user_char12

RULESDBO

ENTITY_EXTENSION

USER_CHAR12

VARCHAR2 (20)

../counterpartyId

closedDate

dateTime

933

in_closed_date

ESTAR

ESTAR_ACCOUNTING_PERIODS

CLOSED_DT

DATE

../closedDate

closedFlag

string

2072

in_closed_flag

RULESDBO

ENTITY

CLOSED_FLAG

CHAR(20)

../closedFlag

fxSource

string

1344

in_fx_source

RULESDBO

ENTITY

FX_SOURCE

CHAR(15)

../fxSource

terminationDate

date

1161

in_termination_date

RULESDBO

ENTITY

TERMINATION_DATE

DATE

../terminationDate

inceptionDate

date

1138

in_inception_date

RULESDBO

ENTITY

INCEPTION_DATE

DATE

../inceptionDate

fiscalEndDate

date

1162

in_fiscal_end_date

RULESDBO

ENTITY

FISCAL_END_DATE

DATE

../fiscalEndDate

entityBaseCurrency

CurrencyCode

86

in_base_currency

RULESDBO

ENTITY

BASE_CURRENCY

CHAR(3)

../entityBaseCurrency

entityCostMethod

string

22

in_cost_method

RULESDBO

ENTITY

COST_METHOD

VARCHAR2 (10)

../entityCostMethod

Extended Entity Properties:

To add the elements below, please set IncludeExtendedDetails=ALL in the RTR

entityAccountingBasis

string

21

 

RULESDBO

ENTITY

ACCOUNTING_BASIS

VARCHAR2 (10)

../entityAccountingBasis

entityPriceMethod

string

1872

in_price_method

RULESDBO

ENTITY

PRICE_METHOD

CHAR

../entityPriceMethod

entitySubType

string

78

in_entity_sub_type

RULESDBO

ENTITY

ENTITY_SUB_TYPE

VARCHAR2(20)

../entitySubType

entitySectorType

string

3948

in_sector_type

RULESDBO

ENTITY_STAR_PROCESSING

SECTOR_TYPE

CHAR

../entitySectorType

entityMasterName

string

1164

 

RULESDBO

ENTITY

ENTITY_NAME

CHAR (30)

../entityMasterName

entityMasterId

string

1163

 

RULESDBO

ENTITY

ENTITY_ID

CHAR (8)

../entityMasterId

entitySectorName

string

1164

 

RULESDBO

ENTITY

ENTITY_NAME

CHAR (30)

../entitySectorName

entitySectorId

string

1163

 

RULESDBO

ENTITY

ENTITY_ID

CHAR (8)

../entitySectorId

entitySectorCount

integer

 

 

Count of Underlying Sectors for Master Entity

 

../entitySectorCount

navRounding

string

10064

in_nav_rounding

RULESDBO

ENTITY

NAV_ROUNDING

VARCHAR2(2)

../navRounding

numberOfNavDigits

integer

10065

in_number_of_nav_digits

RULESDBO

ENTITY

NUMBER_OF_NAV_DIGITS

NUMBER(38,0)

../numberOfNavDigits

legalEntityIdentifier

string

 

 

RULESDBO

ENTITY

LEI

VARCHAR2 (20)

../legalEntityIdentifier

bankAccountNumber

string

9507

in_bank_account_number

RULESDBO

ENTITY

BANK_ACCOUNT_NUMBER

VARCHAR2 (12)

../bankAccountNumber

bankBranchCode

string

2065

in_bank_branch_code

RULESDBO

ENTITY

BANK_BRANCH_CODE

CHAR (20)

../bankBranchCode

countryOfTax

string

1342

in_country_of_tax

RULESDBO

ENTITY

COUNTRY_OF_TAX

CHAR

../countryOfTax

varRateSource

string

3301

in_var_rate_source

RULESDBO

ENTITY

VAR_RATE_SOURCE

CHAR

../varRateSource

eabCoaName

string

1641

in_coa_name

RULESDBO

ENTITY_ACCT_BASIS

COA_NAME

CHAR

../eabCoaName

eabPriceSource

string

1282

in_price_source

RULESDBO

ENTITY_ACCT_BASIS

PRICE_SOURCE 

CHAR

../eabPriceSource

eabRegulatoryCategory

string

12387

in_regulatory_category

RULESDBO

ENTITY_ACCT_BASIS

REGULATORY_CATEGORY 

CHAR

../eabRegulatoryCategory

taxExemptProcessingFlag

string

4948

 

RULESDBO

ENTITY_ACCT_BASIS 

TAX_EXEMPT_FLAG

CHAR

../taxExemptProcessingFlag

entityBasisBaseCurrency

string

86

in_base_currency

RULESDBO

ENTITY_ACCT_BASIS 

BASE_CURRENCY

CHAR

../entityBasisBaseCurrency

nonBusDayProcessing

string

3907

in_non_bus_day_processing

RULESDBO

ENTITY_STAR_PROCESSING

NON_BUS_DAY_PROCESSING

VARCHAR2 (10)

../nonBusDayProcessing

distributionMethod

string

3904

in_distribution_method

RULESDBO

ENTITY_STAR_PROCESSING

DISTRIBUTION_METHOD

CHAR

../distributionMethod

paydowmGlAccount

string

4519

in_pydn_gl_accnt

RULESDBO

ENTITY_STAR_PROCESSING

PYDN_GL_ACCNT

CHAR

../paydowmGlAccount

taxWthldAccntMethod

string

3912

in_tax_wthld_accnt_method

RULESDBO

ENTITY_STAR_PROCESSING

TAX_WTHLD_ACCNT_METHOD

CHAR

../taxWthldAccntMethod

starAcctField29

string

3928

in_star_acct_field_29

RULESDBO

ENTITY_STAR_PROCESSING

STAR_ACCT_FIELD_29

CHAR

../starAcctField29

entityUserDate1

date

1320

in_user_date1

RULESDBO

ENTITY

USER_DATE1

DATE

../entityUserDate1

entityUserDate4

date

1319

in_user_date4

RULESDBO

ENTITY

USER_DATE4

DT

../entityUserDate4

userField3

string

1858

in_user_field3

RULESDBO

ENTITY

USER_FIELD3

VARCHAR2 (10)

../userField3

userField13

string

1866

in_user_field13

RULESDBO

ENTITY

USER_FIELD13

VARCHAR2 (10)

../userField13

userField15

string

1867

in_user_field15

RULESDBO

ENTITY

USER_FIELD15

VARCHAR2 (10)

../userField15

userField16

string

1868

in_user_field16

RULESDBO

ENTITY

USER_FIELD16

VARCHAR2 (10)

../userField16

userField17

string

1642

in_user_field17

RULESDBO

ENTITY

USER_FIELD17

VARCHAR2 (10)

../userField17

userField18

string

1643

in_user_field18

RULESDBO

ENTITY

USER_FIELD18

VARCHAR2 (10)

../userField18

userField19

string

1644

in_user_field19

RULESDBO

ENTITY

USER_FIELD19

VARCHAR2 (10)

../userField19

userField20

string

1645

in_user_field20

RULESDBO

ENTITY

USER_FIELD20

VARCHAR2 (10)

../userField20

userField21

string

1646

in_user_field21

RULESDBO

ENTITY

USER_FIELD21

VARCHAR2 (20)

../userField21

userField22

string

1647

in_user_field22

RULESDBO

ENTITY

USER_FIELD22

VARCHAR2 (20)

../userField22

exUserChar1

string

4054

in_ex_user_char1

RULESDBO

ENTITY_EXTENSION

USER_CHAR1

VARCHAR2 (20)

../exUserChar1

exUserChar3

string

4056

in_ex_user_char3

RULESDBO

ENTITY_EXTENSION

USER_CHAR3

VARCHAR2 (20)

../exUserChar3

exUserChar9

string

4062

in_ex_user_char9

RULESDBO

ENTITY_EXTENSION

USER_CHAR9

VARCHAR2 (20)

../exUserChar9

exUserChar12

string

4065

in_ex_user_char12

RULESDBO

ENTITY_EXTENSION

USER_CHAR12

VARCHAR2 (20)

../exUserChar12

exUserChar30

string

4083

in_ex_user_char30

RULESDBO

ENTITY_EXTENSION

USER_CHAR30

VARCHAR2 (20)

../exUserChar30

exUserChar31

string

4084

in_ex_user_char31

RULESDBO

ENTITY_EXTENSION

USER_CHAR31

VARCHAR2 (20)

../exUserChar31

exUserChar32

string

4085

in_ex_user_char32

RULESDBO

ENTITY_EXTENSION

USER_CHAR32

VARCHAR2 (20)

../exUserChar32

exUserChar33

string

4086

in_ex_user_char33

RULESDBO

ENTITY_EXTENSION

USER_CHAR33

VARCHAR2 (20)

../exUserChar33

exUserChar45

string

4098

in_ex_user_char45

RULESDBO

ENTITY_EXTENSION

USER_CHAR45

VARCHAR2 (20)

../exUserChar45

exUserInd47

string

4170

in_ex_user_ind47

RULESDBO

ENTITY_EXTENSION

USER_IND47

VARCHAR2 (3)

../exUserInd47

exUserInd48

string

4171

in_ex_user_ind48

RULESDBO

ENTITY_EXTENSION

USER_IND48

VARCHAR2 (3)

../exUserInd48

exUserInd49

string

4172

in_ex_user_ind49

RULESDBO

ENTITY_EXTENSION

USER_IND49

VARCHAR2 (3)

../exUserInd49

exUserDate10

date

4203

in_ex_user_date10

RULESDBO

ENTITY_EXTENSION

USER_DATE10

DATE

../exUserDate10

mffEntity

string

16618

in_mff_entity

RULESDBO

ENTITY_STAR_PROCESSING

MFF_ENTITY

VARCHAR2(20)

../mffEntity

acctPeriodFreq

string

624

in_acct_period_freq

RULESDBO

ENTITY_ACCT_BASIS

ACCT_PERIOD_FREQ

 

../acctPeriodFreq

processCenter

string

4896

in_process_center

RULESDBO

ENTITY_STAR_PROCESSING

PROCESS_CENTER

 

../processCenter

ccProcessCtr

string

11407

in_cc_process_ctr

RULESDBO

ENTITY_STAR_PROCESSING

CC_PROCESS_CTR

 

../ccProcessCtr

ccEntity

string

10462

in_cc_entity

RULESDBO

ENTITY_STAR_PROCESSING

CC_ENTITY

 

../ccEntity

portCompType

string

3953

in_port_comp_type

RULESDBO

ENTITY

PORT_COMP_TYPE

 

../portCompType