Question numbers match their folders: folder 01 contains 01-01, 01-02 and so on. The starter dashboard uses 01-05, 01-08 and 01-02; process filter values come from 01-20. OBP identities and SQL filenames remain stable.
Use this selected map to choose a source table, inspect a proposed join or give an AI agent structural context. Start by defining what one result row should represent. The map contains no customer records and grants no access.
What is verified and what still needs checking
Seven source tables appear in the package’s saved SQL. Six supporting tables/views come from maintained analytics templates and remain extensions requiring target inspection. The formdata → form join is present in 05-01–05-02; other mapped relationships were not executed here as target-environment JOIN tests. Identity, types, uniqueness, missing-key rates and cardinality must be checked. This is not a complete database schema.
workorder
One record: One work order.
Evidence: Source used by package questions 01-01, 01-02, 01-03, 01-04, 01-05, 01-06, 01-07, 01-08, 01-09, 01-10, 01-11, 01-12, 06-02, 06-03, 02-12, 01-13, 01-14, 01-15, 01-16, 01-17, 01-18, 01-19, 01-20.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.workordernumber— Recorded work-order number for display and lookup. Field evidence: saved_sql_definition_read.sku— Recorded item/SKU identifier. Field evidence: saved_sql_definition_read.workflowname— Recorded workflow/process name; names are not version identifiers. Field evidence: saved_sql_definition_read.statustype— Technical work-order status code. Field evidence: saved_sql_definition_read.statusname— Display name of the work-order status. Field evidence: saved_sql_definition_read.createdat— Record creation timestamp. Unit: timestamp. Field evidence: saved_sql_definition_read.releasedat— Recorded work-order release timestamp. Unit: timestamp. Field evidence: saved_sql_definition_read.start— Recorded start timestamp for this table’s record. Unit: timestamp. Field evidence: saved_sql_definition_read.end— Recorded end timestamp; interpret it in the context of the table. Unit: timestamp. Field evidence: saved_sql_definition_read.expecteddate— Recorded order due timestamp. Unit: timestamp. Field evidence: saved_sql_definition_read.quantity— Recorded quantity; unit of measure depends on the item and context. Unit: item_dependent. Field evidence: saved_sql_definition_read.validquantity— Reported good quantity on the order. Unit: item_dependent. Field evidence: saved_sql_definition_read.invalidquantity— Reported rejected quantity on the order. Unit: item_dependent. Field evidence: saved_sql_definition_read.progress— Recorded progress value; do not assume a universal percentage scale. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
workflowsessionitem
One record: One workflow run on a unit, batch or quantity.
Evidence: Source used by package questions 02-01, 02-02, 02-03, 02-04, 02-05, 02-06, 02-07, 02-08, 02-09, 02-10, 02-11, 06-01, 02-13, 06-05, 02-14.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: saved_sql_definition_read.workorderid— Recorded internal work-order identifier. Field evidence: repository_documented_not_tenant_tested.workflowid— Recorded workflow-version identifier. Field evidence: repository_documented_not_tenant_tested.workflowname— Recorded workflow/process name; names are not version identifiers. Field evidence: saved_sql_definition_read.partsku— SKU recorded on a production run. Field evidence: saved_sql_definition_read.serials— Array of serial values; may be empty or contain several. Field evidence: repository_documented_not_tenant_tested.userid— Recorded user identifier; association depends on the record type. Field evidence: repository_documented_not_tenant_tested.status— Raw saved status code; its vocabulary depends on the table and process. Field evidence: saved_sql_definition_read.created— Record creation timestamp. Unit: timestamp. Field evidence: saved_sql_definition_read.start— Recorded start timestamp for this table’s record. Unit: timestamp. Field evidence: saved_sql_definition_read.end— Recorded end timestamp; interpret it in the context of the table. Unit: timestamp. Field evidence: saved_sql_definition_read.nettimespent— Recorded run net time, in seconds. Unit: seconds. Field evidence: saved_sql_definition_read.quantity— Recorded quantity; unit of measure depends on the item and context. Unit: item_dependent. Field evidence: saved_sql_definition_read.nextnodename— Next step name recorded on the run. Field evidence: saved_sql_definition_read.nextchaptername— Next chapter name recorded on the run. Field evidence: saved_sql_definition_read.progress— Recorded progress value; do not assume a universal percentage scale. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
stock
One record: One stock record, not necessarily one unit.
Evidence: Source used by package questions 03-01, 03-02, 03-03, 03-04, 03-05, 03-06, 03-07, 03-08, 03-09, 06-04.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.workflowsessionitemid— Recorded production-run identifier. Field evidence: saved_sql_definition_read.workordernumber— Recorded work-order number for display and lookup. Field evidence: saved_sql_definition_read.sku— Recorded item/SKU identifier. Field evidence: saved_sql_definition_read.serial— Recorded serial value; do not assume uniqueness without SKU and identity rules. Field evidence: saved_sql_definition_read.skurev— Item/product revision recorded on stock. Field evidence: saved_sql_definition_read.skudesc— Item description observed on stock records. Field evidence: saved_sql_definition_read.stockstatus— Recorded inventory status. Field evidence: saved_sql_definition_read.productionstatus— Recorded stock production status, separate from stock status. Field evidence: saved_sql_definition_read.quantity— Recorded quantity; unit of measure depends on the item and context. Unit: item_dependent. Field evidence: saved_sql_definition_read.availablequantity— Recorded available quantity; not a guarantee of order allocation. Unit: item_dependent. Field evidence: saved_sql_definition_read.kitstatus— Saved kit-complete flag; does not recalculate component coverage. Field evidence: saved_sql_definition_read.isserial— Saved serial-management flag. Field evidence: saved_sql_definition_read.created— Record creation timestamp. Unit: timestamp. Field evidence: saved_sql_definition_read.source— Recorded source/origin value. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
timelogreport
One record: One time report, possibly linked to several runs.
Evidence: Source used by package questions 04-01, 04-02, 04-03, 04-04, 04-05, 04-06, 04-07, 04-08, 04-09, 04-10, 06-06.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.workorderid— Recorded internal work-order identifier. Field evidence: repository_documented_not_tenant_tested.workordernumber— Recorded work-order number for display and lookup. Field evidence: saved_sql_definition_read.workflowid— Recorded workflow-version identifier. Field evidence: repository_documented_not_tenant_tested.userid— Recorded user identifier; association depends on the record type. Field evidence: repository_documented_not_tenant_tested.sessionids— Array of linked run identifiers; expanding it can duplicate report duration. Field evidence: saved_sql_definition_read.sku— Recorded item/SKU identifier. Field evidence: saved_sql_definition_read.chaptername— Chapter name stored on the time report. Field evidence: saved_sql_definition_read.start— Recorded start timestamp for this table’s record. Unit: timestamp. Field evidence: saved_sql_definition_read.end— Recorded end timestamp; interpret it in the context of the table. Unit: timestamp. Field evidence: saved_sql_definition_read.firstend— First stored end timestamp, used for the limited end-change comparison. Unit: timestamp. Field evidence: saved_sql_definition_read.duration— Stored time-report duration, in milliseconds. Unit: milliseconds. Field evidence: saved_sql_definition_read.recordtype— Stored report creation/record type. Field evidence: saved_sql_definition_read.type— Stored type or classification; use this table’s definition and vocabulary. Field evidence: saved_sql_definition_read.managerapprovalstatus— Saved manager-approval status. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
formdata
One record: One saved form record with any recorded context.
Evidence: Source used by package questions 05-01, 05-02.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.formid— Recorded form-definition identifier. Field evidence: saved_sql_definition_read.sessionid— Recorded run context on a form record; field name differs from stock. Field evidence: repository_documented_not_tenant_tested.workorderid— Recorded internal work-order identifier. Field evidence: repository_documented_not_tenant_tested.workordernumber— Recorded work-order number for display and lookup. Field evidence: repository_documented_not_tenant_tested.stringnumber— Display number of the saved form record. Field evidence: repository_documented_not_tenant_tested.status— Raw saved status code; its vocabulary depends on the table and process. Field evidence: saved_sql_definition_read.created— Record creation timestamp. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
form
One record: One form-type definition.
Evidence: Source used by package questions 05-01, 05-02.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: saved_sql_definition_read.name— Definition/display name, not a guaranteed unique identity. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.
workflow
One record: One version of a workflow definition.
Evidence: Source used by package questions 05-03, 05-04.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.recordid— Documented cross-version workflow identity; verify in the target environment. Field evidence: repository_documented_not_tenant_tested.name— Definition/display name, not a guaranteed unique identity. Field evidence: saved_sql_definition_read.normalizedversion— Stored normalized workflow version number. Field evidence: saved_sql_definition_read.currentreleasedversion— Flag marking a currently released workflow version. Field evidence: saved_sql_definition_read.latestversion— Flag marking the latest version; latest need not be released. Field evidence: saved_sql_definition_read.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: saved_sql_definition_read.
usermodel
One record: One user record.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.displayname— Recorded user display name. Field evidence: repository_documented_not_tenant_tested.username— Recorded username. Field evidence: repository_documented_not_tenant_tested.
workflowsessionitemrecord
One record: One run event/record, not necessarily an execution signature.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.workflowsessionitemid— Recorded production-run identifier. Field evidence: repository_documented_not_tenant_tested.nodeid— Recorded workflow-step/node identifier. Field evidence: repository_documented_not_tenant_tested.originalnodeid— Original step/node identifier used by documented templates; verify the target type and matching rule. Field evidence: repository_documented_not_tenant_tested.userid— Recorded user identifier; association depends on the record type. Field evidence: repository_documented_not_tenant_tested.start— Recorded start timestamp for this table’s record. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.end— Recorded end timestamp; interpret it in the context of the table. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.
sessioncustomfieldview
One record: One saved field value with run and time context.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
workflowsessionitemid— Recorded production-run identifier. Field evidence: repository_documented_not_tenant_tested.fieldid— Recorded field-definition identifier. Field evidence: repository_documented_not_tenant_tested.date— Timestamp associated with the saved field value. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.nodeid— Recorded workflow-step/node identifier. Field evidence: repository_documented_not_tenant_tested.originalnodeid— Original step/node identifier used by documented templates; verify the target type and matching rule. Field evidence: repository_documented_not_tenant_tested.sessionnodeid— Run-specific node identifier; do not substitute a workflow-definition node ID. Field evidence: repository_documented_not_tenant_tested.userid— Recorded user identifier; association depends on the record type. Field evidence: repository_documented_not_tenant_tested.valuestring— Stored text value. Field evidence: repository_documented_not_tenant_tested.valuenumber— Stored numeric value; measurement meaning and unit depend on the field. Unit: field_dependent. Field evidence: repository_documented_not_tenant_tested.valueboolean— Stored Boolean value. Field evidence: repository_documented_not_tenant_tested.valuedate— Stored date value. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.
field
One record: One field definition.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
_id— Internal record identifier; inspect its exposed type and uniqueness. Field evidence: repository_documented_not_tenant_tested.title— Recorded field title. Field evidence: repository_documented_not_tenant_tested.type— Stored type or classification; use this table’s definition and vocabulary. Field evidence: repository_documented_not_tenant_tested.subtype— Recorded field subtype. Field evidence: repository_documented_not_tenant_tested.min— Configured input minimum; not automatically a quality specification limit. Unit: field_dependent. Field evidence: repository_documented_not_tenant_tested.max— Configured input maximum; not automatically a quality specification limit. Unit: field_dependent. Field evidence: repository_documented_not_tenant_tested.
stockitemview
One record: One component row linked to a parent stock record.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
stockid— Recorded parent-stock identifier. Field evidence: repository_documented_not_tenant_tested.sku— Recorded item/SKU identifier. Field evidence: repository_documented_not_tenant_tested.serial— Recorded serial value; do not assume uniqueness without SKU and identity rules. Field evidence: repository_documented_not_tenant_tested.quantity— Recorded quantity; unit of measure depends on the item and context. Unit: item_dependent. Field evidence: repository_documented_not_tenant_tested.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.
workorderkititemview
One record: One required kit-component row for an order.
Evidence: Supporting extension from documented templates; not verified as a package source in this environment.
workorderid— Recorded internal work-order identifier. Field evidence: repository_documented_not_tenant_tested.sku— Recorded item/SKU identifier. Field evidence: repository_documented_not_tenant_tested.rev— Recorded component/item revision. Field evidence: repository_documented_not_tenant_tested.quantity— Recorded quantity; unit of measure depends on the item and context. Unit: item_dependent. Field evidence: repository_documented_not_tenant_tested.issuedquantity— Recorded issued component quantity; compare using compatible units. Unit: item_dependent. Field evidence: repository_documented_not_tenant_tested.deletedat— Soft-delete marker; active facts are normally selected with IS NULL. Unit: timestamp. Field evidence: repository_documented_not_tenant_tested.
Candidate relationships
The following directions and expected multiplicities are documentation hypotheses, not enforced or measured foreign keys. Join using compatible internal identifiers and retain unmatched facts when required by the report.
workflowsessionitem.workorderid→workorder._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.stock.workflowsessionitemid→workflowsessionitem._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.workflowsessionitem.workflowid→workflow._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.timelogreport.workorderid→workorder._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.timelogreport.userid→usermodel._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.timelogreport.workflowid→workflow._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.timelogreport.sessionids[]→workflowsessionitem._id. Expected: array_many_to_many. Measured: no. Evidence: repository_documented_not_tenant_tested.formdata.formid→form._id. Expected: many_to_optional_one. Measured: no. Evidence: saved_sql_join_read.formdata.sessionid→workflowsessionitem._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.formdata.workorderid→workorder._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.workflowsessionitemrecord.workflowsessionitemid→workflowsessionitem._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.sessioncustomfieldview.workflowsessionitemid→workflowsessionitem._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.sessioncustomfieldview.fieldid→field._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.stockitemview.stockid→stock._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.workorderkititemview.workorderid→workorder._id. Expected: many_to_optional_one. Measured: no. Evidence: repository_documented_not_tenant_tested.
Rules before joining
Confirm the authorized database and schema before querying. This file grants no access or write permission.
Resolve table and field availability/types with focused inspection; null data_type means unknown, not varchar.
Read the matching saved SQL and its filters; never infer the metric solely from its name.
Treat identity_candidate and expected_cardinality as hypotheses to validate, not enforced database constraints.
Filter soft-deleted facts with deletedat IS NULL. Place dimension soft-delete filters in LEFT JOIN ON when preserving unmatched facts; keep the original 05-01–05-02 behavior when reproducing it.
Prefer internal IDs to names or business numbers. Do not invent an ID relationship from a similarly named field.
Do not assume stock-to-session is one-to-one. Measure multiplicity and unmatched keys before joining.
Never sum timer duration after expanding sessionids without an explicit allocation rule. Summed timer hours are not attendance.
Do not inner-join historical facts to version definitions unless the requested population explicitly requires a matching definition.
Use workflow._id for one version; workflow.recordid is a documented cross-version identity requiring target verification. Names are display labels.
Do not infer pass/fail tolerances from field.min/max; these are input limits. Tenant field vocabulary and measurement units require discovery.
Do not interpret event records as execution signatures or start/end differences as actual labour without event classification.
Use read-only SELECT for diagnostics; validate totals, missing keys and row counts before and after joins. New examples in this map were not executed.
Do not carry tenant values, record contents, identifiers or credentials into reusable documentation or another environment.
Order quantity can be repeated by a join to multiple reports; aggregate the reports to order grain first. Do not expand sessionids and then sum full timer durations without an allocation rule. A matching stock/run ID is not automatically a one-to-one relationship. Keep the original 05-01–05-02 soft-delete behavior when reproducing their results.
Read-only diagnostic examples
These SELECT examples were not executed in the target environment. Replace {{schema}}, inspect available types and run one statement at a time. The hours example preserves the package’s greater-than-zero and up-to 12-hour duration rule.
-- Check stock-to-run link coverage
-- Documentation example; not executed in target environment.
WITH active_sessions AS (
SELECT _id
FROM {{schema}}.workflowsessionitem
WHERE deletedat IS NULL
GROUP BY _id
)
SELECT
count(*) AS stock_rows,
count_if(st.workflowsessionitemid IS NULL) AS no_session_id,
count_if(st.workflowsessionitemid IS NOT NULL AND s._id IS NULL) AS missing_active_session,
count_if(s._id IS NOT NULL) AS matched_active_session
FROM {{schema}}.stock st
LEFT JOIN active_sessions s ON s._id=st.workflowsessionitemid
WHERE st.deletedat IS NULL;
-- Check multiple stock records for a run
-- Documentation example; not executed in target environment.
SELECT workflowsessionitemid, count(*) AS stock_rows
FROM {{schema}}.stock
WHERE deletedat IS NULL
AND workflowsessionitemid IS NOT NULL
GROUP BY workflowsessionitemid
HAVING count(*) > 1
ORDER BY stock_rows DESC
LIMIT 20;
-- Aggregate reported hours before joining work-order quantities
-- Documentation example; not executed in target environment.
WITH hours_per_order AS (
SELECT workorderid, count(*) AS reports,
sum(duration)/3600000.0 AS reported_hours
FROM {{schema}}.timelogreport
WHERE deletedat IS NULL
AND "end" IS NOT NULL
AND duration > 0 AND duration <= 43200000
GROUP BY workorderid
)
SELECT wo._id, wo.workordernumber, wo.quantity,
h.reports, h.reported_hours
FROM {{schema}}.workorder wo
LEFT JOIN hours_per_order h ON h.workorderid=wo._id
WHERE wo.deletedat IS NULL;
Organization-specific views
Form views follow the documented formdataview-<form._id> shape; organization-specific table views use tableview-<table._id>. Names and exposed columns vary. Inspect the exact form/table definition and view. Do not assume a broad information_schema search will list every view.
Copyable context for an AI agent
Supply the question you want to answer, the intended row grain and the authorized schema along with this structure. Validate unverified fields and joins before running a query. Do not include credentials, customer record values or another organization’s data.
{
"dialect": "Trino",
"schema_placeholder": "{{schema}}",
"contains_customer_data": false,
"tables": [
{
"name": "workorder",
"grain": "One work order",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workordernumber",
"meaning": "Recorded work-order number for display and lookup.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "sku",
"meaning": "Recorded item/SKU identifier.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "workflowname",
"meaning": "Recorded workflow/process name; names are not version identifiers.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "statustype",
"meaning": "Technical work-order status code.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "statusname",
"meaning": "Display name of the work-order status.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "createdat",
"meaning": "Record creation timestamp.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "releasedat",
"meaning": "Recorded work-order release timestamp.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "start",
"meaning": "Recorded start timestamp for this table’s record.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "end",
"meaning": "Recorded end timestamp; interpret it in the context of the table.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "expecteddate",
"meaning": "Recorded order due timestamp.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "quantity",
"meaning": "Recorded quantity; unit of measure depends on the item and context.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "validquantity",
"meaning": "Reported good quantity on the order.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "invalidquantity",
"meaning": "Reported rejected quantity on the order.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "progress",
"meaning": "Recorded progress value; do not assume a universal percentage scale.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "workflowsessionitem",
"grain": "One workflow run on a unit, batch or quantity",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "workorderid",
"meaning": "Recorded internal work-order identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workflowid",
"meaning": "Recorded workflow-version identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workflowname",
"meaning": "Recorded workflow/process name; names are not version identifiers.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "partsku",
"meaning": "SKU recorded on a production run.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "serials",
"meaning": "Array of serial values; may be empty or contain several.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "userid",
"meaning": "Recorded user identifier; association depends on the record type.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "status",
"meaning": "Raw saved status code; its vocabulary depends on the table and process.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "created",
"meaning": "Record creation timestamp.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "start",
"meaning": "Recorded start timestamp for this table’s record.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "end",
"meaning": "Recorded end timestamp; interpret it in the context of the table.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "nettimespent",
"meaning": "Recorded run net time, in seconds.",
"unit": "seconds",
"evidence": "saved_sql_definition_read"
},
{
"name": "quantity",
"meaning": "Recorded quantity; unit of measure depends on the item and context.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "nextnodename",
"meaning": "Next step name recorded on the run.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "nextchaptername",
"meaning": "Next chapter name recorded on the run.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "progress",
"meaning": "Recorded progress value; do not assume a universal percentage scale.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "stock",
"grain": "One stock record, not necessarily one unit",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workflowsessionitemid",
"meaning": "Recorded production-run identifier.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "workordernumber",
"meaning": "Recorded work-order number for display and lookup.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "sku",
"meaning": "Recorded item/SKU identifier.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "serial",
"meaning": "Recorded serial value; do not assume uniqueness without SKU and identity rules.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "skurev",
"meaning": "Item/product revision recorded on stock.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "skudesc",
"meaning": "Item description observed on stock records.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "stockstatus",
"meaning": "Recorded inventory status.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "productionstatus",
"meaning": "Recorded stock production status, separate from stock status.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "quantity",
"meaning": "Recorded quantity; unit of measure depends on the item and context.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "availablequantity",
"meaning": "Recorded available quantity; not a guarantee of order allocation.",
"unit": "item_dependent",
"evidence": "saved_sql_definition_read"
},
{
"name": "kitstatus",
"meaning": "Saved kit-complete flag; does not recalculate component coverage.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "isserial",
"meaning": "Saved serial-management flag.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "created",
"meaning": "Record creation timestamp.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "source",
"meaning": "Recorded source/origin value.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "timelogreport",
"grain": "One time report, possibly linked to several runs",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workorderid",
"meaning": "Recorded internal work-order identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workordernumber",
"meaning": "Recorded work-order number for display and lookup.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "workflowid",
"meaning": "Recorded workflow-version identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "userid",
"meaning": "Recorded user identifier; association depends on the record type.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "sessionids",
"meaning": "Array of linked run identifiers; expanding it can duplicate report duration.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "sku",
"meaning": "Recorded item/SKU identifier.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "chaptername",
"meaning": "Chapter name stored on the time report.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "start",
"meaning": "Recorded start timestamp for this table’s record.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "end",
"meaning": "Recorded end timestamp; interpret it in the context of the table.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "firstend",
"meaning": "First stored end timestamp, used for the limited end-change comparison.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
},
{
"name": "duration",
"meaning": "Stored time-report duration, in milliseconds.",
"unit": "milliseconds",
"evidence": "saved_sql_definition_read"
},
{
"name": "recordtype",
"meaning": "Stored report creation/record type.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "type",
"meaning": "Stored type or classification; use this table’s definition and vocabulary.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "managerapprovalstatus",
"meaning": "Saved manager-approval status.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "formdata",
"grain": "One saved form record with any recorded context",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "formid",
"meaning": "Recorded form-definition identifier.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "sessionid",
"meaning": "Recorded run context on a form record; field name differs from stock.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workorderid",
"meaning": "Recorded internal work-order identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workordernumber",
"meaning": "Recorded work-order number for display and lookup.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "stringnumber",
"meaning": "Display number of the saved form record.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "status",
"meaning": "Raw saved status code; its vocabulary depends on the table and process.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "created",
"meaning": "Record creation timestamp.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "form",
"grain": "One form-type definition",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "name",
"meaning": "Definition/display name, not a guaranteed unique identity.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "workflow",
"grain": "One version of a workflow definition",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "recordid",
"meaning": "Documented cross-version workflow identity; verify in the target environment.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "name",
"meaning": "Definition/display name, not a guaranteed unique identity.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "normalizedversion",
"meaning": "Stored normalized workflow version number.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "currentreleasedversion",
"meaning": "Flag marking a currently released workflow version.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "latestversion",
"meaning": "Flag marking the latest version; latest need not be released.",
"unit": null,
"evidence": "saved_sql_definition_read"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "saved_sql_definition_read"
}
]
},
{
"name": "usermodel",
"grain": "One user record",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "displayname",
"meaning": "Recorded user display name.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "username",
"meaning": "Recorded username.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "workflowsessionitemrecord",
"grain": "One run event/record, not necessarily an execution signature",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "workflowsessionitemid",
"meaning": "Recorded production-run identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "nodeid",
"meaning": "Recorded workflow-step/node identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "originalnodeid",
"meaning": "Original step/node identifier used by documented templates; verify the target type and matching rule.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "userid",
"meaning": "Recorded user identifier; association depends on the record type.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "start",
"meaning": "Recorded start timestamp for this table’s record.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "end",
"meaning": "Recorded end timestamp; interpret it in the context of the table.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "sessioncustomfieldview",
"grain": "One saved field value with run and time context",
"fields": [
{
"name": "workflowsessionitemid",
"meaning": "Recorded production-run identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "fieldid",
"meaning": "Recorded field-definition identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "date",
"meaning": "Timestamp associated with the saved field value.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "nodeid",
"meaning": "Recorded workflow-step/node identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "originalnodeid",
"meaning": "Original step/node identifier used by documented templates; verify the target type and matching rule.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "sessionnodeid",
"meaning": "Run-specific node identifier; do not substitute a workflow-definition node ID.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "userid",
"meaning": "Recorded user identifier; association depends on the record type.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "valuestring",
"meaning": "Stored text value.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "valuenumber",
"meaning": "Stored numeric value; measurement meaning and unit depend on the field.",
"unit": "field_dependent",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "valueboolean",
"meaning": "Stored Boolean value.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "valuedate",
"meaning": "Stored date value.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "field",
"grain": "One field definition",
"fields": [
{
"name": "_id",
"meaning": "Internal record identifier; inspect its exposed type and uniqueness.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "title",
"meaning": "Recorded field title.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "type",
"meaning": "Stored type or classification; use this table’s definition and vocabulary.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "subtype",
"meaning": "Recorded field subtype.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "min",
"meaning": "Configured input minimum; not automatically a quality specification limit.",
"unit": "field_dependent",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "max",
"meaning": "Configured input maximum; not automatically a quality specification limit.",
"unit": "field_dependent",
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "stockitemview",
"grain": "One component row linked to a parent stock record",
"fields": [
{
"name": "stockid",
"meaning": "Recorded parent-stock identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "sku",
"meaning": "Recorded item/SKU identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "serial",
"meaning": "Recorded serial value; do not assume uniqueness without SKU and identity rules.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "quantity",
"meaning": "Recorded quantity; unit of measure depends on the item and context.",
"unit": "item_dependent",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
}
]
},
{
"name": "workorderkititemview",
"grain": "One required kit-component row for an order",
"fields": [
{
"name": "workorderid",
"meaning": "Recorded internal work-order identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "sku",
"meaning": "Recorded item/SKU identifier.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "rev",
"meaning": "Recorded component/item revision.",
"unit": null,
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "quantity",
"meaning": "Recorded quantity; unit of measure depends on the item and context.",
"unit": "item_dependent",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "issuedquantity",
"meaning": "Recorded issued component quantity; compare using compatible units.",
"unit": "item_dependent",
"evidence": "repository_documented_not_tenant_tested"
},
{
"name": "deletedat",
"meaning": "Soft-delete marker; active facts are normally selected with IS NULL.",
"unit": "timestamp",
"evidence": "repository_documented_not_tenant_tested"
}
]
}
],
"relationships": [
{
"id": "session_workorder",
"from_table": "workflowsessionitem",
"from_field": "workorderid",
"to_table": "workorder",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/sessions.sql"
},
{
"id": "stock_session",
"from_table": "stock",
"from_field": "workflowsessionitemid",
"to_table": "workflowsessionitem",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/stock.sql"
},
{
"id": "session_workflow",
"from_table": "workflowsessionitem",
"from_field": "workflowid",
"to_table": "workflow",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/workflow-specification.sql"
},
{
"id": "time_workorder",
"from_table": "timelogreport",
"from_field": "workorderid",
"to_table": "workorder",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/labour-time.sql"
},
{
"id": "time_user",
"from_table": "timelogreport",
"from_field": "userid",
"to_table": "usermodel",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/labour-time.sql"
},
{
"id": "time_workflow",
"from_table": "timelogreport",
"from_field": "workflowid",
"to_table": "workflow",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/labour-time.sql"
},
{
"id": "time_sessions",
"from_table": "timelogreport",
"from_field": "sessionids[]",
"to_table": "workflowsessionitem",
"to_field": "_id",
"expected_cardinality": "array_many_to_many",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/labour-time.sql"
},
{
"id": "form_definition",
"from_table": "formdata",
"from_field": "formid",
"to_table": "form",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "saved_sql_join_read",
"reference": "sql/form-record-links.sql"
},
{
"id": "form_session",
"from_table": "formdata",
"from_field": "sessionid",
"to_table": "workflowsessionitem",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/form-record-links.sql"
},
{
"id": "form_workorder",
"from_table": "formdata",
"from_field": "workorderid",
"to_table": "workorder",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/form-record-links.sql"
},
{
"id": "record_session",
"from_table": "workflowsessionitemrecord",
"from_field": "workflowsessionitemid",
"to_table": "workflowsessionitem",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/step-records.sql"
},
{
"id": "value_session",
"from_table": "sessioncustomfieldview",
"from_field": "workflowsessionitemid",
"to_table": "workflowsessionitem",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/field-values-light.sql"
},
{
"id": "value_field",
"from_table": "sessioncustomfieldview",
"from_field": "fieldid",
"to_table": "field",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/field-values-light.sql"
},
{
"id": "component_parent",
"from_table": "stockitemview",
"from_field": "stockid",
"to_table": "stock",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/as-built-components.sql"
},
{
"id": "kit_workorder",
"from_table": "workorderkititemview",
"from_field": "workorderid",
"to_table": "workorder",
"to_field": "_id",
"expected_cardinality": "many_to_optional_one",
"cardinality_measured": false,
"foreign_key_enforced": "not_verified",
"evidence": "repository_documented_not_tenant_tested",
"reference": "sql/kit-lines.sql"
}
],
"agent_rules": [
"Confirm the authorized database and schema before querying. This file grants no access or write permission.",
"Resolve table and field availability/types with focused inspection; null data_type means unknown, not varchar.",
"Read the matching saved SQL and its filters; never infer the metric solely from its name.",
"Treat identity_candidate and expected_cardinality as hypotheses to validate, not enforced database constraints.",
"Filter soft-deleted facts with deletedat IS NULL. Place dimension soft-delete filters in LEFT JOIN ON when preserving unmatched facts; keep the original 47–48 behavior when reproducing it.",
"Prefer internal IDs to names or business numbers. Do not invent an ID relationship from a similarly named field.",
"Do not assume stock-to-session is one-to-one. Measure multiplicity and unmatched keys before joining.",
"Never sum timer duration after expanding sessionids without an explicit allocation rule. Summed timer hours are not attendance.",
"Do not inner-join historical facts to version definitions unless the requested population explicitly requires a matching definition.",
"Use workflow._id for one version; workflow.recordid is a documented cross-version identity requiring target verification. Names are display labels.",
"Do not infer pass/fail tolerances from field.min/max; these are input limits. Tenant field vocabulary and measurement units require discovery.",
"Do not interpret event records as execution signatures or start/end differences as actual labour without event classification.",
"Use read-only SELECT for diagnostics; validate totals, missing keys and row counts before and after joins. New examples in this map were not executed.",
"Do not carry tenant values, record contents, identifiers or credentials into reusable documentation or another environment."
]
}