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