JDBC Driver for EdgarOnline

Build 20.0.7655


Query the parent/child calculation relationships between numeric fields in the data to validate the consistency of the data and accurately roll up the data. The calculation resource only applies to full financials reported in filings and does not apply to core financials reported in filings.


The driver will use the EdgarOnline API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • TaxonomyId supports the following operator: =.
For example, the following query is processed server side:
SELECT * FROM TaxonomyCalculations WHERE TaxonomyId=18


Name Type Description
SectionId Int Section ID.
TaxonomyId Int The taxonomy id.
SectionTitle String Name of the section.
ParentFieldId Int Parent field ID.
ParentFieldValue String Name of the parent field.
ChildFieldId Int Child field ID.
ChildFieldValue String Name of the child field.
Weight Double Specifies a multiplication factor to apply to the relationship. The multiplication factor is determined by the balance type (Debit or Credit) of the parent and child fields.
RelativeOrder Double Specifies the order of the child field relative to the other child fields included in the calculation relationship.
ChildLevel Int Specifies the level of the calculation relationship in relation to the overall calculation relationship hierarchy.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655