Documentation: paygo_snapshots_ts
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
| Row Name | Type | Example |
|---|---|---|
|
snapshot_date * Day for which the snapshot is calculated.
|
date |
2021-05-03 |
|
account_external_id * ID for the specific account (e.g. paygo loan) associated with the device.
|
string |
C11223344 |
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |
|
days_elapsed_installment_calculated Days elapsed since start of installment period. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
92 |
|
days_elapsed_payment_plan_source Days elapsed since loan start date. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
112 |
|
days_elapsed_payment_plan_calculated Days elapsed since loan start date. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
112 |
|
days_to_cutoff_source Days until system will switch off, -N if locked for N days. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
200 |
|
days_to_cutoff_calculated Days until system will switch off, -N if locked for N days. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
200 |
|
days_delays_cumulative_source Cumulative number of manual delay days applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
20 |
|
days_delays_cumulative_calculated Cumulative number of manual delay days applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
20 |
|
days_delays_daily_source Manual delay days applied, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.5 |
|
days_delays_daily_calculated Manual delay days applied, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.5 |
|
days_arrears_historical_source Cumulative historical days in arrears (cannot decrease). Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
55 |
|
days_arrears_historical_nf_calculated Cumulative historical days in arrears (cannot decrease), non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
55 |
|
days_arrears_historical_f_calculated Cumulative historical days in arrears (cannot decrease), forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
55 |
|
days_par_status_source days_arrears_consecutive_source grouped into ranges. |
string |
1-7 |
|
days_par_status_nf_calculated days_arrears_consecutive_nf grouped into ranges. |
string |
1-7 |
|
days_par_status_f_calculated days_arrears_consecutive_f grouped into ranges. |
string |
1-7 |
|
days_arrears_consecutive_source The count of consecutive days in arrears (credit from payments, discounts, delays < 0). Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
45 |
|
days_arrears_consecutive_nf_calculated The count of consecutive days in arrears (credit from payments, discounts, delays < 0), non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
45 |
|
days_arrears_consecutive_f_calculated The count of consecutive days in arrears (credit from payments, discounts, delays < 0), forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
45 |
|
days_arrears_cumulative_source Cumulative days late on repayment. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
54 |
|
days_arrears_cumulative_nf_calculated Cumulative days late on repayment, non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
54 |
|
days_arrears_cumulative_f_calculated Cumulative days late on repayment, forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
54 |
|
amt_arrears_consecutive_source Amount due from consecutive days late on repayment on a daily basis. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.0 |
|
amt_arrears_consecutive_nf_calculated Amount due from consecutive days late on repayment on a daily basis, non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.0 |
|
amt_arrears_consecutive_f_calculated Amount due from consecutive days late on repayment on a daily basis, forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.0 |
|
custom Saves additional imported data out of standard structure
|
jsonb |
{ "some": "key" } |
|
organization_id References Organization of data
|
integer |
1 |
|
source_id References Source of data
|
integer |
1 |
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
created_at Timestamp when row was inserted
|
datetime |
2021-05-03 6:23:55 |
|
repayment_rate_source Percentage of installments ever paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
repayment_rate_nf_calculated Percentage of installments ever paid, non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
repayment_rate_f_calculated Percentage of installments ever paid, forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_vs_plan_source Percentage of expected cumulative amount that is paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_vs_plan_calculated Percentage of expected cumulative amount that is paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_vs_financed_source Percentage of financed amount that is paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_vs_financed_calculated Percentage of financed amount that is paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_on_time_source Percentage of installments paid on time. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_on_time_nf_calculated Percentage of installments paid on time, non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_paid_on_time_f_calculated Percentage of installments paid on time, forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_elapsed_payment_plan_source Percentage of loan duration elapsed, independent of payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_elapsed_payment_plan_calculated Percentage of loan duration elapsed, independent of payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_elapsed_installments_source Percentage of installment period elapsed, independent of payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
percent_elapsed_installments_calculated Percentage of installment period elapsed, independent of payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12.5 |
|
num_expected_repayments_source The total number of repayments expected, taking into account add-ons and delays. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
20 |
|
num_expected_repayments_calculated The total number of repayments expected, taking into account add-ons and delays. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
20 |
|
days_expected_loan_duration_source Expected loan duration in days, adjusted for offer changes and add-ons, excluding delays. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
120.4 |
|
days_expected_loan_duration_calculated Expected loan duration in days, adjusted for offer changes and add-ons, excluding delays. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
120.4 |
|
days_elapsed_installment_source Days elapsed since start of installment period. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
92 |
|
amt_arrears_cumulative_source Cumulative amount due but not yet paid since installment start. Derived from repayment rate. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.5 |
|
amt_expected_payment_plan_cumulative_calculated Expected cumulative payments against receivable balance (principal + interest), net of refunds/reversals, excluding deposits. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_remaining_installment_source Difference between cumulative amount financed and cumulative amount paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_remaining_installment_calculated Difference between cumulative amount financed and cumulative amount paid. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_lump_sum_add_ons_source Cumulative amount of lump-sum add-ons sold with the contract. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_lump_sum_add_ons_calculated Cumulative amount of lump-sum add-ons sold with the contract. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_paid_deposits_cumulative_source Cumulative amount paid toward deposit, captures partial payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
200.0 |
|
amt_paid_deposits_cumulative_calculated Cumulative amount paid toward deposit, captures partial payments. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
200.0 |
|
amt_paid_installments_cumulative_source Cumulative amount paid on receivable balance (principal + interest), net of refunds/reversals. Includes pre-loan, arrears, and prepayments; excludes deposit. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1200.0 |
|
amt_paid_installments_cumulative_calculated Cumulative amount paid on receivable balance (principal + interest), net of refunds/reversals. Includes pre-loan, arrears, and prepayments; excludes deposit. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1200.0 |
|
amt_paid_payment_plan_cumulative_source Cumulative amount paid by customer (cash purchases, deposits, installments), net of refunds/reversals. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1400.0 |
|
amt_paid_payment_plan_cumulative_calculated Cumulative amount paid by customer (cash purchases, deposits, installments), net of refunds/reversals. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1400.0 |
|
amt_payments_daily_source Amount paid towards the account, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_payments_daily_calculated Amount paid towards the account, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_contract_value_without_discounts_source The total value of the contract without discounts given (i.e. expected amount repaid at the end of the contract). Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
20000.0 |
|
amt_contract_value_without_discounts_calculated The total value of the contract without discounts given (i.e. expected amount repaid at the end of the contract) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
20000.0 |
|
next_payment_due_at_source The time at which the next payment is due. |
datetime |
2021-05-03 0:00:00 |
|
next_payment_due_at_calculated The time at which the next payment is due. |
datetime |
2021-05-03 0:00:00 |
|
installment_period_source The corresponding installment period the snapshot_date belongs to. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
5 |
|
installment_period_calculated The corresponding installment period the snapshot_date belongs to. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
5 |
|
actual_maturity_date_source Actual contract end date, including offer changes, add-ons, delays, and payment lateness. |
date |
2021-05-03 |
|
actual_maturity_date_calculated Actual contract end date, including offer changes, add-ons, delays, and payment lateness. |
date |
2021-05-03 |
|
expected_maturity_date_source Expected contract end date, adjusted for offer changes and add-ons, excluding delays. |
date |
2021-05-03 |
|
expected_maturity_date_calculated Expected contract end date, adjusted for offer changes and add-ons, excluding delays. |
date |
2021-05-03 |
|
account_uid organization_id + data_origin + account_external_id
|
string |
1_crm_C11223344 |
|
amt_arrears_cumulative_nf_calculated Cumulative amount due but not yet paid since installment start, non-forgiving. Derived from repayment rate. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.5 |
|
amt_arrears_cumulative_f_calculated Cumulative amount due but not yet paid since installment start, forgiving. Derived from repayment rate Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12000.5 |
|
amt_credit_daily_source Credit given by amt_refunds_daily_source. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.5 |
|
amt_credit_daily_nf_calculated Credit given by amt_refunds_daily_calculated, non-forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.5 |
|
amt_credit_daily_f_calculated Credit given by amt_refunds_daily_calculated, forgiving. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
15.5 |
|
amt_refunds_cumulative_source Cumulative refund amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
20000.0 |
|
amt_refunds_cumulative_calculated Cumulative refund amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
20000.0 |
|
amt_refunds_daily_source Amount refunded from account, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
90.0 |
|
amt_refunds_daily_calculated Amount refunded from account, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
90.0 |
|
amt_penalties_cumulative_source Cumulative penalty amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
10000.0 |
|
amt_penalties_cumulative_calculated Cumulative penalty amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
10000.0 |
|
amt_penalties_daily_source Penalty amount applied, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_penalties_daily_calculated Penalty amount applied, on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_discounts_cumulative_source Cumulative discount amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_discounts_cumulative_calculated Cumulative discount amount applied. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_discounts_daily_source Discount amount applied on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_discounts_daily_calculated Discount amount applied on day of snapshot. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_expected_deposits_cumulative_source Cumulative expected deposits amount. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
200.0 |
|
amt_expected_deposits_cumulative_calculated Cumulative expected deposits amount. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
200.0 |
|
amt_expected_installments_cumulative_source Cumulative expected installment amount, given all payments on-time. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_expected_installments_cumulative_calculated Cumulative expected installment amount, given all payments on-time. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |
|
amt_expected_installments_daily_cumulative_source Expected installment amount, given all payments on-time, standardized over a day. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
13000.0 |
|
amt_expected_installments_daily_cumulative_calculated Expected installment amount, given all payments on-time, standardized over a day. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
13000.0 |
|
amt_expected_payment_plan_cumulative_source Expected cumulative payments against receivable balance (principal + interest), net of refunds/reversals, excluding deposits. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30000.0 |