maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per (period × close_step) exploding the close rollup into the controller's checklist: post_all_entries, trial_balance_ties, reconcile_bank, lock_period. `step_status` is done / pending / blocked, backed by the entry, trial-balance, and reconciliation counts.
What it means
Watch out for
- mediumReading trial_balance_ties without the period grain
`trial_balance_ties` is per period. The same flag repeats on every step row for that period — dedupe to one row per period before counting tied periods.
- mediumTreating step_status='pending' as failure
`pending` means the step is simply not yet done (e.g. no reconciliations opened). Only `blocked` signals an upstream condition is failing (drafts still open).
Questions this answers
- “Which periods still have draft entries blocking the close?”
- “Show the close checklist for FY2025-M12.”
Related metrics
- gl_balances_by_period
The trial-balance net behind the trial_balance_ties step.
19 of 19
Column
Type
Description
Tests · PII
period_id
UInt64
FK to the fiscal period. Part of the grain.
1 test
period_code
String
Period code (e.g. FY2025-M07).
fiscal_year
Int16
Fiscal year. Int16.
period_month
Int16
Calendar month 1..12. Int16.
period_month_start
Date
Month bucket — toStartOfMonth(period start).
period_status
String
Period close status — open / closed / locked.
period_closed_at
Nullable(DateTime64(6))
When the period was closed. Nullable.
step_order
Int16
1-based ordinal of the checklist step. Int16.
close_step
String
post_all_entries / trial_balance_ties / reconcile_bank / lock_period. Part of the grain.
2 tests
step_status
String
done / pending / blocked.
2 tests
posted_entries
UInt64
Count of posted journal entries in the period. UInt64.
draft_entries
UInt64
Count of draft journal entries (block the close). UInt64.
reversed_entries
UInt64
Count of reversed journal entries. UInt64.
total_entries
UInt64
Total journal entries in the period. UInt64.
reconciliations_total
UInt64
Bank reconciliations opened for the period. UInt64.
reconciliations_balanced
UInt64
Reconciliations in `balanced` status. UInt64.
reconciliations_closed
UInt64
Reconciliations in `closed` status. UInt64.
reconciliations_in_progress
UInt64
Reconciliations still `in_progress`. UInt64.
trial_balance_ties
UInt8
True when the period's posted trial balance nets to zero.