>>>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.

Could you explain that a bit more? How would that work, and why a memo field?