Federal Borrowings Program: Interest on Uninvested Funds
Introduction
Preview
Dataset Properties
Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|---|---|---|---|---|
| Federal Borrowings Program: Interest on Uninvested Funds | record_date | Record Date | The date that data was published. | DATE | 1 |
| Federal Borrowings Program: Interest on Uninvested Funds | department_id | Department ID | The Department Identifier code associated with the borrowing account number. | STRING | |
| Federal Borrowings Program: Interest on Uninvested Funds | fund_id | Fund ID | The General Ledger borrowing account number. | STRING | |
| Federal Borrowings Program: Interest on Uninvested Funds | interest_payable_amt | Interest Payable Amount | The amount of interest owed by Treasury's Credit Reform: Interest Paid on Uninvested Funds (020X1880) account to borrowing accounts that fall under the Federal Credit Reform Act of 1990, as amended (FCRA) as of the last calendar day of the most recent quarter. The amounts for the first three quarters of the Fiscal Year are estimated while the amounts for the fourth quarter are zero as all of the interest is collected by September 30 each fiscal year. | CURRENCY | |
| Federal Borrowings Program: Interest on Uninvested Funds | interest_expense_amt | Interest Expense Amount | The amount of Treasury's Interest Expense for its Credit Reform: Interest Paid on Uninvested Funds (020X1880) account associated with borrowing accounts that fall under the Federal Credit Reform Act of 1990, as amended (FCRA) as of the last calendar day of the most recent quarter. The amounts for the first three quarters of the Fiscal Year are estimated while the amounts for the fourth quarter are actual as all of the interest is collected by September 30 each fiscal year. | CURRENCY |
| Table Name | Description | Row Description | 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. The Fund ID field values consist of the Department ID and the Main Account Code. The Department ID is the first two digits and the Main Account Code is the next four digits in the Fund ID. For example, the Fund ID of 20408899 has a Department ID of 20 and a Main Account Code of 4088. For more information regarding Department ID and Fund ID codes please visit the Federal Account Symbols and Titles Book and the [Expenditure/Receipt Account crosswalk document](https://www.treasurydirect.gov/govt/apps/tbp/Expenditure-Receipt Account Crosswalk.xlsx). Department ID is referred to as AID in the crosswalk document. 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.
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=- 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!
