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)
(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