Entity Common Id Model Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 25, 2024 by Kinga Huszno
2 min read

To extract the elements longEntityName, legalEntityName, totalNumberShareClasses, partitionNumber, set the task parameter IncludeEntityInfo = Y in your control message for the extract or set W_INCLUDE_ENTITY_INFO = Y in the configuration file. To extract the Physical Partitions Model along with these four fields, set IncludeEntityInfo = ALL (or W_INCLUDE_ENTITY_INFO = ALL in the config file). 

There are several ways to calculate the totalNumberShareClasses element:

  • Default count of Share Classes

  • Excluding closed Share Classes when counting Share Classes. To use this mode specify CountTFShareClass = N in your RTR for extract.

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

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

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

entityId

Required

Required

string

1163

in_entity_id

RULESDBO

ENTITY

ENTITY_ID

CHAR(8)

../entityId

entityName

Required

 

string

1164

 

RULESDBO

ENTITY

ENTITY_NAME

CHAR(30)

../entityName

entityType

Required

 

normalizedString

1105,3929

in_entity_type,

in_entity_flag_type

 

RULESDBO

ENTITY

ENTITY_TYPE

CHAR(4)

../entityType

xrefAccountId

Conditionally Required (If Entity ID is not given, we can use this field to resolve Entity)

 

string

 

 

RULESDBO

ENTITY_XREFERENCE

XREF_ACCOUNT_ID

VARCHAR2(50)

../xrefAccountId

xrefAccountIdType

Conditionally Required (If Entity ID is not given, we can use this field to resolve Entity)

 

string

 

 

RULESDBO

ENTITY_XREFERENCE

XREF_ACCOUNT_ID_TYPE

VARCHAR2(20)

../xrefAccountIdType

xrefClassCode

 

 

string

 

 

RULESDBO

ENTITY_XREFERENCE

CLASS_CODE

VARCHAR2(10)

../xrefClassCode

entityXrefs

 

 

EntityXrefIdentifiers

Entity Xref Model (see the table below)

../entityXrefs/

entityResolutionOption

 

 

normalizedString

 

 

not stored in DB, used for resolution logic

 

../entityResolutionOption

entityBattingOrder

 

 

normalizedString

 

 

not stored in DB, used for resolution logic

 

../entityBattingOrder

entityXrefMap

 

 

normalizedString

 

 

not stored in DB, used for resolution logic

 

../entityXrefMap

longEntityName

 

 

string

29

 

RULESDBO

ENTITY

ENTITY_LONG_NAME

 

../longEntityName

legalEntityName

 

 

string

1859

 

RULESDBO

ENTITY

LEGAL_NAME

 

../legalEntityName

totalNumberShareClasses

 

 

integer

 

 

resolved by DB query

 

../totalNumberShareClasses

partitionNumber

 

 

integer

 

 

RULESDBO

ENTITY

STAR_PARTITION

 

../partitionNumber

physicalPartitions

 

 

PhysicalPartitionsModel

Physical Partitions Model (see the table below)

../physicalPartitions/

Entity Xref Model Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

xrefAccountId

 

 

string

1233

 

RULESDBO

ENTITY_XREFERENCE

XREF_ACCOUNT_ID

VARCHAR2(50)

../entityXrefs/xrefAccountId

xrefAccountIdType

 

 

string

1234

 

RULESDBO

ENTITY_XREFERENCE

XREF_ACCOUNT_ID_TYPE

VARCHAR2(20)

../entityXrefs/xrefAccountIdType

xrefClassCode

 

 

string

34

 

RULESDBO

ENTITY_XREFERENCE

CLASS_CODE

VARCHAR2(10)

../entityXrefs/xrefClassCode

xrefUpdateTimestamp

 

 

dateTime

 

 

RULESDBO

ENTITY_XREFERENCE

UPDATE_DATE

DATE

../entityXrefs/xrefUpdateTimestamp

Physical Partitions Model Data Map Table

Element

 Required Inbound Acct Validation

 Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

ppTrades

 

 

string

 

 

resolved by

(SELECT tmp.TMP_PPTRADES FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPTRADES FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'TRADESDBO' AND ROWNUM = 1) tmp ) PPTRADES

 

 

../physicalPartitions/ppTrades

ppHolding

 

 

string

 

 

resolved by 

(SELECT tmp.TMP_PPHOLDING FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPHOLDING FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'HOLDINGDBO%' AND ROWNUM = 1) tmp ) PPHOLDING

 

../physicalPartitions/ppHolding

ppCash

 

 

string

 

 

resolved by 

(SELECT tmp.TMP_PPCASH FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPCASH FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'CASHDBO%' AND ROWNUM = 1) tmp ) PPCASH

 

../physicalPartitions/ppCash

ppPerform

 

 

string

 

 

resolved by 

(SELECT tmp.TMP_PPPERFORM FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPPERFORM FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'PERFORMDBO%' AND ROWNUM = 1) tmp ) PPPERFORM

 

../physicalPartitions/ppPerform

ppLedger

 

 

string

 

 

resolved by 

(SELECT tmp.TMP_PPLEDGER FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPLEDGER FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'LEDGERDBO%' AND ROWNUM = 1) tmp ) PPLEDGER

 

../physicalPartitions/ppLedger

ppEstar

 

 

string

 

 

resolved by 

(SELECT tmp.TMP_PPESTAR FROM (SELECT CURRENT_PHYSICAL_PARTITION TMP_PPESTAR FROM ESTAR.STAR_PARTITION SP WHERE SP.LOGICAL_PARTITION_ID = RULEDBO.ENTITY.STAR_PARTITION AND SP.CURRENT_PHYSICAL_PARTITION LIKE 'ESTAR%' AND ROWNUM = 1) tmp ) PPESTAR

 

../physicalPartitions/ppEstar