Question
Can Northstar Appointments release this quota batch under the supplied import policy?
Evidence
Each source row has id:amount form. Amounts must be integers from 0 through 50, and accepted ids must be unique after trimming. The first accepted record wins.
Checked answer
Return the complete audit summary and release or review decision. The last step checks both the recommendation and the evidence that supports it.
Northstar Appointments receives a small quota feed from a fictional scheduling partner. The operations lead needs a release decision with evidence, because a plausible total can hide broken records or repeated identities. Build the audit in six steps, keeping the original row count while adding syntax, range, uniqueness and retained-amount evidence.
A malformed record differs from a valid record whose amount is outside the permitted range. A duplicate accepted id differs from both. The first valid, in-range record wins for each trimmed case-sensitive id; an invalid earlier record must not reserve that id. The final answer includes the counters and total beside the recommendation. Release only when every source row survives all checks. This is a local policy exercise using supplied rules, not advice about a real scheduling system.