Author: Mike McIver, MCSE

SQL Server Architecture, Design, Development and Administration

Best Job Experience Ever

A Position Of Trust And Confidence

The best job experience I ever had … U.S.A.F. Officer serving as a B-52G Navigator. It was exciting and intense to say the least. Best of all were the very fine people with whom I had the pleasure of serving.

Five (A.M.) To Nine (P.M.)

This stock photo shows the navigators’ station on the lower deck, i.e. the ejection seats go down not up. The Radar Navigator on the left handles the gravity bombs. The Navigator on the right handles the missiles. In addition to navigating within very tight position and timing constraints, the Navigator is the “mission director” responsible for pacing the entire crew during 12 to 18 hour missions. Though the missions are long, the Navigator is very busy from the time the aircraft crosses the “hold line” onto the runway until landing. The required discipline and tenacity is, by far, the most valuable experience in my entire working career.

Best Job Experience Ever
Best Job Experience Ever

If you have a specific business purpose or proposal for SQL Server services or products, and would like to connect, please see more information about Mike McIver, Data Consultant on LinkedIn.

FRB_SR Database

Edit:  Microsoft has discontinued the DataMarket program.  We are working to re-establish this service.

Get It Now on Microsoft’s Azure DataMarket . . .

 

FRB_SR . . . All Federal Reserve Bank Statistical Data in One Place!

A great source of historical, research, and test data, the FRB_SR database consolidates the statistical releases published by the Federal Reserve Bank.  There are

  • 13 statistical releases
  • 35 Datasets
  • Over 15,000 Series
  • Over 8.7 million data points . . . going back to 31 Jan 1919!

No more manual downloads and processing XML files . . . FRB_SR is a fully functional database . . . the data are ready for use; the pic on this ad shows the data structure.

Includes:

Bank Assets & Liabilities
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Assets and Liabilities of Commercial Banks in the U.S. (H.8)
–Charge-off and Delinquency Rates
–Senior Loan Officer Opinion Survey on Bank Lending Practices

Business Finance
–Commercial Paper
–Finance Companies (G.20)

Exchange Rates and International Data
–Foreign Exchange Rates (G.5 / H.10)

Flow of Funds Accounts
–Flow of Funds Accounts of the United States (Z.1)

Household Finance
–Consumer Credit (G.19)*
–Finance Companies (G.20)
–Household Debt Service and Financial Obligations Ratios (FOR)

Industrial Activity
–Industrial Production and Capacity Utilization (G.17)*

Interest Rates
–Selected Interest Rates (H.15)

Money Stock and Reserve Balances
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Factors Affecting Reserve Balances (H.4.1)*

*Principal Economic Indicators

Data are current daily within 2 hours of release by the Federal Reserve Bank.
FRB_SR (data schema and structures) is the original work of, and is owned and copyrighted by the author.  Distribution and use of FRB_SR is under license; the author reserves all rights.  FRB_SR is expressly NOT in the public domain and remains the sole property of the copyright owner.  Distribution or modification of FRB_SR without the knowledge, review, and express permission of the copyright owner is strictly prohibited.  The Federal Reserve Bank statistical releases are public information.

Why pay for FREE DATA?! If you are a do-it-yourselfer or only need partial data, the data are freely available at the Federal Reserve Bank website.  The “Data Download” instructions are here.  Fee based custom development and support are available; please Contact Us.

Get It Now on Microsoft’s Azure DataMarket . . .

U.S. Bank Financial Condition and Performance Data Service

Edit:  Microsoft has discontinued the DataMarket program.  We are working to re-establish this service.

For Immediate Release 8:00 AM EST

10/17/2012

MacroTrenz Corp. Releases Its Latest Solution
U.S. Bank Financial Condition and Performance Data Service
On Microsoft’s Azure Data Marketplace

Jacksonville, FL — 10/17/2012 — MacroTrenz Corp. today announced the release of their U.S. Bank Financial Condition and Performance Data Service which returns, 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 Windows Azure platform, Microsoft’s cloud services platform, provides MacroTrenz Corp. with the ability to build, manage, and deploy cloud based applications.

“With persistent uncertainty and even crisis in world finance, safety and soundness in the banking industry is under intense scrutiny. Our U.S. Bank Financial Condition and Performance Data Service on Microsoft’s Azure Data Marketplace helps financial professionals get the detailed bank condition and performance information they require.” said Geary M. McIver, President of MacroTrenz Corp.

MacroTrenz Corp. automates critical data processes such as the U.S. Bank Financial
Condition and Performance Data Service which provides easy search and data 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.

