Quick Reference

Group Models
⚓ Parties & Fleet Organisation · Person · Vessel · VesselRegistration · Port · Commodity
🧭 Scope Assessment CoastalTradeAssessment · Section12Declaration · Exemption
📝 Applications LicenceApplication · ApplicationVessel · ProposedVoyageMatter · ApplicationDocument · ApplicationValidation
💬 Consultation Publication · InterestedParty · NoticeInResponse · ThirdPartyComment · ApplicantResponse
⚖️ Decisions & Licences InformationRequest · DelegateDecision · Licence · LicenceVessel · LicenceCondition
🗺️ Authorised Voyages AuthorisedVoyage · VariationApplication · VoyageMatterVariation · VariationDecision
🚢 Voyage Operations Voyage · PortCall · CargoMovement · PassengerMovement · VoyageEvent
📋 Notifications & Reports VoyageNotification · VoyageNotificationAmendment · VoyageReport · VoyageReconciliation
🛡️ Compliance WageComplianceAssessment · ComplianceObligation · ComplianceTask · ComplianceException · CorrectiveAction
📚 Assurance RegulatoryCorrespondence · Evidence · Audit · AuditFinding · Notification

The demo scenario, by its codes

The seed loads one coherent story: Northern Coastal Freight (NCF) needs a temporary licence to carry solar-farm project cargo Brisbane → Darwin on the foreign-flagged Pacific Merchant, because no suitable licensed Australian vessel is available in the window.

Code Record Meaning
NCF Organisation Northern Coastal Freight — the applicant / licence holder
CORALS Organisation Coral Sea Shipping — competing operator (lodges the notice in response)
DITRDCA Organisation The Department — regulator
Pacific Merchant Vessel Singapore-flagged (FOREIGN) general-cargo vessel used under the licence
Coral Trader Vessel Coral Sea Shipping's Australian-general vessel offered as the competing service
AUBNE / AUDRW Port Port of Brisbane / Port of Darwin
PROJ Commodity Project Cargo — structural steel, modules and switchgear
CTA-2026-0041 CoastalTradeAssessment Confirms a temporary licence is required
TL-2026-0041 LicenceApplication The temporary licence application (GRANTED)
TL-2026-0041-M01 ProposedVoyageMatter The single proposed matter — BNE→DRW, 6,200 t, ±20%, one voyage
DD-2026-0118 DelegateDecision Grant, with conditions C1 (Schedule A wages) and C2 (report in 5 days)
TL-2026-118 Licence The temporary licence (CURRENT)
AV-2026-118-01 AuthorisedVoyage The authorised voyage created from M01
VAR-2026-118-01 VariationApplication Minor variation — latest loading date 20 → 22 Sep (granted)
PM-BNE-DRW-001 Voyage The actual voyage (COMPLETED), 6,125 t landed
VN-2026-0311 VoyageNotification Pre-voyage notice (ACCEPTED), one amendment
VR-2026-0288 VoyageReport Post-voyage report (ACCEPTED)
EXC-2026-0044 ComplianceException Late notification amendment — detected, controlled, CLOSED
CA-2026-0031 CorrectiveAction Bring the notification-review checkpoint forward (verified)
AUD-2026-0009 Audit Compliance audit — satisfactory, one minor closed finding

The reconciliation to look at: open VoyageReconciliation — the row ties AV-2026-118-01 ↔ VN-2026-0311 ↔ VR-2026-0288, every dimension matches, the quantity variance (+2.1%) is within the 20% tolerance, and the overall result is COMPLIANT.

Status vocabularies (enumerated fields)

These fields render as dropdowns and filters. Values are stored UPPERCASE.

Field Values
Organisation.organisation_type APPLICANT · LICENCE_HOLDER · OWNER · OPERATOR · CHARTERER · SHIPPER · CONSIGNEE · AGENT · REGULATOR · PORT
Vessel.registry_type AUSTRALIAN_GENERAL · AUSTRALIAN_INTERNATIONAL · FOREIGN · OTHER
cargo_or_passengers CARGO · PASSENGERS
LicenceApplication.application_type / Licence.licence_type GENERAL · TEMPORARY · EMERGENCY
LicenceApplication.application_status DRAFT · VALIDATION · SUBMITTED · PUBLISHED · CONSULTATION · ASSESSMENT · INFORMATION_REQUESTED · DECISION_PENDING · GRANTED · REFUSED · WITHDRAWN · LAPSED
Licence.licence_status ISSUED · CURRENT · SUSPENDED · CANCELLED · SURRENDERED · EXPIRED · SUPERSEDED
VariationApplication.variation_type AUTHORISED_MATTERS · NEW_MATTERS · ENERGY_SECURITY
Voyage.voyage_status PLANNED · NOTIFIED · LOADING · LADEN · DEPARTED · ARRIVED · DISCHARGING · COMPLETED · CANCELLED · NOT_PROCEEDED
VoyageNotification.notification_status DRAFT · VALIDATED · SUBMITTED · ACCEPTED · AMENDED · WITHDRAWN · LATE
VoyageReport.reporting_status DRAFT · VALIDATED · SUBMITTED · ACCEPTED · CORRECTED · LATE · REJECTED
VoyageReconciliation.overall_result COMPLIANT · COMPLIANT_WITH_EXCEPTION · POTENTIAL_BREACH · INCOMPLETE
ComplianceException.exception_status DETECTED · ASSESSING · CONTROLLED · REPORTED · REMEDIATION · CLOSED
ComplianceTask.task_status OPEN · IN_PROGRESS · COMPLETED · VERIFIED · OVERDUE · WAIVED · CANCELLED
quantity_unit / capacity_unit TONNES · LITRES · CUBIC_METRES · TEU · VEHICLES · PASSENGERS · UNITS

Other status columns (e.g. on Organisation, Person, Port, port calls, movements) are free text in this prototype — no controlled list is enforced.

Rules of thumb

  • Follow a licence down, not up. Start at Licence → its AuthorisedVoyage rows → each Voyage → its VoyageNotification / VoyageReport → VoyageReconciliation. The drill-down tabs mirror this chain.
  • A voyage is only trustworthy behind an ACCEPTED notification and a reconciled report. In the demo the voyage is COMPLETED, the notification ACCEPTED, the report ACCEPTED, and the reconciliation COMPLIANT — that is the "good" end state.
  • Roles matter on Port, Organisation and Person pages. The same child table appears under distinct tabs — e.g. on a Port page, "Voyages Loading Here" vs "Voyages Discharging Here"; on an Organisation page, "Vessels Owned" vs "Vessels Operated"; on a Person page, "Corrective Actions Owned" vs "…Verified".
  • ctls_reference = the Department's copy. Any record carrying one has a counterpart in the real Coastal Trading Licensing System; this app is the operator's working and evidence copy.