How to Read the EMS or Hospital File Upload Report

Example of error message:
Exception: Record 6481112_123456, line 2, case will not be saved due to missing or invalid values in the following required fields: TRAUMA REGISTRY NUMBER (TRNO)

How to read the error message:
Exception	This is an error.
Record 6481112_123456	The DSHS ID# assigned by the Injury Program for each entity.
Record 6481112_123456	The Trauma Registry Number for Hospital File Uploads or the Run Report ID number for EMS File Uploads.
line 2	The number of the row from the file that was uploaded.
case will not be saved due to missing or invalid values in the following required fields	A record will not be created in the EMS/Trauma Registry for this patient because one of the MANDATORY data elements is either blank or has an invalid value (check data dictionary to see the MANDATORY data elements, dshs.texas.gov/injury-prevention/ems-trauma-registries).
TRAUMA REGISTRY NUMBER (TRNO)	The name of the data element.
TRAUMA REGISTRY NUMBER (TRNO)	The name of the data element in the file that was uploaded.

Example of a 2nd error message for the same record:
Exception: Record 6481112_123456, line 2, required field TRNO must be a numeric value between 1 and 9999999, not 123456
*required field TRNO must be a numeric value between 1 and 9999999*	Describes the range of values that are valid and the length of the data element is 7 digits (9999999) .
*not 123456*	Gives the value that was reported and that is incorrect (the length is 6 digits and in this record there is a single space after the 6 digit number that should not be there).

Information at the end of the list of errors:
[INFO ] [] 2013/04/01 11:48:49 Line 8: Line is empty and is being skipped
*INFO*	Additional information about the uploaded file. INFO does not indicate a processing error due to invalid data.
*2013/04/01 11:48:49*	Date and time the patient record was processed.
*Line 8*	The number of the row from the file that was uploaded.
*Line is empty and is being skipped*	Information about the row that may be useful in determining the quality of the data in the file that was submitted. For example, was Line 8 intentionally left blank or should there have been a patient record on line 8?

Detailed Messages
*Row 2 created new event 987654321 and created new person Sajak Tammy**
Row 2	The number of the row from the file that was uploaded.
created new event	New patient record was created.
*created new person Sajak Tammy**	New patient record person First and Last Name.
* THE LOG BELOW IS FOR TECHNICAL SUPPORT. SKIP TO THE END TO SEE THE SUMMARY**

The last portion of the report is the Import Summary which gives the following information:
Import Summary
[INFO ] [] 2013/04/01 11:48:50 Rows in feed : 8	Number of rows in the file uploaded.
[INFO ] [] 2013/04/01 11:48:50 Records in feed : 6	Number of records that were in the file upload that the EMS/Trauma Registry System detects.
[INFO ] [] 2013/04/01 11:48:50 Records processed successfully : 6	Number of records that processed.
[INFO ] [] 2013/04/01 11:48:50 Records with errors : 0	Number of records with errors.
[INFO ] [] 2013/04/01 11:48:50 Records skipped : 0	Number of records that were skipped.
[INFO ] [] 2013/04/01 11:48:50 New Cases Created : 0	How many cases were created in the EMS/Trauma Registry System.
[INFO ] [] 2013/04/01 11:48:50 New Parties Created : 0	How many new people for this entity (person information) were created in the EMS/Trauma Registry System.
[INFO ] [] 2013/04/01 11:48:50 Deduplicated and Updated Parties : 0	How many duplicated patient record demographic information (person information) were updated for people the entity had previously reported.
[INFO ] [] 2013/04/01 11:48:50 Deduplicated and Updated Cases : 0	How many duplicate patient EMS or hospital cases (event information pertaining to the hospital stay or the EMS run) were updated.
[INFO ] [] 2013/04/01 11:48:50 Deduplicated and Not Updated Parties : 0	How many duplicate patient demographic information (person information) were NOT updated because they were both exactly the same.
[INFO ] [] 2013/04/01 11:48:50 Deduplicated and Not Updated Cases : 0	How many duplicate patients (event information pertaining to the hospital stay or the EMS run) were NOT updated because they were both exactly the same.
[INFO ] [] 2013/04/01 11:48:50 Import finished successfully after 0 seconds.	The file was successfully processed.

Print Instructions