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 2012 data dictionary to see the MANDATORY data elements, http://www.dshs.state.tx.us/injury/registry/datadict.shtm).

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.

Last updated May 2, 2013