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 |