Centre Activity

Personal Registries per Centre

The following plots represent the number of personal records, in line with the operative-log functionality, by department.

Note

• Panel periods refer to the date of surgical intervention for each record, not the moment of its inclusion in the platform.

• Personal records referring to a date of surgical intervention prior to the launch of ReSECT, January 1, 2023, are grouped into a single panel.

Overall

Code

oplog_center_plot()

2023

Code

oplog_center_plot(2023)

2024

Code

oplog_center_plot(2024)

Anatomical Lung Resection Process

Procedures per Department

Important

• Due to the prospective nature of the anatomical lung resection process, only procedures performed after activation date of each department are considered.

• Check if you have missing values for the variable “date of surgery” if the overall figures do not match the sum of annual cases.

• In versions prior to July 1, 2024, only those patients with a saved preoperative form were counted for department volume purpose. Since then, patients with either a saved preoperative form or a surgical intervention form are counted for the same purpose.

Overall

Code

rpa_center_n()

2023

Code

rpa_center_n(2023)

2024

Code

rpa_center_n(2024)

Forms per Department

The degree of participation of each centre in the anatomical lung resection process is evaluated for each of the forms that make up this process.

Activity is measured in terms of the number of active forms, together with the completion of one or more fields considered key for each type of form. A form is activated when it is assigned a main procedure identifier (first variable of each form).

PreOp

Code

rpa_center_forms(regPersonal)

Surgery

Code

rpa_center_forms(rpaCirugia)

PostOp

Code

rpa_center_forms(rpaPostop)

Diagnosis

Code

rpa_center_forms(rpaDx)

Follow-Up

Code

rpa_center_forms(rpaFollow)

ALR Department Participation Index

The participation index by department in the anatomical lung resection process (DPI_ALR) is determined, on an annual basis, by summing up the six-monthly participation indexes of the users working in each centre.

A correction factor is applied to take into account the number of active users for each six-monthly period. A user is considered to be active when his or her personal participation index (PPI_ALR) is above the 25th percentile. As a consequence, for the same number of forms, data quality (missing values) and volume of care, a higher number of active users including data will produce a higher DPI_ALR.

\[DPI_{ALR} = USERS_{active} + \sum_{users}^{}PPI_{ALR}\]

Note

• Since a surgical procedure may contain up to five forms, a higher number of forms per procedure usually indicates a higher filling rate of diagnostic and/or follow-up forms.

• Since user activity is evaluated every 6 months, a department can have twice as many active users as the annual number of users with a PPI_ALR.

The following plot represents the maximum DPI values that a given centre can reach as a result of the sum of the activity rates of its users. The most plausible ranges of the independent variables, surgical volume and ratio of missing values per form, are considered on two axes. To obtain the final DPI, the number of active users must be added as described above.

2023

Code

rpa_center_index(2023)

*Procedures: number of anatomical lung resection records. Missing/Form: number of missing values per form based on 35 variables throughout the five forms in the anatomical lung resection process. Users_ppi: number of different users with personal participation index (PPI_ALR) during the year. Users_active: Sum of active users for each six-monthly period. A user is considered to be active when six-monthly personal participation index (PPI) is higher than the 25th percentile of all the users with personal participation index.

2024

Code

rpa_center_index(2024)

Procedures: number of anatomical lung resection records. Missing/Form: number of missing values per form based on 35 variables throughout the five forms in the anatomical lung resection process. Users_ppi: number of different users with personal participation index (PPI_ALR) during the year. Users_active: Sum of active users for each six-monthly period. A user is considered to be active when six-monthly personal participation index (PPI) is higher than the 25th percentile of all the users with personal participation index.

Overall DPI_ALR

Code

names_df_alr_dpi_audit <- ls(pattern="df_alr_dpi_audit_20")
list_names_df_alr_dpi_audit <- lapply(names_df_alr_dpi_audit, get)
df_alr_dpi_audit_overall <- do.call(rbind, list_names_df_alr_dpi_audit)

df_alr_dpi_audit_overall |>
  filter(!is.na(`Audit Date`)) |>
  group_by(Hospital) |>
  mutate(DPI = sum(DPI, na.rm = TRUE)) |>
  select(Hospital, DPI) %>%
  arrange(desc(DPI)) %>%
  ggplot(aes(x = forcats::fct_reorder(Hospital, DPI), y = DPI)) +
    geom_col(fill = color1)+
    geom_label(aes(label = round(DPI,1)), size=2)+
    coord_flip() +
    theme_minimal()+
    labs(x = NULL, y = "\nOverall DPI", caption = "Only the indices resulting from audited years are aggregated.")