4.2 Registry Staffing Formulas, Time Studies & Resource Allocation

4.2 Registry Staffing Formulas, Time Studies & Resource Allocation

Establishing defensible, data-driven staffing levels is among the most vital responsibilities of cancer registry administration. Without empirical workload analysis, registries frequently suffer from unmanageable abstracting backlogs, missed state reporting deadlines, compromised data quality, and non-compliance with Commission on Cancer (CoC) accreditation standards. Independent prep by OpenExamPrep provides this comprehensive guide to workload analysis, time-and-motion studies, Full-Time Equivalent (FTE) formulas, and operational backlog resolution.

---

Workload Analysis & Time-and-Motion Studies

Rather than relying on arbitrary staffing estimates, registry leadership must conduct structured workload analyses supported by empirical time-and-motion studies. A time-and-motion study systematically measures the exact time required for credentialed staff to execute specific registry tasks under standard operational conditions.

Methodology for Conducting a Registry Time Study

1. Define Core Operational Task Categories: Segment registry work into discrete, measurable units: casefinding screening, analytic abstracting, non-analytic abstracting, patient follow-up, cancer conference coordination, quality control auditing, and administrative reporting.
2. Stratify Abstracting by Case Complexity: Recognize that tumor abstraction time varies widely by anatomical site, clinical stage, and treatment modality. A localized prostate adenocarcinoma managed with active surveillance requires significantly less documentation than an advanced stage III inflammatory breast carcinoma receiving neoadjuvant systemic therapy, bilateral mastectomy with axillary dissection, adjuvant radiation, and hormonal therapy.
3. Establish an Unbiased Sampling Period: Log time data continuously across all abstracting personnel over a representative multi-week period (typically 4 to 8 weeks), avoiding periods with major holiday interruptions or software system downtimes.
4. Incorporate System and Administrative Interruptions: Capture true operational time by factoring in unavoidable administrative delays, electronic health record (EHR) system latency, chart request lag times, and mandatory hospital training.
5. Calculate Standard Statistical Averages: Compute mean completion times, median values, and standard deviations for each task to establish institutional baseline benchmarks.

---

Benchmark Abstracting Times & Task Durations

No standard setter publishes a mandatory abstracting time. The ranges below are illustrative planning figures commonly used as a starting point; replace them with your own time-study results:

---

Full-Time Equivalent (FTE) Calculation Methodology

A Full-Time Equivalent (FTE) is a standardized unit representing the workload of one full-time employee working standard annual business hours. Accurately determining required registry FTEs requires distinguishing between gross hours and net productive hours.

Gross Hours vs. Net Productive Hours

A standard full-time employee is compensated for 40 hours per week across 52 weeks per year: $\text{Gross Annual Hours} = 40 \times 52 = 2,080 \text{ hours per 1.0 FTE}$

However, an employee cannot abstract cases for 2,080 hours. Registry managers must subtract non-productive paid time, including:

• Paid Time Off (PTO / Vacation): 120 to 160 hours annually
• Paid Holidays: 80 to 88 hours annually (typically 10 to 11 hospital holidays)
• Sick Leave: 40 to 80 hours annually
• Continuing Education & Professional Development: time for the ODS requirement of 20 CE credits per two-year cycle (about 10 hours a year, including Category A and in-person CEIP credits), plus any additional training the program requires
• Administrative & Departmental Meetings: 40 to 50 hours annually

Subtracting non-productive hours (averaging 320 to 430 hours) yields the Net Productive Hours: $\text{Net Productive Hours per FTE} = 2,080 - 380 = 1,700 \text{ productive hours/year}$ Net productive hours depend on each employer's leave and meeting policies. A figure around 1,650–1,760 hours per 1.0 FTE is common, and 1,700 hours is a convenient planning assumption, but you should calculate your own.

Dedicated Abstractor vs. Mixed-Role Registrar Productivity

• Pure Abstractor Benchmark: A dedicated 1.0 FTE abstractor whose sole responsibility is abstracting analytic cases (spending 100% of net productive time abstracting) completes an average of 500 to 750 analytic abstracts per year (averaging 2.5 to 3.5 complex cases per 8-hour shift, or 45 to 60 cases per month).
• Mixed-Role Registrar Reality: In many community cancer programs, registrars handle casefinding, cancer conferences, follow-up, and administrative requests in addition to abstracting. In such environments, non-abstracting duties consume 40% to 60% of total staff time. Consequently, a mixed-role 1.0 FTE registrar can only complete 250 to 350 analytic abstracts per year.

Mathematical Formula for Registry Staffing

To calculate total required FTEs, registry managers use a three-step formula:

Step 1: Calculate Total Direct Abstracting Hours
        Hours_Abstracting = (Analytic Volume × Avg Time) + (Non-Analytic Volume × Avg Time)

Step 2: Factor Non-Abstracting Operational Overhead
        Hours_Total = Hours_Abstracting / (1.0 - Non-Abstracting Fraction)

