[Op-torch-devel] code searches

[Michael A R. M. <mi...@we...>]

Ok, some thoughts about code searches.

Currenlty, I have the system set up to search an postgreSQL database  
for ICD9 Codes, and am considering adding the same types of tables  
for CPT and HCPCS codes, and then save the codes to a CPT folder  
object in the encounters.  These billing_code objects will then  
search a formulary for an amount, and create a charge object inside  
the billing_code object, this way our code - charge relations are safe.

Now, my question is, is it better to keep the codes in the sql db, or  
create a couple thousand cpt and hcpcs codes in the torchadmin folder.

I am leaning to keeping the codes in the sql db.

Next question, is how to keep the fee schedules straight.

we will have a default fee schedule, kept in the facility object,  
which will be a table of codes and fee's.  For me logically this is  
easier to make a zope object, yeah, I know, that makes no sense.

Ok, FeeSchedule object:
	containes a list of codes with associated charges.
	For now I am envisioning this as a simple dictionary of fee:charges.

I suppose I could do the same thing for the icd9 codes, and others..

ICD9:
	version = '2006'
	codes = {code :{short: shortdescription, long:longdescription},
					... }

hmm, interesting idea.  I am hesitant to create a bunch of codes, and  
this seems like a do-able idea.
ya got to love stream of conciousness messages. ;)


Thoughts please.

Michael