Expand description
The ledger as the admin explorer and the reconciliation detectors read it, across courses.
Structs§
- Admin
Credit Registration - One ledger row as an admin sees it: every identifier support needs to answer “what happened to this student”, across courses.
- Admin
Credit Registration Filters - The narrowings the admin explorer applies, all of them in SQL.
- Admin
Registration Journey - What the student did and when, around one registration’s completion, for the admin timeline.
- Step
Count - Live rows of one module at one step, with one engagement where the step waits on the student.
Enums§
- Admin
Credit Registration Sort - How the explorer orders a page. Descending only: an ops table is read newest-worst first.
Functions§
- admin_
facing_ 🔒page - The query behind
get_admin_facing.total_countis computed before the limit, so every row of a page carries the count of the whole filtered ledger. - count_
by_ step_ and_ engagement - Live rows per module, step and engagement: the overview’s “Where registrations stand”, the Courses tab’s per-module table and the daily snapshot.
- get_
admin_ facing - A page of the ledger for the admin explorer, cross-course.
- get_
live_ by_ states - Live rows in each of the given states, newest activity first within each state, for the
Reconciliation lists.
limit_per_statecaps every state independently, viaROW_NUMBER, so one state with many rows cannot crowd another out of a sharedLIMIT. - get_
registration_ journey - The journey around
credit_registration_id’s completion.Nonefor no such live row. - sum_
step_ counts_ over_ modules count_by_step_and_engagement’s rows summed over modules, in timeline order.