DFC Floating Rate File Specifications.docx
DOCX document 98 KB Posted
- Attached to
- Interest and Foreign Exchange Rate Data Services Federal contract opportunity
- Solicitation number
- REQ-851-20-0007
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| FAR Clauses for Commercial Items - SAP18DEC2019.pdf | ||
| Data Subscription Services SOW published.docx | DOCX document | |
| US International Development Finance Corporation RFQ.docx | DOCX document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
U.S. International Development Finance Corporation Floating Rates & Foreign Exchange File Specifications Version 1.0
U.S. International Development Finance Corporation
Floating Rates File Specifications
Version 1.0
June 2020 This file specification guide was produced to integrate Floating Rates & Treasury Foreign Exchange rates with DFC systems.
DOCUMENT CONTROL
DOCUMENT INFORMATION
| Title: |
| DFC Floating Rate and Treasury Foreign Exchange Rate File Specification |
| Revision: |
| Version 1.0 |
| Issue Date: |
| June 2020 |
| Filename: |
| DFC Floating Rate and Treasury Exchange Rate File Specification.doc |
DOCUMENT HISTORY
| Version Number |
| Date |
| Summary of Change |
| 1.0 |
| June 2020 |
| Initial Release |
PREFACE
This document provides File Specifications for integrating Floating rates and Treasury Foreign Exchange rates with DFC systems.
This document is to be used in coordination with other documentation including Technical Integration Design Documents.
CONTENTS
| DOCUMENT CONTROL | ii | |
| PREFACE | ii | |
| 1.0 | PURPOSE | 1 |
| 2.0 | FILE NAMING CONVENTION | 2 |
| 3.0 | FLOATING RATE FILE | 3 |
| Data Record Definition | 3 | |
| 3.1 Floating rate file Example: | 4 | |
| 3.1.1 Record Sample for Comma–Delimited File for Floating Rates | 4 | |
| 3.1.2 Record Sample for XML File Floating Rate File | 4 | |
| 4.0 | APPENDIX: Acronyms | 5 |
U.S. International Development Finance Corporation Floating Rates File Specifications Version 1.0
| June 2020 |
| iv |
PURPOSE
This document contains instructions for building CSV or XML files for Floating Rates and Treasury Foreign Exchange rates. The file formats are how Oracle EBS needs to consume the data. In the RFP, DFC is requesting a sample so that we can determine if the vendor can meet the needs that provided in this document.
FILE NAMING CONVENTION
Being able to identify any file transmission is an important consideration for DFC systems. The following is the naming convention for file transmission:
‘XXXXXYYYYMMDDHHMMSS’.ext
Where:
XXXXX: Five–character abbreviation for the Floating Rate file or Treasury file. Example: LIBOR, TREAS or similar five character code which identifies index/Treasury foreign exchange file uniquely.
YYYYMMDDHHMMSS: File Date: (YYYYMMDDHHMMSS) Example: 20200609180210 for date
9-JUN-2020 06:02:10 PM.
.ext: Three-character file extension identifying the file format as follows:
| .csv – comma–delimited format |
| .xml – XML format. |
FLOATING RATE FILE
This section describes the file specifications used to transmit information pertaining to the Floating Rates.
Data Record Definition Section 3.1.1 & 3.1.2 contains examples of data records.
Table 1: Floating Rate File Data Records
| Data Element Name |
| Type |
Format
| Definition / Comments |
| Permitted Values |
| Floating Rate Index Name |
| Character |
| Characters |
| Uniquely identifies the Index. (Ex: LIBOR,SOFR, etc.) |
| Alpha numeric |
Example “3-Month LIBOR USD’ or similar description which identifies each index uniquely.
| Rate Date |
| Date |
| YYYYMMDD |
| Specifies the date for the Index Rate. |
| Numbers. |
Example: 20200609 for date ‘09-JUN-2020’
| Rate |
| Numeric |
| Number with Decimals |
| Specifies the Index Rate for the Rate Date. |
| Numbers with decimal points example |
0.36925
| Currency |
| Character |
| Three-character currency code |
| The Floating Rate Currency for the Maturity |
| Three-character currency code Based on standards |
https://en.wikipedia.org/wiki/ISO_4217
| June 2020 |
| 10 |
3.1 Floating rate file Example:
3.1.1 Record Sample for Comma–Delimited File for Floating Rates The following text shows a portion of the data row:
Floating Rate Index Name, Rate, Rate Date, Currency 3-Month LIBOR based on U.S. Dollar, 0.36925,20200609,USD 3-Month LIBOR based on British Pound,0.23650,20200609,GBP
3.1.2 Record Sample for XML File Floating Rate File
The following text shows a portion of the data in xml:
<?xml version="1.0" encoding="UTF-8"?> <root> <row> <Floating Rate Index Name>3-Month LIBOR based on U.S. Dollar</Floating Rate Index Name> <Rate> 0.36925</Rate> <Rate Date>20200609</Rate Date> <Currency¶>USD¶</Currency¶> </row> <row> <Floating Rate Index Name>3-Month LIBOR based on British Pound</Floating Rate Index Name> <Rate>0.23650</Rate> <Rate Date>20200609</Rate Date> <Currency¶>GBP</Currency¶> </row> </root>
APPENDIX: Acronyms
| Acronym |
| Description |
| DFC |
| U.S. International Development Finance Corporation |
| XML |
| Extensible Markup Language |
| CSV |
| Comma-separated Values |
| June 2020 |
| 19 |
image1.png image2.jpeg image3.jpeg
File details come from the government source that posted it. Updated .