Skilirium

Recognises a data requirement silent on current versus past values

K-110 · Skill knobit · Activity: Capture data requirements · Competence: Data modelling

The requirement does not say whether the business needs only the current value or also what the value was at an earlier date. This decides history, effective dating and SCD strategy.

Can AI do this?

People still lead Few or none of the tested AI models showed they master this. 1 of 10 models master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 96%Mastered
gemini-3.1-pro-previewFlagship 66%Not shown
gpt-6-astraFlagship 90%Not shown
claude-fable-5-1Flagship 90%Not shown
gemini-3.8-flashMid tier 69%Not shown
gpt-6.1-solMid tier 90%Not shown
claude-sonnet-5-5Mid tier 90%Not shown
gemini-3.5-flash-liteLow cost 61%Not shown
gpt-6-lunaLow cost 68%Not shown
claude-haiku-5-5Low cost 67%Not shown

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The requirement and the question of current value or history

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: "Record the customer's address." Acceptable: "Record the customer's address as it was on a payment's value date, so a past statement can be reproduced with the address in force at the time."

Also known as: Time not stated (data requirement)

Related knobits

Builds on

Needed for

All 47 knobits of Capture data requirements.

Source: Review checklist 01-requirements, row 10; Stage 1 (time)