﻿LOGIC OR NOT P060 — SOURCE-TO-TABLE SCHEMA — v0.1.2


extraction_id:
purpose:
observed_at:


sources:
- source_id:
  source_ref:
  source_type:
  source_as_of:
  observability: OBSERVED | PARTIAL | NOT_OBSERVABLE


fields:
- field_id:
  name:
  expected_type:
  expected_unit:
  extraction_rule:
  required_for_output: true | false


records:
- record_id:
  source_id:
  row_or_entity_locator:
  values:
  - field_id:
    value_state: OBSERVED_VALUE | MISSING_IN_SOURCE | UNREADABLE | AMBIGUOUS | NOT_APPLICABLE | NOT_OBSERVABLE | UNKNOWN
    raw_value:
    raw_unit_or_format:
    source_location:
    transformation_state: NONE | NORMALIZED | DERIVED
    normalized_value:
    normalized_unit_or_format:
    derivation_formula_or_rule:
    transformation_basis:
    notes:


validation:
  schema_conformance:
  missing_state_check:
  raw_normalized_preservation_check:
  derived_labeling_check:
  source_traceability_check:
  issues: []


RULES
No empty-to-zero conversion without source basis. No DERIVED value represented as extracted. Normalization preserves raw value. Non-observable source fields remain NOT_OBSERVABLE.
