Search

Background: Health information records in many countries, especially developing countries, are still paper based. Compared to electronic systems, paper-based systems are disadvantageous in terms of data storage and data extraction. Given the importance of health records for epidemiological studies, guidelines for effective data cleaning and sorting are essential. They are, however, largely absent from the literature. The following paper discusses the process by which an algorithm was developed for the cleaning and sorting of a database generated from emergency department records in Lebanon. Design and methods: Demographic and health related information were extracted from the emergency department records of three hospitals in Beirut. Appropriate categories were selected for data categorization. For health information, disease categories and codes were selected according to the International Classification of Disease 10th Edition. Results: A total of 16,537 entries were collected. Demographic information was categorized into groups for future epidemiological studies. Analysis of the health information led to the creation of a sorting algorithm which was then used to categorize and code the health data. Several counts were then performed to represent and visualize the data numerically and graphically. Conclusions: The article describes the current state of health information records in Lebanon and the associated disadvantages of a paper-based system in terms of storage and data extraction. Furthermore, the article describes the algorithm by which health information was sorted and categorized to allow for future data analysis using paper records. Significance for public health In our protocol, we explain the process by which health information collected from paper-based records were analyzed to develop an algorithm to allocate appropriate ICD 10 disease codes and categories to each entry. The algorithm allows for the sequential analysis of the information present and serves to overcome the issue of incomplete records. This is especially relevant in developing countries where paper-based records are highly relied upon, noting that our protocol has already been applied to a study in the Ivory Coast. The protocol allows for a health information database to be cleaned and sorted for research in environmental, social and occupational health. Furthermore, since data cleaning and sorting protocols are sparse, it is crucial to establish a standardized tool to enhance the quality of the conducted research.

To assess the feasibility, reliability, and construct validity of the Camberwell Assessment of Need for the Elderly (CANE) in identifying needs among community-dwelling older adults in South Lebanon with a view towards expanding ageing research in the country.A cross-sectional study was undertaken with 322 individuals, using the CANE, the EQ5d and a socio-demographic questionnaire. Reliability was determined through measuring internal consistency of the CANE. Construct validity was performed through examining CANE inter-item correlations, and comparing correlations with the EQ5d and socio-demographic indicators. A factor analysis was conducted using varimax orthogonal rotation.Cronbach alpha was 0.71. For construct validity, correlations were highest in items measuring needs in looking after the house and food (r = 0.557); company and intimate relationships (r = 0.572); and medication and written/verbal information (r = 0.586). Moderate correlations were found with EQ5d items assessing the same measure, including: EQ5d 'problems taking care of self' and CANE self-care (r = 0.578) and daytime activities (r = 0.523); EQ5d 'problems performing usual activities' and CANE daytime activities (r = 0.553), self-care (r = 0.511) and mobility (r = 0.500); and EQ5d 'problems while walking' and CANE mobility/falls (r = 0.509). Corresponding items of the CANE and EQ-5d were significantly correlated with similar socio-demographic variables. The factor analysis supported results obtained in the CANE inter-item correlations.The Arabic version of the CANE appears acceptable in assessing needs of older adults in South Lebanon. Given that the CANE is an interesting tool that promotes the integration of older persons' perspectives for appropriate interventions, further research is recommended to establish its validity and applicability in other communities in Lebanon and the region.