MacroTrenz Corp. data consulting services:

  • SQL Server Database Audits

  • SQL Server Database Conversions and Migrations

  • SQL Server Database Tuning and Optimization

  • SQL Server Database Reporting, Business Intelligence, and Analytics

More services information is available at our website.

Providing quality, innovation, and reliability for 17 years, MacroTrenz Corp. specializes in helping customers use and manage data.

#########

Product or service names mentioned herein are the trademarks of their respective owners.

For more information, press only, please contact us.

Federal Reserve Bank Data Service Debut

Edit:  Microsoft has discontinued the DataMarket program.  We are working to re-establish this service.

For Immediate Release 12:22 PM EST

12/15/2011

MacroTrenz Corp. Releases Its Latest Solution
Federal Reserve Bank Statistical Data Solution
On Microsoft’s Azure Data Marketplace

Jacksonville, FL — 12/15/2011 — MacroTrenz Corp. today announced the debut of their Federal Reserve Bank Statistical Data service on Microsoft’s Azure Data Marketplace. The service helps enable customers to research and retrieve Federal Reserve Bank Statistics, Historical Data, Surveys, and Reports across the full set of over 100,000 “SERIES” reports and over 8.7 million data points. Such comprehensive functionality is provided by neither the Federal Reserve Bank nor other data services. The Windows Azure platform, Microsoft’s cloud services platform, provides MacroTrenz Corp. with the ability to build, manage, and deploy cloud based applications.

“In today’s world financial climate, easy and ready access to critical Federal Reserve Bank data is more important than ever. Our Federal Reserve Bank Statistical Data service on Microsoft’s Azure Data Marketplace provides insight and access to the Fed’s current monetary policy goals as reflected by it’s key statistical data.” said Geary M. McIver, President of MacroTrenz Corp.

MacroTrenz Corp. automates critical data processes such as Federal Reserve Bank Statistical Data which includes:

Bank Assets & Liabilities
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Assets and Liabilities of Commercial Banks in the U.S. (H.8)
–Charge-off and Delinquency Rates
–Senior Loan Officer Opinion Survey on Bank Lending Practices

Business Finance
–Commercial Paper
–Finance Companies (G.20)

Exchange Rates and International Data
–Foreign Exchange Rates (G.5 / H.10)

Flow of Funds Accounts
–Flow of Funds Accounts of the United States (Z.1)

Household Finance
–Consumer Credit (G.19)*
–Finance Companies (G.20)
–Household Debt Service and Financial Obligations Ratios (FOR)

Industrial Activity
–Industrial Production and Capacity Utilization (G.17)*

Interest Rates
–Selected Interest Rates (H.15)

Money Stock and Reserve Balances
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Factors Affecting Reserve Balances (H.4.1)*

Data are current daily within 1 hour of release by the Federal Reserve Bank.

MacroTrenz Corp. data consulting services:

  • SQL Server Database Audits

  • SQL Server Database Conversions and Migrations

  • SQL Server Database Tuning and Optimization

  • SQL Server Database Reporting, Business Intelligence, and Analytics

More services information is available at our website.

Providing quality, innovation, and reliability for 16 years, MacroTrenz Corp. specializes in helping customers use and manage data.

#########

Product or service names mentioned herein are the trademarks of their respective owners.

For more information, press only, please contact us.

Federal Reserve Bank Data

Federal Reserve Bank Statistical Data All in One Place!

Get It Now on Microsoft’s Azure DataMarket . . . Free Trial!

A great source of historical, research, and test data, the FRB_SR database consolidates the statistical releases published by the Federal Reserve Bank.  There are

  • 14 statistical releases
  • 39 Datasets
  • Over 15,000 Series
  • Over 8.7 million data points . . . going back to 31 Jan 1919!

No more manual downloads and processing XML files . . . FRB_SR is a fully functional database . . . the data are ready for use; the pic on this ad shows the data structure.

Includes:

Bank Assets & Liabilities
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Assets and Liabilities of Commercial Banks in the U.S. (H.8)
–Charge-off and Delinquency Rates
–Senior Loan Officer Opinion Survey on Bank Lending Practices

Business Finance
–Commercial Paper
–Finance Companies (G.20)

Exchange Rates and International Data
–Foreign Exchange Rates (G.5 / H.10)

Flow of Funds Accounts
–Flow of Funds Accounts of the United States (Z.1)

Household Finance
–Consumer Credit (G.19)*
–Finance Companies (G.20)
–Household Debt Service and Financial Obligations Ratios (FOR)

Industrial Activity
–Industrial Production and Capacity Utilization (G.17)*

Interest Rates
–Selected Interest Rates (H.15)

