Skip to content

PRIZM Query

PRIZM Query ("PQ") is a visual query-builder over the whole PRIZM data model — pick entities and columns from a checkbox tree, add filter conditions, execute, and read (or export) a tabular result. It's a self-service reporting tool, not a record editor: nothing you do in PQ writes back to a member, employer, jobsite, or contract record.

This is a SHARED page, not filed under one role, because the Roles & Security Matrix's "PRIZM QUERY" module is Visible for all 8 roles and its one sub-row, "Execute Queries," is View Only uniformly across all 8 too — there's no role-based variant of how this screen works. Whoever can see the sidebar link gets the identical query-builder, the identical read-only access to underlying data, and the identical set of schema gotchas documented here.

Goal What it's for
Build and run a PRIZM Query The query-builder mechanics: entities, columns, conditions, the UI-label-vs-real-field-id gotcha, and the correct way to export a result
Reuse a saved query Load query / Save query mechanics, and this repo's own folder of ready-made example queries
Understand fund-sharded entities Why a query built in one fund's context can silently return empty in another fund — and what actually fixes it
Troubleshoot a query that returns unexpected results Per-attribute operator gaps, data-population vs. stale-query confusion, export/performance limits, and the date-format quirk