Step 3: Divide by Net Productive Hours per FTE
        Required FTEs = Hours_Total / Net Productive Hours (e.g., 1,700)

Worked Example

A cancer program accessions 1,000 new analytic cases and 200 non-analytic cases annually. The registry time study demonstrates that analytic cases require an average of 2.0 hours, while non-analytic cases require 0.5 hours. Non-abstracting duties (casefinding, follow-up, cancer conferences, quality control) consume 35% of total staff effort. The facility's net productive hours per FTE are 1,700 hours per year.

1. Calculate Direct Abstracting Hours: $\text{Analytic Hours} = 1,000 \times 2.0 = 2,000 \text{ hours}$ $\text{Non-Analytic Hours} = 200 \times 0.5 = 100 \text{ hours}$ $\text{Total Abstracting Hours} = 2,000 + 100 = 2,100 \text{ hours}$

2. Account for Non-Abstracting Operational Time (35%): If non-abstracting time is 35%, direct abstracting represents $1.0 - 0.35 = 0.65$ (65%) of total required program hours: $\text{Total Program Hours} = \frac{2,100}{0.65} = 3,230.77 \text{ hours}$

3. Determine Required Full-Time Equivalents: $\text{Required FTEs} = \frac{3,230.77}{1,700} = 1.90 \text{ FTEs}$

Result: The facility requires 1.90 FTEs (typically staffed as two full-time ODS registrars) to maintain timely, accredited operations.

---

Facility Complexity Adjustments

Staffing formulas must be adjusted for institutional clinical complexity. The time required to abstract a cancer case is directly proportional to the complexity of care provided:

---

Managing and Resolving Abstracting Backlogs

An abstracting backlog occurs when eligible cases remain unabstracted beyond the deadlines the registry must meet. For a CoC-accredited program those deadlines are (1) Standard 6.4, which requires submitting all new and updated cases to the Rapid Cancer Reporting System at least once each calendar month; (2) the state's reporting deadline, often about six months; and (3) the abstracting timeliness goal the program sets in its Standard 6.1 quality control protocol, where timeliness is one of the required review activities. The 2020 CoC standards do not set a single national abstracting deadline. Falling behind these deadlines risks noncompliance and incomplete quality measure reporting.

Root-Cause Analysis Framework

When a backlog develops, the registry manager must conduct an immediate root-cause analysis rather than simply demanding increased speed, which inevitably erodes data quality. Common systemic root causes include:

• Personnel Turnover & Vacancies: The departure of an ODS registrar, followed by protracted recruiting cycles due to national workforce shortages.
• EHR System Migrations: Disruptions caused by hospital-wide EHR transitions that sever automated casefinding feeds and alter clinical documentation layouts.
• Institutional Caseload Surges: Expansion of clinical oncology services (e.g., opening a new surgical oncology wing or recruiting specialty oncologists) without commensurate registry staffing increases.
• Inefficient Workflow Bottlenecks: Manual chart retrieval, delayed pathology addenda, or cumbersome paper-based cancer conference coordination.

Prioritized Accessioning & Case Triage

When managing an existing backlog, abstractors must not simply process cases in random chronological order. Cases must be triaged according to strategic regulatory priorities:

                          [Backlog Case Triage]
                                    │
                                    ▼
    [Priority 1: Cases needed for monthly RCRS submission]
     (All new and updated analytic cases, CoC Standard 6.4)
                                    │
                                    ▼
       [Priority 2: State Central Registry Submission Deadlines]
          (Cases approaching statutory state reporting cutoff)
                                    │
                                    ▼
        [Priority 3: Upcoming Multidisciplinary Tumor Boards]
         (Active prospective clinical cases requiring review)
                                    │
                                    ▼
        [Priority 4: Remaining Complex Inpatient Analytic Cases]
           (Surgical resections, multimodality therapy)
                                    │
                                    ▼
         [Priority 5: Non-Analytic Cases (Class 30–99)]
             (Outpatient consults, history-only cases)

Deploying Temporary Contract Abstractors

If internal overtime cannot resolve the backlog within three to six months, the manager should retain contracted abstracting services. To calculate the necessary temporary support: $\text{Contract FTEs Needed} = \frac{\text{Backlog Case Volume}}{\text{Target Months to Resolve} \times \text{Expected Monthly Contractor Output}}$ Example: To eliminate a 600-case backlog within 4 months, assuming an experienced contract ODS abstracts 75 cases per month: $\text{Contract FTEs} = \frac{600}{4 \times 75} = \frac{600}{300} = 2.0 \text{ Temporary Contract FTEs}$

Governance Reporting & Dashboard Metrics

Throughout the backlog resolution period, the registry manager must present a monthly backlog dashboard to the Cancer Committee and hospital executive leadership. Key metrics include:

• Total unabstracted cases categorized by age (0–3 months, 3–6 months, > 6 months).
• Average days from first contact to abstract completion.
• Monthly abstracting completion velocity (cases abstracted vs. incoming casefinding volume).
• Quality audit scores on backlogged batches to prove that speed did not sacrifice accuracy.