Money Stock and Reserve Balances
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Factors Affecting Reserve Balances (H.4.1)*
–Money Stock Measures (H.6)

*Principal Economic Indicators

Data are current daily normally within minutes of release by the Federal Reserve Bank.
FRB_SR (data schema and structures) is the original work of, and is owned and copyrighted by the author.  Distribution and use of FRB_SR is under license; the author reserves all rights.  FRB_SR is expressly NOT in the public domain and remains the sole property of the copyright owner.  Distribution or modification of FRB_SR without the knowledge, review, and express permission of the copyright owner is strictly prohibited.  The Federal Reserve Bank statistical releases are public information.

Why pay for FREE DATA?! If you are a do-it-yourselfer or only need partial data, the data are freely available at the Federal Reserve Bank website.  The “Data Download” instructions are here.  Fee based custom development and support are available; please Contact Us.

 

Get It Now on Microsoft’s Azure DataMarket . . . Free Trial!

 

 

Privacy Policy

Privacy Policy

What information do we collect?

We collect information from you when you register on our site, subscribe to our newsletter or respond to a survey.

When registering on our site, as appropriate, you may be asked to enter your: name, e-mail address, mailing address, phone number, or other information. You may, however, visit our site anonymously.

What do we use your information for?

Any of the information we collect from you may be used in one of the following ways:

• To personalize your experience
(your information helps us to better respond to your individual needs)

• To improve our website
(we continually strive to improve our website offerings based on the information and feedback we receive from you)

• To improve customer service
(your information helps us to more effectively respond to your customer service requests and support needs)

• To process transactions

Your information, whether public or private, will not be sold, exchanged, transferred, or given to any other company for any reason whatsoever, without your consent, other than for the express purpose of delivering the purchased product or service requested.

• To administer a contest, promotion, survey or other site feature

• To send periodic emails

The email address you provide may be used to send you information and updates pertaining to occasional company news, updates, related product or service information, etc.

Note: If at any time you would like to unsubscribe from receiving future emails, please login to your account to unsubscribe. .

How do we protect your information?

We implement measures to maintain your personal information.

Do we use cookies?

Yes. Cookies are small files that a site or its service provider transfers to your computers hard drive through your Web browser (if you allow) that enables the sites or service providers systems to recognize your browser and capture and remember certain information.

We use cookies to help us remember and process the items in shopping carts (if available), understand and save your preferences for future visits, keep track of advertisements and compile aggregate data about site traffic and site interaction so that we can offer better site experiences and tools in the future. We may contract with third-party service providers to assist us in better understanding our site visitors. These service providers are not permitted to use the information collected on our behalf except to help us conduct and improve our business.

If you prefer, you can choose to have your computer warn you each time a cookie is being sent, or you can choose to turn off all cookies via your browser settings. Like most websites, if you turn your cookies off, some of our services may not function properly.

Do we disclose any information to outside parties?

We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information. This does not include trusted third parties who assist us in operating our website, conducting our business, or servicing you. We may also release your information when we believe release is appropriate to comply with the law, enforce our site policies, or protect ours or others rights, property, or safety. However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.

Third party links

Occasionally, at our discretion, we may include or offer third party products or services on our website. These third party sites have separate and independent privacy policies. We therefore have no responsibility or liability for the content and activities of these linked sites. Nonetheless, we seek to protect the integrity of our site and welcome any feedback about these sites.

California Online Privacy Protection Act Compliance

Because we value your privacy we have taken the necessary precautions to be in compliance with the California Online Privacy Protection Act. We therefore will not distribute your personal information to outside parties without your consent.

As part of the California Online Privacy Protection Act, all users of our site may make any changes to their information at anytime by logging into their user account.

Childrens Online Privacy Protection Act Compliance

We are in compliance with the requirements of COPPA (Childrens Online Privacy Protection Act), we do not intend to collect any information from anyone under 13 years of age. Our website, products and services are all directed to people who are at least 13 years old or older.

Online Privacy Policy Only

This online privacy policy applies only to information collected through our website and not to information collected offline.

Terms and Conditions

Please also visit our Terms and Conditions section establishing the use, disclaimers, and limitations of liability governing the use of our website at http://MacroTrenz.com.

Your Consent

By using our site, you consent to our privacy policy.

Changes to our Privacy Policy

If we decide to change our privacy policy, we will post those changes on this page, send an email notifying you of any changes, and/or update the Privacy Policy modification date below.

This policy was last modified on 12 Oct 2017

 

 

 

 

 

 

 

 

MS Front Runner

For Release 7:22 PM EST

6/6/2011

MacroTrenz Corp. Becomes a “Front Runner” With the Release of Its Latest
Federal Reserve Bank Statistical Data Solution

