IM1 Change Log
| Date | Change | Version |
|---|---|---|
| 28/01/2026 | Schema Additions • CareRecord_Observation: OriginalTerm• Admin_PatientHistory: PatientTypeDescription | 8.3 |
| 13/02/2025 | Schema Additions • Appointment_Slot: IsBlocked, NationalSlotCategoryName, ContextType, ServiceSetting• Prescribing_IssueRecord: IssueMethodDescription | 8.2 |
| 24/04/2024 | Schema Discontinuations (replaced with NULL) • Coding_DrugCode: BNFChapterRef• Prescribing_IssueRecord: ExpiryDateSchema Additions • Prescribing_DrugRecord: ExpiryDate | 8.1 |
| 23/10/2023 | Schema Type Changes • CareRecord_ObservationReferral: TransportRequired (Boolean → varchar)Schema Additions • CareRecord_Observation: NumericOperator | 8.0 |
| 07/09/2023 | Documentation Updates • Admin_PatientHistory: Updated StatusDescription description and sample dataSchema Changes • CareRecord_Observation: Removed duplicate AssociatedText field | 8.0 |
| 05/06/2023 | New Tables • Admin_PatientHistorySchema Additions • Admin_UserInRole: RegistrationNumber• Admin_Patient: ContactComments• Appointment_Slot: BookedDate, BookedTime, SlotType• CareRecord_Consultation: ConsultationType• CareRecord_Observation: Qualifiers, Abnormal, AbnormalReason, Episodicity, AssociatedText• CareRecord_ObservationReferral: TransportRequired, ReferralTargetClinician, ReferralTargetDepartment• Coding_DrugCode: BNFChapterRef• Prescribing_IssueRecord: EmisCode, PatientMessage, ScriptPharmacyStamp, Compliance, AverageCompliance, IsPrescribedAsContraceptive, IsPrivatelyPrescribed, PharmacyMessage, PharmacyText, ConsultationGuid, ExpiryDate, ReviewDate• CareRecord_Diary: AssociatedText• CareRecord_Problem: Comment | 8.0 |
| 16/04/2021 | Schema Removals (Information Governance review) • CareRecord_Diary: AssociatedText• CareRecord_Observation: AssociatedText• CareRecord_Problem: Comment | 7.1 |
| 28/08/2020 | Schema Mapping Updates (updated previous_location field for schema columns) • CareRecord_ObservationReferral: ReferralReceivedDate, ReferralReceivedTime, ReferralEndDate, ReferralSourceId, ReferralSourceOrganisationGuid, ReferralReasonCodeId, ReferringCareProfessionalStaffGroupCodeId, ReferralEpisodeRTTMeasurementTypeId, ReferralEpisodeClosureDate, ReferralEpisodeDischargeLetterIssuedDate, ReferralClosureReasonCodeId• Coding_ClinicalCode: CodeId, Term, ReadTermId, SnomedCTConceptId, SnomedCTDescriptionId, EmisCodeCategoryDescription, ParentCodeIDDocumentation Updates • Updated example data format for CareRecord_Diary: AssociatedText; CareRecord_Observation: AssociatedText; CareRecord_Problem: Comment | 7.0 |
| 26/03/2020 | Documentation Updates • Added example data values for CareRecord_Observation: AssociatedText• Added example data values for CareRecord_Problem: Comment | 6.0 |
| 25/04/2017 | Documentation Updates • Updated example data format for all tables • Updated example data format → date: Admin_Patient: DateOfDeactivation• Updated example data format → date: Admin_Patient: DateOfDeath• Updated example data format → time: CareRecord_Observation: EnteredTime• Updated example data format → time: CareRecord_ObservationReferral: ReferralReceivedTime• Updated example data format → number: CareRecord_Problem: ProcessingId• Updated example data format → number: CareRecord_ObservationReferral: ProcessingId• Updated example data format → decimal: CareRecord_Observation: NumericRangeLow, NumericRangeHigh• Updated example data format: CareRecord_Problem: Deleted• Added example data values for Admin_Patient: MiddleNames, HouseNameFlatNumber, ResidentialInstituteCode, CarerName, CarerRelation• Added example data values for CareRecord_Diary: EffectiveDatePrecision• Added example data values for CareRecord_Observation: EffectiveDatePrecision• Added example data values for CareRecord_ObservationReferral: ReferralServiceType• Added example data values for CareRecord_Problem: ExpectedDuration | 5.5 |
| 26/09/2016 | Schema Additions • Coding_ClinicalCode: ParentCodeId | 5.4 |
| 22/09/2016 | Schema Removals • All tables: AgreementGuid Schema Type Changes • CareRecord_Problem: Deleted (→ boolean)• Admin_OrganisationLocation: Deleted (→ boolean, max length 5), IsMainLocation (→ boolean, max length 5) | 5.3 |
| 25/04/2016 | Schema Additions • CareRecord_Problem: DeletedSchema Renames • Admin_Patient: PersonGUID → PersonGuid | 5.2 |