Hello,
I want to apologize in advance if these questions have been asked already. I have been searching the forum but didn't see much about this.
I am new to Centricity and am trying to find any information I can about the system we use for billing here. It is Centricity Business v5.3 and I'm looking for any information such as a data dictionary or examples of SQL or Crystal Reports built off this database.
I've seen several SQL queries here but I don't have the same tables. The majority of the tables start with "dim." (Example dim.patient or dim.diagnosis). I don't have a patient profile table like in the examples I've seen here and I can't seem to determine what the foreign keys are to link tables, like to determine what patients are linked to what diagnosis.
I have been searching the forums, the database itself, and online but perhaps I'm not asking the right question. Does anyone have any experience with reporting on Centricity Business (as it seems there are several versions of "Centricity")?
Thanks so much in advance for any guidance or advice. I really appreciate it!