Table Details
| Property | Value |
|---|---|
| Table Name | provenance.rwa.figure_loan_originations |
| Table Status | Beta 🌱 |
| Unique Key | scope_address |
| Clustering Key(s) | signed_at::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| scope_address | VARCHAR(16777216) | Bech32 loan scope identifier on Provenance. Unique and permanent. |
| signed_at | TIMESTAMP_NTZ(9) | Timestamp when the loan was signed (scope created event). |
| funded_at | TIMESTAMP_NTZ(9) | Timestamp when funding completed (first NAV set). NULL = still in rescission or unfunded. |
| days_to_funding | NUMBER(38,0) | Calendar days between signing and funding. Typically 3-7 days (rescission + ACH window). |
| initial_nav_usd | FLOAT | Funded loan amount in USD (first NAV value; denom “usd” = mils, divided by 1000). |
| latest_nav_usd | FLOAT | Most recent NAV in USD. Decreases as loan amortises or pays off. |
| latest_nav_at | TIMESTAMP_NTZ(9) | Timestamp of the most recent NAV event for this loan. |
| signing_tx | VARCHAR(16777216) | Transaction hash of the scope creation event. |
| funding_tx | VARCHAR(16777216) | Transaction hash of the first NAV event. |
| is_funded | BOOLEAN | TRUE if initial_nav_usd is set (funding completed). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |