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 and Trauma Registries (EMSTR) 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 EMSTR 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 EMSTR 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 EMSTR 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