screen_delinquency_drivers

SIGNAL, NOT A VERDICT. FIDC delinquency over a window, both metrics side by side: first vs last observation of delinquency in BRL (vl_inadimpl) and in percentage points of NAV, with the move classified by the two thresholds — consistent_worsening (value up AND rate up), value_up_rate_masked (value up, rate flat or down: NAV grew with it), denominator_only (rate up, value flat or down: NAV shrank, not new delinquency), improvement (both down), stable. Reads fact_fund_monthly, the series fund_nav and panel serve, so it can be reproduced from them. No sector, no debtor, no guarantee: a classification of two numbers, not a finding about the fund. Refuses a window starting before 2025-01 (FIDC delinquency regime break). stopped_reporting flags a last filing two or more months behind the window end; a fund that quit reporting does not read as clean. Defaults are the /fidc page’s (12 months, 6 observations, R$1mm, 1 p.p.). Every row carries screen and params. More than 1000 rows RAISES 22023 (never trimmed): pin p_driver.

Row cap. A window producing more than 1000 rows raises SQLSTATE 22023 naming this function. Nothing is trimmed to fit — PostgREST would silently cut the response at 1000 and a cut-short series is indistinguishable from one that simply ends. This function does not page — narrow the window instead.

POST /rpc/screen_delinquency_drivers

screen_delinquency_drivers

cURL

curl --request POST \
  --url https://zcjbtpxuhdekpwcxmepn.supabase.co/rest/v1/rpc/screen_delinquency_drivers \
  --header 'Content-Type: application/json' \
  --header 'apikey: <api-key>' \
  --data '
{
  "p_end": null,
  "p_months": 12,
  "p_min_months": 6,
  "p_min_delta_brl": 1000000,
  "p_min_delta_pp": 1,
  "p_driver": null
}
'

200

[
  {
    "cnpj": "<string>",
    "fund_name": "<string>",
    "status": "<string>",
    "window_from": "2023-12-25",
    "window_to": "2023-12-25",
    "n_months": 123,
    "months_missing": 123,
    "first_month": "2023-12-25",
    "last_month": "2023-12-25",
    "delinquency_start": 123,
    "delinquency_end": 123,
    "delta_brl": 123,
    "nav_start": 123,
    "nav_end": 123,
    "delta_nav": 123,
    "rate_start": 123,
    "rate_end": 123,
    "delta_pp": 123,
    "stopped_reporting": true,
    "driver": "<string>",
    "screen": "<string>",
    "params": {}
  }
]

Authorizations

apikey · string · header · required

The publishable key (sb_publishable_…), on every request. It is NOT a JWT — sending it as Authorization: Bearer is rejected as an invalid JWT. It identifies the project, not you, and maps to the Postgres anon role.

Body

application/json

p_end · string<date> | null

Defaults to NULL::date.

p_months · integer<int32> | null · default: 12

Defaults to 12.

p_min_months · integer<int32> | null · default: 6

Defaults to 6.

p_min_delta_brl · number | null · default: 1000000

Defaults to 1000000.

p_min_delta_pp · number | null · default: 1

Defaults to 1.0.

p_driver · enum<string> | null

Defaults to NULL::text.

Available options: consistent_worsening, value_up_rate_masked, denominator_only, improvement, stable

Response

200

application/json

The result set, oldest first. An unknown id is an empty array, not a 404 and never a guessed value.

cnpj · string | null

fund_name · string | null

status · string | null

window_from · string<date> | null

window_to · string<date> | null

n_months · integer<int64> | null

months_missing · integer<int32> | null

first_month · string<date> | null

last_month · string<date> | null

delinquency_start · number | null

delinquency_end · number | null

delta_brl · number | null

nav_start · number | null

nav_end · number | null

delta_nav · number | null

rate_start · number | null

rate_end · number | null

delta_pp · number | null

stopped_reporting · boolean | null

driver · string | null

screen · string | null

params · object | null