3. Objectives and Methodology
The core aim of this study is to establish a seamless flow of information, thereby simplifying patient eligibility verification for discounts and ensuring efficient DB management. This process must handle checking and updating existing records; adding new eligible companies and individuals; and removing or deactivating those who no longer qualify. Since the card’s discount structure extends to registered family members, tracking these relationships within the system is essential to ensure that linked accounts are automatically updated or deactivated if the primary cardholder’s eligibility changes.
This objective responds directly to structural challenges within the Portuguese healthcare sector, where heterogeneous information systems, legacy databases, and continued reliance on manual administrative procedures remain prevalent, resulting in fragmented data environments and operational inefficiencies [
18]. Such fragmentation limits real-time data exchange and process automation, increasing processing times and constraining the reliability of administrative operations, particularly in the absence of semantic interoperability mechanisms [
18,
20]. Evidence from high-income healthcare systems demonstrates that integrated and interoperable information infrastructures improve data accuracy and reduce operational errors, while fragmented systems are associated with higher risks of inconsistencies and cost inefficiencies [
19]. Establishing a seamless flow of information is therefore a prerequisite for accurate discount allocation, operational efficiency, and financial control, especially within Healthcare 4.0-enabled loyalty programs that depend on timely, standardized, and reliable data integration across organizational systems [
52].
The study adopted a mixed-methods data collection approach, combining qualitative and quantitative techniques, with a focus on the eligibility verification activity of the healthcare loyalty program [
26].
Quantitative data were collected through direct observation and manual time measurements of the verification process during patient check-in, particularly during peak operational periods. Baseline measurements were obtained for the AS-IS process, and equivalent measurements were collected after system implementation to assess the TO-BE process under comparable conditions [
57].
Qualitative data were gathered during the Process Identification and Discovery phases of the BPM lifecycle [
26] through direct observation and informal semi-structured discussions with key stakeholders, including reception staff, accounting personnel, and hospital management. These qualitative insights supported the development of the AS-IS process model and enabled the identification of operational challenges such as fragmented data sources, reliance on manual eligibility verification, and time-consuming checks [
58,
59]. The combination of qualitative insights and quantitative measurements supported the performance analysis presented in
Section 4 and
Section 5.
This initial analysis revealed several limitations that hindered both the efficiency and accuracy of the existing process. The key challenges identified were:
Lack of digitalization and automation in the management of the discount card;
Inefficient data management and difficulty in maintaining an up-to-date user DB;
Limited access to data from partner companies;
Questionable data reliability due to the absence of a proper verification mechanism, although service usage by beneficiaries could be tracked.
To address these issues, the study addresses the following operational sub-objectives:
Process Analysis and Redesign: Analyze the AS-IS eligibility verification process to identify bottlenecks and design a TO-BE model that minimizes manual intervention;
DB Centralization: Develop a structured, centralized SQL DB to consolidate fragmented data regarding patients, partner companies, and family beneficiaries;
Automation of Verification Routines: Implement automated daily verification protocols to ensure real-time data consistency and reliability across systems;
Operational Interface Development: Provide a dedicated administrative interface for the manual management of exceptions, including the activation, deactivation, and updating of beneficiary records;
System Integration: Synchronize the centralized data with the MedicineOne 8.13.124 (M1) hospital software to automate discount application at the point of sale;
Performance Monitoring: Enable the generation of management reports to support evidence-based decision-making and continuous monitoring of process efficiency.
To achieve these objectives, the paper adopted BPM as its guiding methodology. BPM optimizes organizational workflows to enhance efficiency, reduce costs, and improve customer experience [
27]. It integrates methods, techniques, and tools for designing, monitoring, analyzing, and improving operations, ensuring alignment with strategic objectives [
28].
BPM has been shown to improve service quality, reduce waiting times, optimize workflows, and create a more efficient and patient-centric environment [
29]. It has also facilitated organizational change, providing structured methodologies that enhance staff engagement and operational effectiveness [
30].
A key component of this approach is the Business Process Model and Notation (BPMN), a widely adopted graphical standard for modeling business processes. BPMN offers a clear, understandable notation that bridges the gap between business analysts and technical implementers, thereby enhancing transparency and reducing operational inefficiencies [
60,
61,
62]. Furthermore, Business Process Management Systems (BPMSs) support BPM by providing platforms for designing, implementing, and optimizing processes, which rely on BPMN 2.0 models to structure, automate, and improve operations [
63].
The BPM lifecycle has several approaches. According to [
26], it includes 6 phases, which are:
Process Identification: Define the business problem, identify relevant processes, and establish their relationships within the organization.
Process Discovery: Document the current state, AS-IS, of processes through modeling.
Process Analysis: Identify and quantify issues in the AS-IS process using performance metrics whenever possible.
Process Redesign: Develop improvements to address the issues and create a future TO-BE process model.
Process Implementation: The changes to move from the AS-IS to the TO-BE process are prepared and performed. These changes are applied through organizational adjustments and information technology (IT) system updates.
Process Monitoring and Controlling: Track performance, identify bottlenecks or errors, and take corrective actions, enabling constant improvement, which may require repeating the cycle continuously.
BPM effectively integrates methods, techniques, and tools to design, implement, manage, and analyze business processes [
28], creating a bridge between IT and process management to optimize operational efficiency [
26]. As organizations recognize the benefits of BPMN, its widespread adoption has led to its increased use across various sectors [
62], supporting improved task execution and decision-making.
Recognizing the numerous benefits of BPM, including increased efficiency, transparency, and standardized procedures, we adopted the BPM lifecycle as our guiding methodology. On top of that, the inherently visual nature of BPMN diagrams made complex operations easier to understand and communicate, helping to build consensus and reduce uncertainty among staff. We used SAP SIGNAVIO as our BPMN modeling tool, leveraging the visual nature of BPMN diagrams to simplify complex operations, facilitate communication, and build consensus.
During the preparation of this article, a generative AI was used to support language refinement, assist in organizing ideas, and provide suggestions to improve clarity and coherence. All AI-assisted text was carefully reviewed, validated, and edited.
4. Results and Major Findings
4.1. BPM Lifecycle
To integrate the solution effectively, we followed the BPM lifecycle. The initial Process Identification and Discovery phases involved conducting meetings with key stakeholders to understand the current process and identify core issues. Stakeholders included: receptionists, who directly interact with clients; the accounting department, which manages the financial repercussions; and the hospital board, which ultimately bears any financial losses.
These discussions highlighted a major problem: the lack of a centralized, easily accessible, and well-organized DB for managing the health card. This issue is particularly critical as the card offers two plans: the Gold plan for employees of the Embeiral group, and the Silver plan for employees of other partner companies with established agreements with CSSMH. Another significant challenge was the management of discounts. Although the M1 DB is designed to automatically apply discounts based on predefined parameters, the health card discount parameters were not regularly updated, frequently necessitating manual verification and approval of discounts. This was rectified during the meetings when the responsible individual updated the discount table for 2025, restoring automated discount application via the DB.
We then modeled the initial AS-IS process, as illustrated below in
Figure 1.
The process currently starts when a client arrives at reception, checks in, and states they have the health card. The receptionist accesses the client’s profile, but information about the card’s existence or validity is often outdated or unavailable. The receptionist must rely solely on the client’s statement.
After this step, an entity associated with the discount plan is added to the client’s profile, again without systematic eligibility checks. The receptionist then selects all relevant medical acts within the system to create an invoice. A major inefficiency arises here: if the system fails to automatically display the price for any of the selected medical acts, the receptionist is obligated to contact the individual responsible for price management in the DB. This designated person must then review the medical records and manually update the DB as necessary. Consequently, the receptionist must then re-enter all medical acts into the system. Only once every act has an associated price can the final invoice be generated.
Payment is typically collected before the medical act occurs, though specific, well-defined exceptions exist. The adjusted amount is then charged to the client, and a paper receipt is issued to both the client and CSSMH. This entire transaction is subsequently recorded in the M1 system.
A closer analysis highlights a severe operational weakness: the absence of a systematic method for verifying customer eligibility. This often leads to errors in discount application that are difficult and costly to rectify post-transaction, complicating financial reconciliation, undermining billing accuracy, and reducing the reliability of financial statements.
Considering these issues, a process redesign was necessary to address them. The modeled TO-BE process is illustrated below in
Figure 2.
In the improved model, discount verification and application are streamlined for accuracy and efficiency. When a client arrives, the receptionist performs a mandatory eligibility verification by searching for the client’s Tax Identification Number (NIF) on a dedicated website, regardless of any existing association. This verification confirms:
If the client is eligible, the correct entity is added to their profile, ensuring their plan status is accurate for automatic discount application. If the client is inactive or not found, they are charged the standard rate or any applicable third-party insurance discounts
The receptionist then selects all relevant medical acts and issues an invoice in the system based on the client’s associated plan. Leveraging the updated DB, the system now automatically applies the appropriate loyalty discount according to the client’s plan or charges the standard rate if no plan is applicable. This crucial automation eliminates the need for manual verification and internal DB updates related to discount rules, minimizing the risk of human error and significantly reducing processing time.
Following this, the payment transaction occurs, and a paper receipt is provided to both the client and CSSMH. Importantly, the transaction is simultaneously recorded in the M1 system, which ensures full transparency and accurate financial record-keeping. The new model completely streamlines the workflow and guarantees that only eligible clients receive benefits. Since these benefits are applied automatically through the updated DB, they effectively resolve previous issues where discounts were frequently missed due to outdated or missing information.
The key difference between the AS-IS and TO-BE models is the introduction of a centralized DB, which is the foundation for the verification website. This consolidation makes verifying eligibility and plan type straightforward, ensuring accurate, efficient verification through streamlined communication between platforms and staff. By storing all discount rules within the M1 software’s DB, the process is now fully automated, eliminating manual intervention. This reduces error risk, ensures consistent discount application, and allows staff to focus on patient care rather than administrative tasks.
Table 2 summarizes the main differences between the AS-IS and TO-BE models and highlights the operational effects of the proposed redesign.
Automating discount application follows best practices in loyalty and promotional systems, improving operational efficiency, enhancing the patient experience, and providing a more transparent and reliable process for both the hospital and its beneficiaries. Furthermore, with discounts managed centrally, updating or personalizing offers for different patient segments or partner entities becomes easier, supporting a more flexible and competitive loyalty program in the long term.
4.2. Database and Code
4.2.1. System Architecture and Technologies Used
To detail the solution’s development, an overview of the components and their interactions is provided through two UML diagrams.
Figure 3 presents a high-level view of the main software components (blue) and secondary ones (yellow).
Figure 4 demonstrates how data from external sources (Cegid Primavera and M1) is processed by automated scripts, stored centrally in the new CSSMHSI DB, and accessed by user programs for verification and management. Together, these diagrams provide a comprehensive understanding of the solution’s structure, from the software’s internal logic to its integration with external systems. The programs depicted are described in the sections below.
Technologies selected include Python 3.13, Flask 3.1.0, HTML5, CSS3, JavaScript (ECMAScript 2024), and SQL Server Management Studio 20 (SSMS 20), chosen for their technical fit and alignment with the internal team’s experience.
4.2.2. Database Design and Implementation
The first significant step in the development process was designing and creating the DB, which involved organizing the data to support the new health card interface.
Three key entities were identified:
PESSOAS: Employees and other individuals who hold the health card;
EMPRESAS: Partner companies whose employees are eligible for discounts;
FAMILIARES: Family members of employees who also benefit from the program.
Based on the system requirements identified, we developed an Entity-Relationship Diagram (ERD) to structure the DB and define how the data would be organized and interconnected. The ERD highlighted the relationships between the main tables, specifically the foreign key constraints. The PESSOAS table is linked to the EMPRESAS table through a foreign key, ensuring each cardholder is associated with their respective company. Similarly, the FAMILIARES table is linked to the PESSOAS table, establishing a relationship between family members and their primary cardholder. These relationships are essential for maintaining data integrity and supporting the automated update processes.
Figure 5 illustrates the ERD, showing the entities and their respective attributes.
Following this, the relationships between these entities were clearly defined, each person is linked to one company, and each family member is associated with a specific employee. Special attention was given to ensuring data integrity, traceability, and eligibility validation, which are essential to guarantee secure access and prevent misuse. This included the implementation of mechanisms to verify user status (such as active or inactive), ensure consistency in discount plans, allow for future scalability in tracking card usage, and expand the system’s functionality.
Once the design was finalized, the preexisting data was cleaned and standardized to ensure accuracy. Subsequently, the DB and its tables were created.
4.2.3. Data Protection and Security Compliance in System Implementation
Given the sensitive nature of health-related data, data protection regulations are particularly relevant for CSSMH. The system was designed with key GDPR principles in mind: only essential data, such as the beneficiary’s name, NIF, and National Health Service (SNS) number, is collected (data minimization), and access is restricted through role-based control (integrity and confidentiality). The data is used solely to manage and apply healthcare service discounts (purpose limitation) and is stored securely in a structured SQL Server. Although no direct patient care data is involved, precautions were taken to ensure that data processing is lawful and transparent. For future improvements, adding a formal consent mechanism and data retention policy would further strengthen GDPR compliance.
Sensitive information, such as database credentials, was secured using environment variables instead of hardcoding. This approach aligns with the GDPR principles of integrity and confidentiality and adheres to security guidelines from ISO/IEC 27001 [
42] and OWASP. The verification program operates on a secure server protected by multiple layers of security, including a firewall, established security policies, and mandatory Multi-Factor Authentication (MFA) for administrative access. Furthermore, the server is safeguarded by industry-leading antivirus solutions, and both local and cloud backups are maintained to ensure data integrity and disaster recovery.
4.2.4. Development of the Management Program
A Python-based desktop application was developed to simplify day-to-day DB management for non-technical users, particularly HR staff. This tool allows users to view, update, and manage DB records without requiring direct SQL queries. Key features include:
List Companies and Individuals: The functions retrieve and display records stored in the DB, offering a quick overview of existing information.
Search Individuals by Characteristics: Filter and find individuals based on specific criteria such as name, NIF, or company affiliation.
Add Individuals and Companies Manually: Insert new records into the respective tables through manual entry, valid for on-the-spot registrations.
Bulk Import via Excel: Given that the company frequently receives data in Excel format, the program includes the functionality to import multiple individuals directly from an Excel file at once.
Update Records: Edit key information such as name changes (e.g., due to marriage), updates to employee codes, or health plan alterations.
Delete Records: Companies or individuals can be manually deleted in extreme cases. An Excel-driven deletion function was also created to handle removals more efficiently for large batches.
Status Management: A function was implemented to update an individual’s status from active to inactive rather than permanently deleting records. This preserves historical data and aligns with best practices for maintaining data integrity.
The program includes validation mechanisms to ensure that all operations comply with the DB’s rules and maintain its integrity.
4.2.5. Automated Update Program and Retrieval and Synchronization of SNS Numbers
A second automated Python program was developed to eliminate manual effort and ensure data consistency. This script runs daily, automatically retrieving the latest information from partner DBs and updating the CSSMHSI DB. Additionally, a helper script was also created to obtain the SNS number, a unique identifier for patients in the Portuguese healthcare system, as it was missing from the current DBs used to gather other client information. The aim was to extract this data from the M1 software DB by matching users in our internal DB by their corresponding NIF entries.
4.2.6. Backend System Architecture and Functionality
A simple web-based interface was developed for quick user eligibility verification by hospital staff, allowing checks to be performed using the user’s NIF. The backend architecture was built using Python and the Flask framework. This setup manages secure and efficient interactions with the SQL Server DB to verify the user’s eligibility, associated company, and discount plan. The backend’s core function is to execute the complex verification logic and return a simple status to the frontend.
4.2.7. Frontend Design and Functionality
The user-facing component of the system, designed for quick eligibility checks by hospital staff, was built as a lightweight and intuitive web interface using HTML, CSS, and JavaScript. The primary design goal was to prioritize usability and speed to ensure minimal disruption to the patient check-in process.
The interface is intentionally simple, featuring a single, easily accessible input field for the NIF. After the staff member enters the NIF, the system returns the user’s status with immediate visual feedback. This feedback is managed through a color-coded system for instant recognition:
A green label signifies the user is active and fully eligible for discounts;
A red label indicates the user is inactive and does not qualify for the loyalty program benefits;
A blue label is used to display the associated company for cross-reference.
The interactivity of the system is managed by JavaScript, which facilitates asynchronous communication (AJAX) with the Flask backend. This design is crucial because it allows the system to query the SQL Server DB and display the results without requiring a full page reload, providing a seamless, near-instantaneous user experience that significantly reduces the patient’s waiting time at the reception desk. Clear, informative error messages guide users through issues like empty fields or failed backend communication.
A typical verification process consists of:
Accessing the Site: The receptionist accesses the dedicated verification site from any networked workstation within the hospital;
Input and Search: The receptionist enters the NIF of the individual being checked (either the cardholder or the related employee) and initiates the search;
Data Retrieval: The system receives and displays the user’s information or an explicit error message if the NIF is invalid or not found.
Result Interpretation: The staff interprets the result, which is supported by a color-coded status indicator for immediate visual recognition (see
Figure 6 below for an example).
4.2.8. Integrating Family Members into the Discount System
The core system was fundamentally designed to manage the employee data provided by partner companies. However, the system also needed a robust solution to accommodate eligible family members who are entitled to the same health discount benefits. These individuals are not included in official company employee records, and, critically, pre-collecting this sensitive information from each partner company was not feasible due to both data privacy concerns and significant administrative limitations.
To address this challenge effectively, a practical on-site registration solution was implemented. This process is triggered upon arrival when family members requesting access to the discount must first provide the NIF of the employee to whom they are related. This employee NIF is immediately verified through the existing validation mechanism to confirm the primary cardholder’s active status.
If the employee association is confirmed, the receptionist then uses a dedicated registration program, which adds the family member to a specific table within the centralized DB. This specialized table is exclusively designed to manage these secondary cases by linking each family member directly to the corresponding employee record via foreign keys.
To ensure efficient operation and ease of use, and to eliminate the dependency on a local Python environment installation, this registration program was packaged as a standalone executable. The application was installed directly on the front desk workstations, making it clearly labeled and easily accessible. This design allows staff to launch the form quickly, enter the required family member data, and submit it with a single click. This capability allows for the real-time registration of eligible family members without holding up the patient queue, all while rigorously maintaining data integrity and compliance standards.
For new employees, a distinct proactive process was established to manage their family enrollment. The Human Resources (HR) departments of all partner companies agreed to proactively ask new employees which eligible family members they wish to include in the loyalty plan. This pre-collected information is then securely communicated from the partner company’s HR department to CSSMH’s HR department, allowing the centralized DB to be updated accordingly before the family member ever arrives at the hospital, thereby ensuring seamless discount access from the start.
4.3. Implementation, Monitoring and Controlling
Following the successful completion of the system’s development, comprehensive user manuals were immediately distributed to all relevant staff members to facilitate a smooth operational transition. It is essential to note that the digital loyalty program only entered active use at the very end of May 2025. Consequently, the current dataset on system utilization remains limited, reflecting both this very recent implementation date and the initial number of individuals who have visited CSSMH to access the discounts. Despite the short implementation window, initial rigorous testing by the IT team confirmed that the entire system operates reliably and efficiently.
To ensure that all DB modifications are executed correctly and that the programs are consistently functioning as intended, we implemented comprehensive logging mechanisms. Most automated programs generate detailed log files that meticulously record every data change, including the specific type of modification, the affected DB records, and the precise date and time of the event. For manual updates, additional fields, such as the transaction timestamp and the user’s username, are also stored directly in the DB, which significantly enhances traceability and accountability. Furthermore, automated notifications are configured to instantly confirm successful executions or to promptly alert administrators in case of errors or operational anomalies. This systematic approach to logging and monitoring ensures the overall reliability and smooth operation of the new digital system while supporting stringent compliance and audit requirements.
Building on this foundational operational integrity, further monitoring efforts will concentrate on two primary strategic aspects: the frequency of health card use across various medical specialties and the effectiveness of the reception staff’s interaction with the new verification website.
Usage Frequency by Service Type: The system now meticulously captures detailed data on the frequency of health card usage categorized by various medical specialties. This information is crucial for strategic evaluation, as it reveals which services are most highly valued by cardholders and helps identify opportunities to proactively promote underutilized departments. This monitoring is particularly relevant given that, historically, some users have opted for alternative health insurance discounts when those external policies offered greater financial advantages. This situation resulted in missed revenue opportunities for the hospital, as external insurance discounts can be utilized at any healthcare provider, not exclusively at CSSMH. The loyalty program is specifically designed to be highly scalable, allowing current partner companies and other large organizations (such as banks or similar entities) to join and offer the benefit to their employees. Therefore, providing more attractive, competitive discounts based on usage insights could significantly increase the program’s overall appeal and competitive position. These insights are visually summarized in automated monthly reports generated using Visual Studio Reporting tools (see
Figure 7 for an example). These detailed reports will be automatically dispatched to the marketing manager, providing a comprehensive breakdown of card usage by service and corresponding specialty. This type of automated reporting is already standard practice in other areas of the hospital.
Reception Staff Engagement: Monitoring is also extended to the reception staff’s interactions, specifically tracking how frequently card transactions are processed using the new system. This operational data is crucial for assessing staff adaptation to the new digital workflow and for efficiently identifying any remaining or additional training needs. Ensuring that all personnel are proficient in using the real-time verification tool allows the hospital to maintain high standards of service quality and operational consistency across all points of patient entry.
Figure 7.
Sample automated report generated with Visual Studio Reporting tools, illustrating card usage by service and specialty.
Figure 7.
Sample automated report generated with Visual Studio Reporting tools, illustrating card usage by service and specialty.
The analytical reports generated from this systematic monitoring process offer valuable, actionable insights for hospital management. By examining trends in both card usage and staff engagement, decision-makers are empowered to accurately evaluate the program’s overall effectiveness and to identify specific areas for further enhancement. For instance, if certain medical specialties consistently show lower card usage rates, the management may consider implementing targeted communication strategies or making strategic adjustments to the discount structure to increase appeal. This data-driven approach ensures that hospital resources are allocated effectively and that the loyalty program continues to evolve dynamically in response to both patient demands and institutional needs.
To assess the degree of improvement, the redesigned process was evaluated using a multi-dimensional healthcare logistics framework, focusing on service-level, resource-oriented, and flow-based performance indicators [
26,
27,
28]. Prior to implementation, eligibility verification exhibited high stochastic variability and frequent delays, negatively affecting front-office service levels. Following implementation, verification is completed within a predictable time window, improving service responsiveness and reliability. Administrative workload was analyzed as an indicator of resource utilization efficiency. Whereas the previous process required multiple manual interactions, such as verbal confirmation, fragmented system checks, and manual DB updates, the redesigned workflow consolidates these activities into a single automated step, improving staff productivity and reducing cognitive load on reception personnel [
57,
58,
59].
Implementation of the new solution also significantly reduced the time required for eligibility verification. The process now typically takes less than one minute, compared to up to five minutes previously, and the internal interface requires no direct login, further streamlining operations. This improvement supports a faster, more reliable workflow and enhances the patient’s experience. These times refer specifically to the eligibility verification step; the entire check-in process may still take longer.
Building on these performance improvements, we conducted an initial operational analysis to evaluate the system’s functionality, scope, and usage across service types. Rather than limiting our assessment to the post-implementation period, data collection began when the system was ready for deployment. Although the official rollout was delayed at the start of May, the system was prepared and suitable for early evaluation. This approach ensures we capture the solution’s benefits from its earliest operational stage. It is important to note that the DB remains limited, particularly regarding information on family members and Silver plan employees. Consequently, our analysis focused on card usage by service and specialty, comparing the total number of consultations (Pk) to the distinct number of users (Np) who booked them. Users were further categorized as ComRH (present in the new DB and eligible for verification) or SemRH (not yet in the new DB and therefore not eligible for automated verification) (see
Figure 8).
During this period, out of 224 services booked, there were 116 unique users. Of these, only 35 were already present in our DB and could be verified, leaving 81 users (accounting for 159 medical acts) who still required the previous manual verification process. In other words, almost 70% of users and, correspondingly, around 71% of services during this period could not yet benefit from automated eligibility checks.
Even so, this already represents a 30% improvement over the previous AS-IS process; however, further progress is still needed. To better understand the limitations of the current system, we analyzed the usage patterns of the discount program further. For example, in outpatient consultations, the number of users not present in the DB and using the discount was more than double those who could be automatically verified (see
Figure 9). This gap poses a significant risk of financial loss due to potential errors or delays in manual verification.
Considering the most extreme scenario, where manual eligibility verification previously took up to five minutes per case compared to less than one minute with the new system, the reduction in time is substantial. The process now requires only 20% of the time previously needed, resulting in an 80% decrease per verification. With 30% of cases now processed in a maximum of one minute instead of five, this already translates to a 24% reduction in total time spent on eligibility verification.
Furthermore, Flow Efficiency (FE) was calculated to quantify the proportion of value-added activities in the verification process, using the standard formula: FE = VAT/TLT × 100, where Value-Added Time (VAT) represents the time spent on actual eligibility verification, and Total Lead Time (TLT) represents the total lead time including non-value-added activities such as patient data entry, waiting, and rework. The decomposition of times is presented in seconds in
Table 3.
In the AS-IS process, only the manual verification step (90 s) contributed to value-added time out of a total lead time of 300 s, resulting in FE = 30%. In the TO-BE process, automated verification accounted for 25 s of value-added time, while the total lead time was reduced to 60 s due to elimination of waiting and rework; patient data entry remained non-value-added. This led to a FE of approximately 41.7%. The overall FE results are summarized in
Table 4. These results demonstrate that automation significantly increases the proportion of value-added activities by around 11.7% while reducing total lead time by 80%.
Process throughput was further assessed as an indicator of service flow capacity. Variability in the baseline process had constrained client intake during peak periods; the redesigned system now allows higher patient volumes without additional human resources. Operational quality was evaluated via the rate of rework and exception handling. Verification failures requiring repeated checks or corrective DB entries have been largely eliminated through mandatory validation and automated discount application, reducing operational waste and improving overall flow reliability [
57,
59]. Finally, process consistency was evaluated as a measure of operational reliability. Standardizing the verification sequence across staff members has reduced execution variability. Together, these improvements provide a robust assessment of the degree of operational enhancement achieved, consistent with state-of-the-art healthcare [
58] and BPM evaluation practices [
26].
5. Discussion
The aim of this study was to design, implement, and evaluate a Health 4.0-oriented loyalty program capable of improving operational efficiency, data reliability, and patient flow management within a Portuguese private hospital. To this end, the full BPM lifecycle was applied, resulting in a digital solution that integrates a centralized SQL database, automated eligibility verification routines, and a dedicated administrative interface embedded in daily operations. The system’s impact was assessed using a multi-dimensional logistics framework combining FE, throughput analysis, and operational quality indicators, enabling a structured evaluation of lead-time reduction, process stability, and workflow reliability.
First, the results show that automation substantially improves administrative process performance. Verification time was reduced by approximately 80%, decreasing from an average of five minutes to under one minute, while FE increased from 30% to 41.7%. Additionally, with 30% of cases now processed in one minute instead of five, the system achieves an overall 24% reduction in total time spent on eligibility verification. These improvements reflect a higher proportion of value-added work following the elimination of waiting, confirmation delays, and rework activities. The quantitative gains are consistent with the observed reduction in process variability and the more predictable execution times recorded during the initial monitoring period.
Second, the study highlights the critical role of centralized data management in improving data accuracy and reducing operational risk. In the AS-IS process, fragmented information sources and manual verification procedures led to inconsistent discount application, frequent rework, and an increased likelihood of billing errors. The introduction of a centralized SQL-based database, combined with automated synchronization with the M1 system and structured handling of employees and family members, eliminated previously observed verification failures and ensured standardized discount allocation across plans and partner entities.
Third, the findings confirm the value of BPM as a structured methodology for healthcare process improvement in non-clinical contexts. The AS-IS analysis identified key bottlenecks, including manual verification, dispersed information sources, and execution variability across staff members. These inefficiencies were systematically addressed in the TO-BE model through automation, standardization, and process simplification supported by BPMN modeling. The observed improvements in lead time, FE, throughput, and error reduction validate the assumptions defined during the redesign phase and demonstrate that the implemented solution performs reliably under real operating conditions. The TO-BE model also confirms that eliminating operational waste has created a more seamless and dependable information flow [
59].
Fourth, the study shows that automation enhances throughput and service flow capacity, particularly during peak periods. In the baseline process, operational variability and manual checks constrained patient intake and increased pressure on reception staff. The redesigned system supports higher patient volumes without additional staffing [
57], by shortening verification time and reducing interruptions related to discount confirmation and price validation. Initial usage monitoring by service and specialty indicates that, even with a still-growing database, especially for family members and Silver plan employees, the new workflow already absorbs demand more efficiently. Eligibility verification has evolved from a manual administrative task into a high-throughput logistical component within the patient service chain [
58].
Finally, this study underscores that loyalty programs can function as internal logistical systems that directly influence administrative performance rather than serving solely as marketing instruments. By treating eligibility verification as a high-throughput logistical component within the patient service chain and supporting it with logging, monitoring, and reporting mechanisms, the hospital reduced administrative burden, improved the reliability of discount application, and enabled real-time decision-making at the front desk. These findings expand the strategic relevance of loyalty programs within healthcare operations and information systems.
5.1. Theoretical Implications
This study makes several theoretical contributions to the fields of Health 4.0, BPM, healthcare loyalty programs, and healthcare information systems, in line with the novelty dimensions identified in
Section 1.2.
First, the study extends Health 4.0 theory by demonstrating that its principles can be effectively applied to administrative and logistical processes within healthcare organizations. While prior research has predominantly focused on clinical applications such as smart devices, patient monitoring, and decision-support systems, this study shows that Health 4.0-oriented solutions can also play a central role in structuring and stabilizing high-frequency administrative workflows. By embedding a loyalty program within daily hospital operations and supporting it through automation and real-time data integration, the study broadens the conceptual scope of Health 4.0.
Second, the study advances BPM theory in healthcare by illustrating how the full BPM lifecycle can be operationalized and empirically evaluated in a non-clinical context. Existing literature often emphasizes process modeling or isolated redesign phases, with limited evidence of end-to-end deployment combined with system-integrated performance evaluation. By integrating AS-IS and TO-BE modeling, BPMN-based redesign, and quantitative and qualitative indicators such as lead time, FE, throughput, and error reduction, this research reinforces BPM as a comprehensive transformation methodology rather than a purely descriptive or analytical approach.
Third, this study contributes to loyalty program theory by reframing loyalty mechanisms as operational systems embedded in service delivery processes. Whereas prior studies have largely focused on satisfaction, loyalty drivers, and retention intentions, this research conceptualizes eligibility verification as a high-frequency, process-integrated activity that affects internal logistics and billing accuracy. This perspective links loyalty program research with operations management and demonstrates that loyalty programs can generate operational value alongside relational and behavioral outcomes.
Fourth, the study contributes to information systems and data management theory by highlighting the role of centralized databases and automated routines in supporting operationally critical healthcare processes. In contrast to fragmented or largely theoretical data integration approaches reported in the literature, this study provides empirical evidence of how a centralized SQL-based database enables real-time eligibility verification and standardized rule enforcement. These findings support theoretical perspectives that emphasize data integration, structure, and operationalization as key sources of digital value.
Finally, the study enriches the empirical literature on Health 4.0 and healthcare operations by providing a real-world case from the Portuguese context. Given the scarcity of system-level, operational studies conducted in Portuguese healthcare institutions, this research offers context-sensitive insights and demonstrates how national-specific constraints, such as legacy information systems and regulatory requirements, can be addressed through integrated BPM, data management, and automation strategies.
5.2. Implications for Managers and Policymakers
The findings of this study offer clear and actionable implications for healthcare managers, IT teams, and policymakers seeking to improve administrative efficiency, data governance, and service flow through digital transformation.
For healthcare managers, the observed 80% reduction in eligibility verification lead time and the increase in FE from 30% to 41.7% demonstrate that even relatively small administrative processes can yield substantial performance gains when redesigned using BPM and automation principles. Managers can use similar AS-IS/TO-BE analyses to identify bottlenecks, reduce variability, and stabilize front-desk operations, particularly during peak periods, thereby improving staff productivity and patient flow without increasing headcount.
From an operational and financial control perspective, the introduction of mandatory verification rules, centralized discount parameters in M1, and automated discount application reduces human error and ensures consistent enforcement of pricing policies. This directly lowers the risk of incorrect billing, manual corrections, and revenue leakage associated with eligibility misclassification. Managers responsible for revenue assurance and partner agreements can leverage such systems to improve transparency and accountability across complex discount structures.
For IT teams, the study provides a concrete example of how modular architectures, combining a centralized SQL database, Python-based automation routines, a web-based interface, and logging and reporting mechanisms, can be implemented incrementally and integrated with existing legacy systems. This approach allows organizations to modernize administrative processes without full system replacement, while maintaining scalability for future extensions such as expanded partner coverage, enhanced monitoring, or advanced analytics.
From a policy perspective, the case highlights the importance of promoting interoperability, data governance, and secure automation in healthcare systems. Policymakers can use this evidence to support initiatives that encourage standardized data structures, controlled data sharing between organizations, and the adoption of automation aligned with regulatory frameworks. The alignment of the implemented system with GDPR principles and security best practices such as ISO/IEC 27001 [
42] and OWASP demonstrates that efficiency gains in administrative logistics can be achieved without compromising data protection, patient privacy, or institutional trust.
5.3. Limitations and Future Research Directions
Despite its contributions, this study has several limitations that suggest directions for future research, many of which are consistent with the monitoring and expansion perspectives already identified in the system design.
First, the analysis is based on a single Portuguese private hospital, which may limit the generalizability of the findings to other institutional, organizational, or regulatory contexts. Future studies should replicate the methodology in different healthcare settings, including public hospitals and multi-site organizations, to compare implementation challenges, legacy system constraints, and performance outcomes.
Second, the study confirms that access to up-to-date partner company data remains a constraint, particularly for expanding coverage of Silver plan employees and their family members. Future research could examine different interoperability frameworks and data-sharing arrangements between hospitals and partner organizations, assessing how varying integration strategies affect data completeness, verification reliability, and financial risk.
Third, the present work focuses primarily on the eligibility verification component of the loyalty program and its immediate logistical and operational effects. Subsequent studies could extend the analysis to other elements already identified as relevant within the monitoring framework, such as usage patterns by service and specialty, beneficiary engagement over time, and the impact of targeted communication or discount adjustments on service mix and retention.
Fourth, evaluation was shortly after system implementation, using an initial dataset that reflects a recent rollout and limited penetration among eligible users, particularly family members. Longitudinal studies are needed to assess the sustainability of efficiency gains, the evolution of staff workload and adoption, and the system’s resilience to organizational and regulatory changes as the database grows and additional partners are onboarded.
Finally, although automation significantly reduced routine workload and manual rework, some exceptions and data corrections still require manual handling, and the monitoring framework is at an early stage of maturity. Future research could investigate how enhanced rule-based decision support and more advanced monitoring dashboards can further reduce exception handling effort, support proactive management of underused services or segments, and strengthen evidence-based decision-making regarding discount structures and partner portfolio evolution, while remaining compliant with GDPR and existing security practices.
6. Conclusions
Delivering high-quality healthcare services depends not only on medical excellence but also on the efficiency and adaptability of supporting processes. In this context, implementing a digital, data-driven loyalty card verification platform at CSSMH represents a significant advancement in aligning operational practices with Health 4.0 principles and the broader digital transformation underway in the healthcare sector.
The creation and integration of a centralized database, supported by automation tools such as Python and SQL Server, directly addressed longstanding issues of data reliability, traceability, and process fragmentation. The introduction of a monitoring framework now enables real-time visibility into card usage and staff interactions, providing management with actionable insights for operational decision-making. These developments reflect the importance of data-driven loyalty systems highlighted by [
30] and demonstrate how digital infrastructures can enhance both patient engagement and institutional competitiveness.
This transformation directly reflects the BPM lifecycle articulated by [
26,
28], whose structured methodologies enabled the systematic redesign and optimization of workflows. The adoption of BPMN modeling and collaborative tools, as advocated by [
30], proved essential for building consensus and reducing resistance among staff, ensuring that process changes were both understood and embraced across the organization. Equally critical was the emphasis on data protection and compliance, guided by [
4] and international standards such as ISO/IEC 27001 [
42] and OWASP. Their guidelines ensured that the system not only met legal requirements but also fostered patient trust through robust security measures. The study’s alignment with Health 4.0, as described by [
9,
29], is evident in creating a scalable, interoperable, patient-centered platform. Loyalty management strategies, drawing on the insights of [
8,
15,
47], were embedded to strengthen patient engagement and institutional reputation.
From a healthcare logistics and supply chain perspective, the results of this study are consistent with recent HCSC literature emphasizing the role of information integration, visibility, and process coordination in enhancing operational resilience and performance [
49,
50]. The observed reductions in processing time, error susceptibility, and administrative workload align with evidence that digitally enabled information flows and standardized decision mechanisms improve responsiveness and reliability in healthcare operations [
51,
52]. Moreover, the establishment of centralized data governance and real-time monitoring capabilities reflects the resilience-oriented principles associated with supply chain immunity, particularly the importance of transparency, traceability, and adaptive response mechanisms in routine operations [
54,
55].
While some limitations remain, these do not diminish the demonstrated effectiveness of the implemented solution. Instead, they highlight areas where the system can be further strengthened as adoption expands. Moreover, the preliminary outcomes reinforce a culture of evidence-based decision-making and continuous improvement within the institution.
In summary, this paper highlights how the structured application of principles from BPM, healthcare logistics, information security, and customer loyalty can generate tangible value in a healthcare setting.