vidane
released this
2026-10-30 16:45:46 -04:00
| 0 commits to main since this release
- TBO investigation worksheet, in a popup. Each TBO row now has a Detail
icon that opens a second grid with the dates laid out side by side for that
member: the term date the TBO observed, the end date last supplied by the
agency, the end date last delivered to BCBSM on an 834, the last change feed
reported to the agent, the group's production go-live date, and your most
recent event note. Benefits Still Active, Recommended Action and
Next Steps come back blank on purpose — they are the cells you fill in as
you work the case. Sorting and the checkbox filters work in the popup as they
do in the main grid.
- A batch of worksheets at once. Tick several TBO rows and use the new
Show detail button: every selected TBO comes back in one popup, and the
lookup runs once however many rows you picked. If a TBO has already been
cleared or expired it simply returns no worksheet, and the popup says so
rather than showing an empty grid with no explanation. A failed lookup gets a
Try Again button, so you don't have to close the popup to retry.
- Copy a whole row in two clicks. In the worksheet popup, double-clicking a
row selects the entire row (the same block you get by dragging), and Ctrl+C —
or right-click → Copy — puts it on the clipboard as one tab-separated line,
blank where the grid shows —, so it pastes straight into Excel or a ticket.
Only the columns you can see are copied; the TBO id and type columns are
hidden by default here, since rows are already told apart by name and SSN.
- Double-click means different things in the two grids, deliberately. In the
TBO grid a double-click opens that row's worksheet — the same as its Detail
icon. It is ignored in the pinned columns, so it can never press Add Event,
Re-eval, Link or Detail twice by accident, and it never touches the row
checkboxes: a batch you have picked for re-evaluation stays picked. In the
popup grid, where the point is reading and copying, it selects the row.
- Full column names on hover. A truncated column header now shows its whole
name as a tooltip in every grid.
- Admins: one-time setup. The popup calls a new stored procedure,
analytics.BcnTboWorkflowHelper_Details, which must exist in En.Enrollment
(script at sql/analytics.BcnTboWorkflowHelper_Details.sql in the source
repo; needs database compatibility level 130 or higher for OPENJSON). The
TBO ids are sent to it as JSON text, so a very large id cannot be rounded on
the way to the database. Without the procedure the main grid is unaffected and
the popup just reports that the object is missing.
Downloads