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 27 Current »

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

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

 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