search

fishbaugher / WAweb-Issues

A repository to track issues with WAweb usage. This includes problems, work arounds, shortcuts, and workflow suggestions
0 stars 0 forks source link

Custom e-Tables (drop lists) (Measure Types, Cost Center Types, etc) #2

Open fishbaugher opened 8 months ago

fishbaugher commented 8 months ago

The desktop version of WA allowed states to modify all drop lists including measure types. If ORNL allows the drop lists to be edited, then the primary list of measure types could be expanded to include all the sub types since we maintained unique ID codes for all measure type and measure sub type selections in v8.11, the same applies to cost center type and sub type selectors. In ORNL language this would be "user editable e-table contents" (MJF)

Here are the custom 8.11 drop lists for cost center type and work order measure types. Both are cascading (new in 8.11 for MN) but 8.x has always allowed custom drop list contents via a backend table named tblzSelector which contains the drop list contents and identifiers for the entire user interface. Here are the screen shots of the cascading selectors in WA 8.11

Untitled Untitled 2 Untitled 3 Untitled 4

And here are the same selectors in WAweb.

Untitled5 Untitled6

Without the ability to characterize the cost center or work order measure grouping (type) in a systematic way, we would have to go back to relying on naming conventions for cost centers and measures which are problematic in practice.

fishbaugher commented 6 months ago

This is a feature in 8.12 not 8.6, so it is really a new feature only request.

fishbaugher commented 6 months ago

In the absence of cascading drop lists, I propose to standardize on the cost center naming convention as shown in the attached spreadsheet.

CostCenterNamingConvention.xls

This file also added to the top level path in this repository code.

eckmanwe commented 6 months ago

To clarify/restate. The request is to modify the current Cost Center Type enumeration nationwide based upon MN's implementation. [Please Confirm]

Similarly, the requested list is as follows [Please Confirm]:

US DOE State Utility Donated Other Federal Other funds included in grant budget Other funds not included in grant budget LIHEAP (see State/EAP) (inactive) Program Carryover (inactive) BIL Wx Readiness (WRF) EI WIRE SERC/WRAP SERC-2 CSPP ARRA (inactive) Other EAP/WX Program EAP/WX Carryover Healthy AIR State Propane Oil (inactive) EAP/WX ARPA (inactive) Other Healthy AIR CIP MERC (inactive) Other

fishbaugher commented 5 months ago

No, the request it to open up the e-tables for each state so they can create state specific super-set lists that comply with the national list, but allow for extension.

Funding sources and measure types are two of the things that seem to change each program year. Perhaps if those drop lists were kept current (yea hard)with new funding sources and measure rules, then there would be no need to create custom lists.

In MN for v8.12 we implemented nested two-level selectors for both cost centers and work order measure types. A fair bit of thinking went into the list and portions of that work might be applicable nationally.

But, for now, some way to expand the lists like available in 8.9 would be wonderful. In v8.9 the tblzSelector was stored in the backend MDB file, so the user could adjust the lists just by editing that one backend table...