Warehouse Analytics and Ledger Tools for Enterprise Reporting
Walter includes:
datamart/: The data mart schema, scripts, and CI/CD pipelines.web/: The web application for data visualization and reporting.
Instructions for setting up and using each component are provided in their respective directories.
Open User Management from the Admin Dashboard. Search with at least three characters from a name, email, campus username, or IAM ID. Results are limited to 25 people; refine the query if needed. Select a person to view their roles, choose a role and select Add Role, or use the remove button beside an existing role.
See the admin eligibility, account linking, and refresh rules if a person is missing or a grant cannot resolve their account.
The department detail report includes two fields based on vacation usage history:
- Last Vacation is the latest reporting date with positive vacation usage across all available history through the employee's snapshot. It is not the actual day leave was taken. A later zero-usage report in the same month does not hide earlier usage.
- Projected, exported as Months to Cap, estimates time to the balance cap using the monthly accrual estimate minus average monthly usage. Usage includes signed corrections and totals all distinct reporting dates in each month, counting repeated position rows once per date. The average uses the six most recent observed months, including the current reporting month when available. Shorter histories use fewer months; missing months are not filled with zeros.
The monthly accrual estimate uses the latest positive period award, with the existing cap-tier fallback. See the accrual calculator for duplicate handling, fallback, and rounding rules. Notification projection and vacation-date fields use the same calculator.
From a person's Projects overview, open Projections and choose New plan. Work through Funding sources, Staffing, Other expenses, and Review, then choose Create plan to save the reviewed scenario and open its workspace. Canceling before submission leaves no saved plan. Workspace edits require Save plan; Apply accepts an editor's changes into the draft.
Open a saved plan from Your plans. Duplicate copies its saved version after pending changes are saved. Plan details contains the permanent Delete action, which requires confirmation. Scenario edits do not change upstream accounting. See the calculation reference for funding, salary, expense, and budget rules.
Open the /web directory in VSCode and choose "Reopen in Container" to set up the development environment.
From there, read the instructions in /web/README.md.
TBD