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 (
activitiestable) - 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 (
activitieswherewbaType='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(viawbaTypesenum) - 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:
- Manual upload of training certificates (simple file attachment)
- LMS integration via API (complex, hospital-specific)
- 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
| Section | Priority | Data Available | Gap Level | Target Part |
|---|---|---|---|---|
| 1. Personal Details | High | ~90% | Low | Part 2 (previous appraisals only) |
| 2. Year in Review | High | ~95% | Minimal | Part 3 (aggregation) |
| 3. Well-being | High | ~100% | None | Part 3 (aggregation) |
| 4. CPD Activities | High | ~100% | None | Part 3 (aggregation) |
| 5. MSF / 360 Reviews | High | ~100% | None | Part 3 (aggregation) |
| 6. WBAs | High | ~100% | None | Part 3 (aggregation) |
| 7. Mandatory Training | Low | ~0% | High | Future (LMS integration) |
| 8. PDP | Medium | ~30% | Medium | Part 2 + Part 5 (AI) |
| 9. Submission Workflow | Medium | ~0% | High | Part 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
| Part | Issue | Scope |
|---|---|---|
| Part 1 | #2461 | Requirements, data mapping, architecture (this document) |
| Part 2 | #2462 | Database schema for appraisals, PDP goals, workflow state |
| Part 3 | #2463 | tRPC procedures and aggregation service |
| Part 4 | #2464 | Frontend appraisal dashboard and form UI |
| Part 5 | #2465 | AI-powered PDP generation (Gemini integration) |
| Part 6 | #2466 | Appraiser workflow, digital sign-off, PDF export |
Implementation Status
All parts of this epic are complete. The following sub-issues have been delivered and merged:
| Issue | Title | Status |
|---|---|---|
| #2461 | Requirements document & data mapping | ✅ Closed |
| #2462 | Database schema & Drizzle ORM tables | ✅ Closed |
| #2463 | Appraisal data aggregation service (backend) | ✅ Closed |
| #2464 | Appraisal form UI with data pre-population | ✅ Closed |
| #2465 | AI-assisted PDP plan generation | ✅ Closed |
| #2466 | Submission workflow & notifications | ✅ Closed |