DJ Mentions & On-Air Announcements Module

Overview

The DJ Mentions & On-Air Announcements module manages the lifecycle of paid announcements from creation to on-air delivery. It serves as a critical bridge between the station's business operations and its on-air programming, ensuring that client-paid content is properly approved, scheduled, and delivered by presenters.

Purpose

This module streamlines the process of:

• Creating structured announcements for on-air delivery
• Managing multi-step approval workflows
• Scheduling mentions within appropriate programming slots
• Providing presenters with timely access to approved scripts
• Tracking mention delivery and performance

Key Users

Role	Primary Activities
Front Desk Staff	Initial creation of mentions, receipt attachment
Marketing Manager	Content review and first-level approval
Programming Director	Scheduling review and second-level approval
Station Manager	Final approval and oversight
On-Air Presenters	Viewing and delivering approved mentions

Module Components

1. Mention Creation & Upload

Features:

• Mention creation form with client selection
• Receipt attachment and payment validation
• Script entry with formatting tools
• Optional audio file upload
• Date range and frequency specification

Business Rules:

• All mentions require an associated client and payment
• Script content is required for all mentions
• Start/end dates must be validated against payment amount
• Frequency cannot exceed available slots

2. Approval Workflow

Approval Sequence:

1. Front Desk creates mention → Status: "Pending Marketing Review"
2. Marketing Manager reviews → Status: "Pending Programming Review" or "Rejected"
3. Programming Director reviews → Status: "Pending Station Manager Review" or "Rejected"
4. Station Manager provides final approval → Status: "Approved" or "Rejected"

Features:

• Role-specific approval interfaces
• Rejection with required feedback
• Email notifications at each stage
• Audit trail of approval actions
• Dashboard views of pending approvals

3. Scheduling System

Features:

• Auto-scheduling based on availability
• Manual scheduling override
• Conflict detection and resolution
• Frequency distribution logic
• Visualization of mention schedule

Scheduling Rules:

• Mentions can only be scheduled after full approval
• System distributes mentions according to frequency settings
• Prime-time slots may be prioritized based on payment tier
• Scheduling respects program clock limitations

4. Presenter Interface

Features:

• Daily queue of scheduled mentions
• Countdown timer to next mention
• Downloadable/printable scripts
• Mark as "aired" functionality
• Quick search for mentions

Presenter Rules:

• Presenters can only view fully approved mentions
• Mentions are only visible on their scheduled day
• Presenters must mark mentions as "aired" for tracking
• Schedule changes are highlighted with notifications

5. Analytics & Reporting

Features:

• Client-specific mention delivery reports
• Presenter performance metrics
• Delivery compliance tracking
• Revenue analysis by time slot
• Schedule density visualization

Database Structure

The module primarily uses these database tables:

• mentions: Core mention data including content and approval status
• mention_schedules: When specific mentions are scheduled to air
• mention_delivery_logs: Records of actual on-air delivery

Key relationships:

• mentions → clients (many-to-one)
• mentions → payments (many-to-one)
• mentions → mention_schedules (one-to-many)
• mention_schedules → users (presenters) (many-to-one)

API Endpoints

Endpoint	Method	Description
/api/mentions	GET	List mentions with filtering
/api/mentions	POST	Create new mention
/api/mentions/{id}	GET	Get mention details
/api/mentions/{id}	PUT	Update mention
/api/mentions/{id}/approve	POST	Approval action
/api/mentions/{id}/reject	POST	Rejection action
/api/mentions/{id}/schedule	POST	Schedule mention
/api/mentions/presenter-queue	GET	Get presenter's daily queue
/api/mentions/{id}/mark-aired	POST	Mark as aired

User Interfaces

1. Mention Creation Form

A comprehensive form for Front Desk staff to create mentions with:

• Client selection dropdown (with search)
• Payment/receipt attachment
• Script editor with formatting
• Date range picker
• Frequency selector
• Special instructions field

2. Approval Dashboard

Role-specific dashboards showing:

• Mentions awaiting your approval
• Recently approved/rejected mentions
• Quick approve/reject actions
• Detailed view with full mention history

3. Scheduling Interface

Visual calendar-style interface for:

• Viewing current mention schedule
• Drag-and-drop rescheduling
• Conflict highlighting
• Batch scheduling operations
• Schedule export options

4. Presenter Queue

Streamlined interface for on-air talent showing:

• Today's mentions sorted by time
• Countdown to next mention
• Easily readable script display
• Quick mark-as-aired button
• Search for specific mentions

Workflows

New Mention Creation

On-Air Delivery

Integration Points

Internal Modules

• Clients & Business Module: For client selection and validation
• Accounts & Finance Module: For payment validation
• Programming & Clocks Module: For scheduling within program structures
• Reporting & Analytics Module: For performance metrics
• Notification System: For alerts and updates

External Systems (Future)

• Playout System: Automatic queuing in studio automation
• SMS Gateway: Text notifications to presenters
• Client Portal: Client access to mention status

Security Considerations

• Role-based access control for all module functions
• Audit logging of all approval actions
• Electronic signature capture for final approvals
• Version control for edited mention content
• Validation to prevent scheduling conflicts

Technical Implementation

Backend Components

• MentionController for API endpoints
• MentionService for business logic
• Approval workflow middleware
• Schedule generation service
• Notification dispatchers

Frontend Components

• Mention creation form component
• Approval interface components
• Calendar-based scheduling component
• Presenter queue component
• Analytics dashboard widgets

Future Enhancements