Documentation: paygo_accounts_snapshots_ts
Time Series data of events processed from meters_ts
To import data in this format you can use our API.
-> API Documentation
You can also supply us with files in xlsx, csv or json format.
-> Example CSV
type | p14n | blurred | autogenerated | required | |
---|---|---|---|---|---|
account_uid | string | ⤫ | ⤫ | ✓ | ⤫ |
organization_id + data_origin + account_external_id; FK to accounts table | |||||
snapshot_date | date | ⤫ | ⤫ | ⤫ | ✓ |
Date for which snapshot is calculated for. | |||||
account_status | enum: active, completed, defaulted, cancelled, locked, returned | ⤫ | ⤫ | ⤫ | ✓ |
active, completed, defaulted, cancelled, locked, returned | |||||
days_in_repayment | integer | ⤫ | ⤫ | ⤫ | ✓ |
When negative: Days until paygo period starts - account is in downpayment period. Then counts up from zero when paygo repayment period starts. | |||||
cumulative_paid_amount | float | ⤫ | ⤫ | ⤫ | ✓ |
The accumulated amount the customer paid to this snapshot date. | |||||
days_to_cutoff | integer | ⤫ | ⤫ | ⤫ | ✓ |
How many days until system will switch off. Negative if locked for N days. | |||||
cumulative_days_locked | integer | ⤫ | ⤫ | ⤫ | ✓ |
How many days system was off over its lifetime. | |||||
total_remaining_amount | float | ⤫ | ⤫ | ⤫ | ✓ |
How much money is left to payoff the system. | |||||
account_external_id | string | ⤫ | ⤫ | ⤫ | ✓ |
id for the specific account (e.g. paygo loan) associated with the shs device; FK to accounts table | |||||
created_at | datetime | ⤫ | ⤫ | ✓ | ⤫ |
Timestamp when row was inserted | |||||
updated_at | datetime | ⤫ | ⤫ | ✓ | ⤫ |
Timestamp when row was updated | |||||
source_id | integer | ⤫ | ⤫ | ✓ | ⤫ |
References Source of data | |||||
organization_id | integer | ⤫ | ⤫ | ✓ | ⤫ |
References Organization of data | |||||
custom | jsonb | ⤫ | ⤫ | ✓ | ⤫ |
Saves additional imported data out of standard structure | |||||
data_origin | string | ⤫ | ⤫ | ✓ | ⤫ |
Origin of the data, generic or name of the api | |||||
trust_score | float | ⤫ | ⤫ | ✓ | ⤫ |
calculated value how much we trust data |