BISS SOO Attachment B - Sample BISS Portfolio Data Sets.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Enterprise Test Data Management Federal contract opportunity
- Solicitation number
- CORHQ-24-R-0686
- Issued by
- Federal Deposit Insurance Corporation
About this file
This document is a spreadsheet attachment titled "Sample BISS Portfolio Data Sets" that provides detailed technical information about various data sources and systems used by the Federal Deposit Insurance Corporation (FDIC). The spreadsheet catalogs numerous data systems including their names, formats, sizes, update frequencies, and the ETL (Extract, Transform, Load) tools used to process them.
The document lists over 80 different data sets ranging from financial reporting systems like Large Insured Depository Institutions (LIDI) to administrative systems like the Vendor Time Reporting System (VTRS). Key technologies mentioned include Oracle databases, IBM DB2, SAP Data Services, Mulesoft, Azure Data Factory, and various ETL tools. Data sizes range from less than 1MB to several GB, with update frequencies varying from real-time to annual. This appears to be a technical reference document supporting the Enterprise Test Data Management solicitation (CORHQ-24-R-0686), which seeks vendors to provide test data management services with proposal submissions due January 13, 2025 (Phase 1) and January 31, 2025 (Phase 2).
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| CORHQ-24-R-0686 Amendment 0005.pdf | ||
| CORHQ-24-R-0686 Amendment 0004.pdf | ||
| Enterprise TDM Pricing Workbook Version 2.xlsx | XLSX spreadsheet | |
| CORHQ-24-R-0686 Amendment 0003.pdf | ||
| Summary of Changes Amendment 0003.pdf | ||
| CORHQ-24-R-0686 Amendment 0002.pdf | ||
| ETDM Live Session Presentation Slides.pdf | ||
| BISS SOO Attachment C 2027 Target State Architecture v1.1updated.pdf | ||
| BISS SOO Attachment C - 2027 Target State Architecture v1.1 updated.pdf | ||
| CORHQ-24-R-0686 Amendment 0001.pdf | ||
| Enterprise TDM Pricing Workbook.xlsx | XLSX spreadsheet | |
| CORHQ-24-R-0686.pdf | ||
| BISS SOO Attachment D - ETDM Accomplishments to Date.docx | DOCX document | |
| Questions and Answers Sheet.xlsx | XLSX spreadsheet | |
| BISS SOO Attachment A - Software Tools Inventory.xlsx | XLSX spreadsheet | |
| BISS SOO Attachment C - 2027 Target State Architecture v1.1.pdf |
Show all 16
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
BISS Data Sets
| Name | Short Name | List of S/W Tools Used | Data Set | Format (CSV/DB/etc) | Data Source | Size (MB) | Frequency | ETL Tool/Shell Script/Python/Mulesoft, etc |
| Large Insured Depository Institutions | LIDI | SAP Data Services |
Oracle SQL Server
| DB2 | RRPS - Risk Related Premium System | DB | DB2 | Daily during quarterly runs | SAP Data Services | |||
| National Information Center User Access data in CBIS | DB | DB2 | Daily during quarterly runs | SAP Data Services | ||||
| EDW - DSCRDM | DB | Oracle | Daily during quarterly runs | SAP Data Services | ||||
| EDW - CBIS_BASEL | DB | Oracle | Daily during quarterly runs | SAP Data Services | ||||
| EDW - VISION - VIS | DB | Oracle | Daily during quarterly runs | SAP Data Services | ||||
| OMWI Contractor Workforce Dashboard | OMWI CWD | SAP Data Services |
JSP, JavaScript, Java Tableau
| Oracle | EDW APS View | Database View | DOA | Small (< 10,000 rows) | Daily | SAP Data Services | |||
| Vendor Questionnaire | Database | User input into CWD website | Small | Ad-hoc | |||||
| Flexible Environment Project | Flex Environment | Y14A | XML | FRB | 30 files/3MB per day unless the FRB sends a baseline | Daily | BODS .NET Windows Scripting PL/SQL | ||
| Y14Q | XML | FRB | 67 files (70 starting 10/22)/20MB per day unless the FRB sends a baseline | Daily | BODS .NET Windows Scripting PL/SQL | ||||
| Volcker | CSV | FRB | 40 files/480MB per day | Daily | BODS .NET Windows Scripting PL/SQL | ||||
| SNL | txt inside Zip | SNL | 40 files/480MB per day | Daily | BODS. .NET Windows Scripting | ||||
| BBAPI | Pulled via Bloomber API | Bloomberg | Varies based on the Tickers and date range in the control file | Daily | BODS .NET Windows Scripting PL/SQL | ||||
| DRSK | txt inside GZ | Bloomberg | 2 Files. Daily-62MB, Weekly-2.6GB | Daily-T-F. Weekly-M | BODS .NET Windows Scripting PL/SQL | ||||
| CDS | xlsx | DTCC | Small Files | Only runs when customer provides a file to load | BODS | ||||
| SIRS | Pulled via Bloomber API | Bloomberg | 2 Files. Daily-62MB, Weekly-2.6GB | Whenever customer enters data into the control table M-F 05:30-20:00 | BODS .NET | ||||
| 2052A | CSV | FRB | 11 files/average 27MB per day unless the FRB sends a baseline | Daily | BODS. .NET Windows Scripting | ||||
| 2052B | Depricated | FRB | N/A | N/A | N/A | ||||
| Diversity and Inclusion Analytics Dashboard | DIADASHBOARD | SAP Data Services |
Microsoft Power BI
| Oracle | EDW PMD (Person Master Dimension) | Database View | CHRIS HR (DIA view) | Medium | Daily | SAP Data Services | |||
| Awards | CSV | CHRIS HR | Small | Yearly | SAP Data Services | ||||
| DOA Inclusion Index Survey Results | CSV | DOA | Small | Yearly | SAP Data Services | ||||
| Census.gov - Civilian Labor Force | CSV | Census.gov | Small | Decade | SAP Data Services | ||||
| EDW Personel Actions | Database View | CHRIS HR (DIA view) | Medium | Daily | SAP Data Services | ||||
| Dataset Catalog | DSC | DSCTLG | Oracle DB | Application User Interface | < .01 | Real Time |
Feeney, Patrick A. [CTR]: Feeney, Patrick A. [CTR]:
| 'Real Time' signifies that the data are processed once the user submits the data. | Oracle APEX | ||||||||
| DMCB Portal | DMCBPORTAL | DMCB_PORTAL | Oracle DB | Application User Interface | 0.1528930664 | Real Time | Oracle APEX | ||
| ETL Catalog | ETLCat | ETL_CATALOG | Oracle DB | IBM DS Repository | 27 | Daily, Weekly | Oracle APEX, IBM DS | ||
| Enterprise Data Management Portal | EDMPortal | EDWCOPS | Oracle DB | Application User Interface | 14.7 | Real Time, Daily | Oracle APEX | ||
| Vendor Time Reporting System | VTRS | VTRS | Oracle DB | Application User Interface | 0.1432495117 | Real Time | Oracle APEX | ||
| Person Master Dimension | PMD | EDWCNSMR, MDREF | Oracle DB | ARCS, CHRIS, GAL(AD) | 21.6 | Daily | IBM DS, PL SQL | ||
| Branch Location Assessment Maps | BLAM | ArcGIS | Census Data | U.S. Census | JavaScript | ||||
| Location Data | Oracle DB | SIMS/EDW | ArcGIS | ||||||
| Qualified Financial Contracts- DFA | QFCDFA | QFC decision data | CSV | Banks / Fin. Institutions | 8 Files - various sizes depending on bank | As Needed | GlobalScape, Python, Shell Scripts, Tableau | ||
| Enterprise Reference Data Repository | ERD | EDWCNSMR, MDREF | Oracle DB | ZIP, Census, Geo Names, CBIS | 21.6 |
Feeney, Patrick A. [CTR]: Feeney, Patrick A. [CTR]:
Notice: ERD and PMD use the same data sets, thus when calculating total size the total will actually be 21.6MB higher due to the fact that these data sets are in this list twice including their sizes.
Feeney, Patrick A. [CTR]: Feeney, Patrick A. [CTR]:
| 'Real Time' signifies that the data are processed once the user submits the data. | Static | Mulesoft, Java, PL SQL | |||||||
| Master Database List | MDBL | MDBL, MDBL2 | Oracle DB | OEM, SQL Server and IBM DB2 Sys Catalog | 9.6 | Daily | Oracle APEX | ||
| CIO Security Analytics Dashboard | CIOSA | ETL, Tableau, SharePoint | AoR/POA&M Control Chart | CSAM Dataset DFAODS schema, Lookup from EARep and NIST (Cyber Security Framework) | Daily | Tableau | |||
| AOR/POA&M Reporting | CSAM, Lookup from EARep and NIST (Cyber Security Framework) | Daily | Tableau | ||||||
| CSIS Departed Personnel Assets | Service Now and CHRISHR (EDW) | Daily | Tableau | ||||||
| FPG Dashboard | Excel | Excel, Python to extract to required format, SAP Data Services ETL into Oracle DB | Daily | Tableau | |||||
| IMS Dashboard | Budget Files on File Server. Asset Information extracted using REST API via SAP Data Services ETL into Oracle DB | Daily | Tableau | ||||||
| ITRGP - Federal Regulatory Tracking | SharePoint | ITRGP SharePoint OMB Tracking List | Daily | Tableau | |||||
| ITRGP - OIG GAO Audit Findings | SharePoint | ITRGP SharePoint Internal PCA List | Daily | Tableau | |||||
| New Hire Onboarding | Service Now and CHRISHR | Daily | Tableau | ||||||
| PVG Dashboard | Excel | Tenable (execution of Tenable batch API) CASM and POAM Tracker xls file from PVG group | Daily | Tableau | |||||
| Vulnerability Dashboard | Tenable (execution of Tenable batch API), BIG Fix, Satellite, Active Directory, Service Now extract through email | Daily | Tableau | ||||||
| SECPATCHMGMT Vulnerability Dashboard | Tenable (execution of Tenable batch API), BIG Fix, Satellite, Active Directory, Service Now extract through email | Daily | Tableau | ||||||
| ACP PIV Exceptions and Token Logins | AMAG team wrote PowerShell script for "FDIC PIV Exemptions OUs CleanUP Report" that's dropped daily on 83p file share | Daily | Tableau | ||||||
| ACP PIV Logical Access Dashboard | Receive PIV data source file from Splunk team via email, Active Directory | Daily | Tableau | ||||||
| ACP PIV Inventory Dashboard | CHRISHR (EDW), GSA File from DMB | Daily | Tableau | ||||||
| Enterprise Operational Data Store | ENTODS | ENTODS | Oracle DB | NFE | 36000 | Daily, Weekly | IBM DS, PL SQL | ||
| APEX Enterprise Catalog | AEC | AAUR | Oracle DB | Application User Interface, ServiceNow | 5.2 | Daily | Oracle APEX | ||
| Financial Company Master Dimension | FCMD | FCMD | Oracle DB | SIMS, CBIS BNK, PMD, ViSION | ERROR:#N/A | Daily | IBM DS | ||
| PRODUCTION DATA COPY | PDC | WAIVER | Oracle DB | Application User Interface | < .01 | Real Time | Oracle APEX | ||
| On-Call ID | ONCALLID | ONCALLID | Oracle DB | Application User Interface | < .01 | Real Time | Oracle APEX | ||
| Data Standards Glossary | DSG | GLOSSARY | Oracle DB | Application User Interface | < .01 | Real Time | Oracle APEX | ||
| Corporate Services Analytics | CSA | Tableau |
IBM DS
PL SQL
Mulesoft
| SAP Data Services | EDW - PMD | Oracle DB | ARCS, CHRIS, GAL(AD) | 21.6 | Daily | IBM DS, PL SQL, SAP Data Services | |||
| EDW - GSA | Oracle DB | GSA USAccess | Daily | IBM DS (?), QuerySIP | |||||
| EDW - ENS/Everbridge | Oracle DB | Everbridge | Daily | Mulesoft | |||||
| EDW - APS | Oracle DB | APS | 1.3 | Daily | IBM DS, PL SQL | ||||
| Enterprise Data Warehouse | EDW | APS | Oracle DB | APS | 1.3 | Daily | IBM DS, PL SQL | ||
| ASSETDM | Oracle DB | 4C | 934.9 | Daily | IBM DS, PL SQL | ||||
| ASTEPLGCY | Oracle DB | Historical Data Mart - no active source | 21.5 | Static | IBM DS | ||||
| CALL TFR IA | Oracle DB | Historical Data Mart - no active source | 0.2 | Static | IBM DS | ||||
| CBIS | Oracle DB | CBIS | 175.5 | Daily | IBM DS | ||||
| DITUTIL | Oracle DB | Manual Load & Update | 0.2 | Daily | PL/SQL | ||||
| DSCHRS | Oracle DB | DSCHRS | 23.6 | Daily | IBM DS | ||||
| DRRBOLD_CNSMR | Oracle DB | BOLD - Business Owned Application | < .01 | Daily | PL/SQL | ||||
| DSCRDM | Oracle DB | SIMS, CHRISHR, PMD | 8.3 | Daily | IBM DS | ||||
| DSCRDM_CONF | Oracle DB | SIMS, CHRISHR, PMD | 6.3 | Daily | IBM DS | ||||
| EDWSTG | Oracle DB | EDWSTG | 32.0 | Daily | IBM DS | ||||
| ETV | Oracle DB | Historical Data Mart - no active source | 5.9 | Static | IBM DS | ||||
| ETVPS | Oracle DB | Historical Data Mart - no active source | 7.4 | Static | IBM DS | ||||
| FDW | Oracle DB | Historical Data Mart - no active source | 570.4 | Static | IBM DS | ||||
| FMS_CNSMR | Oracle DB | FMS - Business Owned Application | < .01 | Daily | PL/SQL | ||||
| ICE_CNSMR | Oracle DB | ICE - Business Owned Application | < .01 | Daily | PL/SQL | ||||
| LIDI | Oracle DB | LIDI | 1.6 | Daily | IBM DS | ||||
| MONSTER | Oracle DB | monster.gov | ERROR:#N/A | Daily | IBM DS | ||||
| NESS | Oracle DB | NESS | 0.4 | Daily | IBM DS | ||||
| NFE EPM | Oracle DB | NFE | 624.4 | Daily | IBM DS | ||||
| NFE IODS | Oracle DB | NFE | 22.0 | Daily, Weekly | IBM DS | ||||
| PCAM | Oracle DB | PCAM | 1.1 | Daily, Weekly | IBM DS | ||||
| PDI | Oracle DB | Historical Data Mart - no active source | 0.3 | Static | IBM DS | ||||
| PEP_CNSMR | Oracle DB | PEP - Business Owned Application | < .01 | Daily | PL/SQL | ||||
| EDW | PREMISE_CNSMR | Oracle DB | PREMISE - Business Owned Application | < .01 | Daily | PL/SQL | |||
| RIS_BHCVIEW | Oracle DB | RIS_BHC | ERROR:#N/A | Quarterly | SAS, PL SQL | ||||
| RIS_MERGHIST | Oracle DB | RIS_MERGHIST | ERROR:#N/A | Quarterly | SAS, PL SQL | ||||
| RIS_RISVIEWX | Oracle DB | RIS | 171.3 | Quarterly | SAS, PL SQL | ||||
| RTS | Oracle DB | RTS | 0.3 | Static | IBM DS | ||||
| SIM | Oracle DB | SIMS | 5.7 | Daily | IBM DS | ||||
| SIS | Oracle DB | Historical Data Mart - no active source | 0.1 | Static | IBM DS | ||||
| SOD | Oracle DB | Summary of Deposits (SAS data set) | 8.0 | Annual | IBM DS | ||||
| SOD SL | Oracle DB | Historical Data Mart - no active source | 0.5 | Static | IBM DS | ||||
| SOURCE | Oracle DB | SOURCE | 1.6 | Daily | IBM DS | ||||
| VISION | Oracle DB | ViSION | 36.3 | Daily | IBM DS | ||||
| SRS | Oracle DB | SRS | 0.1 | Daily | IBM DS | ||||
| Enterprise Data Lake House | N/A | Azure Data Lake, Azure DataBricks | reference_data | Databricks Managed Tables | EDW | Daily | Azure Data Factory, Databricks Notebook | ||
| RIS | Databricks Managed Tables | EDW/Business Files | < 1 | Quarterly | Azure Data Factory, Databricks Notebook | ||||
| sod | Databricks Managed Tables | EDW | Quarterly | Azure Data Factory, Databricks Notebook | |||||
| FY Y14M | Databricks Managed Tables | Connect:Direct | Daily | Azure Data Factory, Databricks Notebook | |||||
| Moody's | Databricks Managed Tables | Internet API | Daily | Azure Data Factory, Databricks Notebook | |||||
| FR 2052A | Databricks Managed Tables | Connect:Direct | 11 files/average 27MB per day unless the FRB sends a baseline | Daily | Azure Data Factory, Databricks Notebook | ||||
| eCASE | Databricks Managed Tables | Vendor SQL Server | Daily | Azure Data Factory, Databricks Notebook | |||||
| LEI | Databricks Managed Tables | Internet API | Daily | Azure Data Factory, Databricks Notebook | |||||
| CoStar | Databricks Managed Tables | FTP Site | Daily | Azure Data Factory, Databricks Notebook | |||||
| FR Y-14Q | Databricks Managed Tables | Connect:Direct | 67 files (70 starting 10/22)/20MB per day unless the FRB sends a baseline | Daily | Azure Data Factory, Databricks Notebook | ||||
| Framework for Oversight of Compliance and CRA Activities User Suite | FOCUS | Appian, Mulesoft, IRI, Oracle, DB2, SQL Server | SIMS | Oracle | Data Hub | Daily | Mulesoft | ||
| CBIS | Oracle/DB2 | Data Hub/DB2 | Daily | Mulesoft | |||||
| CCD | clould.gov/MySQL | clould.gov/MySQL | Daily | Mulesoft | |||||
| RADD | SQL Server | RADD | Daily | Mulesoft | |||||
| ViSION | Oracle | Data Hub | Daily | Mulesoft | |||||
| DSC Hours | SQL Server | DSC Hours | Daily | Mulesoft | |||||
| DCP Hours/CHRIS HR | Oracle | Data Hub | Daily | Mulesoft | |||||
| Workforce Plus | Oracle | Data Hub | Daily | Mulesoft | |||||
| HMDA | web/csv | HMDA | Annually | Mulesoft | |||||
| SOD | csv | SOD | Annually | Mulesoft | |||||
| Census | web/csv | FFIEC, Census | Annually | Mulesoft | |||||
| Benchmark | Oracle | EDW | Quarterly | Mulesoft | |||||
| Third Party | Oracle | EDW | One-time | Mulesoft | |||||
| Supervision 360 | S360 | Appian, Mulesoft, IRI, Oracle, DB2, SQL Server | SIMS | Oracle | Data Hub | Mulesoft | |||
| DSC Hours | SQL Server | DSC Hours | Mulesoft | ||||||
| CHRIS HR | Oracle | Data Hub | Mulesoft | ||||||
| CBIS | Oracle/DB2 | Data Hub/DB2 | Mulesoft | ||||||
| RADD | SQL Server | RADD | Mulesoft | ||||||
| VISION | Oracle/DB2 | Data Hub/DB2 | Mulesoft | ||||||
| R3 | Oracle | Data Hub | Mulesoft | ||||||
| RRPS | DB2 | DB2 | Mulesoft | ||||||
| NESS | Oracle | Data Hub | Mulesoft |
&"Source Sans Pro SemiBold"&12&K000000 CONTROLLED//FDIC BUSINESS&1#_x000D_
File details come from the government source that posted it. Updated .