Development of an Automated Database System to Enhance the Efficiency of Tuition Fee Revenue and Collaborative Program Management (CAMT-Revenue) Case Study: College of Arts, Media and Technology, Chiang Mai University

Jonglak Somrang

doi:10.14456/jiskku.2026.6

Authors

Jonglak Somrang College of Arts, Media and Technology, Chiang Mai University, Thailand

DOI:

https://doi.org/10.14456/jiskku.2026.6

Keywords:

Database system, Lean approach, Real-time data management

Abstract

Purpose: This research aims to develop a database system for collecting tuition fees and managing joint program revenue (CAMT-Revenue). Moreover, it also seeks to improve the efficiency of budget planning and financial reporting for the university in a timely and accurate manner.

Methodology: The study employs a Research and Development approach utilizing the Lean four-step process: Check/Measure, Process Design, System Development, and Evaluation. The tools include API integration for retrieving data from the Registrar's Office, process mapping, and user acceptance testing through interviews and focus groups with personnel from three central departments.

Findings: The CAMT-Revenue system reduced operational time from 10 to 3 days, increasing efficiency by 70%. It replaced manual Excel storage with an automated "single source of truth," ensuring data integrity and real-time verification. Users reported high satisfaction due to reduced workloads and improved transparency in revenue tracking.

Applications of this study: This study is helpful for higher education administrators and financial officers in departments such as Educational Services, Policy and Planning, and Finance. The integrated Digital Automation model, combining Lean Thinking, Knowledge Management, and Data Integrity, can be applied to other university revenue streams or public sector financial management systems to eliminate waste.

Downloads

Download data is not yet available.

References

Ardarsa, P., & Hadkhuntod, P. (2025). Development of a network device service monitoring system: Chaiyaphum Rajabhat University. Savant Journal of Social Sciences, 2(3), 38–50.

Chakpitak, N. (2009). Thritsadi kan chatkan khwamru [Knowledge management theory]. Thanapress.

Eiamsiriwong, O. (2012). System analysis and design (Rev. ed., pp. 50–58). SE-ED Education.

Kanitpanyajaroen, T., & Tiptipakorn, S. (2025). Development of information system for data management: A case study of a community enterprise meat goats raising group in Koh Kha District, Lampang Province. Sripatum Journal of Social Sciences, Chonburi, 11(1), 114–135.

Kansulee, K. (2020). Development of computer traffic data storage systems within Academic Resources and Information Technology, Pibulsongkram Rajabhat University. PULINET Journal, 7(1), 25–35.

Mangkon, N., & Sukruay, T. (2021). Kan nam lakkan lean ma chai nai kan phatthana prasitthiphap rabop ok lek nangsue lae khamsang [Using lean principles to improve the efficiency of developing a document and order numbering system]. Faculty of Medical Technology, Chiang Mai University.

Marandi, B. (2024). A study on the role of database systems in the field of education. International Journal of Cloud Computing and Database Management, 5(2), 109–113. https://doi.org/10.33545/27075907.2024.v5.i2b.78

Ministry of Education. (2021). Digital education action plan 2020–2022. Information and Communication Technology Center.

Panich, W. (2005). Kan chatkan khwamru chabap nak patibat [Knowledge management for practitioners]. Suphapjai Publishing House.

Phuklang, N., Charoensiri, W., Yupas, Y., & Khenaphum, S. (2016). Factors affecting job efficiency in government financial management of Rajabhat Maha Sarakham University under the Government Fiscal Management Information System (GFMIS). Chorphayom Journal, 27(2), 159–165.

Phumthong, W., Sompongtham, C., & Labmala, S. (2024). Suggestions for database system development for schools in School Network 6 (Pho Sai-Rai Tai) under Ubon Ratchathani Primary Educational Service Area Office 3. Journal of Mani Chettha Ram Wat Chommani, 8(6), 624–636.

Thailand Innovative Administration Consultancy Institute. (2024). Modern public administration with lean government. https://www.tia.or.th/insight-details.html?id=40

Womack, J. P., & Jones, D. T. (2003). Lean thinking: Banish waste and create wealth in your corporation. Simon & Schuster.