New article
Recently updated
Reporting Data Dictionary
Who is this article for?Ideagen Aviation Safety (Cora) administrators or data scientists.
Access keys for Galileo are required.
If you are working with Galileo then you may need to identify how the various tables link together.
This article links to the data dictionary for Reporting only. If you need to review the data dictionary for other modules please see the Galileo Data Dictionary.
This article covers:
- Report Fields
- report
- report_additional_information_field
- report_additional_information_field_new
- report_additional_information_field_tracker
- report_category
- report_classification
- report_classification_field
- report_classification_field_new
- report_classification_fields_tracker
- report_field
- report_feld_new
- report_field_tracker
- report_interested_party
- report_link
- report_organisational_unit
- report_repeated_section_column_tracker
- report_repeated_section_tracker_new
- report_section_field
- report_section_field_new
- report_section_tracker
Important Note: This information is intended for use by qualified data analysts and scientists and an understanding of how Ideagen Aviation Safety (Cora) operates is required.
Report Fields
The table below contains the following columns:
- Field Name: The field/column name displayed in Galileo.
- Data Type: The format the data will be presented in.
- Links: Any additional tables/fields linked by this field.
Looking for workflow data? Workflows exist in several modules but the workflow data is stored centrally. The workflow tables therefore include workflows and stages from all modules. Please visit Workflow Data Dictionary for details on Workflow data.
report
|
Name |
Type |
Links |
|---|---|---|
|
report_key |
int4 |
|
|
report_id |
uuid |
report_additional_information_field.report_id report_additional_information_field_new.report_id report_additional_information_field_tracker.report_id risk_assessment.report_id report_classification.report_id report_classification_field.report_id report_classification_field_new.report_id report_classification_fields_tracker.report_id report_field.report_id report_field_new.report_id report_field_tracker.report_id report_interested_party.report_id report_link.linked_from_report_id report_link.linked_to_report_id report_organisational_unit.report_id report_section_field_new.report_id report_section_tracker.report_id timeline_event.report_id workflow.context_id |
|
title |
text |
|
|
status |
text |
|
|
summary |
text |
|
|
form_id |
uuid |
forms.form_id |
|
form_revision_id |
uuid |
|
|
form_name |
text |
|
|
owner_id |
uuid |
user.user_id |
|
raised_date |
timestamptz |
|
|
closed_date |
timestamptz |
|
|
opened_date |
timestamptz |
|
|
submitted_date |
timestamptz |
|
|
reported_by_id |
uuid |
user.user_id |
|
is_mor |
bool |
|
|
number |
text |
|
|
last_sent_to_regulator_date |
timestamptz |
|
|
version |
int4 |
|
|
raised_from_audit_id |
uuid |
audit.audit_id |
|
raised_from_checklist_item_id |
uuid |
audit_checklist_item.item_id |
|
category_id |
uuid |
report_category.category_id |
|
duplicate_of_report_id |
uuid |
|
|
relationship_id |
uuid |
|
|
organisational_unit_id |
uuid |
organisational_unit.organisational_unit_id |
|
valid_from |
timestamptz |
|
|
valid_to |
timestamptz |
|
report_additional_information_field
|
Name |
Type |
Links |
|---|---|---|
|
report_additional_information_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
additional_information_fields |
jsonb |
|
report_additional_information_field_new
|
Name |
Type |
Links |
|---|---|---|
|
report_additional_information_field_key |
int4 |
|
|
field_name |
text |
|
|
additional_information_field_id |
uuid |
|
|
report_id |
uuid |
report.report_id |
|
field_bank_field_id |
uuid |
|
|
is_checklist |
bool |
|
|
reference_type |
text |
|
|
collection_id |
uuid |
|
|
value_type |
text |
|
|
value_id |
uuid |
|
|
value_text |
text |
|
|
value_float |
float8 |
|
report_additional_information_field_tracker
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
report.report_id |
|
additional_information_field_id |
uuid |
|
|
field_bank_field_id |
uuid |
|
|
is_checklist |
bool |
|
|
reference_type |
text |
|
|
collection_id |
uuid |
|
report_category
|
Name |
Type |
Links |
|---|---|---|
|
category_key |
int4 |
|
|
category_id |
uuid |
report.category_id |
|
colour |
text |
|
|
title |
text |
|
report_classification
|
Name |
Type |
Links |
|---|---|---|
|
report_classification_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
item_id |
uuid |
|
|
item_name |
text |
|
report_classification_field
|
Name |
Type |
Links |
|---|---|---|
|
report_classification_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
classification_fields |
jsonb |
|
report_classification_field_new
|
Name |
Type |
Links |
|---|---|---|
|
report_classification_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
field_id |
uuid |
|
|
list_type |
text |
|
|
list_id |
uuid |
|
|
reference_type |
text |
|
|
value_id |
uuid |
|
report_classification_fields_tracker
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
report.report_id |
|
field_id |
uuid |
|
|
list_id |
text |
|
report_field
|
Name |
Type |
Links |
|---|---|---|
|
report_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
fields |
jsonb |
|
report_feld_new
|
Name |
Type |
Links |
|---|---|---|
|
report_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
field_id |
uuid |
|
|
field_name |
text |
|
|
column_id |
uuid |
|
|
form_field_id |
uuid |
|
|
field_bank_field_id |
uuid |
|
|
is_checklist |
bool |
|
|
is_repeater_field |
bool |
|
|
section_id |
uuid |
|
|
persistent_section_id |
uuid |
|
|
section_template_id |
uuid |
|
|
primary_linked_section_id |
uuid |
|
|
reference_type |
text |
|
|
collection_id |
uuid |
|
|
value_id |
uuid |
|
|
value_type |
text |
|
|
value_text |
text |
|
|
value_float |
float8 |
|
report_field_tracker
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
report.report_id |
|
field_id |
uuid |
|
|
column_id |
uuid |
|
|
form_field_id |
uuid |
|
|
field_bank_field_id |
uuid |
|
|
is_checklist |
bool |
|
|
is_repeater_field |
bool |
|
|
section_id |
uuid |
|
|
persistent_section_id |
uuid |
|
|
section_template_id |
uuid |
|
|
json_path |
text |
|
|
section_json_path |
text |
|
|
reference_type |
text |
|
|
collection_id |
uuid |
|
|
value |
jsonb |
|
report_interested_party
|
Name |
Type |
Links |
|---|---|---|
|
report_interested_party_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
interested_party_id |
uuid |
|
|
type |
text |
|
report_link
|
Name |
Type |
Links |
|---|---|---|
|
linked_from_report_id |
uuid |
report.report_id |
|
linked_to_report_id |
uuid |
report.report_id |
report_organisational_unit
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
report.report_id |
|
organisational_unit_id |
uuid |
organisational_unit.organisational_unit_id |
|
relationship_id |
uuid |
|
report_repeated_section_column_tracker
|
Name |
Type |
Links |
|---|---|---|
|
column_id |
uuid |
|
|
section_id |
uuid |
|
report_repeated_section_tracker_new
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
report.report_id |
|
report_section_id |
uuid |
|
|
report_section_name |
text |
|
|
parent_section_id |
uuid |
|
|
repeater_field_id |
uuid |
|
|
section_template_id |
uuid |
|
|
linked_to_section |
uuid |
|
|
timestamp |
timestamptz |
|
|
is_deleted |
bool |
|
report_section_field
|
Name |
Type |
Links |
|---|---|---|
|
report_section_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
section_id |
uuid |
|
|
primary_linked_section_id |
uuid |
|
|
section_template_id |
uuid |
|
|
persistent_section_id |
uuid |
|
|
json_path |
text |
|
|
fields |
jsonb |
|
report_section_field_new
|
Name |
Type |
Links |
|---|---|---|
|
report_section_field_key |
int4 |
|
|
report_id |
uuid |
report.report_id |
|
section_id |
uuid |
|
|
primary_linked_section_id |
uuid |
|
|
section_template_id |
uuid |
|
|
persistent_section_id |
uuid |
|
|
value_id |
uuid |
|
|
value_text |
text |
|
|
value_float |
float8 |
|
report_section_tracker
|
Name |
Type |
Links |
|---|---|---|
|
report_id |
uuid |
|
|
form_section_id |
uuid |
report.report_id |
|
report_section_id |
uuid |
|
|
persistent_section_id |
uuid |
|
|
is_deleted |
bool |
|