>>How flexible do you want to make this?
>>
>>Will you be parsing all the HIPAA transactions?
>
>I will probably add a column for the 271, 270, etc to make it more flexible for the future, but for the moment I'm just looking to work through the 271.

We normalized our tables because we parse most of the transactions.

You might consider adding a Pre-assignment hook column (memo). That allows a totally table-driven solution.