Entity Regulatory Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Eagle DB | DB Table | DB Field | Data Type | XPath |
|---|---|---|---|---|---|---|---|---|
objectType | Required | Required | ObjectTypeEnum | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/objectType | ||
objectId |
|
| ObjectId | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/objectId | ||
objectDescription |
|
| FeedTypeEnum | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/objectDescription | ||
updateTimestamp | Required | Required | dateTime | RULESDBO | ENTITY_REGULATORY | UPDATE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/updateTimestamp |
customElements | Not recommended | CustomElements - reserved for customizations | EagleML/entityTransaction/entityRegulatory/customElements | |||||
updateSource | Required | Required | string | RULESDBO | ENTITY_REGULATORY | UPDATE_SOURCE | VARCHAR2(255) | EagleML/entityTransaction/entityRegulatory/updateSource |
accountingValidationFlag |
|
| YesNoOptionEnum | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/accountingValidationFlag | ||
mutualEntityType |
|
| MutualEntityTypeEnum | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/mutualEntityType | ||
Entity Common Id Model - see extra data map table | EagleML/entityTransaction/entityRegulatory/ | |||||||
effectiveDate | Required for history mode | date | RULESDBO | ENTITY_REGULATORY_HIST | EFFECTIVE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/effectiveDate | |
historyOnlyFlag |
|
| YesNoOptionEnum | not stored in DB |
| EagleML/entityTransaction/entityRegulatory/historyOnlyFlag | ||
firstNCenFilingDate |
|
| date | RULESDBO | ENTITY_REGULATORY | FIRST_NCEN_FILING_DATE | DATE | EagleML/entityTransaction/entityRegulatory/firstNCenFilingDate |
finalNCenFilingDate |
|
| date | RULESDBO | ENTITY_REGULATORY | FINAL_NCEN_FILING_DATE | DATE | EagleML/entityTransaction/entityRegulatory/finalNCenFilingDate |
fidelityBond |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | FIDELITY_BOND | CHAR(1) | EagleML/entityTransaction/entityRegulatory/fidelityBond |
fidelityBondAmount |
|
| decimal | RULESDBO | ENTITY_REGULATORY | FIDELITY_BOND_AMOUNT | NUMBER | EagleML/entityTransaction/entityRegulatory/fidelityBondAmount |
officerErrorInsurance |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | OFFICER_ERROR_INSURANCE | CHAR(1) | EagleML/entityTransaction/entityRegulatory/officerErrorInsurance |
officerErrorInsClaims |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | OFFICER_ERROR_INS_CLAIMS | CHAR(1) | EagleML/entityTransaction/entityRegulatory/officerErrorInsClaims |
exemptiveOrders |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | EXEMPTIVE_ORDERS | CHAR(1) | EagleML/entityTransaction/entityRegulatory/exemptiveOrders |
exemptiveOrdersReleaseNumber |
|
| integer | RULESDBO | ENTITY_REGULATORY | EXEMPTIVE_ORDERS_REL_NBRS | NUMBER | EagleML/entityTransaction/entityRegulatory/exemptiveOrdersReleaseNumber |
internalControlWeakness |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | INTERNAL_CONTROL_WEAKNESS | CHAR(1) | EagleML/entityTransaction/entityRegulatory/internalControlWeakness |
valuationChangeDate |
|
| date | RULESDBO | ENTITY_REGULATORY | VAL_CHANGE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/valuationChangeDate |
valuationChangeDescription |
|
| string | RULESDBO | ENTITY_REGULATORY | VAL_CHANGE_DESC | VARCHAR2(255) | EagleML/entityTransaction/entityRegulatory/valuationChangeDescription |
valuationChangeAssetType |
|
| string | RULESDBO | ENTITY_REGULATORY | VAL_CHANGE_ASSET_TYPE | VARCHAR2(255) | EagleML/entityTransaction/entityRegulatory/valuationChangeAssetType |
valuationChangeInvestmentType |
|
| string | RULESDBO | ENTITY_REGULATORY | VAL_CHANGE_INV_TYPE | VARCHAR2(255) | EagleML/entityTransaction/entityRegulatory/valuationChangeInvestmentType |
valuationChangeBasis |
|
| string | RULESDBO | ENTITY_REGULATORY | VAL_CHANGE_BASIS | VARCHAR2(255) | EagleML/entityTransaction/entityRegulatory/valuationChangeBasis |
accountingPracticeChange |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | ACCOUNTING_PRAC_CHANGE | CHAR(1) | EagleML/entityTransaction/entityRegulatory/accountingPracticeChange |
materialModification |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | MATERIAL_MODIFICATION | CHAR(1) | EagleML/entityTransaction/entityRegulatory/materialModification |
separateAccount |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | SEPARATE_ACCOUNT | CHAR(1) | EagleML/entityTransaction/entityRegulatory/separateAccount |
indexAffiliated |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | INDEX_AFFILIATED | CHAR(1) | EagleML/entityTransaction/entityRegulatory/indexAffiliated |
indexExclusive |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | INDEX_EXCLUSIVE | CHAR(1) | EagleML/entityTransaction/entityRegulatory/indexExclusive |
expenseLimitation |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | EXPENSE_LIMITATION | CHAR(1) | EagleML/entityTransaction/entityRegulatory/expenseLimitation |
expenseReduceWaive |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | EXPENSE_REDUCE_WAIVE | CHAR(1) | EagleML/entityTransaction/entityRegulatory/expenseReduceWaive |
expenseWaiveRecoup |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | EXPENSE_WAIVE_RECOUP | CHAR(1) | EagleML/entityTransaction/entityRegulatory/expenseWaiveRecoup |
expensePrevWaiveRecoup |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | EXPENSE_PREV_WAIVE_RECOUP | CHAR(1) | EagleML/entityTransaction/entityRegulatory/expensePrevWaiveRecoup |
regStmtEffectiveDate |
|
| date | RULESDBO | ENTITY_REGULATORY | REG_STMT_EFFECTIVE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/regStmtEffectiveDate |
mostRecentUnitRegDate |
|
| date | RULESDBO | ENTITY_REGULATORY | MOST_RECENT_UNIT_REG_DATE | DATE | EagleML/entityTransaction/entityRegulatory/mostRecentUnitRegDate |
highlyLiqInvMin |
|
| decimal | RULESDBO | ENTITY_REGULATORY | HIGHLY_LIQ_INV_MIN | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMin |
highlyLiqInvMinDate |
|
| date | RULESDBO | ENTITY_REGULATORY | HLIM_DATE | DATE | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinDate |
highlyLiqInvMinBoardApprovalDate |
|
| date | RULESDBO | ENTITY_REGULATORY | HLIM_BOARD_APPROVAL_DATE | DATE | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinBoardApprovalDate |
highlyLiqInvMinRarLevel |
|
| decimal | RULESDBO | ENTITY_REGULATORY | HLIM_RAR_LEVEL | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinRarLevel |
highlyLiqInvMinRarValue |
|
| decimal | RULESDBO | ENTITY_REGULATORY | HLIM_RAR_VALUE | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinRarValue |
highlyLiqInvMinLowLimit |
|
| decimal | RULESDBO | ENTITY_REGULATORY | HLIM_LOW_LIMIT | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinLowLimit |
highlyLiqInvMinLowLimitDate |
|
| date | RULESDBO | ENTITY_REGULATORY | HLIM_LOW_LIMIT_DATE | DATE | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinLowLimitDate |
highlyLiqInvMinCureDate |
|
| date | RULESDBO | ENTITY_REGULATORY | HLIM_CURE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinCureDate |
highlyLiqInvMinChanged |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | HLIM_CHANGED | CHAR(1) | EagleML/entityTransaction/entityRegulatory/highlyLiqInvMinChanged |
investorConcentrationPercent |
|
| decimal | RULESDBO | ENTITY_REGULATORY | INV_CONC_PERCENT | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/investorConcentrationPercent |
investorConcentrationDate |
|
| date | RULESDBO | ENTITY_REGULATORY | INV_CONC_DATE | DATE | EagleML/entityTransaction/entityRegulatory/investorConcentrationDate |
liquidityExclusion |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | LIQUIDITY_EXCLUSION | CHAR(1) | EagleML/entityTransaction/entityRegulatory/liquidityExclusion |
liquidityExclusionReason |
|
| string | RULESDBO | ENTITY_REGULATORY | LIQUIDITY_EXCLUSION_REASON | CHAR(3) | EagleML/entityTransaction/entityRegulatory/liquidityExclusionReason |
fundExclusionHliLimit |
|
| decimal | RULESDBO | ENTITY_REGULATORY | FUND_EXCLUSION_HLI_LIMIT | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/fundExclusionHliLimit |
fundExclusionHliDate |
|
| date | RULESDBO | ENTITY_REGULATORY | FUND_EXCLUSION_HLI_DATE | DATE | EagleML/entityTransaction/entityRegulatory/fundExclusionHliDate |
illiquidCureDate |
|
| date | RULESDBO | ENTITY_REGULATORY | ILLIQUID_CURE_DATE | DATE | EagleML/entityTransaction/entityRegulatory/illiquidCureDate |
locId |
|
| string | RULESDBO | ENTITY_REGULATORY | LOC_ID | CHAR(50) | EagleML/entityTransaction/entityRegulatory/locId |
locWithdrawal |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | LOC_WITHDRAWAL | CHAR(1) | EagleML/entityTransaction/entityRegulatory/locWithdrawal |
locAvgOustanding |
|
| decimal | RULESDBO | ENTITY_REGULATORY | LOC_AVG_OUSTANDING | NUMBER(36,12) | EagleML/entityTransaction/entityRegulatory/locAvgOustanding |
locDaysInUse |
|
| integer | RULESDBO | ENTITY_REGULATORY | LOC_DAYS_IN_USE | NUMBER(5) | EagleML/entityTransaction/entityRegulatory/locDaysInUse |
interfundLending |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | INTERFUND_LENDING | CHAR(1) | EagleML/entityTransaction/entityRegulatory/interfundLending |
interfundLoanAmount |
|
| decimal | RULESDBO | ENTITY_REGULATORY | INTERFUND_LOAN_AMT | NUMBER(36,12) | EagleML/entityTransaction/entityRegulatory/interfundLoanAmount |
interfundLoanDays |
|
| integer | RULESDBO | ENTITY_REGULATORY | INTERFUND_LOAN_DAYS | NUMBER(5) | EagleML/entityTransaction/entityRegulatory/interfundLoanDays |
interfundBorrowing |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | INTERFUND_BORROWING | CHAR(1) | EagleML/entityTransaction/entityRegulatory/interfundBorrowing |
interfundBorrowAmount |
|
| decimal | RULESDBO | ENTITY_REGULATORY | INTERFUND_BORROW_AMT | NUMBER(36,12) | EagleML/entityTransaction/entityRegulatory/interfundBorrowAmount |
interfundBorrowDays |
|
| integer | RULESDBO | ENTITY_REGULATORY | INTERFUND_BORROW_DAYS | NUMBER(5) | EagleML/entityTransaction/entityRegulatory/interfundBorrowDays |
securitiesLendingAuthorized |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | SEC_LENDING_AUTHORIZED | CHAR(1) | EagleML/entityTransaction/entityRegulatory/securitiesLendingAuthorized |
redemptionsAtRiskDate |
|
| date | RULESDBO | ENTITY_REGULATORY | RAR_DATE | DATE | EagleML/entityTransaction/entityRegulatory/redemptionsAtRiskDate |
redemptionsAtRisk1 |
|
| decimal | RULESDBO | ENTITY_REGULATORY | RAR_1 | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/redemptionsAtRisk1 |
redemptionsAtRisk2 |
|
| decimal | RULESDBO | ENTITY_REGULATORY | RAR_2 | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/redemptionsAtRisk2 |
redemptionsAtRisk3 |
|
| decimal | RULESDBO | ENTITY_REGULATORY | RAR_3 | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/redemptionsAtRisk3 |
redemptionsAtRisk4 |
|
| decimal | RULESDBO | ENTITY_REGULATORY | RAR_4 | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/redemptionsAtRisk4 |
redemptionsAtRisk5 |
|
| decimal | RULESDBO | ENTITY_REGULATORY | RAR_5 | NUMBER(26,10) | EagleML/entityTransaction/entityRegulatory/redemptionsAtRisk5 |
rule10f3 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_10F_3 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule10f3 |
rule12d11 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_12D1_1 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule12d11 |
rule15a4 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_15A_4 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule15a4 |
rule17a6 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_17A_6 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule17a6 |
rule17a7 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_17A_7 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule17a7 |
rule17a8 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_17A_8 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule17a8 |
rule17e1 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_17E_1 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule17e1 |
rule22d1 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_22D_1 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule22d1 |
rule23c1 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_23C_1 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule23c1 |
rule32a4 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_32A_4 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule32a4 |
rule6c7 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_6C_7 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule6c7 |
rule11a2 |
|
| YesNoOptionEnum | RULESDBO | ENTITY_REGULATORY | RULE_11A_2 | CHAR(1) | EagleML/entityTransaction/entityRegulatory/rule11a2 |