I have a table called avIssues which contains patient issues. The issues stored in this table come in two basic types called IssueType and they are 'Billing' and basically everything else.

There will be edit screens to allow the user to create and manage issue types. Right now there will be logic that says:

if the issue is billing

  Gather information about the issue such as billing amount, date of service, etc.

otherwise

  Store notes about the issue in RTF format

The problem is that right now I need to determine if the item is a billing issue. I can see later on the client wanting code to take action based on different codes.

The question is what's the best to set up the data so that I can code a CASE statement later? I could use a code in the table, but this doesn't seem like the best approach. Anyone have other ideas?