Refer to the article Reliability and Validity of the NDNQI Injury Falls Measure by Garrard et al. NDNQI fall measures provide a proper method for reporting injury falls, which could be useful for hospitals in comparing their data with reliable national comparison data to develop fall prevention plans.
Based on information presented in Table 1 (Garrard et al., pp. 116-117), an example of data tables that can be created is as follows:
Patient Table
PatientlD LastName FirstName FallCode 001 Smith Jane 2 002 Doe John 2 003 Johnson Mike 1
Fall Table