Versions Compared

Old Version 23

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

compared with

New Version 24

changes.mady.by.user Pamela Totas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Extract-only_fields_info
Extract-only_fields_info
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  along with these four fields please , set IncludeEntityInfo = ALL (or W_INCLUDE_ENTITY_INFO = ALL in the config file). 

Info

There are several ways to calculate the totalNumberShareClasses element:

  • Default count of Share Classes
  • Excluding closed Share Classes when counting Share Classes - to . To use this mode please 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/

Anchor
_entityXref
_entityXref
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

Anchor
PP_Model
PP_Model
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

Expand
titleDB query (click to expand):


Code Block
languagesql
(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 

Expand
titleDB query (click to expand):


Code Block
languagesql
(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 

Expand
titleDB query (click to expand):


Code Block
languagesql
(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 

Expand
titleDB query (click to expand):


Code Block
languagesql
(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 

Expand
titleDB query (click to expand):


Code Block
languagesql
(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 

Expand
titleDB query (click to expand):


Code Block
languagesql
(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

...