Raw tables
Every table in the database, introspected live — columns, types and references are read from the schema itself, so anything the schema gains appears here automatically. This is the escape hatch for edge cases; the normal workflow never sends you here. Back to the dashboard.
Writes here bypass the workflow checks and the friendly messages. Prefer the normal screens.
| # | initiative_id | contract_number | contract_start_date | contract_end_date | colloquial_name | total_award_amount |
|---|---|---|---|---|---|---|
| #1 | PROG — Program 1 | C-001 | Jan 1, 2025 | Dec 31, 2026 | Test | — |
empty
| # | award_id | tranche_number | label | start_date | end_date | amount |
|---|---|---|---|---|---|---|
| #1 | C-001 · Test · 2025-01-01→2026-12-31 1 | 1 | Y1 | Jan 1, 2025 | Dec 31, 2026 | 100,000.00 |
empty
empty
empty
| # | scenario_id | sink_id | tranche_id | spending_category_id | label | budget_amount |
|---|---|---|---|---|---|---|
| #1 | 1 1 | DRIVER — Driver [personnel] 1 | #1 Y1 $100000 1 | SALARY — Salary 4 | Driver salary | 28000 |
| #2 | 1 1 | DRIVER — Driver [personnel] 1 | #1 Y1 $100000 1 | FRINGE — Fringe benefits 5 | Driver fringe | 7000 |
| #3 | 1 1 | DRIVER — Driver [personnel] 1 | #1 Y1 $100000 1 | SALARY — Salary 4 | Driver 3 salary | 28000 |
empty
| # | code | name | scenario_type | initiative_id | award_id | parent_scenario_id |
|---|---|---|---|---|---|---|
| #1 | APP-1 | Approved Budget | approved | — | C-001 · Test · 2025-01-01→2026-12-31 1 | — |
| # | code | name | year_start_month | year_start_day | description |
|---|---|---|---|---|---|
| #1 | FY | FY | 1 | 1 | — |
empty
| # | code | name | sink_type | entity_id | description | is_active |
|---|---|---|---|---|---|---|
| #1 | DRIVER | Driver | personnel | — | — | 1 |
| # | code | name | fiscal_calendar_id | description |
|---|---|---|---|---|
| #1 | FD | Funder | FY — FY 1 | — |
| # | funding_source_id | code | name | description |
|---|---|---|---|---|
| #1 | Funder [FD] 1 | PROG | Program | — |
empty
| # | role_title | hire_date | termination_date | annual_salary | benefits_rate | notes |
|---|---|---|---|---|---|---|
| #1 | Driver | Jan 1, 2025 | — | 28,000.00 | 0.25 | — |
empty
empty
| # | parent_category | primary_cat | companion_cat | derivation | label | sort_order |
|---|---|---|---|---|---|---|
| #1 | PERSONNEL — Personnel 1 | SALARY — Salary 4 | FRINGE — Fringe benefits 5 | benefits_rate | Fringe is estimated as benefits_rate × salary | 0 |
| # | sink_id | tranche_id | allocation_amount | allocation_percent | start_date | end_date |
|---|---|---|---|---|---|---|
| #1 | DRIVER — Driver [personnel] 1 | #1 Y1 $100000 1 | — | 1 | Jan 1, 2025 | — |
empty
empty