Jacksonville, FL — 6/6/2011 — MacroTrenz Corp. today announced it will launch a new application using the Windows Azure Platform. Federal Reserve Bank Statistical Data in combination with the Windows Azure platform helps enable customers to research and retrieve Federal Reserve Bank Statistics, Historical Data, Surveys, and Reports across the full set of over 100,000 “SERIES” reports and over 8.7 million data points. Such comprehensive functionality is provided by neither the Federal Reserve Bank nor other data services. The Windows Azure platform, Microsoft’s cloud services platform, provides MacroTrenz Corp. with the ability to build, manage, and deploy cloud based applications.

“Thru the technical and marketing support provided by the Front Runner program, we are excited to see the innovative solutions built on the Windows Azure platform by the ISV community,” said Doug Hauger, general manager for Windows Azure Microsoft Corp. “The companies who choose to be a part of the Front Runner program show initiative and technological advancement in their respective industries.”

“Windows Azure platform provides greater choice, flexibility, and cost control in how we develop and deploy data-centric applications for our customers, both on-premises or in the cloud” said Geary M. McIver, President of MacroTrenz Corp.

MacroTrenz Corp. automates critical data processes such as Federal Reserve Bank Statistical Data which includes:

Bank Assets & Liabilities
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Assets and Liabilities of Commercial Banks in the U.S. (H.8)
–Charge-off and Delinquency Rates
–Senior Loan Officer Opinion Survey on Bank Lending Practices

Business Finance
–Commercial Paper
–Finance Companies (G.20)

Exchange Rates and International Data
–Foreign Exchange Rates (G.5 / H.10)

Flow of Funds Accounts
–Flow of Funds Accounts of the United States (Z.1)

Household Finance
–Consumer Credit (G.19)*
–Finance Companies (G.20)
–Household Debt Service and Financial Obligations Ratios (FOR)

Industrial Activity
–Industrial Production and Capacity Utilization (G.17)*

Interest Rates
–Selected Interest Rates (H.15)

Money Stock and Reserve Balances
–Aggregate Reserves of Depository Institution and the Monetary Base (H.3)
–Factors Affecting Reserve Balances (H.4.1)*

Data are current daily within 2 hours of release by the Federal Reserve Bank.

MacroTrenz Corp. data consulting services:

· SQL Server Database Audits

· SQL Server Database Conversions and Migrations

· SQL Server Database Tuning and Optimization

· SQL Server Database Reporting, Business Intelligence, and Analytics

More services information is available at our website.

Providing quality, innovation, and reliability for 16 years, MacroTrenz Corp. specializes in helping customers use and manage data.

#########

Product or service names mentioned herein are the trademarks of their respective owners.

For more information, press only, please contacts us.

U.S Bank Financial Condition and Performance Data Service


Your satisfaction is our number one priority.  Please contact us 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-2017, MacroTrenz Corp., All rights reserved.

Federal Reserve Bank Financial Data Service

Edit:  Microsoft has discontinued the DataMarket program.  We are working to re-establish this service.

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

Federal Reserve Bank Financial Data Service

Documentation

Contents

  1. Data Description
  2. Primary Entities
  3. Lookup Entities
  4. Entity Diagram

Data Description

The Federal Reserve Bank Financial Data Service is a concise and readily usable form of the Statistics, Historical Data, Surveys, and Reports published in flat file format by the U.S. Federal Reserve Bank.  The Federal Reserve Bank Financial Data Service provides data search and retrieval across the full set of over 100,000 “SERIES” reports and over 8.7 million data points. Such comprehensive functionality like this is not provided by the Federal Reserve Bank.

  • The hierarchy of the data has four levels.Statistical Release: Major divisions of financial and ecomomic information. | Data Sets: A grouping category wherein each Series uses the same attributes set. | Series: Equivalent to a “Report”, each with a unique set of values applied to the attributes. | Observations: “The Data” for a particular SERIES.
  • Each hierarchy level adds a respesentive key for that level.Statistical Release: respesentive key = SR_ID | Data Sets: respesentive key = DataSet_ID | Series: respesentive key = SERIES_ID | Observations: respesentive key = OBS_ID
  • Record sets at each level are identified by the parent keys in the hierarchy.Statistical Release: record set identifier = (N/A for this top level) | Data Sets: record set identifier = SR_ID | Series: record set identifier = SR_ID & DataSet_ID | Observations: record set identifier = SR_ID, DataSet_ID, & SERIES_ID
  • Unique records at each level are identified by ALL keys down through the hierarchy to that level.Statistical Release: unique record identifier = SR_ID | Data Sets: unique record identifier = SR_ID & DataSet_ID | Series: unique record identifier = SR_ID, DataSet_ID, & SERIES_ID | Observations: unique record identifier = SR_ID, DataSet_ID, SERIES_ID, & OBS_ID
  • Except for Series, there is only one OData Entity for each level. Due to the varying attribute sets among Series, the lookup table SERIES_ATTRIBUTES provides attribute details for a particular Series. The intended user interface is a drill down through the hierarchy to identify the key set SR_ID, DataSet_ID, & SERIES_ID to then query OBSERVATIONS for all observation rows for a SERIES. Users should be able to retrieve a unique record at any level in the hierarchy by also specifiying optional parameters for that entity. All result sets returned to the user should include all entity properties (columns).

