Documentation des données
Trouvez ci-dessous une liste de nos tables de données.
Toutes les données importées seront soit directement importées, soit converties dans cette structure. Les données qui ne peuvent pas être directement mises en correspondance avec les colonnes existantes sont collectées dans la colonne json personnalisée.
Plus de documentation et d'informations pour les utilisateurs de Prospect peuvent être trouvées dans le
Wiki Prospect
| agents | All our Agents (Installers/Sales Agents) |
|---|---|
| customers | All our Customers |
| installations | All Installations of our devices. This could be an SHS, a grid, a meter, etc. |
| installations_ts | Time Series data of individual devices |
| paygo_snapshots_ts | Time series data containing daily snapshots of paygo-type accounts (e.g. Paygops, Angaza), containing both internally calculated and CRM-sourced fields. |
| paygo_source_snapshots_ts | Time series data containing daily paygo account snapshots as reported directly from CRM data sources (e.g. Paygops, Angaza). |
| payments_ts | Payment time series data for SHS Accounts or Meter Accounts |
| reports | This table saves data from Ascent reports submitted by PIUs for both connections and non-connections based metrics. It saves them in the same level of granularity as the submitted report, allowing for validation checks and data ingestion. |
| targets | This tables saves targets data for Ascent reports submitted by PIUs. It allows for tracking and validation of targets set for various metrics. |
| trust_trace | Trust Trace - the results of data validations and checks on subjects from other tables. Populated by data processors. |
| yearly_reports | This tables aggregates the data from the reports table into yearly summaries. It allows for simplification of queries on Grafana. |
| custom | This tables saves completely custom data as json. For easier export and graphing per source views with customizable structure are automatically created. |