Delay Code Database

• IATA Standards: Pre-loaded with industry-standard delay codes
• Delay Groups: Organized into categories (01-99 groups)
• Code Structure: Support for code, numeric, and sub-code identifiers
• Descriptions: Human-readable delay reason descriptions
• Prefix Linking: Assign codes to specific flight number prefixes
• Advanced Search: Search by code, numeric, sub-code, or description

Flight Delay Tracking

• Multiple Delays: Track multiple delay reasons per flight
• Duration Tracking: Record delay duration in hours with HH:MM display
• Sequencing: Order delays by priority or chronology
• Data Protection: Locked flight delays cannot be modified
• Activity Tracking: Integrated chatter for delay communication

Reporting & Analysis

• Grouped Views: View delays by IATA category
• Time Formatting: Automatic conversion to HH:MM format
• Historical Data: Complete delay history per flight
• Standardized Codes: Consistent reporting across operations

flight.delay.group

Categorizes delay codes into IATA standard groups:

• numeric: Group identifier (e.g., 11, 21, 31)
• name: Group description (e.g., "Aircraft Technical")

SQL Constraints:

• Unique numeric identifier

Pre-loaded Groups:

• 01-09: Passenger and Baggage
• 11-19: Aircraft Technical
• 21-29: Aircraft Damage
• 31-39: Operations and Crewing
• 41-49: Weather
• 51-59: Air Traffic Flow Management
• 61-69: Airport and Governmental Authorities
• 71-79: Cargo and Mail
• 81-89: Aircraft Rotation
• 91-99: Miscellaneous

flight.delay.code

Comprehensive delay code records:

• code: Alphanumeric code (required)
• numeric: Numeric identifier (e.g., 11, 12)
• sub_code: Sub-code identifier (e.g., "A", "B")
• description: Human-readable delay reason
• group_id: Link to delay group (Many2one)
• prefix_ids: Valid flight prefixes (Many2many)
• active: Enable/disable code

Display Name:

Computed format: CODE - NUMERIC/SUBCODE

Example: 11 - 11/A

Search Capability:

Custom name_search supports searching across:

• Code field
• Numeric field
• Sub-code field
• Description field

SQL Constraints:

• Unique combination of code and sub_code

flight.delay

Individual delay records linked to flights:

• flight_id: Parent flight record (required, cascade delete)
• code_id: Delay code reference (required)
• duration: Delay duration in hours (Float)
• sequence: Display order (Integer, default 10)

Inheritance:

• flight.lock.mixin: Prevents modification of locked flight delays

Display Name:

Computed format: CODE - NUMERIC/SUBCODE (HH:MM)

Example: 11 - 11/A (02:15)

flight.flight Extensions

The flight.flight model is extended with:

• delay_ids: One2many field to flight.delay records

View Enhancements:

• Delays tab in flight form view
• Delay count and summary in flight list view

Requirements

• Odoo 18.0
• flight module (SmartOps Flight Management)
• flight_number module (Flight numbering)

Steps

1. Install from Odoo Apps menu
2. Delay groups and codes are automatically loaded
3. Access delay tracking from flight records
4. Navigate to Configuration menu for delay code management

Recording Flight Delays

1. Open a flight record
2. Navigate to the Delays tab
3. Click Add a line
4. Select a delay code from the dropdown:
   • Search by code (e.g., "11")
   • Search by description (e.g., "technical")
   • Browse by category
5. Enter duration in hours:
   • 0.5 = 30 minutes
   • 1.0 = 1 hour
   • 2.25 = 2 hours 15 minutes
6. Adjust sequence if multiple delays exist
7. Save the record

Managing Delay Codes

Viewing Codes:

Navigate to Flights > Configuration > Delay Codes

Creating Custom Codes:

1. Click Create
2. Enter code, numeric, and optional sub-code
3. Add description
4. Select delay group
5. Link to flight prefixes if applicable
6. Save

Deactivating Codes:

Set the active field to False to hide unused codes.

Searching for Delay Codes

Use the search bar in delay code views or delay selection dropdowns:

• By Code: Enter "11" to find all code 11 delays
• By Numeric: Enter "11" to find numeric 11 delays
• By Sub-code: Enter "A" to find all "A" sub-codes
• By Description: Enter "technical" to find technical delays

Passenger and Baggage (01-09)

Delays caused by passengers, baggage handling, and related services.

Aircraft Technical (11-19)

Delays due to aircraft technical issues, maintenance, or defects.

Aircraft Damage (21-29)

Delays caused by aircraft damage requiring repair.

Operations and Crewing (31-39)

Delays related to flight operations, crew availability, or crew issues.

Weather (41-49)

Delays caused by meteorological conditions.

Air Traffic Flow Management (51-59)

Delays imposed by ATC or flow management restrictions.

Airport and Government (61-69)

Delays caused by airport operations or governmental authorities.

Cargo and Mail (71-79)

Delays related to cargo and mail handling.

Aircraft Rotation (81-89)

Delays caused by late arrival of aircraft from previous rotation.

Miscellaneous (91-99)

Other delays not covered by standard categories.

Lock Mechanism

Flight delays inherit the flight.lock.mixin behavior:

• When a flight is locked, delay records cannot be created, modified, or deleted
• Ensures data integrity for completed flights
• Prevents accidental modification of historical data
• Maintains audit trail compliance

Delay Recording

• Record Promptly: Enter delays as soon as causes are known
• Be Specific: Use the most specific sub-code available
• Accurate Duration: Enter precise delay durations
• Multiple Reasons: Record all contributing delay factors
• Sequence Logically: Order delays chronologically or by impact

Code Management

• Use Standards: Stick to IATA codes when possible
• Custom Codes: Create custom codes only for unique situations
• Prefix Linking: Link codes to prefixes to filter relevant codes
• Regular Review: Periodically review and update delay code usage

Reporting

• Group Analysis: Review delays by group to identify patterns
• Trend Tracking: Monitor delay trends over time
• Root Cause: Use delay data for operational improvements
• Performance Metrics: Calculate delay-related KPIs

Dependencies

'depends': [
    'flight',
    'flight_number',
]

Security

Access rights defined in security/ir.model.access.csv:

• Flight User: Read access to delay codes and groups
• Flight Manager: Full CRUD access to all delay records
• Flight Admin: Configuration access to delay groups and codes

Data Files

Pre-loaded data in CSV format:

• data/flight.delay.group.csv: IATA delay groups
• data/flight.delay.code.csv: Standard IATA delay codes

Views

• Delay code list, form, and search views
• Delay group list and form views
• Flight form view extension with delays tab
• Menu structure under Flights > Configuration