SSIM Type 3 & Type 4 Record Retrieval Guide

Overview

The Standard Schedules Information Manual (IATA SSIM) establishes standard electronic data formats for exchanging global airline schedules. Within Chapter 7 of the SSIM standard:

• Type 3 Records (Flight Leg): Define individual flight leg operational and commercial schedules (origin, destination, departure/arrival times, equipment, seating configuration, and operating designations).
• Type 4 Records (Segment Data & DEI): Carry segment-level overrides and Data Element Identifiers (DEIs), which convey codeshare operating relationships, crew employer disclosures, terminal overrides, and e-ticketing compatibility.

All standard SSIM record lines have a fixed width of exactly 200 characters (bytes).

Output Formats & Prompt Variations

Variation 1: Raw Standard Fixed-Width (IATA 200-Byte Format)

Outputs unprocessed, byte-accurate 200-character lines compliant with IATA Chapter 7.

Natural Language Prompt:

PROMPT

Provide the full raw SSIM Type 3 and Type 4 records for BA 175 on 2026-06-15 in standard fixed-width 200-character format inside a code block.

Example Output:

3 BA 0175 01J20260601202610251234567 LHR09450945+01005 JFK12301230-04000777W F14J56W44Y183 000124 4 BA 0175 01J20260601202610251234567 LHRJFK050BA 0175 000125

Variation 2: Columnar / Tabular Layout with Headers Extracts the record fields into a structured markdown table with explicit column headers mapped directly to the database schema.

Natural Language Prompt:

PROMPT

Extract the SSIM Type 3 record for BA 175 on 2026-06-15 and display it in a Markdown table with column headers: - Carrier (flight_airline_designator) - Flight Number (flight_number) - Leg (leg_sequence_number) - Service Type (service_type) - Operation Validity (operation_from to operation_to) - Days of Operation (days_operation) - Departure Station & Time (departure_station, time_passenger_departure, time_variation_departure_station, passenger_terminal_departure_station) - Arrival Station & Time (arrival_station, time_passenger_arrival, time_variation_arrival_station, passenger_terminal_arrival_station) - Aircraft Type (aircraft_type) - Cabin Configuration (passenger_reservations_booking_designator) - Operating Carrier Disclosure (operating_airline_disclosure)

Example Output:

Carrier	Number	Leg	Service Type	Start Date	End Date	Op Days	Departure	Dep Time	Dep UTC Diff	Dep Term	Arrival	Arr Time	Arr UTC Diff	Arr Term	Model	Res Book Id	Op Carrier
BA	175	1	J	2026-06-01	2026-10-25	1234567	LHR	0945	+0100	5	JFK	1230	-0400	7	77W	F14J56W44Y183	BA

Variation 3: Decoded Operational Breakdown Expands coded fields (service types, meal codes, traffic restrictions, and DEI numbers) into plain English descriptions.

Natural Language Prompt:

PROMPT

Retrieve the SSIM record for BA 175 on 2026-06-15 and provide a fully decoded operational breakdown: 1. Flight Leg Summary (Origin, Destination, Local Times, UTC Offsets, Elapsed Block Time) 2. Aircraft & Configuration Details 3. All Data Element Identifiers (DEIs) decoded with official IATA descriptions 4. Traffic Restrictions and Meal Service codes decoded

Variation 4: Multi-Leg & Full Itinerary Rotation Queries through-flights and multi-leg schedule rotations across all intermediate stops.

Natural Language Prompt:

PROMPT

Extract all SSIM Type 3 and Type 4 records for flight QR 0001 across all intermediate legs on 2026-06-15. Display each leg sequentially in fixed-width format followed by a leg-by-leg routing summary table.

Example Routing Summary Table:

Leg	Origin	Destination	Departure	Arrival	Aircraft	Operating Carrier	Notes
1	DOH	DXB	2026-06-15 21:10	2026-06-15 23:20	777	QR	First segment
2	DXB	LHR	2026-06-16 01:40	2026-06-16 05:55	777	QR	Next leg in rotation