Skip to content

Appraisal Workflow Requirements ​

Overview ​

Annual consultant appraisals are a regulatory requirement for medical professionals registered with the AMC (Australian Medical Council) and GMC (General Medical Council, UK). The appraisal process involves collecting evidence across multiple domains, reflecting on practice, and meeting with an appraiser to discuss professional development.

Currently this process is entirely manual — doctors gather evidence from disparate systems, fill in forms by hand, and submit paper/PDF documents. PPP already holds the majority of the data required for an appraisal, making it uniquely positioned to automate this workflow.

Reference: Matt Randell's Loom video walkthrough of the manual AMC/GMC consultant appraisal process.

Appraisal Form Structure ​

The appraisal form consists of 9 sections, each requiring specific evidence and reflection. Below is a breakdown of each section with the current manual process and PPP's automation opportunity.


Section 1: Personal Details & Inputs ​

What the appraiser needs:

  • Full name, registration number, regulatory body
  • Specialty and scope of work
  • Employing hospital(s) and job title
  • Educational supervisor / colleague appraiser
  • Date of last appraisal and appraiser name

Current manual process: Doctor manually enters all personal details each year, often copying from previous appraisals.

PPP automation opportunity: HIGH — PPP holds all user profile data (users table), specialty (speciality table), hospital assignments (user_hospitals), and supervisor relationships (user_supervisors). Previous appraisal history is the only gap (requires new schema, Part 2).


Section 2: Year in Review ​

