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

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

Anchor
PP_Model PP_Model

Physical Partitions Model Data Map Table

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