"Diagnosis" Report

[tag701]

We are trying to "audit" our glaucoma patients to make sure that everyone has an appointment when they should.  I've tried the Correspondence Report but I don't want to have to do each glaucoma Dx separately (too many!!).  I tried the Diagnosis Report but that just doesn't seem to work too well because as you drill down to the patient name it doesn't even have the Dx code on the top of the report so printing it is kind of useless.

For the time being we are using the Diagnosis Report, drilling down to the patient names for each Dx, printing to file and then copy/paste to make one big spreadsheet.  I'm assuming that is the best we are going to get but I was just curious if anyone had anything else.  Thanks!

[KizerOpt]

so what if you add a field in the medical record for 'glaucoma' and use that field number in the Correspondence report to pull a list? You would get all patients with that field checked (yes). You'd just need to make sure to mark it in each patient record. Other than that, whatever you do is a workaround. There is no such thing as 'and', or 'or', or 'from' 'to' in the report.

Karen

[friscoeyeassociates]

I think you can search more than one Diag Code at a time on the Correspondence Report as long as separated by a comma... Why not have a notepad saved on your desktop with all of the Glaucoma Diag codes typed out and separated by a comma. Copy and Paste the list of codes anytime you wanted to run that Correspondence Report.. I would also un check the "has future appointment" option and choose "No" as well so the report pulls only patients without a future appointment since they are the only ones needing to schedule. 

Also you could just copy the list of Glauc Codes I have below to use if you want. I think I have most of them, but you can add and take away whatever you would like. 



H40.,H40.0,H40.00,H40.001,H40.002,H40.003,H40.009,H40.01,H40.011,H40.012,H40.013,H40.019,H40.02,H40.021,H40.022,H40.023,H40.029,H40.03,H40.031,H40.032,H40.033,H40.039,H40.04,H40.041,H40.042,H40.043,H40.049,H40.05,H40.051,H40.052,H40.053,H40.059,H40.06,H40.061,H40.062,H40.063,H40.069,H40.1,H40.10,H40.10X0,H40.10X1,H40.10X2,H40.10X3,H40.10X4,H40.11,H40.11X0,H40.11X1,H40.11X2,H40.11X3,H40.11X4,H40.12,H40.121,H40.1210,H40.1211,H40.1212,H40.1213,H40.1214,H40.122,H40.1220,H40.1221,H40.1222,H40.1223,H40.1224,H40.123,H40.1230,H40.1231,H40.1232,H40.1233,H40.1234,H40.129,H40.1290,H40.1291,H40.1292,H40.1293,H40.1294,H40.13,H40.131,H40.1310,H40.1311,H40.1312,H40.1313,H40.1314,H40.132,H40.1320,H40.1321,H40.1322,H40.1323,H40.1324,H40.133,H40.1330,H40.1331,H40.1332,H40.1333,H40.1334,H40.139,H40.1390,H40.1391,H40.1392,H40.1393,H40.1394,H40.14,H40.141,H40.1410,H40.1411,H40.1412,H40.1413,H40.1414,H40.142,H40.1420,H40.1421,H40.1422,H40.1423,H40.1424,H40.143,H40.1430,H40.1431,H40.1432,H40.1433,H40.1434,H40.149,H40.1490,H40.1491,H40.1492,H40.1493,H40.1494,H40.15,H40.151,H40.152,H40.153,H40.159,H40.2,H40.20,H40.20X0,H40.20X1,H40.20X2,H40.20X3,H40.20X4,H40.21,H40.211,H40.212,H40.213,H40.219,H40.22,H40.221,H40.2210,H40.2211,H40.2212,H40.2213,H40.2214,H40.222,H40.2220,H40.2221,H40.2222,H40.2223,H40.2224,H40.223,H40.2230,H40.2231,H40.2232,H40.2233,H40.2234,H40.229,H40.2290,H40.2291,H40.2292,H40.2293,H40.2294,H40.23,H40.231,H40.232,H40.233,H40.239,H40.24,H40.241,H40.242,H40.243,H40.249,H40.3,H40.30,H40.30X0,H40.30X1,H40.30X2,H40.30X3,H40.30X4,H40.31,H40.31X0,H40.31X1,H40.31X2,H40.31X3,H40.31X4,H40.32,H40.32X0,H40.32X1,H40.32X2,H40.32X3,H40.32X4,H40.33,H40.33X0,H40.33X1,H40.33X2,H40.33X3,H40.33X4,H40.4,H40.40,H40.40X0,H40.40X1,H40.40X2,H40.40X3,H40.40X4,H40.41,H40.41X0,H40.41X1,H40.41X2,H40.41X3,H40.41X4,H40.42,H40.42X0,H40.42X1,H40.42X2,H40.42X3,H40.42X4,H40.43,H40.43X0,H40.43X1,H40.43X2,H40.43X3,H40.43X4,H40.5,H40.50,H40.50X0,H40.50X1,H40.50X2,H40.50X3,H40.50X4,H40.51,H40.51X0,H40.51X1,H40.51X2,H40.51X3,H40.51X4,H40.52,H40.52X0,H40.52X1,H40.52X2,H40.52X3,H40.52X4,H40.53,H40.53X0,H40.53X1,H40.53X2,H40.53X3,H40.53X4,H40.6,H40.60,H40.60X0,H40.60X1,H40.60X2,H40.60X3,H40.60X4,H40.61,H40.61X0,H40.61X1,H40.61X2,H40.61X3,H40.61X4,H40.62,H40.62X0,H40.62X1,H40.62X2,H40.62X3,H40.62X4,H40.63,H40.63X0,H40.63X1,H40.63X2,H40.63X3,H40.63X4,H40.8,H40.81,H40.811,H40.812,H40.813,H40.819,H40.82,H40.821,H40.822,H40.823,H40.829,H40.83,H40.831,H40.832,H40.833,H40.839,H40.89,H40.9,H42.

[tag701]

Thank you guys! Those are both great ideas. I will try them. Thank you!!!

[KizerOpt]

I believe in Crystal, the comma and list does a search for each record with all the parameters, which brings up nothing. I tested it again with a quick search of myopia and astigmatism codes and it returned nothing. Have you had success with the list method, Frisco?

Karen

[friscoeyeassociates]

I believe it depends on where in the Correspondence Report you are searching... If you are searching the records tab then yes you can only search for one. However if you are searching on the billing tab of the report you can put in the list of codes and it will find any invoice created in that time period with any of the diag codes you listed.

Photo for reference

[KizerOpt]

May 18, 2016 10:21:46 GMT -6 friscoeyeassociates said:

I believe it depends on where in the Correspondence Report you are searching... If you are searching the records tab then yes you can only search for one. However if you are searching on the billing tab of the report you can put in the list of codes and it will find any invoice created in that time period with any of the diag codes you listed.

Photo for reference

Good tip, thanks!