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
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

You can also supply us with files in xlsx, csv or json format. -> Example CSV

	Required	Type	p14n	Blurred	Autogenerated
snapshot_date Date for which snapshot is calculated for.	✓	date	⤫	⤫	⤫
account_status active, completed, defaulted, cancelled, locked, returned	✓	enum: active, completed, defaulted, cancelled, locked, returned	⤫	⤫	⤫
days_in_repayment When negative: Days until paygo period starts - account is in downpayment period. Then counts up from zero when paygo repayment period starts.	✓	integer	⤫	⤫	⤫
cumulative_paid_amount The accumulated amount the customer paid to this snapshot date.	✓	float	⤫	⤫	⤫
days_to_cutoff How many days until system will switch off. Negative if locked for N days.	✓	integer	⤫	⤫	⤫
cumulative_days_locked How many days system was off over its lifetime.	✓	integer	⤫	⤫	⤫
total_remaining_amount How much money is left to payoff the system.	✓	float	⤫	⤫	⤫
account_external_id id for the specific account (e.g. paygo loan) associated with the shs device; FK to accounts table	✓	string	⤫	⤫	⤫
is_most_recent used in an DB index to identify most recent payment snapshots	✓	boolean	⤫	⤫	⤫
account_uid organization_id + data_origin + account_external_id; FK to accounts table	⤫	string	⤫	⤫	✓
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
organization_id References Organization of data	⤫	integer	⤫	⤫	✓
custom Saves additional imported data out of standard structure	⤫	jsonb	⤫	⤫	✓
data_origin Origin of the data, generic or name of the api	⤫	string	⤫	⤫	✓