app.import_row_results

TableRow level security on

Outcome of every source row of an import (Section 4.6.2 steps 4 to 8): its row state and reason, and for a Written row the batch, the row written and what the write did. This is where the import batch id of every imported row lives.

Primary key: id

Columns of app.import_row_results
Column	Type	Nullable	Description
id	uuid	No	Primary key, UUID v7.
org_id	uuid	No	Owning org, derived from app.import_jobs on insert; never accepted from the caller and never changed.References app.organizations.id
import_job_id	uuid	No	Import.References app.import_jobs.id
import_batch_id	uuid	Yes	Batch that wrote the row; set exactly when the row is Written.References app.import_batches.id
sheet_name	text	No	Source sheet.
row_number	integer	No	One-based row number in the sheet, as the person sees it.
row_state	app.import_row_state	No	Valid, Invalid, Written, Refused or Skipped.
reason	text	Yes	Why a row is Invalid, Refused or Skipped (refusal message or rule).
target_table	text	Yes	Table the row was written to.
target_id	uuid	Yes	Row written, created, updated or merged into.
write_action	app.import_write_action	Yes	Created, Updated or Merged.
before_image	jsonb	Yes	Audit diff of an updated or merged target before the write (the columns the import changed), used to undo it.
undo_outcome	app.undo_outcome	Yes	Reverted or Kept when the batch was undone.
undo_reason	text	Yes	Why a row was kept: the later edit or dependent row.
created_at	timestamp with time zone	No	When the row was inserted. Set by the database.
created_by	uuid	Yes	Person who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_at	timestamp with time zone	No	When the row last changed. Set by the database.
updated_by	uuid	Yes	Person who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_at	timestamp with time zone	Yes	Soft delete time. A row with deleted_at set is ignored by every access helper.