Skip to content

Treasury DataTapes Documentation

Sunnova Logo

Overview

Treasury DataTapes are standardized financial datasets designed to support Sunnova's treasury operations, financial reporting, and analytics. Each datatape provides a consistent, well-documented collection of financial data with clear column definitions, data lineage, and transformation logic.

Available DataTapes

We currently maintain 7 production datatapes, each serving specific treasury and financial analysis needs:

DataTape Description Total Columns Key Features Status Frequency Key Stakeholders
CONCORD Backup servicer report for systems managed by Concord 156 Customer details, Customer payment history tracking, Multi-system data integration (+ 4 modules) In Progress Weekly Treasury Reporting Team, Revenue Management (+ 1 more)
DEALER_TRANSACTIONS Partner and vendor payment processing 17 Dealer payment tracking, Transaction-level analysis, Payables/receivables management (+ 1 more) (+ 3 modules) Stable Adhoc Alvarez & Marsal
GREAT_AMERICA System and payment data for Great America portfolios 57 Equipment finance tracking, Lease portfolio analytics, Partnership data management (+ 1 modules) Stable Monthly Treasury Reporting Team
KLIM Essential loan information and customer demographics 75 Unified customer pipeline, Comprehensive loan tracking, Payment history analysis (+ 1 more) Stable Monthly Treasury Reporting Team, KLIM
SLA Solar Loan Asset (SLA) Facility systems and operational metrics 46 SLA performance tracking, Battery data integration, Operational metrics (+ 1 more) (+ 5 modules) Stable Weekly Treasury Team, Portfolio Management (+ 2 more)
TEP Tax Equity Partnerships datatape analytics 65 Tax equity analytics, NovaFDE framework, Treasury enhancement tracking (+ 1 more) (+ 1 modules) Ongoing Weekly Treasury Tranching Team, Tax Equity Partners (+ 1 more)
THEOREM Interest analysis and loan portfolio reporting 7 Interest calculation engine, Loan tape data processing, Payment tracking integration (+ 1 modules) Stable Monthly Treasury Reporting Team, Theorem

Key Benefits

  • Standardized Data Structure: Consistent column definitions and data types across all datatapes
  • Complete Documentation: Every column includes source table, description, and transformation details
  • Data Lineage Tracking: Clear visibility into how calculated fields are derived
  • Quality Assurance: Automated validation and profiling for each datatape
  • Version Control: All datatape configurations and SQL queries are version controlled

DataTape Architecture

Each datatape follows a standardized structure that ensures consistency and maintainability:

datatapes/[name]/
├── [name]_config.yaml          # Configuration and column definitions
├── run_[name].py              # Execution script
├── sql/                       # SQL query files
│   ├── query1.sql
│   └── query2.sql
├── completed_output/          # Generated datatape files
├── query_cache/              # Cached query results
└── logs/                     # Execution logs

Data Sources and Integration

Our datatapes integrate data from multiple enterprise systems:

  • Oracle Data Sources: Primary financial and operational databases
  • CSV Reference Files: Supporting data files for enrichment
  • Calculated Fields: Derived metrics and transformations
  • Data Quality Checks: Automated validation and profiling

Quick Start

  1. Explore Available DataTapes: Browse the DataTapes section to see available datasets
  2. Review Column Documentation: Each datatape page includes detailed column definitions
  3. Check Configuration: Review YAML configurations to understand data sources
  4. Run Generation: Use the provided runner scripts to generate datatapes

DataTape Categories

Core Financial DataTapes

  • Concord: Primary system for portfolio management and customer data
  • KLIM: Essential loan information and customer demographics

Operational DataTapes

  • Dealer Transactions: Partner and vendor payment processing
  • SLA: Service level agreement and operational metrics

Specialized DataTapes

  • Great America: Leasing and equipment finance data
  • TEP: Treasury enhancement program analytics

Documentation Features

Each datatape documentation includes:

  • Column Inventory: Complete list of all output columns
  • Source Mapping: Which database tables and fields feed each column
  • Calculated Fields: Logic for derived and computed columns
  • Data Transformations: Any data cleaning or formatting applied
  • SQL Queries: All source queries with parameter details
  • Configuration: Complete YAML configuration reference