---
id: TST-PFM-OPS-011
title: Cross job query view
kind: unit
product_area: platform
module: operations
revision: 1
status: draft
source_sha:
  macroservice-libraries: 54536a441935c6e09fdb7f96f0bec71c52ba4e03
repository: macroservice-libraries
files:
  - packages/jobs/src/persistence/cross-job-query.view.spec.ts
implements: []
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 1
estimate_basis: Scheduling estimate only; no duration is measured during this documentation pass.
isolation: 'Process-local inputs, registries and test adapters.'
evidence:
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts at
    54536a441935c6e09fdb7f96f0bec71c52ba4e03: existing suite body, setup, assertions and cleanup.
binding_note: This existing engineering suite is registered without claiming a complete specification scenario.
assertion_sources:
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#selects from every
    registered root
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#joins the roots
    with UNION ALL
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#creates the view as
    security_invoker so each branch keeps its RLS
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#targets the
    qualified view name
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#emits no INSTEAD OF
    trigger, so the view stays read-only
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#emits no update
    rule, so the view stays read-only
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#gives each
    registered root one branch
  - >-
    macroservice-libraries:packages/jobs/src/persistence/cross-job-query.view.spec.ts#selects every
    common-contract column, in the same order, in every branch
---

# Cross job query view

## Verification Boundary

This suite exercises background work through its declared function or structural boundary. Its implementation is present at the pinned source revision, and this register records no execution result.

## What This Suite Proves

The checks exercise cross job query view within the file’s declared setup and assertion boundary. The structured assertion anchors distinguish these checks from the surrounding feature flows. No complete specification scenario is attributed to this suite yet.

## What It Does Not Prove

Local execution does not establish deployed infrastructure, live commercial-provider configuration or authorization-cache completion. Registration and an implemented suite do not establish a passing result.

## Real Dependencies and Test Doubles

The production logic under assertion is real. Inputs, registries or source files supply the declared test data; no live service workflow runs.

## Must Not Be Doubled

The production function, registry or builder under assertion remains real.