Home Forums The XBRL API Does concept.id number change overtime?

This topic contains 1 reply, has 2 voices, and was last updated by  David Tauriello 3 weeks, 3 days ago.

  • Author
    Posts
  • #124720

    Tim Bui
    Participant

    To shorten the code, rather than using concept.local-name, I started to use concept.id to call for fact.values. However, I started to realize that the numbers of concept.id change depending on the CIK and the fiscal year–even though the concept.local-names are exactly the same.

    Can you please describe what drives this difference so that I can better construct the code?

    Here are some examples of different concept.ids that have the same concept.local-name:
    entity.cik period.fiscal-year concept.local-name concept.id
    0001109879 2011 IncreaseDecreaseInInventories 9049
    0000090168 2011 IncreaseDecreaseInInventories 68486
    0000027093 2011 IncreaseDecreaseInInventories 6249201
    0000812074 2012 IncreaseDecreaseInInventories 10288733
    0000110621 2014 IncreaseDecreaseInInventories 15795815
    0001122976 2013 IncreaseDecreaseInInventories 12743567
    0001421182 2015 IncreaseDecreaseInInventories 10288733
    0000811596 2016 IncreaseDecreaseInInventories 18601247
    0001524741 2017 IncreaseDecreaseInInventories 21660607
    0000004281 2018 IncreaseDecreaseInInventories 21660607

  • #126287

    David Tauriello
    Keymaster

    Each company submits its own ‘extension taxonomy’ to the SEC – it’s essentially a cut-down version of only the US GAAP elements needed, plus any extension elements the company creates because it cannot find an existing element that adequately covers the fact(s) being reported by the extension elements.

    So, while the concept.local-name values in your list above are identical, the concept.id values will differ, because our database assigns concept.id values based on the facts as they appear in the company’s instance, not as they may relate to the US GAAP taxonomy.

    If you use concept.is-base (set as =true in the query or returned as true/false in fields) you can quickly distinguish whether the concept.id is a US GAAP element.

You must be logged in to reply to this topic.

Comment