Objective To solve the needs of accurate data statistics for day ward, with a retrieval module designed. Methods This paper introduces design basis and ideas, designs PL/SQL program,  embeds SQL query statements in the CMIS system program, and uses cases to analyze the operation process and module function. Results Through manual, day ward logo, the use of module for comparison, it is of high practical value to use the retrieval module for information statistics of day ward.Conclusion The module could ensure the accuracy of day patient information. The value of information is reflected, and better services are provided for clinical, scientific research, management analysis, and data excavation.