title: Using Hospital Information System Data to Capture Nurse Workload.
abstract: Aim Using hospital information system (HIS) data to capture nurse workload. Method Direct and indirect nursing items were included by survey and group discussion, workload of nurses is calculated by the work hour measurement of nursing item. Nursing items were matching with HIS index. An ETL (Extract, Transform, Load) tool, Microsoft SSIS, is to capture all HIS index if it happened in a day. Results The workload of a ward can be calculated automatically the day before. Discussion This study provides a new approach to achieve nursing workload. However, a confirmatory study should be implemented in the future to verify the reliability of workload.
authors.affiliation: Department of Nursing, West China Hospital, Sichuan University.
authors.forename: Shangping
authors.initials: S
authors.lastname: Zhao
authors.affiliation: Department of Nursing, West China Hospital, Sichuan University.
authors.forename: Hong
authors.initials: H
authors.lastname: Chen
authors.affiliation: Neurology Department, West China Hospital, Sichuan University.
authors.forename: Ling
authors.initials: L
authors.lastname: Feng
mesh_terms: D000465:Algorithms; D002681:China; D003198:Computer Simulation; D006751:Hospital Information Systems / Q000706:statistics & numerical data*; D016247:Information Storage and Retrieval / Q000379:methods*; D015233:Models, Statistical; D009737:Nursing Records / Q000706:statistics & numerical data*; D009741:Nursing Staff, Hospital / Q000706:statistics & numerical data*; D057184:Practice Patterns, Nurses' / Q000706:statistics & numerical data*; D016526:Workload / Q000706:statistics & numerical data*