Top

Primary Entities

  • [STATISTICAL_RELEASES]:

    Top level, lists details of each Statistical Release

    • Query Keys
      1. “SR_ID”, int, optional. . . noramlly not required, result set is small (12 rows currently)
    • Columns Returned . . .
      • SR_ID . . . key identifier
      • NAME
      • DESCRIPTION
      • DATE
    • Use . . . Primary purpose is to identify “SR_ID” for drilldown to DATASETS.
  • [DATASETS]:

    Second level, “label” for grouping SERIES having the same SERIES_ATTRIBUTES.

    • Query Keys
      1. “SR_ID”, int, optional . . . noramlly not required, result set is small (35 rows currently)
      2. “DataSet_ID”, int, optional . . . noramlly not required, result set is small (35 rows currently)
    • Columns Returned . . .
      • SR_ID . . . key identifier
      • DataSet_ID . . . key identifier
      • DATASET . . . identification abbreviation
      • DATASET_DESCRIPTION
      • SERIES_COUNT . . . number of series within the DATASET
    • Use . . . Primary purpose is to identify “SR_ID” and “DataSet_ID” for drilldown to SERIES. Take note of the SERIES_COUNT column.
  • [SERIES]:

    Third Level, lists details, e.g. SERIES_NAME, DESCRIPTION, etc.

    • Query Keys
      1. “SR_ID”, int, required.
      2. “DataSet_ID”, int, required.
      3. “SERIES_ID”, int, optional.
    • Columns Returned . . .
      • SR_ID . . . key identifier
      • DataSet_ID . . . key identifier
      • SERIES_ID . . . key identifier
      • DATASET . . . identification abbreviation
      • SERIES_NAME
      • DESCRIPTION
      • FREQUENCY . . . data observation frequency, e.g. daily, monthly, etc.
      • RECORD_COUNT . . . number of observations
    • Use . . . Primary purpose is to identify “SR_ID”, “DataSet_ID”, AND “SERIES_ID” for drilldown to OBSERVATIONS(the data).
  • [OBSERVATIONS]:

    Fourth Level, lists the actual data.

    • Query Keys
      1. “SR_ID”, int, required.
      2. “DataSet_ID”, int, required.
      3. “SERIES_ID”, int, required.
      4. “OBS_ID”, int, optional.
    • Columns Returned . . .
      • SR_ID . . . key identifier
      • DataSet_ID . . . key identifier
      • SERIES_ID . . . key identifier
      • OBS_ID . . . key identifier
      • OBS_STATUS . . . e.g. A (normal), NA (not available)
      • OBS_VALUE
      • TIME_PERIOD

      SR_ID, NAME, DESCRIPTION, DATE.

    • Use . . . pulls the actual data for a SERIES.

Top

Lookup Entities

  • [SERIES_ATTRIBUTES]:

    Third Level, lookup “Helper” table with SERIES specific attributes/value pairs.lists details, e.g. SERIES_NAME, DESCRIPTION, etc.

    • Query Keys
      1. “SR_ID”, int, required.
      2. “DataSet_ID”, int, required.
      3. “SERIES_ID”, int, required.
    • Columns Returned . . .
      • SR_ID . . . key identifier
      • DataSet_ID . . . key identifier
      • SERIES_ID . . . key identifier
      • ATTRIBUTE_ID . . . key identifer
      • ATTRIBUTE . . . e.g. UNIT_MULT
      • ATTRIBUTE_DESCRIPTION
      • ATTRIBUTE_VALUE . . . e.g. 1000000 (millions)
      • ATTRIBUTE_VALUE_DESCRIPTION
    • Use . . . Primary purpose is to identify a SERIES’ attributes, e.g. Series Name, Currency, Frequency code list, Loan type, etc.

Top

Entity Diagram

FRB_SR Entity Diagram

Top

Copyright © 2011-2017, MacroTrenz Corp., All rights reserved.