What the appraiser needs:

  • Summary of clinical work performed
  • Changes to scope of practice
  • Significant events or complaints
  • CPD plan completion status (was last year's plan achieved?)
  • End-of-year reflection

Current manual process: Doctor writes a free-text narrative summarising their year, referencing logbook numbers and CPD records from separate systems.

PPP automation opportunity: HIGH — PPP has CPD plans with completion tracking (cpd_plans.confirmEoy), end-of-year reflections (cpd_end_of_year.reflection jsonb), high-level requirements (cpd_plans.highLevelRequirements), and surgical logbook statistics (activities filtered by type='logbookCase'). The aggregation service can auto-generate a year summary with case counts, procedure breakdowns, and CPD completion rates.


Section 3: Well-being & Health ​

What the appraiser needs:

  • Self-assessment of physical and mental well-being
  • Any health concerns affecting practice
  • Support mechanisms in place
  • WHO-5 or equivalent well-being score trends

Current manual process: Doctor completes a brief well-being self-assessment, often a checkbox or short narrative. Many skip this or provide minimal detail.

PPP automation opportunity: HIGH — PPP has comprehensive wellness data:

  • WHO-5 questionnaire scores (wellness_questionnaire — 5 questions + computed score)
  • Daily wellness/readiness scores (wellness_score_daily — sleep guidance, workload guidance)
  • Health metrics from wearables (health_metric_daily — sleep, HRV, activity data)
  • Trend analysis over the appraisal period

The system can present anonymised trend charts (no raw daily data exposed to appraiser) with the doctor's consent.


Section 4: CPD Activities & Evidence ​

What the appraiser needs:

  • List of CPD activities undertaken during the appraisal period
  • Evidence of learning and impact on practice
  • Hours/points by CPD category
  • CPD plan activities and their completion status

Current manual process: Doctor exports CPD records from their CPD tracker (often a separate system), manually categorises activities, and attaches certificates.

PPP automation opportunity: HIGH — PPP is the CPD tracker. All data is already structured:

  • Activities by type and date range (activities table)
  • CPD plan activities with target points (cpd_plan_activities)
  • CPD categories and classes (cpd_categories, cpd_classes)
  • Activity evidence attachments (via storage)

Auto-generation of CPD summary tables with hours, categories, and completion percentages is straightforward.


Section 5: Multi-Source Feedback (MSF) / 360 Reviews ​

What the appraiser needs:

  • 360 review results with anonymised colleague feedback
  • Multi-Consultant Report (MCR) assessor ratings
  • Multi-Source Feedback (QMF/MSF) results
  • Supervisor sign-off on 360 reviews
  • Reflection on feedback received

Current manual process: Doctor collects feedback forms from colleagues via email/paper, collates results, and presents summaries to the appraiser.

PPP automation opportunity: HIGH — PPP manages the entire MSF/360 workflow:

  • 360 reviews (ppp_360) with status tracking, supervisor assignment, and sign-off
  • 360 reviewers (ppp_360_reviewers) with response tracking and reminders
  • Individual review responses (ppp_360_reviews) with questions and answers
  • MCR assessor responses (mcr_assessor_responses) with attributes/ratings
  • MSF/QMF activities (activities where wbaType='qmf')
  • Automated reminder service already exists (appraisalReminderService)

Section 6: Workplace-Based Assessments (WBAs) ​

What the appraiser needs:

  • Summary of WBAs completed (CEX, CBD, PBA, SSA)
  • Assessor ratings and progression trends
  • Case mix and complexity analysis

Current manual process: Doctor prints WBA forms or references a separate e-portfolio system.

PPP automation opportunity: HIGH — PPP stores all WBA types:

  • Activity types: cex, cbd, pba, ssa (via wbaTypes enum)
  • Assessor ratings (conRatingLevel)
  • Case details (hospital, procedure, acuity, patient demographics)
  • Progression charts can be auto-generated from historical data

Section 7: Mandatory Training ​

What the appraiser needs:

  • Evidence of completed mandatory training (fire safety, infection control, manual handling, etc.)
  • Compliance status against hospital requirements
  • Training expiry dates

Current manual process: Doctor provides certificates from hospital LMS or HR system.

PPP automation opportunity: LOW — PPP does not currently track mandatory training records. This data typically lives in hospital Learning Management Systems (LMS). Options for future integration:

  1. Manual upload of training certificates (simple file attachment)
  2. LMS integration via API (complex, hospital-specific)
  3. Hospital admin bulk import capability

Gap: Requires new schema (Part 2) or external integration.


Section 8: Personal Development Plan (PDP) ​

What the appraiser needs:

  • Current PDP goals and objectives
  • Progress against previous PDP
  • New PDP for the coming year
  • How goals will be achieved (methods, resources, timeline)

Current manual process: Doctor creates a new PDP document (Word/PDF), references last year's goals, and sets new ones in discussion with their appraiser.

PPP automation opportunity: MEDIUM — PPP has CPD plans which partially overlap with PDP functionality (cpd_plans.highLevelRequirements), but a structured PDP with goals, milestones, and AI-generated suggestions requires new schema.

Gap: Requires new appraisal_pdp_goals table (Part 2) and AI generation service (Part 5).


Section 9: Checklists & Summary / Submission ​

What the appraiser needs:

  • Pre-appraisal checklist (all evidence gathered?)
  • Appraiser's summary and recommendations
  • Outcome: satisfactory / unsatisfactory / deferred
  • Sign-off by both doctor and appraiser
  • Date of next appraisal

Current manual process: Paper checklist, manual sign-off, PDF submission to medical administration.

PPP automation opportunity: MEDIUM — Requires a new workflow engine:

  • Pre-submission validation (are all sections complete?)
  • State machine for appraisal lifecycle (draft → submitted → under review → completed)
  • Digital signature / acknowledgement by both parties
  • PDF export of completed appraisal

Gap: Requires new workflow schema (Part 2) and state machine service (Part 6).


Automation Priority Matrix ​

SectionPriorityData AvailableGap LevelTarget Part
1. Personal DetailsHigh~90%LowPart 2 (previous appraisals only)
2. Year in ReviewHigh~95%MinimalPart 3 (aggregation)
3. Well-beingHigh~100%NonePart 3 (aggregation)
4. CPD ActivitiesHigh~100%NonePart 3 (aggregation)
5. MSF / 360 ReviewsHigh~100%NonePart 3 (aggregation)
6. WBAsHigh~100%NonePart 3 (aggregation)
7. Mandatory TrainingLow~0%HighFuture (LMS integration)
8. PDPMedium~30%MediumPart 2 + Part 5 (AI)
9. Submission WorkflowMedium~0%HighPart 2 + Part 6

Bottom line: PPP can automate 6 of 9 sections immediately with existing data. Section 8 (PDP) is partially covered. Only Sections 7 (mandatory training) and 9 (submission workflow) require significant new infrastructure.

Epic Roadmap Reference ​

PartIssueScope
Part 1#2461Requirements, data mapping, architecture (this document)
Part 2#2462Database schema for appraisals, PDP goals, workflow state
Part 3#2463tRPC procedures and aggregation service
Part 4#2464Frontend appraisal dashboard and form UI
Part 5#2465AI-powered PDP generation (Gemini integration)
Part 6#2466Appraiser workflow, digital sign-off, PDF export

Implementation Status ​

All parts of this epic are complete. The following sub-issues have been delivered and merged:

IssueTitleStatus
#2461Requirements document & data mapping✅ Closed
#2462Database schema & Drizzle ORM tables✅ Closed
#2463Appraisal data aggregation service (backend)✅ Closed
#2464Appraisal form UI with data pre-population✅ Closed
#2465AI-assisted PDP plan generation✅ Closed
#2466Submission workflow & notifications✅ Closed

Internal documentation — org members only