> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Figure Loan Originations 🌱

### 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.                     |