Skip to content
ucdavisPublic

About

Warehouse Analytics and Ledger Tools for Enterprise Reporting

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

1,609 Commits

Folders and files

Repository files navigation

Walter

Warehouse Analytics and Ledger Tools for Enterprise Reporting

Overview

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.

Managing user roles

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.

Vacation accrual reporting

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.

Projection plans

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.

Getting Started (Web)

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.

Getting Started (Data Mart)

TBD

About

Warehouse Analytics and Ledger Tools for Enterprise Reporting

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Used by

Contributors

Languages