BAT answer level – kept in sync with Prisma enum BatAnswerLevel. Defined here so this file can be used by admin PWA (no

Course Media Migration

Migrates media files attached to courses from the legacy MySQL database.

This migration:

1. Reads media records from legacy MySQL media table (where room_name = 'courseMgt_course')
2. Joins with course table to get course_code
3. Maps legacy course codes to new course codes and gets PostgreSQL course ID
4. Builds legacy S3 path: /sites/default/media/{large|normal}/{media_id}-{media_name}
5. Builds new S3 path: course/{course_id}/{image|video|document}/{media_id}-{media_name}
6. Copies S3 files from legacy bucket to new bucket
7. Creates/updates Media records in PostgreSQL linked to the course

Environment variables required:

• LEGACY_S3_BUCKET: Source bucket name (e.g., "evolution-course-management")
• LEGACY_AWS_REGION: AWS region for legacy bucket (e.g., "ap-southeast-1")
• LEGACY_AWS_ACCESS_KEY_ID: AWS access key for legacy bucket (legacy AWS account)
• LEGACY_AWS_SECRET_ACCESS_KEY: AWS secret key for legacy bucket (legacy AWS account)
• AWS_S3_MEDIA_BUCKET: Destination bucket name (e.g., "recallassess-media-uat-113010539978")
• AWS_REGION: AWS region for new bucket (e.g., "ap-southeast-1")
• AWS_ACCESS_KEY_ID: AWS access key for new bucket (new AWS account)
• AWS_SECRET_ACCESS_KEY: AWS secret key for new bucket (new AWS account)

Course Module Media Migration

Migrates media files attached to course modules from the legacy MySQL database.

This migration:

1. Reads media records from legacy MySQL media table (where room_name = 'courseMgt_courseLevel')
2. Joins with training_topic table to get topic_code (which maps to course_module_code)
3. Maps topic_code to course_module_code and gets PostgreSQL course_module ID
4. Builds legacy S3 path: /sites/default/media/{large|normal}/{media_id}-{media_name}
5. Builds new S3 path: private/course-module/{course_module_id}/image/{media_id}-{media_name}
6. Copies S3 files from legacy bucket to new bucket
7. Creates/updates Media records in PostgreSQL linked to the course_module

Environment variables required:

• LEGACY_S3_BUCKET: Source bucket name (e.g., "evolution-course-management")
• LEGACY_AWS_REGION: AWS region for legacy bucket (e.g., "ap-southeast-1")
• LEGACY_AWS_ACCESS_KEY_ID: AWS access key for legacy bucket (legacy AWS account)
• LEGACY_AWS_SECRET_ACCESS_KEY: AWS secret key for legacy bucket (legacy AWS account)
• AWS_S3_MEDIA_BUCKET: Destination bucket name (e.g., "recallassess-media-uat-113010539978")
• AWS_REGION: AWS region for new bucket (e.g., "ap-southeast-1")
• AWS_ACCESS_KEY_ID: AWS access key for new bucket (new AWS account)
• AWS_SECRET_ACCESS_KEY: AWS secret key for new bucket (new AWS account)

Course Module Page Media Migration

Migrates media files attached to course module pages from the legacy MySQL database.

This migration:

1. Reads media records from legacy MySQL media table (where room_name = 'courseMgt_courseContentLink')
2. Joins with course_content_link and course_content to get course_content_id
3. Joins with course_section to get section title
4. Maps legacy course codes and section titles to new course_module_page_id
5. Maps room_name + record_type to MediaName enum (PHOTO, VIDEO, DOCUMENT)
6. Maps media_type to MediaType enum (IMAGE, VIDEO, DOCUMENT)
7. Builds legacy S3 path: /sites/default/media/{large|normal}/{media_id}-{media_name}
8. Builds new S3 path: course_module_page/{course_module_page_id}/{photo|video|document}/{media_id}-{media_name}
9. Copies S3 files from legacy bucket to new bucket
10. Creates/updates Media records in PostgreSQL linked to the course_module_page

Environment variables required:

• LEGACY_S3_BUCKET: Source bucket name (e.g., "evolution-course-management")
• LEGACY_AWS_REGION: AWS region for legacy bucket (e.g., "ap-southeast-1")
• LEGACY_AWS_ACCESS_KEY_ID: AWS access key for legacy bucket (legacy AWS account)
• LEGACY_AWS_SECRET_ACCESS_KEY: AWS secret key for legacy bucket (legacy AWS account)
• AWS_S3_MEDIA_BUCKET: Destination bucket name (e.g., "recallassess-media-uat-113010539978")
• AWS_REGION: AWS region for new bucket (e.g., "ap-southeast-1")
• AWS_ACCESS_KEY_ID: AWS access key for new bucket (new AWS account)
• AWS_SECRET_ACCESS_KEY: AWS secret key for new bucket (new AWS account)

Recall Email Template Skeleton

Single source of truth for the wrapper around all Recall emails. Header, footer, base styles, and bulletproof button patterns live HERE and HERE ONLY. Individual templates supply only the body content.

Phase 1 (April 2026): standardized brand purple, real logo, three footer variants by category, dropped legally-incomplete fields until provided.

Minimal shape of an email_log row + relations needed to replace {{user.}}, {{course.}}, {{mail.}}, and common {{system.}} keys.

Minimal invoice shape for pickInvoicePeriodForPdf — same rules as the fluid invoice report payload and SSR PDF download.

API responses include fields not always present on generated Stripe typings.

API responses include fields not always present on generated Stripe typings.