This is the core of the implementation. Add five columns to the existing reference table.
6-1. The five columns
| Column | Type and example values | Role |
status | initial_forecast / revised_forecast / actual / restated / proposed | The status of the figure. The four buckets in §2, plus proposed |
supersedes | The row_id of the earlier row. Empty if none | Points to the row this row replaced |
superseded_by | The row_id of the later row. Empty for the current version | Points to the row that replaced this one. Being empty is the test for the current version |
effective_from | Date | The date from which this row is treated as the current version for verification. The fiscal year covered is carried by fiscal_period |
precedence | Integer (smaller takes precedence) | Precedence when documents conflict. The value decided in §4-2 |
6-2. How they relate to the existing columns
The reference table in the previous article has announced_date (the date the value was published), last_verified (the date the reference table itself was last verified), and source_document (the name of the source document). The new columns do not overlap in role with these.
| Existing column | Question it answers | Column this article adds | Question it answers |
announced_date | When was this value published | effective_from | From when is this row treated as the current version |
last_verified | When was the reference table last checked | superseded_by | Is this row still the current version |
source_document | Which document was it taken from | precedence | If documents conflict, which one wins |
| (Value columns: fiscal period, accounting standard, currency, unit, scope of consolidation) | What value is it | status | What status does that value carry |
A word on why announced_date and effective_from are separate. Corrective disclosure replaces figures for a past period with a later date attached. The amended report may be filed in August 2026 while the period covered by the replaced figures is the fiscal year ending March 2025. The fiscal year covered is carried by fiscal_period, and effective_from carries the date from which this row is treated as the current version for verification. The publication date alone cannot express these two separately.
6-3. An implementation example in CSV
As in the previous article, the reference table can be a spreadsheet or a CSV. Here the column definitions are shown as a CSV header. Do not make it an image. The point is to allow mechanical matching in later steps.
row_id,question_id,question_en,expected_value,status,fiscal_period,period_type,consolidation,accounting_standard,currency,unit,continuing_ops,announced_date,effective_from,supersedes,superseded_by,precedence,source_document,source_url,source_page,tolerance,last_verified
R001,Q010,What is the actual consolidated revenue for the fiscal year ending March 2026,1234567,actual,2026-03,FY,consolidated,IFRS,JPY,million,continuing,2026-05-12,2026-05-12,,R004,3,kessan_tanshin,https://example.co.jp/ir/tanshin_2026q4.pdf,p.1,0,2026-08-16
R002,Q011,What is the latest company forecast for consolidated revenue for the fiscal year ending March 2027,1300000,initial_forecast,2027-03,FY,consolidated,IFRS,JPY,million,continuing,2026-05-12,2026-05-12,,R003,3,kessan_tanshin,https://example.co.jp/ir/tanshin_2026q4.pdf,p.1,0,2026-08-16
R003,Q011,What is the latest company forecast for consolidated revenue for the fiscal year ending March 2027,1250000,revised_forecast,2027-03,FY,consolidated,IFRS,JPY,million,continuing,2026-08-05,2026-08-05,R002,,4,gyoseki_yoso_shusei,https://example.co.jp/ir/rev_20260805.pdf,p.1,0,2026-08-16
R004,Q010,What is the actual consolidated revenue for the fiscal year ending March 2026,1229000,restated,2026-03,FY,consolidated,IFRS,JPY,million,continuing,2026-08-20,2026-08-20,R001,,1,teisei_hokokusho,https://example.co.jp/ir/teisei_20260820.pdf,p.3,0,2026-08-21
Read out what these four rows are saying.
Q010 (actual) has two rows. R001 holds R004 in superseded_by, so it is not the current version
R004 derives from the amended report and has precedence 1, the highest. This one is the current version
Q011 (forecast) also has two rows, and R003 (the revised forecast) is the current version
- Because
R001 has not been deleted, when AI answers 1234567 it can be judged as answering with the pre-corrective-disclosure value
That last point is the practical payoff of this design. Because the old row is still there, the type of error can be identified. Had it been deleted, the record would say no more than "mismatch."
6-4. Finer-grained judgments
Holding a status column raises the granularity of the judgment. The verification in the previous article records match or mismatch; adding the status axis splits mismatch further.
- Value and status both match: no problem
- Value matches, status differs: the version has been mistaken. AI is answering with a real published value of the company, but not the current version
- Value does not match: the traditional kind of error. The number itself does not match a value the company published
- Value does not match and matches no past version either: the origin may not be a published document of the company at all
The second and the fourth call for entirely different responses. A mistaken version can be treated as a problem in how the company presents information. If the causes sit on the company's side — the current version is hard to find, prior-year pages do not state the year, old pages remain reachable from search — then the company can act on them. The fourth suggests that the company's materials may not be being referred to at all.