What is the leading cause of our files to be returned by the NM Health Policy Commission (NMHPC) for errors?
The file is a fixed-width file which means that all data fields start and end at specific locations on the line of the record. The leading cause for the data to not load into the database is because the file is not padded (with spaces) out to the last position specified. For the submission of 2009 data the last position in the file is 587. Each record (line) should have this many characters on each line even though they will be blank spaces at the end of some lines. In other words, when looking at the file, if you hit the “end” key on any line it should place your cursor at position 588.
