Your satisfaction is our number one priority.  Please use the contact page for support inquiries.

U.S Bank Financial Condition and Performance Data Service

Documentation

Contents

  1. Data Description
  2. Function Imports
  3. Entity Diagram

Data Description

The U.S Bank Financial Condition and Performance Data Service publishes, in a concise and readily usable data format, the regulatory reports, financial data, and structural information for FDIC-insured bank and thrift institutions published by the Federal Financial Institutions Examinations Council (FFIEC). The earliest data provided is from March 31, 2001. The U.S Bank Financial Condition and Performance Data Service provides data search and retrieval across the full set of over 350,000 quarterly Bank Call and Uniform Bank Performance reports representing over one billion data points. In addition, individual MDR element data can be retrieved across banks and reporting periods.

Top

Function Imports

    • [GET_REPORTING_PERIODS]:
      • Query Keys
        1. None.
      • Columns Returned . . .
        • PERIOD_ID
      • Use . . . Returns a list of all quarterly reporting period identifiers in the format YYYYMMDD.
      • Example URL Query: GET_REPORTING_PERIODS
    • [GET_BANK_LOOKUP]:
      • Query Keys
        1. "PERIOD_ID", int, required . . . reporting period in the format YYYYMMDD.
        2. "SEARCH_SNIPPET", string(10 characters max, alphanumeric only), required . . . searches for string in these bank information fields in this order:
          1. Name
          2. Address
          3. City
          4. State
          5. IDRSSD (FFIEC Bank Identifier)
          6. FDIC Certificate Number
          7. OCC Charter Number
          8. OTS Docket Number
          9. ABA Routing Number
          10. ZIP Code
      • Columns Returned . . .
        • PERIOD_ID . . . reporting period identifier
        • ID_RSSD . . . FFIEC bank identifier
        • FDICCertNumber . . . FDIC Certificate Number
        • OCCChartNumber . . . OCC Charter Number
        • OTSDockNumber . . . OTS Docket Number
        • PrimaryABARoutNumber . . . ABA Routing Number
        • Name . . . bank name
        • Address . . . bank address
        • City . . . bank city
        • State . . . bank state
        • ZIP . . . zip code
      • Use . . . identify individual bank/branch information and address(es) .
      • Example URL Queries:
        1. GET_BANK_LOOKUP?PERIOD_ID=20111231&SEARCH_SNIPPET='hancock'
        2. GET_BANK_LOOKUP?PERIOD_ID=20111231&SEARCH_SNIPPET='10057'
    • [GET_REPORT_CALL]:
      • Query Keys
        1. "ID_RSSD", int, required.
        2. "PERIOD_ID", int, required . . . reporting period in the format YYYYMMDD.
      • Columns Returned . . .
        • ID_RSSD . . . FFIEC bank identifier
        • REPORT_DATE . . . reporting period date
        • ENTRY . . . report line item, e.g. "section", "subsection", "blankline", MDR element name
        • ENTRY_TYPE . . . report line item type, e.g. fact, credit, debit
        • ENTRY_PERIOD . . . report line item time span type, e.g. duration, instant, null for fact ENTRY_TYPE
        • ENTRY_STARTDATE . . . report line item time span start
        • ENTRY_ENDDATE . . . report line item time span end
        • UNIT_TYPE . . . classification of the report line item VALUE, e.g. USD
        • DECIMALS . . . number of decimal digits in the report line item VALUE
        • VALUE . . . the report line item datum
        • HEADER_LINE . . . the report line item description
        • HEADER_COLUMN . . . the report line item column description
        • SCHEDULE . . . report of condition or report of income schedule identifier
        • SCHEDULE_LINE . . . report of condition or report of income schedule line identifier
        • SCHEDULE_COL . . . report of condition or report of income column identifier
        • USE . . . the report line item usage requirement, e.g. required, optional
        • LEVEL . . . formatting information indicating the level of indentation for the report line
        • SORT . . . the report line item sort key
      • Use . . . returns the full CALL REPORT, in a concise and readily usable data format, for the specified bank and reporting period.
      • Example Query: GET_REPORT_CALL?ID_RSSD=37&PERIOD_ID=20111231
    • [GET_REPORT_UBPR]:
      • Query Keys
        1. "ID_RSSD", int, required.
        2. "PERIOD_ID", int, required . . . reporting period in the format YYYYMMDD.
      • Columns Returned . . .
        • ID_RSSD . . . FFIEC bank identifier
        • REPORT_DATE . . . reporting period date
        • REPORT_PAGE . . . report page name
        • REPORT_LINE . . . the report line item description
        • ENTRY . . . report line item, e.g. "section", "subsection", "page", "blankline", MDR element name
        • ENTRY_TYPE . . . report line item type, e.g. fact, credit, debit
        • ENTRY_PERIOD . . . report line item time span type, e.g. duration, instant, null for fact ENTRY_TYPE
        • ENTRY_STARTDATE . . . report line item time span start
        • ENTRY_ENDDATE . . . report line item time span end
        • UNIT_TYPE . . . classification of the report line item VALUE, e.g. USD
        • DECIMALS . . . number of decimal digits in the report line item VALUE
        • VALUE . . . the report line item datum
        • USE . . . the report line item usage requirement, e.g. required, optional
        • LEVEL . . . formatting information indicating the level of indentation for the report line
        • SORT . . . the report line item sort key
      • Use . . . returns the full UBPR REPORT, in a concise and readily usable data format, for the specified bank and reporting period.
      • Example Query: GET_REPORT_UBPR?ID_RSSD=37&PERIOD_ID=20111231
    • [GET_RAW_DATA]:
      • Query Keys . . . NOTE: while each query key is optional, at least one must must be specified to get results.
        1. "ID_RSSD", int, optional.
        2. "PERIOD_ID", int, optional . . . reporting period in the format YYYYMMDD.
        3. "ELEMENT_NAME", string(8 characters max, alphanumeric only), optional.
      • Columns Returned . . .
        • ID_RSSD . . . FFIEC bank identifier
        • PERIOD_ID . . . reporting period date
        • ELEMENT_NAME . . . MDR element name, e.g. "RIAD4150", "UBPRE001"
        • ENTRY_STARTDATE . . . report line item time span start
        • ENTRY_ENDDATE . . . report line item time span end
        • UNIT_TYPE . . . classification of the report line item VALUE, e.g. USD
        • DECIMALS . . . number of decimal digits in the report line item VALUE
        • VALUE . . . the report line item datum
      • Use . . . returns raw data in a concise and readily usable format.
      • Example URL Query using keys: GET_RAW_DATA?ID_RSSD=37&PERIOD_ID=20111231
  • Top

    Entity Diagram

    FFIEC Entity Diagram
    Top
    Copyright © 2011-2012, MacroTrenz Corp., All rights reserved.