Federal Borrowings Program: Interest on Uninvested Funds
A quarterly report containing interest balances associated with Treasury's Credit Reform: Interest Paid on Uninvested Funds account.
About This Dataset
Description:
The Federal Borrowings Program: Interest on Uninvested Funds dataset provides quarterly interest balances associated with the Department of the Treasury (Treasury) Credit Reform: Interest Paid on Uninvested Funds account. This data includes the amount of interest payable and interest expense by department.
| Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|
| Table Name | Description | Row Description | File Sizes | Row Count |
|---|
| Name | Definition |
|---|
Notes & Known Limitations
The Federal Borrowings Program facilitates loans to federal agencies on behalf of the Department of the Treasury. Because actual interest rates for the fiscal year aren't available until September, the interest payable and interest expense amounts on the Fiscal Quarters One (Q1) through Three (Q3) reports are estimates provided either by the agency or based on the previous fiscal year's interest collection. All interest collections are transacted at the end of September each fiscal year, so the interest payable for the Fourth Quarter (Q4) will be zero for all accounts and the interest expense column will reflect the actual amount of the interest collected for the fiscal year. Interest on Uninvested Funds account (020X1880) was established pursuant to the Federal Credit Reform Act of 1990, as amended (FCRA): 'Cash balances of the financing accounts in excess of current requirements shall be maintained in a form of uninvested funds and the Secretary of the Treasury shall pay interest on these funds.'
Beginning in fiscal year 2020, agencies are identified by the Department ID and Fund ID fields. In fiscal years 2018 and 2019, agencies are identified by the Treasury Account Symbol field. Prior to fiscal year 2018, agencies are identified by the Agency Name field.
Preview
API Quick Guide
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/https://api.fiscaldata.treasury.gov/services/api/fiscal_service/| Field Name | Display Name | Data Type |
|---|
- Parameter:
fields= - Definition: The fields parameter allows you to select which field(s) should be included in the response.
- Accepts: The
fields=parameter accepts a comma-separated list of field names (no parentheses). - Required: No, specifying fields is not required to make an API request.
- Default: If desired fields are not specified, all fields will be returned.
- Notes: When a field named passed to the
fields=parameter is not available for the endpoint accessed, an error will occur. Note that omitting fields can result in automatically aggregated and summed data results. For more information, view the full documentation on Aggregation and Sums.
?fields=- Parameter:
filter= - Definition: Filters are used to view a subset of the data based on specific criteria. For example, you may want to find data that falls within a certain date range, or only show records which contain a value larger than a certain threshold.
- Accepts: The filter parameter
filter=accepts filters from the list below, as well as specified filter criteria. Use a colon at the end of a filter parameter to pass a value or list of values. For lists passed as filter criteria, use a comma-separated list within parentheses. Filter for specific dates using the formatYYYY-MM-DD. - Required: No, filters are not required to make an API request.
- Default: When no filters are provided, the default response will return all fields and all data.
lt= Less thanlte= Less than or equal togt= Greater thangte= Greater than or equal toeq= Equal toin= Contained in a given set
?filter=undefined:eq:2020-05-31https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?filter=undefined:eq:2020-05-31- Parameter:
sort= - Definition: The sort parameter allows a user to sort a field in ascending (least to greatest) or descending (greatest to least) order.
- Accepts: The sort parameter
sort=accepts a comma-separated list of field names. - Required: No, sorting is not required to make an API request.
- Default: When no sort parameter is specified, the default is to sort by the first column listed. Most API endpoints are thus sorted by date in ascending order (historical to most current).
- Notes: You can nest sorting by passing the
sort=parameter a comma-separated list.
?sort=-undefinedhttps://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined- Parameter:
format= - Definition: The format parameter allows a user to define the output method of the response (CSV, JSON, XML).
- Accepts: The
format=parameter acceptsxml,json, orcsvas an input. - Required: No, the format parameter is not required to make an API request.
- Default: When no format is specified, the default response format is JSON.
?format=csv- Parameter:
page[size]=andpage[number]= - Definition: The page size will set the number of rows that are returned on a request, and page number will set the index for the pagination, starting at 1. This allows the user to paginate through the records returned from an API request.
- Accepts: The
page[number]=andpage[size]=parameters both accept integers. - Required: No, neither pagination parameters are required to make an API request.
- Default: When no page number or page size parameter is specified, the default response is
- Page number: 1
- Page size: 100
- Specifying the endpoint
- Requesting the JSON response format
- Sorting the data by
in descending order - Setting pagination parameters
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined&format=json&page[number]=1&page[size]=1Loading...For More API Information
- Aggregation and sums
- Pivoting
- Response codes
- Meta object
- ...and more!
