The learning aim must not have more than one Apprenticeship contract type record at the same time
This is wrong and needs correcting. It is not a judgement call.
In plain English
A learning aim must not have Learning Delivery FAM records with overlapping dates where the Learning Delivery FAM type is Apprenticeship contract type (ACT) If there is more than one ACT record the 'Date to' of the earlier record must be returned and before the 'date from' of the later record.
Why it matters
A record that fails this rule may be excluded from funding until the underlying data is corrected.
Most likely causes
Ranked, because in practice a few causes explain most cases.
Check these first
LearningDeliveryFAM.LearnDelFAMTypeLearningDeliveryFAM.LearnDelFAMDateToLearningDeliveryFAM.LearnDelFAMDateFrom
How to investigate
In your system
These steps are system-neutral: they describe what has to be true in the data, which is the same whatever software your college runs. We do not publish supplier screen paths we have not verified, because menu locations differ by version and by local configuration, and a confidently wrong instruction is worse than none.
System-neutral
- Read the official wording for this record in the source named below.
- Find the affected records in your own data using the fields listed.
- Trace each one back to the source system entry that produced it.
- Correct the cause in the source system rather than the generated file.
Building your own map of where each of these lives in your system is the most useful induction document an MIS team can have. How to build one.
How to fix it
Stop this happening again
Fixing the record clears this case. A control is what stops the next one, so each of these names what to do, who owns it and how often.