Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

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

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

RULESDBOENTITY_XREFERENCEUPDATE_DATEDATE../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

 DB query (click to expand):
(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 

 DB query (click to expand):
(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 

 DB query (click to expand):
(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 

 DB query (click to expand):
(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 

 DB query (click to expand):
(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 

 DB query (click to expand):
(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

  • No labels