Much of the disjointed nature of those tables stems from the early days of DHCP (the acronym before it was called VistA) before there was formal Database Administration. Medical Center Division was created by the Registration developers. The Institution file was created by Kernel developers. Facility was created by Oncology developers. Division was created by Engineering developers. And Hospital Location was created by Scheduling developers. At least the Medical Center Division file has a direct association with the official entry or entries in the Institution file.
I would guess that the Facility file is used for oncology reporting purposes. Institution is actually a rather broad category that can include more than hospitals and clinics. There may be labs and many other kinds of organizational institutions in the file. The Medical Center Division is primarily the set of "parameters" for how a division operates with regard to registration and administration purposes. Hospital Locations are indeed subordinate to a medical center division (one institution may be one or more divisions). The three fields you mention are indeed specific to VA reporting requirements. Cameron Schlehuber -----Original Message----- From: Wasif Toor In order to create a "Hospital" in VistA one comes across following designated entities: Medical Center Institute Facility (This file contains the list of all US Hospitals - 5861 entries) Division (Medical Center Division) Hospital Location (Wards, Clinics, Labs) Question: What is the exact purpose of having the whole list of hospitals in the FACILITY file? We assume that MEDICAL CENTER & INSTITUTE are interchangeable terms for a Hospital Question: Is the above assumption correct? While creating a hospital, we adhere to the following hierarchy: Institute/Medical Center = (Hospital) Division Hospital Location Question: Is the above hierarchy valid? During Admission, we come across the following fields: Admitting Regulation Type of Admission Facility Treating Speciality These entries available in these fields seem to be appropriate from VA point of view. Question: Are there any dependencies on the above data sets, or are these just labels to the record? Can we add or delete them without worrying about their dependencies? ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members