HIMSS Data dictionary - onetomapanalytics/Meta_Data GitHub Wiki

HIMSS - Data dictionary

Tables description:

Table Name	Description	Links
AcuteInfo	This table contains statistic and summary information about the hospitals (acute care facilities) in the database.	This table links to the other tables by the HAEntityID
AppVendorPlan	This table contains a list of the vendors under consideration for purchase for the applications tracked.	This table links to the HAEntityApplicationPlan table by AppID
AutoIdentification	High level information about the use of bar coding and RFID by department	This table links to the other tables by the HAEntityID
AutoIdentificationProduct	This table provides information about the vendors and products used for printing and scanning technology for bar coding in specific departments.	This table links to the other tables by the HAEntityID
BarcordingDetails	This table contains information on break milk administration,k specimen collection and transfusion verification data located.	This table links to the other tables by the HAEntityID
BiometricTechnology	This table contains information on the status of Biometric technology at the hospitals.	This table links to the other tables by the HAEntityID
CDSS	This table contains the components of a Clinical Decision Support System (CDSS)	This table links to the other tables by HAEntityID
Computer	This table contains information on the use of computers such as desktops, laptops, thin clients PC blades.	This table links to the other tables by the HAEntityID
Connectivity	This table contains information on the status of the hospitals connectivity.	This table links to the other tables by the HAEntityID
Contact	This table is a duplicate free list of the contacts at all the facilities in the database.	This table links to the HAEntityContact table by ContactID
ContactSource	This table is a code table for the functions a contact fills.	This tables links to the HAEntityContact table by HAEntityContactSourceID to ContactSourceID
ContactType	This table is a code table for the type of contact an individual fills such as Key Personnel, HIPPA Security, Steering Committee, etc.	This table links to the HAEntityContact table by TypeID
DataCenterApplication	This table list the applications that the data center is running	This table links to the other tables by HAEntityID
DataCenterFacility	This table establishes the link between data centers and the facilities they service.	This table links to the HAEntity table either by ParentID (data center's HAEntityID) or HAEntityID (facilities HAEntityID)
DisasterRecoveryPlan	This table provides information on the types of facilities that are included in the system's disaster recovery plan.	This table links to the other tables by the HAEntityID
DistributionPlan	This table provides information on how the hospital distributes and physicians access softcopy images in the radiology and cardiology departments.	This table links to the other tables by the HAEntityID
EMRAM_StageSeven	This table provides the UniqueId of all the Validated Stage 7 Hospital's	This table links to the HAEntity table by the UniqueId. See HAEntity Table to see how HAEntity Links to other Tables.
ExpeditureApproval	This table provides information regarding the expenditure approval process at the integrated delivery system.	This table links to the other tables by the HAEntityID
HAEntity	This table contains the demographic information for all the facilities and systems tracked in the database. (This is a self referencing table).	This table links to the other tables by the HAEntityID. This table also links to itself by HAEntityID to ParentID. The table linked by HAEntityID will pull the IDS information and the table linked by ParentID will pull the facility information.
HAEntityApplication	This table contains the automation information for all the facilities in the database.	This table links to the other tables by the HAEntityID. This table also links to the HAEntityApplicationPlan table by ApplicationId or Application.
HAEntityApplicationCharacteristics	This table contains information on transaction standards for EDI, where medical necessity checking is used and the departments where document management and electronic forms are being used.	This table links to the other tables by the HAEntityID. This table also links to the HAEntityApplication table by the AppID.
HAEntityApplicationFunction	This table contains information on the functionality of the Ambulatory EMR. This is Ambulatory facility-specific data.	This table links to the other tables by the HAEntityID.
HAEntityApplicationPlan	This table contains the plan details for the applications tracked in the HAEntityApplication table.	This table links to the other tables by the HAEntityID. This table also links to the HAEntityApplication table by ApplicationId or Application.
HAEntityContact	This is an index table that links contact information to facility and IDS demographic information in other tables. This table includes the status of the contact type.	This table links to the Contact table by ContactID (to include names), to the Contact Source table by HAEntityContactSourceID to ContactSourceID (to determine functions) and to the Contact Type table by TypeID (to included contact type information) as well as to the HAEntity table by HAEntityID (to include demographic details)
HAEntityHistory	This table provides information on the construction, divestiture, merger and acquisitions that have occurred at the system.	This table links to the HAEntity table by HAEntityId and SurveyId
HAEntityRegion	This table provides information regarding the regions or areas a health system provides services to.	This table links to the other tables by the HAEntityID
HandheldInfo	This table provides information on how and where handheld devices are used at a hospital.	This table links to the other tables by the HAEntityID
HardwareInfo	This table provides information on the use of Smartphones and Workstation on Wheels (WOW).	This table links to the other tables by the HAEntityID
HostedSoftware	This table lists the software vendors the remote hosted company is supporting.	This table links to other tables by the HAEntityID. This table also links to the Service table by the ServiceID.
IEInitiatives	This table provides the Name of Information Exchange Initiative The facility participates in.	This table links to the other tables by the HAEntityID
IHDSChanges	This table is designed to provide insight into changes made to the IHDSs in the database. Included in this table are any IHDSs that have been deleted or added to the HIMSS Analytics Database.	This table links to the HAEntity table by SurveyId
ISPlan	This table provides information on what areas the IS Strategic plan addresses at the system.	This table links to the other tables by the HAEntityID
ISPlanDecision	This table provides information on the facilities that drive the IS Strategic plan.	This table links to the other tables by the HAEntityID
LongTermStorage	This table provides information on the types and status of general long term storage used and the vendors who provide this technology to the hospitals.	This table links to the other tables by the HAEntityID
MedAdministration	This table provides information on the elements that are bar coded or have an RFID tag for the medication administration process.	This table links to the other tables by the HAEntityID
MedicalDeviceInfo	This table contains information on the medical devices used at the hospital.	This table links to the other tables by the HAEntityID
MedicalDeviceInterface	This table contains information on the types EMR interface connections used at the hospital by medical device type.	This table links to the other tables by the HAEntityID. This table also links to the MedicalDeviceInfo table by the DeviceId.
MedicalDeviceProduct	This table provides details on the vendors and products of the medical devices used at the hospital.	This table links to the MedicalDeviceInfo table by DeviceID and HAEntityID
MedicalDeviceStrategy	This table provides information about the medical device strategies around new equipment purchases, replacement policies, and reasons for interfacing.	This table links to the other tables by the HAEntityID
PACSComponent	The tables contains information on PACS components in use and PACS component purchase plans.	This table links to the other tables by the HAEntityID
PACSInfo	The table provides an overview of PACS, including number and types of images and image distribution.	This table links to the other tables by the HAEntityID
PACSVendor	This table contains the PACS vendor, products, and number of licensed work stations.	This table links to the other tables by the HAEntityID
ParentInfo	This table contains parent level demographic information including, number and types of visits, parent financial data, date of data, sources of patient revenue, number of physicians, disaster recovery detail, IS strategic plans, and IS budget.	This table links to the other tables by ParentId or HAEntityId
Pharmacy	This tables provides an overview of the pharmacy department, including FDA bar code regulations, use and planned ADMS, Robots, and EMARs.	This table links to the other tables by the HAEntityID
PharmacyProduct	This table contains the vendor and product detail for the pharmacy department.	This table links to the other tables by the HAEntityID
PreferredSupplier	This table contains detail on preferred hardware suppliers and preferred channels for acquiring hardware from those vendors	This table links to the other tables by the HAEntityID
ProductHistory	This table provides by ProductID the history of a product appearing in the database. These changes include name changes, company mergers and product acquisitions.	This table links to the VendorHistory table by PreviousName
PurchasingOrganization	This table lists the GPOs that parent or hospital (2008) organizations are members of.	This table links to the other tables by the HAEntityID
SecuritySoftware	This tables lists the security systems in place at the organizations	This table links to the other tables by the HAEntityID
Server	This table contains information on the use of servers such as mainframes, application servers, and network servers, including types, vendors and products, numbers in use, and numbers planned.	This table links to the other tables by the HAEntityID
Service	This table contains detail on consultants and outsourcers in use or planned, including the service, the supplier, and the contract date and length.	This table links to the other tables by the HAEntityID
Survey	This table identifies the year the system's interview was completed.	This table links to the other tables by the SurveyId.
SurveySegment	This table identifies the segment that the survey in.	This table links to the other tables by the SurveyId.
TelecomInfo	This table provides the In use and Plan information for Telecommunication.	This table links to the other tables by the HAEntityID
Telecommunication	This table contains the vendors used for long distance and network voice and data telecommunications services.	This table links to the other tables by the HAEntityID
UseOfITComponent	This table contains detail on the types of IT components used by physicians, what percentage of physicians use those components, and whether the components are accessible via a physician dashboard	This table links to the other tables by the HAEntityID
VendorHistory	This table provides by VendorID the history of a product appearing in the database. These changes include name changes, company mergers and product acquisitions.	This table links to the AppVendorPlan, Computer, Connectivity, LongTermStorage, PACSVendor, PharmacyProduct, PreferredSupplier, ProductHistory, Server, Service, Telecommunication, and WirelessVendor by VendorID. This table can also be linked to the HAEntityApplication table by VendorId to the SoftwareVendorId.
Wireless	This table contains an overview of the wireless environment, including WLAN use and plans, 802.11 standards planned and in use, WLAN types, number of access points planned and in use, number and types of devices on WLAN, percent using WLAN, percent using handhelds, where wireless access is in use and planned, and how wireless is used or will be used.	This table links to the other tables by the HAEntityID
WirelessAccess	This table list the departments where wireless devices are in use.	This table links to the other tables by the HAEntityID
WirelessVendor	This table lists the vendors and products in use for the various types of wireless technology.	This table links to the other tables by the HAEntityID

Element list by table:

Table Name	Field Name	SQL Data Type	Access Data Type	Description
AcuteInfo	AcuteId	int	Number/Long Integer	Record identification number
AcuteInfo	AHAAdmissions	int	Number/Long Integer	"Number of Admissions which includes the number of adult and pediatric admissions only (excluding
births). This number includes all patients admitted during the a 12-month
reporting period, including neonatal and swing admissions."
AcuteInfo	CapitalExpense	int	Number/Long Integer	Equipment, building, project or software expenses that will be recognized over more than one accounting year, excluding outlay for operation or maintenance
AcuteInfo	CCD_Transaction	bit	Yes/No	Yes = the hospital is using HL7 CCD (continuum of care document) transactions to share patient data with other organizations?
AcuteInfo	CDSSDataIntegrated	bit	Yes/No	Yes = the medical content data is integrated into workflow applications as clinical decision support tools or decision alerts for clinicians
AcuteInfo	CIOBiometricalOper	bit	Yes/No	Yes = the hospital CIO has responsibility for Biomedical Operations
AcuteInfo	CIOHIM	bit	Yes/No	Yes = the hospital CIO has responsibility for Health Information Management (HIM)
AcuteInfo	CIOTelecommunications	bit	Yes/No	Yes = the hospital CIO has responsibility for Telecommunications
AcuteInfo	ClinicalEngOutsourced	bit	Yes/No	Yes = the hospital outsources Biomedical/Clinical Engineering
AcuteInfo	ClinicalEngReportOther	varchar	Text	Description of other departments to which the outsourced firm or in-house biomedical/clinical engineering department reports
AcuteInfo	ClinicalEngReportTo	int	Number/Long Integer	Identification number for the department to which the outsourced firm or in-house biomedical/clinical engineering department reports
AcuteInfo	ClinicalEngReportToDept	varchar	Text	Description of the department to which the outsourced firm or in-house biomedical/clinical engineering department reports (See Tab BB)
AcuteInfo	ClosedLoop	bit	Yes/No	Yes=doing closed-loop medication administration at the point of care
AcuteInfo	CMSAttestationMU1	bit	Yes/No	This is a flag populated to indicate an organization has attested to meeting the Stage 1 Meaningful Use requriements.
AcuteInfo	ConsumerDashboard	bit	Yes/No	Yes = the hospital utilizes a consumer dashboard
AcuteInfo	CPOEAffiliatedPhPerc	varchar	Text	The percentage of affiliated physicians using the CPOE system
AcuteInfo	CPOEEmergencyDept	bit	Yes/No	Yes= the CPOE system is used in the emergency department
AcuteInfo	CPOEHospitalsPerc	varchar	Text	The percentage of hospitalists using the CPOE system
AcuteInfo	CPOEInpatient	bit	Yes/No	Yes= the CPOE system is used in the inpatient setting
AcuteInfo	CPOEMandated	bit	Yes/No	Yes = healthcare system mandated that physicians utilize CPOE system
AcuteInfo	CPOEOtherFTPhPerc	varchar	Text	The percentage of other physicians using the CPOE system
AcuteInfo	CPOEPhysicianPerc			The percentage range of all medical orders entered by physicians using CPOE (see tab AS-Perc Ranges)
AcuteInfo	CPOEResidentsPerc	varchar	Text	The percentage of residents using the CPOE system
AcuteInfo	CPOEWhenOwnOrders	varchar	Text	The time frame for all physicians to be entering all orders into the CPOE system (see tab F-CPOEOwnOrdersTimeFrames)
AcuteInfo	Depreciation	int	Number/Long Integer	This year's recognized portion of the capital investment expenses from years past
AcuteInfo	ElectronicMedRecPerc	varchar	Text	The percent range of the hospital's current medical record that is electronic (includes digital and/or scanned data) (see tab AS-Perc Ranges)
AcuteInfo	FEEH	int	Yes/No	Yes = The Hospital has an equity interest in Indemnity Fee for Service Plan
AcuteInfo	FEEN	int	Yes/No	Yes = The Hospital's Health Network has an equity interest in Indemnity Fee for Service Plan
AcuteInfo	FEES	int	Yes/No	Yes = the Hospital's Health System has an equity interest in Indemnity Fee for Service Plan
AcuteInfo	FEEV	int	Yes/No	Yes = The Hospital's Joint Venture with Insure has an equity interest in Indemnity Fee for Service Plan
AcuteInfo	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
AcuteInfo	HMOH	int	Yes/No	Yes = The Hospital has an equity interest in Health Maintenance Organization
AcuteInfo	HMON	int	Yes/No	Yes = The Hospital's Health Network has an equity interest in Health Maintenance Organization
AcuteInfo	HMOS	int	Yes/No	Yes = The Hospital's Health System has an equity interest in Health Maintenance Organization
AcuteInfo	HMOV	int	Yes/No	Yes = The Hospital's Joint Venture with Insure has an equity interest in Health Maintenance Organization
AcuteInfo	IEInitiative	bit	Yes/No	Yes = the hospital participates in an Information Exchange Imitative(s)
AcuteInfo	IEInitiativePlan	bit	Yes/No	Yes = the hospital plans to participate in an Information Exchange Imitative(s)
AcuteInfo	IsAttachmentRules	bit	Yes/No	Yes = that claims attachment rules are available to identify claims the require additional clinical information before being transmitted to the payer
AcuteInfo	IsBiometric	bit	Yes/No	Yes = the hospital uses biometric technology for security
AcuteInfo	IsBiometricPlan	bit	Yes/No	Yes = the hospital plans to purchase/use biometric technology for security
AcuteInfo	ISBudget	decimal	Number/Decimal	The total amount budgeted by the IS department at the Acute-Care Hospital for the current fiscal year end. This amount includes all operating expenses. It is the IS department operating expense as a percent of total operating expense at the acute-care level.
AcuteInfo	IsClaimsRemittance	bit	Yes/No	Yes = claims remittance transactions are received directly from the payer and the AR system is automatically updated with no clearinghouse involved
AcuteInfo	IsDashBoard	bit	Yes/No	Yes = the biller has a dashboard for the business office on which rejected claims can be edited and resubmitted and updates to the files used to create the bills are triggered by the editing process
AcuteInfo	IsEFTTransaction	bit	Yes/No	Yes = electronic funds transactions are submitted directly to the hospital's bank by the payer with no clearinghouse involved
AcuteInfo	IsEligibilityTransaction	bit	Yes/No	Yes = eligibility and authorization transactions are executed directly with the payer with no clearinghouse involved
AcuteInfo	IsEMRDocumentation	bit	Yes/No	Yes = bill can be created from the encoded clinical documentation of the EMR and no intervention from the HIM department is required
AcuteInfo	IsIdentifyRules	bit	Yes/No	Yes = that pended or rejected claims are identified and rules can be created to ensure future claims are not pended or rejected for the same reason
AcuteInfo	IsInterfacingMedicalDevice	bit	Yes/No	Yes = the hospital is interfacing its medical devices
AcuteInfo	IsPayerSubmitted	bit	Yes/No	Yes = claims are submitted directly to the payer with no clearinghouse involved
AcuteInfo	LastMonthFiscalYear	int	Number/Long Integer	The month of the year that the Acute-Care Hospital fiscal year closes
AcuteInfo	Magnet	bit	Yes/No	Yes = Magnet hospital
AcuteInfo	MedDevCapExpenseLFYear	int	Number/Double	The Capital Expense for acquiring or replacing medical devices in your most recent fiscal year end
AcuteInfo	MedDevInterfaceOther	varchar	Text	Description of other departments supporting interfacing for general biomedical/clinical engineering
AcuteInfo	MedDevInterfaceSupport	int	Number/Long Integer	Identification number for the department supporting interfacing for general biomedical/clinical engineering (See Tab BC-MedDeviceInterfaceDept)
AcuteInfo	MedDevOpExpenseLFYear	int	Number/Double	The Operating budget for supporting and maintaining medical devices in your most recent fiscal year end
AcuteInfo	NetOperRevenue	float	Number/Double	Net operating revenue includes revenues associated with the main operations of the hospital (net inpatient+ net out patient revenue). It does not include dividends, interest income or non-operating income.
AcuteInfo	NetPatientRevenue	float	Number/Long Integer	"Net Patient Revenue in hospitals, is gross inpatient revenue plus gross outpatient revenue minus related deductions from revenue.
"
AcuteInfo	NofAdjDischarge	int	Number/Long Integer	Adjusted discharges recognizes outpatient utilization. This is accomplished by dividing gross revenue by gross inpatient revenue, which will usually result in a factor greater than 1.0, unless there was no outpatient revenue. You adjust the discharges by multiplying this factor by the number of discharges.
AcuteInfo	NofAdjPatientDays	int	Number/Long Integer	Inpatient days plus equivalent inpatient days attributed to outpatient services. Equivalent inpatient days are calculated by multiplying inpatient days by the ratio of total revenue to inpatient revenue.
AcuteInfo	NofBirths	int	Number/Long Integer	Number of births at each Acute-Care Hospital in the most recent fiscal year
AcuteInfo	NofEmergRoomVisits	int	Number/Long Integer	Number of emergency room visits at each Acute-Care Hospital in the most recent fiscal year
AcuteInfo	NofNurses	int	Number/Long Integer	Number of nurses at the acute care hospital
AcuteInfo	NofOperatingRooms	int	Number/Long Integer	Number of operating rooms at each Acute-Care Hospital
AcuteInfo	NofOutpatientVisits	int	Number/Long Integer	Number of outpatient visits at each Acute-Care Hospital in the most recent fiscal year.
AcuteInfo	NofSurgicalOperations	int	Number/Long Integer	Number of inpatient and outpatient surgical operations
AcuteInfo	NofTotDischarge	int	Number/Long Integer	The total number of patients discharged from the hospital in a calendar year
AcuteInfo	NofTotPatientDays	int	Number/Long Integer	The number of calendar days of care provided for hospital inpatient treatment under the terms of the patient’s health plan, excluding the day of discharge
AcuteInfo	NurseDocUsePerc	varchar	Text	Percentage of nurses using the nursing documentation system (see tab AS-Perc Ranges)
AcuteInfo	ObstetricalCareLevel	int	Number/Long Integer	Obstetrical Level a hospital is equipped to provide for comprehensive emergency medical services to patients suffering traumatic injuries
AcuteInfo	OrgControlDetail	varchar	Text	Indicates the detail of the specific type of organization control that is responsible for establishing policy for operation of the hospital.
AcuteInfo	OrgControlOverall	varchar	Text	Indicates the overall type of organization that is responsible for establishing policy for overall operation of the hospital. (see tab K - Org Control)
AcuteInfo	PayrollExpense	float	Number/Double	Payroll expense for a 12-month period, this includes all salaries and wage expenses.
AcuteInfo	PhysDocUsePerc	varchar	Text	Percentage of physicians using the physician documentation system (see tab AS-Perc Ranges)
AcuteInfo	PPOH	int	Yes/No	Yes = The Hospital has an equity interest in Preferred Provider Organization
AcuteInfo	PPON	int	Yes/No	Yes = the Hospital's Health Network has an equity interest in Preferred Provider Organization
AcuteInfo	PPOS	int	Yes/No	Yes = The hospital's Health System has an equity interest in Preferred Provider Organization
AcuteInfo	PPOV	int	Yes/No	Yes = The Hospital's Joint Venture with Insure has an equity interest in Preferred Provider Organization
AcuteInfo	PublishedCMSAttestationMU1	datetime	Date/Time	This is the date that the organizations attestation to meeting the Stage 1 Meaningful Use requriements was published by CMS.
AcuteInfo	RevManagedCare	int	Number/Long Integer	Percent of Managed Care that makes up the patient revenue at the hospital
AcuteInfo	RevMedicaid	int	Number/Long Integer	Percent of Medicaid that makes up the patient revenue at the hospital
AcuteInfo	RevMedicare	int	Number/Long Integer	Percent of Medicare that makes up the patient revenue at the hospital
AcuteInfo	RevOther	int	Number/Long Integer	Additional information on the patient revenue breakdown at the hospital
AcuteInfo	RevTradComm	int	Number/Long Integer	Percent of traditional commercial insurance that makes up the patient revenue at the hospital
AcuteInfo	StageValidation	bit	Yes/No	Yes = the hospital has been validated as a Stage 6 or 7
AcuteInfo	StructuredPhysDocPerc	varchar	Text	The percent range of physician documentation that is captured from structured template documentation solutions (see tab AS-Perc Ranges)
AcuteInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
AcuteInfo	TotalOperExpense	float	Number/Double	The total amount of money the Acute-Care Hospital spends on operations such as staffing, property expenses, etc. for the most recent fiscal year.
AcuteInfo	TranscriptionFTE	decimal	Number/Decimal	Number of transcription full-time equivalents
AcuteInfo	TranscriptionLines	int	Number/Long Integer	Number of lines transcribed
AcuteInfo	TraumaLevel	int	Number/Long Integer	Trauma Level a hospital is equipped to provide for comprehensive emergency medical services to patients suffering traumatic injuries (see tab S- Trauma Level)
AppVendorPlan	AppId	int	Number/Long Integer	Identification number for applications with software purchase plan. Use this field to link to the HAEntityApplicationPlan table.
AppVendorPlan	Id	int	Number/Long Integer	Record identification number
AppVendorPlan	ProductId	int	Number/Long Integer	Unique identification number for product
AppVendorPlan	ProductName	varchar	Text	The software product being considered for purchase
AppVendorPlan	VendorId	int	Number/Long Integer	Unique identification number for vendor
AppVendorPlan	VendorName	varchar	Text	The software vendor being considered for purchase
AutoIdentification	DepartmentId	int	Number/Long Integer	Identification number of the department type
AutoIdentification	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
AutoIdentification	InUseFlag	bit	Yes/No	Yes = the hospital utilizes bar coding, RFID or bar coding/RFID
AutoIdentification	PlanFlag	bit	Yes/No	Yes = the hospital plans to use bar coding, RFID or bar coding/RFID
AutoIdentification	SurveyId	int	Number/Long Integer	Identification number assigned to survey
AutoIdentification	Timeframe	varchar	Text	The timeframe for purchasing bar coding, RFID or bar coding/RFID
AutoIdentification	Type	varchar	Text	Type of autoidentification (see tab AT-AutoID Type)
AutoIdentificationProduct	Category	varchar	Text	The type of bar coding equipment (See tab B-Category)
AutoIdentificationProduct	Department	varchar	Text	The department where bar coding, RFID, or bar coding/RFID is being used.
AutoIdentificationProduct	DepartmentId	int	Number/Long Integer	Identification number of the department type
AutoIdentificationProduct	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
AutoIdentificationProduct	ProductId	int	Number/Long Integer	Identification number for product
AutoIdentificationProduct	ProductName	varchar	Text	The product name for bar coding, RFID, bar coding/RFID equipment
AutoIdentificationProduct	Status	varchar	Text	Status of the bar coding, RFID, bar coding/RFID equipment
AutoIdentificationProduct	SurveyId	int	Number/Long Integer	Identification number assigned to survey
AutoIdentificationProduct	Type	varchar	Text	Type of autoidentification (see tab AR- AutoId Time Frame )
AutoIdentificationProduct	VendorId	int	Number/Long Integer	Identification number for vendor
AutoIdentificationProduct	VendorName	varchar	Text	The vendor name for bar coding, RFID, bar coding/RFID equipment
BarcodingDetails	BarcodingDetailsId	int	Number/Long Integer	Record identification number
BarcodingDetails	SurveyId	int	Number/Long Integer	Identification number assigned to survey
BarcodingDetails	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
BarcodingDetails	DepartmentId	int	Number/Long Integer	Identification number associated with Department
BarcodingDetails	DepartmentName	varchar	Text	Name of Department
BarcodingDetails	ProcessId	int	Number/Long Integer	Identification number associated with how bar coding is used
BarcodingDetails	ProcessName	varchar	Text	Description of how bar coding is used.
BiometricTechnology	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
BiometricTechnology	Id	int	Number/Long Integer	Record identification number
BiometricTechnology	SurveyId	int	Number/Long Integer	Identification number assigned to survey
BiometricTechnology	TechnologyId	int	Number/Long Integer	Identification number for biometric technology type used
BiometricTechnology	TechnologyName	varchar	Text	The type of biometric technology used (See tab C-Biometric Tech)
BiometricTechnology	Type	varchar	Text	The status of the use of the biometric technology (i.e. current or plan)
CDSS	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
CDSS	ID	int	Number/Long Integer	Record identification number
CDSS	ProcessDesc	varchar	Text	Components of a Clinical Decisions Support System (CDSS) (see tab AX- ProcessDesc)
CDSS	ProcessID	int	Number/Long Integer	Identification number associated with the components of the Clinical Decision Support System (CDSS)
CDSS	SurveyId	int	Number/Long Integer	Identification number assigned to survey
CDSS	VendorId	int	Number/Long Integer	Unique identification number for vendor
CDSS	VendorName	varchar	Text	Name of the software vendor utilized
Computer	ComputerType	varchar	Text	Type of Computer (see tab D-ComputerTypes)
Computer	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Computer	HowManyPlanned	int	Number/Long Integer	Number of Units Planned
Computer	Id	int	Number/Long Integer	Record identification number
Computer	InUse	bit	Yes/No	Yes = the hospitals is using the specified vendor currently
Computer	NofComputers	int	Number/Long Integer	Number of Units in Use
Computer	OperatingSystem	varchar	Text	Name of the operating system the computers run on
Computer	Planned	bit	Yes/No	Yes/No Field indicating Computer purchase plans
Computer	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Computer	VendorId	int	Number/Long Integer	Record identification number
Computer	VendorName	varchar	Text	Name of Computer Vendor
Connectivity	Category	varchar	Text	Further Detail on Connectivity Type (See tab E-Connectivity Types)
Connectivity	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Connectivity	Id	int	Number/Long Integer	Record identification number
Connectivity	PlanTerm	varchar	Text	Planned timeframe to purchase Broadband services (See tab A-Plan Timeframes)
Connectivity	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Connectivity	Type	varchar	Text	Type of Connectivity (See tab E-Connectivity Types)
Connectivity	UsePlan	varchar	Text	Indicated current or planned use
Connectivity	VendorId	int	Number/Long Integer	Unique identification number for vendor
Connectivity	VendorName	varchar	Text	Name of Connectivity Vendor
Contact	ContactId	int	Number/Long Integer	Unique identification number for contact. This number changes from year to year.
Contact	Credentials	varchar	Text	Contact's Credentials (See tab H-Credentials)
Contact	Email	varchar	Text	Contact’s Email Address
Contact	Ext	varchar	Text	Contact's Phone Extension
Contact	FirstName	varchar	Text	Contact’s First Name
Contact	LastName	varchar	Text	Contact’s Last Name
Contact	MiddleInitial	varchar	Text	Contact’s Middle Initial
Contact	ParentId	int	Number/Long Integer	Parent Entity identification number for the contact
Contact	Phone	varchar	Text	Contact’s Phone
Contact	Salutation	varchar	Text	Contact’s Salutation
Contact	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Contact	Title	varchar	Text	Contact’s Title
Contact	UniqueId	int	Number/Long Integer	Fixed unique identifier for the contact. This number will not change from year to year.
ContactSource	ContactSourceId	int	Number/Long Integer	Identification number of the position
ContactSource	Name	varchar	Text	The name of the position function (See tab I-Contact Sources)
ContactType	Name	varchar	Text	The name of the type of contact (See tab J-Contact Types)
ContactType	TypeId	int	Number/Long Integer	identification number of the contact type
DataCenterApplication	Application	varchar	Text	Software application name (See tab P-Application List)
DataCenterApplication	ApplicationId	int	Number/Long Integer	Unique identification number for application
DataCenterApplication	Category	varchar	Text	The category the software application is associated with (See table P-Application List)
DataCenterApplication	CategoryId	int	Number/Long Integer	Unique identification number for application category
DataCenterApplication	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
DataCenterApplication	Id	int	Number/Long Integer	Record identification number
DataCenterApplication	SurveyId	int	Number/Long Integer	Identification number assigned to survey
DataCenterFacility	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
DataCenterFacility	Id	int	Number/Long Integer	Record identification number
DataCenterFacility	ParentId	int	Number/Long Integer	Unique Identification number of data center
DisasterRecoveryPlan	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
DisasterRecoveryPlan	Id	int	Number/Long Integer	Record identification number
DisasterRecoveryPlan	Plan	varchar	Text	Facilities Included in Disaster Recovery Plan (See tab L-Plan Facilities)
DisasterRecoveryPlan	PlanId	int	Number/Long Integer	Identification number for type of facilities included in Disaster Recovery Plan
DisasterRecoveryPlan	PlanOther	varchar	Text	Description of Other Planned Facilities
DisasterRecoveryPlan	SurveyId	int	Number/Long Integer	Identification number assigned to survey
DistributionPlan	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
DistributionPlan	Id	int	Number/Long Integer	Record identification number
DistributionPlan	Option	varchar	Text	Options for expanding the distribution of PACS images
DistributionPlan	Other	varchar	Text	Description of Other Distribution Plans
DistributionPlan	SurveyId	int	Number/Long Integer	Identification number assigned to survey
DistributionPlan	Type	varchar	Text	Type of PACS Images, Radiology or Cardiology
EMRAM_StageSeven	UniqueId	int	Number/Long Integer	The UniqueID of the Validated Stage 7 Hospitals
ExpeditureApproval	ApprovedBy	varchar	Text	The individual or group with the authority to approve the expenditure
ExpeditureApproval	ApprovedTo	float	Number/Double	The largest amount of money the approving individual or group has the authority to approve
ExpeditureApproval	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
ExpeditureApproval	Id	int	Number/Long Integer	Record identification number
ExpeditureApproval	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntity	AcuteId	int	Number/Long Integer	For sub-acute care facilities the HAEntityID of the acute care facility that the sub-acute care facility uses the same software platform as.
HAEntity	Address1	varchar	Text	Entity's Street Address
HAEntity	Address2	varchar	Text	Additional Address Info if Necessary
HAEntity	AverageDailyCensus	int	Number/Decimal	The Average number of Home Health Visits in a day
HAEntity	CBSA	varchar	Text	Core Business Statistical Area where the Entity is located
HAEntity	City	varchar	Text	City where the Entity is located
HAEntity	DataCenterAcuteId	int	Number/Long Integer	Unique identifier of Data Center serving the Entity
HAEntity	EmailConvention	varchar	Text	Email Convention for Entity
HAEntity	EntityNo	int	Number/Long Integer	FacilityID or IDS or Independent Health SystemID from 2004
HAEntity	Fax	varchar	Text	Fax Number
HAEntity	FreeStanding	bit	Yes/No	Yes = the sub-acute care facility is not housed in another facility
HAEntity	FTEEMRSupport	int	Number/Long Integer	Number of IS FTEs that support EMR applications
HAEntity	FTEHelpDesk	decimal	Number/Decimal	Number of IS FTEs at the Help Desk
HAEntity	FTEMgmt	decimal	Number/Decimal	Number of IS FTEs in management
HAEntity	FTENetworkAdmins	decimal	Number/Decimal	Number of IS FTEs that are network administrators
HAEntity	FTEOperations	decimal	Number/Decimal	Number of IS FTEs working in operations
HAEntity	FTEOther	decimal	Number/Decimal	Number of other IS FTEs
HAEntity	FTEPCSupport	decimal	Number/Decimal	Number of IS FTEs providing PC support
HAEntity	FTEProgrammers	decimal	Number/Decimal	Number of IS FTEs that are Programmers
HAEntity	FTEProjectMgmt	decimal	Number/Decimal	Number of IS FTEs that are Project Managers.
HAEntity	FTERCMSupport	int	Number/Long Integer	Number of IS FTEs that support RCM applications
HAEntity	FTESecurity	decimal	Number/Decimal	Number of IS FTEs in IS Security
HAEntity	FTETotal	decimal	Number/Decimal	Total number of IS FTEs
HAEntity	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntity	HAEntityType	varchar	Text	Description of surveyed entity type (See tab M-Facility Types)
HAEntity	HAEntityTypeId	int	Number/Long Integer	Unique identification number associated with surveyed entity type (See tab M-Facility Types)
HAEntity	IsIDSACOClassified	bit	Yes/No	Yes = IDS is ACO Classified
HAEntity	IsIDSPCMHCertified	bit	Yes/No	Yes = IDS is PCHM Certified
HAEntity	IsIDSPlanningACO	bit	Yes/No	Yes = IDS is planning to be ACO Classified
HAEntity	IsIDSPlanningPCMH	bit	Yes/No	Yes = IDS is planning to be PCHM Certified
HAEntity	IsImaging	bit	Yes/No	Yes = the ambulatory facilities provides imaging services (sometimes in addition to the primary service offered)
HAEntity	Latitude	int	Double	Entity's Latitude
HaEntity	Longitude	int	Double	Entity's Longitude
HAEntity	MedicareNumber	varchar	Text	Medicare identification number
HAEntity	Name	varchar	Text	Entity's Name
HAEntity	NofBeds	int	Number/Long Integer	Number of Licensed Beds
HAEntity	NofFTE	decimal	Number/Decimal	Total number of FTEs
HAEntity	NofHCareVisits	int	Number/Long Integer	Number of Home Health Visits annually
HAEntity	NofIntensiveCareBeds	int	Number/Long Integer	Number of Intensive Care Beds
HAEntity	NofPhysicians	int	Number/Long Integer	Number of Physicians employed at the ambulatory
HAEntity	NofStaffedBeds	int	Number/Long Integer	Number of Beds that can be operated at present staffing levels
HAEntity	NoOfNeonatalIntensiveCareBeds	int	Number/Decimal	Number of Neonatal Intensive Care Beds
HAEntity	OwnershipStatus	varchar	Text	Ownership Status; Owned, Managed, Leased, or Affiliated
HAEntity	ParentId	int	Number/Long Integer	identification number of the IDS and Independent Health System that the facilities and data centers are associated
HAEntity	Phone	varchar	Text	Phone Number
HAEntity	PhysAffiliated	int	Number/Long Integer	Total number of physicians affiliated with the hospital through an affiliated physician organization
HAEntity	PhysFT	int	Number/Long Integer	Total number of full-time salaried physicians employed by the hospital, receiving a regular paycheck from the organization
HAEntity	PhysHospitalists	int	Number/Long Integer	Total number of hospitalists employed by the hospital who are responsible for the patient's care during the hospital stay.
HAEntity	PhysOther	int	Number/Long Integer	Additional information on the physicians at the hospital
HAEntity	PhysResidents	int	Number/Long Integer	Total number of residents at the hospital.
HAEntity	PhysTotal	int	Number/Long Integer	Total number of physicians in the hospital
HAEntity	ProfitStatus	varchar	Text	Not for Profit or Profit
HAEntity	SameISSystem	bit	Yes/No	Yes = the sub-acute care facility uses the same software platform as a hospital in the health care system
HAEntity	ServicePopulation	int	Number/Long Integer	Size of Population served by entity
HAEntity	State	varchar	Text	State where entity is located
HAEntity	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntity	Type	varchar	Text	Description of the entities primary service provided (see tab N-Facility Descriptions)
HAEntity	UniqueId	int	Number/Long Integer	Fixed unique identifier for the entity. This number will not change from year to year.
HAEntity	VendorSelStrategy	varchar	Text	Description of the facility's vendor selection strategy (See tab O-Selection Strategies)
HAEntity	Website	varchar	Text	Entity's website
HAEntity	YearFormed	int	Number/Long Integer	Year Entity Formed
HAEntity	YearOpened	int	Number/Long Integer	Year Entity was acquired
HAEntity	Zip	varchar	Text	Entity's Postal Zip Code
HAEntityApplication	AppId	int	Number/Long Integer	Record identification number
HAEntityApplication	Application	varchar	Text	Software application name (See tab P-Application List)
HAEntityApplication	ApplicationId	int	Number/Long Integer	Unique identification number for application
HAEntityApplication	Category	varchar	Text	The category the software application is associated with (See table P-Application List)
HAEntityApplication	CategoryId	int	Number/Long Integer	Unique identification number for application category
HAEntityApplication	ContractYear	int	Number/Long Integer	The year the software was contracted
HAEntityApplication	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityApplication	HardwareProductId	int	Number/Long Integer	Unique identification number for product
HAEntityApplication	HardwareProductName	varchar	Text	Hardware model running the software system
HAEntityApplication	HardwareVendorId	int	Number/Long Integer	Unique identification number for vendor
HAEntityApplication	HardwareVendorName	varchar	Text	Hardware vendor running the software system
HAEntityApplication	ImplementedMonth	int	Number/Long Integer	The month the contracted software will be implemented
HAEntityApplication	ImplementedYear	int	Number/Long Integer	The year the contracted software will be implemented
HAEntityApplication	IsAnalyzingProtocolAdherence	bit	Yes/No	Yes = Hospital is analyzing protocol adherence and effectiveness for Business Intelligence - Clinical
HAEntityApplication	IsBuildingProtocolAdherence	bit	Yes/No	Yes = Hospital is building their own clinical protocols and pathways for Business Intelligence - Clinical
HAEntityApplication	IsPlanAnalyzingProtocolAdherence	bit	Yes/No	Yes = Hospital is planning to analyzing protocol adherence and effectiveness for Business Intelligence - Clinical
HAEntityApplication	IsPlanBuildingProtocolAdherence	bit	Yes/No	Yes = Hospital is planning to build their own clinical protocols and pathways for Business Intelligence - Clinical
HAEntityApplication	IsThereUpgradePlan	bit	Yes/No	Yes = Hospital plans to upgrade their current Vendor
HAEntityApplication	ReplacementPlan	bit	Yes/No	Yes = there are plans to purchase software. Plans include both new purchases and replacements.
HAEntityApplication	SoftwareProductId	int	Number/Long Integer	Unique identification number for product
HAEntityApplication	SoftwareProductName	varchar	Text	Software vendor’s product utilized
HAEntityApplication	SoftwareVendorId	int	Number/Long Integer	Unique identification number for vendor
HAEntityApplication	SoftwareVendorName	varchar	Text	Name of the software vendor utilized
HAEntityApplication	Status	varchar	Text	Indicates the status of an application (See Q-Automation Status)
HAEntityApplication	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntityApplication	UpgradePlanTimeFrame	varchar	Text	Indicates the Plan Timeframe to upgrade their current Vendor
HAEntityApplication	UpgradePlanVersion	varchar	Text	Indicates what version of Product they are planning to upgrade to
HAEntityApplicationCharacteristics	AppId	int	Number/Long Integer	Record identification number
HAEntityApplicationCharacteristics	Characteristic	text	Text	Description of departments where document management, electronic forms, medical necessity checking, transaction standards for EDI and telemedicine is being used. (See tab AW- Characteristics)
HAEntityApplicationCharacteristics	CharacteristicID	int	Number/Long Integer	Unique identification number for characteristic
HAEntityApplicationCharacteristics	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityApplicationCharacteristics	Id	int	Number/Long Integer	Record identification number
HAEntityApplicationCharacteristics	SurveyId	int	Number/Long Integer	Record identification number
HAEntityApplicationFunction	CategoryId	int	Number/Long Integer	Identification number for the EMR Function Category
HAEntityApplicationFunction	CategoryName	text	Text	Description of Ambulatory EMR Function Category being utilized. (See Tab BA-AmbulatoryCategoryFunction)
HAEntityApplicationFunction	FunctionId	int	Number/Long Integer	Identification number for the EMR Function
HAEntityApplicationFunction	FunctionName	text	Text	Description of Ambulatory EMR Function being utilized. (See tab BA-AmbulatoryCategoryFunction)
HAEntityApplicationFunction	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityApplicationFunction	Id	int	Number/Long Integer	Record identification number
HAEntityApplicationFunction	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntityApplicationPlan	AppId	int	Number/Long Integer	identification number for applications with software purchase plan
HAEntityApplicationPlan	Application	varchar	Text	Software application name (See tab P-Application List)
HAEntityApplicationPlan	ApplicationId	int	Number/Long Integer	Unique identification number for application
HAEntityApplicationPlan	Budgeted	bit	Yes/No	Yes = the software purchase has been budgeted
HAEntityApplicationPlan	Contract	varchar	Text	The estimated timeframe the facility plans to sign a contract (See tab A-Plan Timeframe)
HAEntityApplicationPlan	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityApplicationPlan	Installation	varchar	Text	The estimated timeframe the facility plans to have completed installation of the system (See tab A-Plan Timeframe)
HAEntityApplicationPlan	RFP	bit	Yes/No	Yes = the facility uses RFP's when purchasing
HAEntityApplicationPlan	RFPDateMonth	int	Number/Long Integer	The month the RFP has or will be sent out
HAEntityApplicationPlan	RFPDateYear	int	Number/Long Integer	The year the RFP has or will be sent out
HAEntityApplicationPlan	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntityApplicationPlan	VendorDecision	varchar	Text	The estimated timeframe the facility plans to make a vendor decision (See tab A-Plan Timeframe)
HAEntityContact	ContactId	int	Number/Long Integer	Unique identification number for contact
HAEntityContact	HAContactSourceId	int	Number/Long Integer	Identification number of the position
HAEntityContact	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityContact	Id	int	Number/Long Integer	Record identification number
HAEntityContact	Status	varchar	Text	The status of the position and the system or facility (See tab G-Contact Status)
HAEntityContact	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntityContact	TypeId	int	Number/Long Integer	identification number of the contact type
HAEntityHistory	Action	varchar	Text	Type of current or planned activity (See tab R-Actions)
HAEntityHistory	BedSize	int	Number/Long Integer	Planned Number of Licensed Beds for a hospital being constructed or expanded
HAEntityHistory	BeginConstruction	varchar	Text	Timeframe to begin the construction or expansion project (see Tab A - Plan Timeframe)
HAEntityHistory	EndConstruction	varchar	Text	Timeframe to complete the construction or expansion project (see Tab A - Plan Timeframe)
HAEntityHistory	FundingAmount	varchar	Text	Amount of funding for the construction or expansion project
HAEntityHistory	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityHistory	HAEntityTypeId	int	Number/Long Integer	Unique identification number associated with surveyed entity type
HAEntityHistory	HistoryId	int	Number/Long Integer	Record identification number
HAEntityHistory	IsPlan	bit	Yes/No	Yes = the project is planned (See tab R-Actions)
HAEntityHistory	ProjectDescription	text	Memo	Details for the facility change that may include time frames, bed size or type of facility
HAEntityHistory	ProjectType	varchar	Text	Type of planned construction or expansion project (see Tab - AY ProjectType)
HAEntityHistory	SubjectHAEntityId	int	Number/Long Integer	HAEntityID of the facility that the project is associated with
HAEntityHistory	SubjectName	varchar	Text	Name of the entity that the project is associated with.
HAEntityHistory	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HAEntityRegion	Description	varchar	Text	The specific names of the counties, states, etc. the IDS/ Independent Health System services
HAEntityRegion	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HAEntityRegion	RegionId	int	Number/Long Integer	Record identification number
HAEntityRegion	RegionName	varchar	Text	The type of region that the IDS/Independent Health System services (Counties; State; Regional; National; or Other)
HAEntityRegion	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HandheldInfo	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HandheldInfo	Id	int	Number/Long Integer	Record identification number
HandheldInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HandheldInfo	Type	varchar	Text	Handheld Use
HandheldInfo	Value	varchar	Text	Description of Handheld uses (see tab AI-HandHeld Uses)
HandheldInfo	ValueOther	varchar	Text	Further Description of Other uses or areas of uses
HardwareInfo	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HardwareInfo	Id	int	Number/Long Integer	Record identification number
HardwareInfo	InUseFlag	bit	Yes/No	Yes = the hardware type is in use at the hospital
HardwareInfo	ItemValue	int	Text	The type of hardware (see tab AZ)
HardwareInfo	PlanFlag	bit	Yes/No	Yes = the hardware type is palnned to be used at the hospital
HardwareInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HostedSoftware	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
HostedSoftware	Id	int	Number/Long Integer	Record identification number
HostedSoftware	ServiceId	int	Number/Long Integer	Identification number assigned to the service
HostedSoftware	SurveyId	int	Number/Long Integer	Identification number assigned to survey
HostedSoftware	VendorId	int	Number/Long Integer	Unique identification number for vendor
HostedSoftware	VendorName	varchar	Text	Name of the vendor hosting the software on their servers
IEInitiatives	HAEntityID	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
IEInitiatives	IEInitiativeName	varchar	Text	Name of Information Exchange Initiative Hospital is apart of
IEInitiatives	IEInitiativePlanType	varchar	Text	Planned Timeframe to participate in an Information Exchange Initiative
IEInitiatives	ISPlan	bit	Yes/No	Yes = Hospital plans to participate in an Information Exchange Initiative
IEInitiatives	SurveyId	int	Number/Long Integer	Identification number assigned to survey
IHDSChanges	ChangeDate	varchar	Date/Time	The date the change was made to the HIMSS Analytics Database
IHDSChanges	ChangeId	int	Number/Long Integer	Record identification number
IHDSChanges	ChangeType	varchar	Text	Description of the reason for the change to the HIMSS Analytics Database, such as a merger, a new system or a deletion
IHDSChanges	Comment	text	Memo	Explanation of changes made to the HIMSS Analytics Database
IHDSChanges	Edition	varchar	Text	Indicates which edition of the HIMSS Analytics Database the data is from
IHDSChanges	Id	int	Number/Long Integer	Unique identification for each changed record
IHDSChanges	IsPlan	bit	Yes/No	Yes = the change is planned
IHDSChanges	NewIDSId	int	Number/Long Integer	The new healthcare system's EntityNo
IHDSChanges	OldIDSId	int	Number/Long Integer	The old healthcare system's EntityNo
IHDSChanges	SurveyId	int	Number/Long Integer	Identification number assigned to survey
ISPlan	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
ISPlan	Id	int	Number/Long Integer	Record identification number
ISPlan	Plan	varchar	Text	Description of the areas the IS strategic plan addresses (See tab T-Strategic Plans)
ISPlan	SurveyId	int	Number/Long Integer	Identification number assigned to survey
ISPlanDecision	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
ISPlanDecision	Id	int	Number/Long Integer	Record identification number
ISPlanDecision	Plan	varchar	Text	Description of the facilities that drive the IS strategic plan (See tab L-Plan Facilities)
ISPlanDecision	PlanId	int	Number/Long Integer	Identification number for the type of facilities that drive the IS strategic plan
ISPlanDecision	PlanOther	varchar	Text	Description of the other facilities that drive the IS strategic plan
ISPlanDecision	SurveyId	int	Number/Long Integer	Identification number assigned to survey
LongTermStorage	Area	varchar	Text	Indicates the area where the long term storage technology is used (See tab AN-Storage Areas)
LongTermStorage	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
LongTermStorage	Id	int	Number/Long Integer	Record identification number
LongTermStorage	StorageOther	varchar	Text	Description of Other storage types
LongTermStorage	StorageType	varchar	Text	Type of storage used for all long term storage at the hospital (See tab U-Storage Types)
LongTermStorage	SurveyId	int	Number/Long Integer	Identification number assigned to survey
LongTermStorage	Type	varchar	Text	Current or Planned Use
LongTermStorage	VendorId	int	Number/Long Integer	Unique identification number for vendor
LongTermStorage	VendorName	varchar	Text	Name of the vendor used for long term storage.
MedAdministration	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
MedAdministration	ProcessDesc	varchar	Text	A description of the elements that are bar coded or have an RFID tag in the medication administration process (see tab AV-ProcessDec)
MedAdministration	ProcessID	int	Number/Long Integer	Identification number associated with the elements that are bar coded or have an RFID tag in the medication administration process
MedAdministration	SurveyId	int	Number/Long Integer	Identification number assigned to survey
MedicalDeviceInfo	DeviceID	int	Number/Long Integer	Record identification number
MedicalDeviceInfo	DeviceType	varchar	Text	Type of medical device (See Tab BF)
MedicalDeviceInfo	DeviceTypeId	int	Number/Long Integer	The identification number for the medical device
MedicalDeviceInfo	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
MedicalDeviceInfo	Id	int	Number/Long Integer	Record identification number
MedicalDeviceInfo	IsEMRInterfacePlan	bit	Yes/No	Yes = the hospital has plans to interface the device type to the EMR
MedicalDeviceInfo	PurchaseTimeframeId	int	Number/Long Integer	Identification number for the planned timeframe (see Tab BG)
MedicalDeviceInfo	PurchaseTimeframeValue	varchar	Text	Description of timeframe for planned purchases
MedicalDeviceInfo	QtyEMRInterface	int	Number/Long Integer	Number of medical devices deployed that are interfaced with the EMR
MedicalDeviceInfo	QtyEMRInterfacePlan	int	Number/Long Integer	Number of medical devices the organization plans to interfaced with the EMR within 1 - 2 years
MedicalDeviceInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
MedicalDeviceInterface	Category	varchar	Text	Description of Interface Category (see Tabe BE-MedicalDeviceInteface)
MedicalDeviceInterface	DeviceID	int	Number/Long Integer	Record identification number (links to DeviceId in MedicalDeviceInfo)
MedicalDeviceInterface	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
MedicalDeviceInterface	Id	int	Number/Long Integer	Record identification number
MedicalDeviceInterface	SurveyId	int	Number/Long Integer	Identification number assigned to survey
MedicalDeviceInterface	Value	varchar	Text	Type of EMR Connection in use for interfacing device type.
MedicalDeviceInterface	ValueID	int	Number/Long Integer	Identification number for the type of EMR Connection in use (see Tab BH)
MedicalDeviceInterface	ValueOther	varchar	Text	Other type of EMR Connection in use for interfacing device type not included on Tab BH).
MedicalDeviceProduct	DeviceID			Identification number for medical device. Use this field to link to the MedicalDeviceInfo table.
MedicalDeviceProduct	DeviceType	varchar	Text	Type of medical device (See Tab BF)
MedicalDeviceProduct	DeviceTypeId	int	Number/Long Integer	The identification number for the medical device
MedicalDeviceProduct	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
MedicalDeviceProduct	Id	int	Number/Long Integer	Record identification number
MedicalDeviceProduct	ProductId	int	Number/Long Integer	Unique identification number for product
MedicalDeviceProduct	ProductName	varchar	Text	Software vendor’s product utilized
MedicalDeviceProduct	Quantity	int	Number/Long Integer	Number of medical devices
MedicalDeviceProduct	VendorId	int	Number/Long Integer	Unique identification number for vendor
MedicalDeviceProduct	VendorName	varchar	Text	Name of Server Vendor in Use
MedicalDeviceStrategy	Category	varchar	Text	The type of strategy (see Tab BD-MedDeviceStrategy)
MedicalDeviceStrategy	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
MedicalDeviceStrategy	Id	int	Number/Long Integer	Record identification number
MedicalDeviceStrategy	SurveyId	int	Number/Long Integer	Identification number assigned to survey
MedicalDeviceStrategy	Value	varchar	Text	The strategy for medical devices (see Tab BD-MedDeviceStrategy)
MedicalDeviceStrategy	ValueID	int	Number/Long Integer	Identification number of the strategy
MedicalDeviceStrategy	ValueOther	varchar	Text	Another strategy for medical devices not included on Tab BD-MedDeviceStrategy
PACSComponent	Category	varchar	Text	Already Purchased or Planned
PACSComponent	Component	varchar	Text	Type of PACS Component (See tab V-PACS Components)
PACSComponent	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PACSComponent	Id	int	Number/Long Integer	Record identification number
PACSComponent	Other	varchar	Text	Further Description of Other components
PACSComponent	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PACSComponent	Type	varchar	Text	Department that is referred to regarding PACS (see tab W-PACS Types)
PACSInfo	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PACSInfo	Id	int	Number/Long Integer	Record identification number
PACSInfo	ImgDistrCCU	bit	Yes/No	Yes/No Images distributed to Critical Care Unit
PACSInfo	ImgDistrER	bit	Yes/No	Yes/No Images distributed to Emergency Room
PACSInfo	ImgDistrICU	bit	Yes/No	Yes/No Images distributed to Intensive Care Unit
PACSInfo	ImgDistrOR	bit	Yes/No	Yes/No Images distributed to Operating Rooms
PACSInfo	ImgDistrOther	bit	Yes/No	Yes/No Images distributed to other departments
PACSInfo	ImgDistrOtherComment	varchar	Text	Description of other distribution departments
PACSInfo	ImgDistrThisDeptOnly	bit	Yes/No	Yes/No Images only distributed with in Radiology or Cardiology
PACSInfo	ImgDistrWeb	bit	Yes/No	Yes/No Images distributed over the Web
PACSInfo	NofDigitalStudies	int	Number/Long Integer	Number of digitized studies or procedures done annually
PACSInfo	NofStudies	int	Number/Long Integer	Total number of studies or procedures done annually
PACSInfo	OtherLocationAccess	bit	Yes/No	Yes = The images are accessible from locations outside of the hospital
PACSInfo	PACSIntegrated	bit	Yes/No	Yes = Radiology/ Cardiology PACS is integrated with RIS/ CIS
PACSInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PACSInfo	Type	varchar	Text	Department that is referred to regarding PACS (see tab W-PACS Types)
PACSVendor	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PACSVendor	NofWorkstations	int	Number/Long Integer	Number of Workstations Licensed from PACS vendor
PACSVendor	PACSVendorId	int	Number/Long Integer	Unique identification number for vendor
PACSVendor	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PACSVendor	Type	varchar	Text	Radiology or Cardiology
PACSVendor	VendorId	int	Number/Long Integer	Unique identification number for vendor
PACSVendor	VendorName	varchar	Text	Name of PACS vendor
ParentInfo	AnnualOpCost	float	Number/Double	The annual operating cost for the entire healthcare organization spent on operations such as staffing, property expenses, etc. In numeric form for the most recent fiscal year end
ParentInfo	AnnualRevenue	float	Number/Double	The amount of net income that a system generated from patient care, investments and other sources for the most recent fiscal year end; revenues in excess of expenses
ParentInfo	BackUpFacilityType	varchar	Text	Description of the type of backup facility (see tab Z-Backup Facility Types)
ParentInfo	CapitalExpense	int	Number/Long Integer	Equipment, building, project or software expenses that will be recognized over more than one accounting year, excluding outlay for operation or maintenance
ParentInfo	DateOfData	datetime	Date/Time	Date the data collection was completed
ParentInfo	Depreciation	int	Number/Long Integer	This year's recognized portion of the capital investment expenses from years past
ParentInfo	ExtAuditFirmId	int	Number/Long Integer	Unique identification number for vendor
ParentInfo	ExtAuditFirmName	varchar	Text	Name of the external auditing firm
ParentInfo	FiscalEndDateMonth	int	Number/Long Integer	The month the fiscal year ends
ParentInfo	ISBudget	decimal	Number/Decimal	The total amount budgeted by the IS department at the healthcare systems for the current fiscal year end. This amount includes all operating expenses. It is the IS department operating expense as a percent of total operating expense at the healthcare system level.
ParentInfo	ISPlan	bit	Yes/No	Yes = the system has an IS strategic plan
ParentInfo	ISPlanInEffect	varchar	Text	The length of time the strategic plans is in effect for from the year it was written (See tab Y-ISPlan Timeframes)
ParentInfo	ISPlanYear	int	Number/Long Integer	The year the IS strategic plan was written
ParentInfo	NofOutpatientVisits	int	Number/Long Integer	Total number of individuals seen on an outpatient basis at the integrated healthcare delivery system for the most recent fiscal year
ParentInfo	NofRadiologyProc	int	Number/Long Integer	Number of radiology studies/procedures at the health system for the most recent fiscal year
ParentInfo	OutsourceRecovery	bit	Yes/No	Yes = the IDS/Independent Hospital System outsourcers their disaster recovery
ParentInfo	OutsourceRecoveryVendor	varchar	Text	The name of the vendor the IDS/Independent Hospital System providing the outsourced disaster recovery services
ParentInfo	OutsourceRecoveryVendorId	int	Number/Long Integer	Unique identification number for vendor
ParentInfo	ParentId	int	Number/Long Integer	Identification number for IDS and Independent Health Systems. Unique with survey year
ParentInfo	PhysAffiliated	int	Number/Long Integer	Total number of physicians affiliated with the system through an affiliated physician organization
ParentInfo	PhysFT	int	Number/Long Integer	Total number of full-time salaried physicians employed by the ihealth care system, receiving a regular paycheck from the organization
ParentInfo	PhysHospitalists	int	Number/Long Integer	Total number of hospitalists employed by the health care system
ParentInfo	PhysOther	int	Number/Long Integer	Additional information on the physicians at the health care system
ParentInfo	PhysResidents	int	Number/Long Integer	Total number of residents at the health care system
ParentInfo	PhysTotal	int	Number/Long Integer	Total number of other (not on-staff, full-time salaried or affiliated) physicians at the health care system
ParentInfo	RecoveryPlan	bit	Yes/No	Yes = the IDS/Independent Hospital System has a disaster recover plan
ParentInfo	RecoveryPlanIsBackup	bit	Yes/No	Yes = the IDS/Independent Hospital System has a backup facility for disaster recovery
ParentInfo	RecoveryPlanYear	int	Number/Long Integer	The year the disaster recover plan was written
ParentInfo	RevManagedCare	float	Number/Double	Percentage of patient revenue from managed care organizations
ParentInfo	RevMedicaid	float	Number/Double	Percentage of patient revenue from Medicaid (Public) insurance
ParentInfo	RevMedicare	float	Number/Double	Percentage of patient revenue from Medicare
ParentInfo	RevOther	float	Number/Double	Percentage of patient revenue from other sources, such as CHAMPUS, worker's comp., self pay, etc.
ParentInfo	RevTradComm	float	Number/Double	Percentage of patient revenue from traditional commercial insurance
ParentInfo	StarkNofClinics	int	Number/Long Integer	Number of clinicls the system currently provides Ambulatory EMR services to community physicians under the current Stark relaxation laws (non-owned clinics)
ParentInfo	StarkNofSolutions	int	Number/Long Integer	Number of Ambulatory EMR solutions the system currently provides to community physicians under the current Stark relaxation laws (non-owned clinics)
ParentInfo	StarkPlan	bit	Yes/No	Yes = the system plans to offer Ambulatory EMR services to community physicians (non-owned clinics) (See tab A-Plan Timeframe)
ParentInfo	StarkPlanTimeFrame	varchar	Text	The timeframe in which the system plans to offer Ambulatory EMR services to community physicians (non-owned clinics)
ParentInfo	StarkRelaxation	bit	Yes/No	Yes = the system currently provides Ambulatory EMR services to community physicians under the current Stark relaxation laws (non-owned clinics)
ParentInfo	SteeringCommittee	bit	Yes/No	Yes = the system has a formal IS steering committee
ParentInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Pharmacy	ADM	bit	Yes/No	Yes = the facility uses ADMs to dispense medication
Pharmacy	ADMPerc	decimal	Number/Decimal	The percentage of the total dispensed medication that is done via the Automated Dispensing Machines (ADMs)
Pharmacy	ADMPlanned	bit	Yes/No	Yes = the facility plans to purchase ADMs to dispense medication (See tab A-Plan Timeframes)
Pharmacy	ADMTimeFrame	varchar	Text	The time frame for purchasing ADMs to dispense medication (See tab AA-Pharmacy Plan Timeframes)
Pharmacy	Carousels	bit	Yes/No	Yes = the facility uses caorusels
Pharmacy	CarouselsPlanned	bit	Yes/No	Yes = the facility has plans to purchase carousels
Pharmacy	CarouselsTimeframe	varchar	Text	The timeframe for purchasing carousels (See tab AA-Pharmacy Plan Timeframes)
Pharmacy	DeptED	bit	Yes/No	Yes = the facility uses ADMs to dispense medication in the emergency department
Pharmacy	DeptMedical	bit	Yes/No	Yes = the facility uses ADMs to dispense medication in the Medical/Surgical department
Pharmacy	DeptOR	bit	Yes/No	Yes = the facility uses ADMs to dispense medication in the operating room
Pharmacy	DeptOther	bit	Yes/No	Yes = the facility uses ADMs to dispense medication in the another department
Pharmacy	DeptOtherName	varchar	Text	Description of the other department where ADMs are used to dispense medication
Pharmacy	EMAR_CPOE	varchar	Text	Indicates if the EMAR is integrated with pharmacy, CPOE or both.
Pharmacy	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Pharmacy	Id	int	Number/Long Integer	Record identification number
Pharmacy	InventoryMgmt	int	Number/Long Integer	Description of how inventory management is tracked in pharmacy
Pharmacy	IVPumpPlanned	bit	Yes/No	Yes = the facility plans to purchase IV Pumps
Pharmacy	IVPumpsPlanTimeFrame	varchar	Text	The timeframe the hospitals plans to purchase IV Pumps in months (See tab AA-Pharmacy Plan Timeframes)
Pharmacy	IVPumpsPlanTimeQty	varchar	Text	Number of IV Pumps the hospital plans to purchase
Pharmacy	IvPumpsSafetySoftware	bit	Yes/No	Yes = safety software is utilized on the IV Pumps
Pharmacy	Robot	bit	Yes/No	Yes = the facility uses robot technology to fill medication orders
Pharmacy	RobotPlanned	bit	Yes/No	Yes = the facility has plans to use or change robot technology to fill medication orders
Pharmacy	RobotTimeFrame	varchar	Text	The time frame for purchasing robot technology to fill medication orders (See tab AA-Pharmacy Plan Timeframes)
Pharmacy	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PharmacyProduct	ContractMonth	int	Number/Long Integer	The month the facility plans to purchase the technology for the pharmacy
PharmacyProduct	ContractYear	int	Number/Long Integer	The year the facility plans to purchase the technology for the pharmacy
PharmacyProduct	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PharmacyProduct	Id	int	Number/Long Integer	Record identification number
PharmacyProduct	NofDevices	int	Number/Long Integer	Number of ADM devices used at the facility
PharmacyProduct	ProductId	int	Number/Long Integer	Unique identification number for product
PharmacyProduct	ProductName	varchar	Text	The name of the vendor's product used
PharmacyProduct	Qty	varchar	Text	The number of devices the hospital has
PharmacyProduct	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PharmacyProduct	Type	varchar	Text	The type of technology used (See tab AB-Pharmacy Technology)
PharmacyProduct	VendorId	int	Number/Long Integer	Unique identification number for vendor
PharmacyProduct	VendorName	varchar	Text	The name of the vendor used
PreferredSupplier	Channel	varchar	Text	Preferred Channel for acquiring hardware; Direct from Manufacturer, Reseller, Third Party Vendor, or No Preference
PreferredSupplier	ChannelVendor	varchar	Text	Primary supply chain vendor for reseller & gpo
PreferredSupplier	ChannelVendorID	int	Number/Long Integer	Unique identification number for channel vendor
PreferredSupplier	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PreferredSupplier	Id	int	Number/Long Integer	Record identification number
PreferredSupplier	SurveyId	int	Number/Long Integer	Identification number assigned to survey
PreferredSupplier	Type	varchar	Text	Types of Hardware
ProductHistory	AcquisitionDate	datetime	Date/Time	Date and time the acquisition occurred in the HIMSS Analytics DatabaseTM
ProductHistory	Comment	varchar	Text	Description of the action putting the product in the history table
ProductHistory	CurrentOwnerName	varchar	Text	Name of the vendor who currently owns the product
ProductHistory	DateNameChanged	datetime	Date/Time	Date and time the acquisition occurred in the HIMSS Analytics DatabaseTM
ProductHistory	Id	int	Number/Long Integer	Record identification number
ProductHistory	IndustryChangeDate_Day	varchar	Text	Day the product was acquired in the industry by the new vendor
ProductHistory	IndustryChangeDate_Month	varchar	Text	Month the product was acquired in the industry by the new vendor
ProductHistory	IndustryChangeDate_Year	varchar	Text	Year the product was acquired in the industry by the new vendor
ProductHistory	PreviousName	varchar	Text	The previous name of the product
ProductHistory	PreviousOwner	varchar	Text	The vendor who owned the product before an acquisition
ProductHistory	Product	varchar	Text	Product Name
ProductHistory	ProductID	int	Number/Long Integer	Identification number for the product
PurchasingOrganization	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
PurchasingOrganization	Id	int	Number/Long Integer	Record identification number
PurchasingOrganization	Organization	varchar	Text	Name of purchasing alliance or group
PurchasingOrganization	OrganizationId	int	Number/Long Integer	Identification number of purchasing alliance or group
PurchasingOrganization	SurveyId	int	Number/Long Integer	Identification number assigned to survey
SecuritySoftware	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
SecuritySoftware	Id	int	Number/Long Integer	Record identification number
SecuritySoftware	Software	varchar	Text	Type of Security software (See tab AD-Security Technology)
SecuritySoftware	SoftwareId	int	Number/Long Integer	Identification number for type of security used
SecuritySoftware	SurveyId	int	Number/Long Integer	Identification number assigned to survey
SecuritySoftware	Type	varchar	Text	Indicates if the security technology is current or planned
Server	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Server	HowManyPlanned	int	Number/Long Integer	Number of Units Planned
Server	Id	int	Number/Long Integer	Record identification number
Server	InUseFlag	bit	Yes/No	Yes = the server is currently used
Server	NofUnits	int	Number/Long Integer	Number of Servers
Server	OperatingSystem	varchar	Text	Unique ID for Server Operating System
Server	OperatingSystemName	varchar	Text	Name of Server Operating System
Server	PlannedFlag	bit	Yes/No	Yes/No Planning New Servers
Server	ProductId	int	Number/Long Integer	Unique identification number for product
Server	ProductName	varchar	Text	Name of Server Product in Use
Server	ServerType	varchar	Text	The type of server used at the hospital (See tab AE-Server Types)
Server	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Server	Timeframe	varchar	Text	The timeframe in which there are plans to implement virtual servers
Server	VendorId	int	Number/Long Integer	Unique identification number for vendor
Server	VendorName	varchar	Text	Name of Server Vendor in Use
Service	Category	varchar	Text	The status of the use of the consulting services or outsourcing (i.e. current or plan)
Service	CompanyId	int	Number/Long Integer	Identification of the organization providing the consulting or outsourcing service
Service	CompanyName	varchar	Text	Name of the organization providing the consulting or outsourcing service
Service	ContractLength	varchar	Text	The length of the contract from the date it was contracted
Service	ContractMonth	int	Number/Long Integer	The month the service was or will be contracted
Service	ContractYear	int	Number/Long Integer	The year the service was or will be contracted
Service	Function	varchar	Text	Type of service being supplied (See tab AF-Service Types)
Service	FunctionOther	varchar	Text	Description of services out side of the listed options
Service	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Service	Id	int	Number/Long Integer	Record identification number
Service	SignContractTimeframe	varchar	Text	The time frame the hospital will sign a contract for outsourcing and consulting services
Service	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Service	Type	varchar	Text	Indicates the type of service (see tab AF-Service Types)
Survey	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Survey	Year	int	Number/Long Integer	Year the system and facilities have been updated in
SurveySegment	SegmentID	varchar	Number/Long Integer	Unique identification number for segment
SurveySegment	SegmentName		Text	Name of the segment (See tab AO-Segments)
SurveySegment	SurveyId	int	Number/Long Integer	Identification number assigned to survey
TelecomInfo	HAEntityId	int	Number/Long Integer	Unique identification number associated with surveyed entity type (See tab M-Facility Types)
TelecomInfo	InUseFlag	bit	Yes/No	Yes = the Telecommunication type is in use at the hospital
TelecomInfo	PlanFlag	bit	Yes/No	Yes = the Telecommunication type is planned to be used at the hospital
TelecomInfo	SurveyId	int	Number/Long Integer	Identification number assigned to survey
TelecomInfo	UpgradePlanTimeFrame	varchar	Text	Planned Timeframe for Planned Telecommunication type
Telecommunication	Category	varchar	Text	Differentiates between type of telecommunication types (see tab AG-Telecommunication Types)
Telecommunication	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Telecommunication	Id	int	Number/Long Integer	Record identification number
Telecommunication	Status	varchar	Text	The status of the use of the telecommunication technology (i.e. current or planned)
Telecommunication	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Telecommunication	Type	varchar	Text	Differentiates between the types of services (see tab AG-Telecommunication Types)
Telecommunication	VendorId	int	Number/Long Integer	Unique identification number for vendor
Telecommunication	VendorName	varchar	Text	The vendor providing the telecommunication technology
UseOfITComponent	Component	varchar	Text	The component or application that the physicians can access via a dashboard (See tab AH-Physician Access Components)
UseOfITComponent	ComponentId	int	Number/Long Integer	Identification number for the type of component or application that the physicians can access via a dashboard
UseOfITComponent	ComponentOther	varchar	Text	Description for the other components the physicians can access via a dashboard that are not included in the options
UseOfITComponent	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
UseOfITComponent	Id	int	Number/Long Integer	Record identification number
UseOfITComponent	Perc	varchar	Text	The percentage or percentage range of the physicians accessing the component via the dashboard
UseOfITComponent	SurveyId	int	Number/Long Integer	Identification number assigned to survey
UseOfITComponent	Type	varchar	Text	Indicated if the component are accessed via the dashboard and which are not
VendorHistory	DateOfChange	datetime	Date/Time	Date the action was taken on the vendor
VendorHistory	HistoryID	int	Number/Long Integer	Record identification number
VendorHistory	IndustryChangeDate_Day	varchar	Text	Day the vendor change occurred in the industry
VendorHistory	IndustryChangeDate_Month	varchar	Text	Month the vendor change occurred in the industry
VendorHistory	IndustryChangeDate_Year	varchar	Text	Year the vendor change occurred in the industry
VendorHistory	Note	text	Text	Description of the action putting the vendor in the history table
VendorHistory	PrevName	varchar	Text	Previous name of the original vendor that the action was taken on
VendorHistory	PrevVendorId	int	Number/Long Integer	Previous identification number for the original vendor that the action was taken on
VendorHistory	Vendor	varchar	Text	Name of the original vendor that the action was taken on
VendorHistory	VendorID	int	Number/Long Integer	Identification number for the vendor
VendorHistory	vendorName	varchar	Text	Name of the vendor that acquired the original vendor
Wireless	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
Wireless	HandHeldPerc	decimal	Number/Decimal	The percentage of physicians using handheld devices
Wireless	Id	int	Number/Long Integer	Record identification number
Wireless	IsWLAN	bit	Yes/No	Yes = the hospital has a wireless local area network (WLAN)
Wireless	IsWLANPlan	bit	Yes/No	Yes = the hospital has plans to implement or expand their wireless local area network (WLAN)
Wireless	NofAccessPoints	int	Number/Long Integer	The number of current access points to the WLAN
Wireless	NofAccessPointsEndOfYear	int	Number/Long Integer	The number of access points to the WLAN planned in the next year.
Wireless	SurveyId	int	Number/Long Integer	Identification number assigned to survey
Wireless	Version	varchar	Text	The 802.11 standard used (i.e. a, b, g, n)
Wireless	VersionEndOfYear	varchar	Text	The 802.11 standard planned (i.e. b, g, n)
WirelessAccess	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
WirelessAccess	Id	int	Number/Long Integer	Record identification number
WirelessAccess	Location	varchar	Text	The location of the WLANs in the facility (see tab AK-WLAN Locations)
WirelessAccess	SurveyId	int	Number/Long Integer	Identification number assigned to survey
WirelessVendor	HAEntityId	int	Number/Long Integer	Identification number associated with surveyed entity. Unique within survey year.
WirelessVendor	Id	int	Number/Long Integer	Record identification number
WirelessVendor	NofUnits	int	Number/Long Integer	The number of units provided by the vendor for the type of wireless technology
WirelessVendor	OperatingSystem	varchar	Text	Unique identification number for product
WirelessVendor	OperatingSystemName	varchar	Text	The name of the operating system running the wireless device
WirelessVendor	SurveyId	int	Number/Long Integer	Identification number assigned to survey
WirelessVendor	Type	varchar	Text	The type of wireless technology (See tab AM-Wireless Devices)
WirelessVendor	VendorId	int	Number/Long Integer	Unique identification number for vendor
WirelessVendor	VendorName	varchar	Text	The name of the vendor used for the type of wireless technology

HIMSS - Data dictionary