Victorian Emergency Minimum Dataset (VEMD) User Manual
Contents
1. On each occasion a new Scheduled Admission Date is allocated and on each occasion the Reason SAD changed event is reported A new Scheduled Admission Date Identifier SAD Identifier must be reported each time Event Type Set SAD is reported for an episode When it becomes evident that the Scheduled Admission Date will not proceed as planned a Reason SAD Changed event must be reported The SAD Identifier generated for this Reason SAD Changed event must be the same as the SAD Identifier previously reported for the related Set SAD event The SAD Identifier should be generated by a health service s computer system and must be unique to each pair of bookings and cancellations Set SAD and Reason SAD Changed events within an episode S287 Scheduled Admission Date Exceeded 417 Scheduled Admission Date Changed Without Reason For Change 418 Reason For SAD Change Reported But No related SAD 426 Invalid SAD Identifier 427 SAD Identifier Previously Reported For This Episode 429 SAD Identifier Event Type Mismatch Section 2 Intra Episode Event Section 3A Reason For SAD change Scheduled Admission Date This section Episode Identifier Event Date Event Type Section 4 Scheduling Booking To definitively link an episode s booking to its cancellation Set SAD and Reason SAD Changed events Department of Health health service July 2005 Version 1 Effective 1 July 2005 Department Code set Hospital generated of Health source2. Related items Administration Purpose Principal data users Collection start Definition source ESIS Manual 13 Edition Section 3B Data Definitions The Patient Identifier that is to be retained where two or more patient records are merged Retained_Patient_Identifier 10 XXXXXXXXXX Merge extract The Patient record being retained when two or more patient records are merged The campus health service identifies the need to merge two or more patient records The retained Patient Identifier is reported in the Merge extract paired with the Patient Identifier being discontinued The merge will only be successful when both the Identifier being retained and the Identifier being continued have previously been submitted to ESIS 416 Retained Patient Identifier does not exist Section 4 Merging of Patient Identifiers To facilitate the merge of patient records Department of Health July 2005 Version 1 Effective 1 July 2005 Department of Health Code set source N A Page 12 Scheduled Admission Date Identifier Specification Definition Label Field Size Layout Reported in Reported for Reported when Reporting guide Edits Related items Administration Purpose Principal data users Collection start Definition source An identifier that links a Set SAD event to its Reason SAD Changed event SAD_ Identifier 10 XXXXXXXXXX Intra Episode extract Event Types Set SAD and Reason SAD Changed
3. ESIS Manual 13 Edition Section 3B Data Definitions Page 13
4. set source Hospital generated ESIS Manual 13 Edition Section 3B Data Definitions Page 5 Event Date Specification Definition Label Field Size Layout Reported in Reported for Reported when Reporting guide Edits Related items The date on which an Intra Episode Event occurred Event_Date 8 DDMMYYYY Intra Episode extract All events reported in the Intra Episode extract An Intra Episode event Intra Episode Events may occur multiple times within a waiting episode but there can only be one event per episode per day for Readiness Clinical Urgency or MAPT The Event Date must represent the date on which the event occurred not the date of data entry Scheduling events Set SAD and Reason SAD Changed can be reported as having occurred more than once per day provided the SAD Identifier is unique for each pair of bookings and cancellations within an episode When an episode is first registered clinically it will have an initial Clinical Urgency and a Readiness for Care value The Event Dates for this should be the same as the Clinical Registration Date 287 Scheduled Admission Date Exceeded 383 Multiple Events Of Same Type For Same Episode On One Day 384 Invalid Event Date 412 Episode Registered Without A Clinical Urgency 413 Episode Registered Without A Readiness For Care 417 Scheduled Admission Date Changed Without Reason For Change 418 Reason For SAD Change Reported But No related SAD 426 I
5. Definitions Page 1 Version A version number for each data item beginning with 1 for the initial version of the data item and incremented by one for each subsequent revision A new version number is allocated to a data item when changes have been made to one or more of the following attributes Name Definition or Code set Definition source Identifies the authority that defined this data item and the unique identifier for the data item if applicable Code set source Identifies the authority that developed the code set for this data item ESIS Manual 13 Edition Section 3B Data Definitions Page 2 Data Items Ceased Patient Identifier Specification Definition Label Field Size Layout Reported in Reported for Reported when Reporting guide Edits Related items Administration Purpose Principal data users Collection start Definition source ESIS Manual 13 Edition Section 3B Data Definitions The Patient Identifier that is to be ceased where two or more patient records are merged Ceased_Patient_Identifier 10 XXXXXXXXXX Merge extract All patient records that are being discontinued as a result of a merge The campus health service identifies the need to merge two or more patient records The discontinued Patient Identifier is reported in the Merge extract and paired with the Patient Identifier being retained The merge will only be successful when both the Identifier being retained and t
6. Elective Surgery Information System ESIS User Manual 13th Edition 2010 11 Section 3B Data Definitions Download from the Department of Health web site at http www health vic qov au hdss Published By The Department of Health Victoria Authorised By The Victorian Government 50 Lonsdale Street Melbourne Version Version 13 0 Year 2010 11 ESIS Manual Sections The Elective Surgery Information System ESIS Manual sections are Please follow the arrow and click the manual section number you require Click Section Number Lists the terms and abbreviations used in the ESIS manual Glossary ESIS Manual Introduction Provides information on the development and purpose of the ESIS data collection scope and coverage contact details and a list of relevant abbreviations Concept and Derived Item Definitions Provides definitions of concepts that are the foundation of the ESIS collection and information that the department derives from the data submitted Data Definitions Details the specifications of data items relating to individual waiting episodes for reporting to ESIS Details the technical or database elements required for submission of ESIS data Section 3b Business Rules Draws together a number of concepts and data items as well as describing the technical functions of the ESIS processing Compilation and Submission Specifies the required format of ESIS records submitted to AED
7. It includes details such as file naming conventions file structures reporting requirements data security test submission and system migration Section 7 Editina Each ESIS edit message is listed in this section in numerical order The entry for each edit message describes the problem and the remedy Section 8 Supplementary Code Lists http www health vic gov au hdss reffiles index htm Contents SECTION 3B Data Definitions Data Definition Structure Data Items Ceased Patient Identifier Episode Identifier Event Date Event Type Event Value Retained Patient Identifier Scheduled Admission Date Identifier O A WO O 10 12 13 SECTION 3B Data Definitions Section 3B provides the specifications for each ESIS database specific item and alphabetically sets out the required technical elements for submission of ESIS data Note Section 3A details the related ESIS collection data elements in the data collection Sites and software vendors should be aware that this manual describes how to submit the data to the Department of Health and not as they are stored in a sites system Sites should map from their stored values to the specified ESIS values Data Definition Structure Specification Definition Label Field Size Valid Values Layout Reported in Reported for Reported when Code set Reporting guide Edits Related items Administration Purpose Principal data users Collection start A sta
8. he Identifier being continued have previously been submitted to ESIS 415 Ceased Patient Identifier Does Not Exist Section 4 Merging Patient Identifiers To facilitate the merge of patient records Department of Health July 2005 Version 1 Effective 1 July 2005 Department of Health Code set source Department of Health Page 3 Episode Identifier Specification Definition A string of characters that uniquely identifies a waiting episode for a given health service Label Episode_Identifier Field Size 9 Layout XXXXXXXXX Leading zero filled alphanumeric characters only Reported in Episode extract Primary Key Intra Episode extract Foreign Key Reported for All waiting list episodes Reported when The episode is first registered on the waiting list Reporting guide The Episode Identifier must be unique to a single episode and cannot be re used an Episode Identifier must not be re assigned to another episode for the same patient or to another patient It is usually generated and allocated by the health service s computer system and should have no relationship with the patient s unit record number Patient Identifier Once allocated to an episode the Episode Identifier cannot be changed The Episode Identifier remains constant throughout the episode Whilst other information in the episode record may be changed including the Patient Identifier the Episode Identifier ensures that the episode can be identified by the
9. health service When migrating data from an existing hospital system to a new one the Episode Identifier must be preserved Edits 174 New Episode Old Clinical Registration Date 378 Episode Identifier Invalid 379 Episode Identifier Exists Multiple Times In One Episode Level Extract 381 Referential Integrity Error Between Intra Episode Event and Episode 383 Multiple Events Of Same Type For Same Episode On One Day 386 PPP For This Episode Has Changed 387 Surgical Specialty Has Changed 388 Clinical Registration Date Has Changed 397 Unmatched Transfer As Reported By Receiving health service 398 Unmatched Transfer As Reported By Originating health service 408 The Patient Identifier To Which This Episode Relates Has Changed 414 Previous Identifier Of Transferred Episode Invalid ESIS Manual 13 Edition Section 3B Data Definitions Page 4 Related items Administration Purpose Principal data users Collection start Definition source Section 2 Foreign Key Intra Episode Event Primary Key and Referential Integrity Section 3A Previous Identifier of Transferred Episode Section 4 Transfer Of Ownership Of Waiting Episode To uniquely identify a row of episode level data To relate Intra Episode events to their episode Department of Health Health Services July 1999 previously Version 1 Effective 1 July 1999 called Uniquaskey Code set source 2 Effective 1 July 2005 Department of Health Code
10. iness For Care Intra Episode extract All events reported in the Intra Episode extract An Intra Episode event occurs and is reported in the Intra Episode extract with an Event Date Event Type Episode Identifier and SAD Identifier for scheduling events Intra Episode Events can occur multiple times within a waiting episode For MAPT Urgency and Readiness events there can only be one event per episode per day Scheduling events can occur multiple times in a single day Refer to the Scheduling booking business rules for direction on how this is to be reported Event values are described in the following Data Definitions e Clinical Urgency e Readiness For Care e Reason For Scheduled Admission Date Change e Scheduled Admission Date e Multi attribute Prioritisation Tool MAPT Score The Event Value is the only field in an Intra Episode event that can be changed updated All other change to Intra Episode data requires the submission of an Intra Episode event Deletion and then reporting the correct data Deleting an intra episode event When deleting an intra episode level record the event value field contains the word DELETE S287 Scheduled Admission Date Exceeded 295 Date Of Admission Not Equal To Scheduled Admission Date 296 Reason For Removal Implies Procedure received But Not Ready For Care ESIS Manual 13 Edition Section 3B Data Definitions Page 10 Edits cont d 315 Clinical Urgency Cat 1 Wai
11. nly be one event per episode per day for Readiness or Clinical Urgency or MAPT Scheduling events Set SAD and Reason SAD Changed can be reported as having occurred more than once per day provided the SAD Identifier is unique for each pair of bookings and cancellations within an episode When an episode is first registered clinically it will have an initial Clinical Urgency category and a Readiness For Care value The Event Dates for these should be the same as the Clinical Registration Date Each Intra Episode Event will have an Event Value that is relevant to the Event Type Refer to Section 4 Business Rules Intra Episode events for additional information 287 Scheduled Admission Date Exceeded 295 Date Of Admission Not Equal To Scheduled Admission Date 296 Reason For Removal Implies Procedure received But Not Ready For Care 315 Clinical Urgency Cat 1 Wait More Than 30 Days 375 Clinical Urgency Category For ESAS Reason For Removal Invalid 383 Multiple Events Of Same Type For Same Episode On One Day 385 Invalid Event Type 389 Intra Episode Event Value For Clinical Urgency Change Invalid 390 Intra Episode Event Value For Readiness Change Invalid 391 Invalid Intra Episode Event Value For SAD Change reason ESIS Manual 13 Edition Section 3B Data Definitions Page 8 Edits Cont d Related items Administration Purpose Principal data users Collection start Definition source 390 Intra Episode Even
12. nvalid SAD identifier 427 SAD Identifier Previously Reported For This Episode Section 2 Intra Episode Event This section Event Type Event Value Section 3A Clinical Urgency Readiness For Care Scheduled Admission Date Reason For Scheduled Admission Date Change Scheduled Admission Date Identifier ESIS Manual 13 Edition Section 3B Data Definitions Page 6 Administration Purpose To identify the dates on which certain events relevant to ESIS happened to Waiting List patients for a given episode Principal data users Department of Health Collection start July 2005 Version 1 Effective 1 July 2005 Definition source Department of Health ESIS Manual 13 Edition Section 3B Data Definitions Page 7 Event Type Specification Definition Label Field Size Reported in Reported for Reported when Code set Reporting guide Edits The types of Intra Episode Events that may occur multiple times within a waiting episode Event_Type N A Intra Episode extract All events reported in Intra Episode extract An Intra Episode event occurs Code Descriptor Urgency Clinical Urgency set or reset Readiness Readiness For Care set or reset Set SAD Scheduled Admission Date set or reset Reason SAD Reason For Scheduled Admission Date Change Changed MAPT Multi attribute Prioritisation Tool Score Intra Episode Events may occur multiple times within a waiting episode but there can o
13. t More Than 30 Days 375 Invalid Clinical Urgency Category For ESAS Reason For Removal 383 Multiple Events of Same Type for Same Episode on One Day 389 Invalid Intra Episode Event Value For Clinical Urgency Change 390 Invalid Intra Episode Event Value For Readiness Change 391 Invalid Intra Episode Event Value For SAD Change Reason 392 Invalid Intra Episode Event Value For Set SAD Event 400 Date Of Admission For Awaited Procedure Invalid 412 Episode Registered Without a Clinical Urgency 413 Episode Registered Without a Readiness For Care 417 Scheduled Admission Date Changed Without Reason For Change 418 Reason For SAD Change Reported But No related SAD Related items Section 3A Clinical Urgency Readiness For Care Scheduled Admission Date Reason For Scheduled Admission Date Change Multi Attribute Prioritisation Tool MAPT Score This section Episode Identifier Event Date Event Type Section 4 Scheduling Booking Administration Purpose To collect the data relating to Intra Episode Events Principal data users Department of Health Collection start July 2005 Version 1 Effective 1 July 2005 2 Effective 1 July 2007 Definition source Department of Health Code set source Department of Health ESIS Manual 13 Edition Section 3B Data Definitions Page 11 Retained Patient Identifier Specification Definition Label Field Size Layout Reported in Reported for Reported when Reporting guide Edits
14. t Value For Readiness Change Invalid 391 Invalid Intra Episode Event Value For SAD Change reason 392 Invalid Intra Episode Event Value For Set SAD Event 412 Episode Registered Without A Clinical Urgency 413 Episode Registered Without A Readiness For Care 417 Scheduled Admission Date Changed Without Reason For Change 418 Reason For SAD Change Reported But No related SAD 427 SAD Identifier Previously Reported For This Episode 429 SAD Identifier Event Type Mismatch 431 Intra Episode Event Value For MAPT Invalid Section 3A Clinical Registration Date Clinical Urgency Readiness For Care Scheduled Admission Date Reason For Scheduled Admission Date Change This section Event Date Event Value SAD Identifier Section 4 Intra Episode Events To identify the type of events relevant to ESIS that happened to Waiting List patients for a given episode Department of Health July 2005 Version 1 Effective 1 July 2005 2 Effective 1 July 2007 Department of Health Code Set Source Department of Health ESIS Manual 13 Edition Section 3B Data Definitions Page 9 Event Value Specification Definition Label Field Size Layout Valid Values Reported in Reported for Reported when Reporting guide Edits The value of the Event Type reported in the Intra Episode extract Event_Value N A DDMMYYYY NNN NNN DELETE Code from code sets e Clinical Urgency e Reason For Scheduled Admission Date Change e Read
15. tement that expresses the essential nature of a data item The first row of a field in a text extract Labels represent field names The maximum number of characters accommodated by this field The title of the Code set valid for this data item when these are not specifically listed in Section 3 of this Manual Code sets not listed in Section 3 of this Manual are available from http health vic gov au hdss reffiles index htm X Alpha or Numeric character in range A Z a z 0 9 DD Numeric characters representing day of the month Leading zero filled Range 01 31 MM Numeric characters representing month Leading zero filled Range 01 12 YYYY Numeric characters representing year A Alpha character in range A Z a z N Numeric character in range 0 9 The specific text extract in which this data item is submitted to ESIS The specified circumstances when this data item must be reported The stage in the episode data submission cycle when this data item is to be reported to ESIS The valid values for the data item current financial year only Additional comments or advice on reporting the item A list of edits edit numbers and titles that relate to this data item A reference to related data items within this collection The main reason s for the collection of this data item Identifies the key primary users of this information The date the collection of this data item commenced ESIS Manual 13 Edition Section 3B Data
Download Pdf Manuals
Related Search