How to set up custom columns Some background What are custom columns? The Original Report, Validated Reports, Occurrences and Safety recommendation list views allow users to see specific data fields in a tabular format, enabling them to browse, sort, filter, and export data efficiently. ECCAIRS2 offers the possibility to set up per document type which attributes can be shown in the list view. Up to 30 attributes and Custom Attributes can be added to a list view, and this per document type. ·         Original Reports ·         Validated Reports ·         Occurrences ·         Safety Recommendations Although list views are widely used throughout ECCAIRS2, it is only the above list views that are concerned. Furthermore, the setup of custom columns is only available for Authority users, not for reporters that submit their reports. Setting up custom columns ECCAIRS2 has been developed so the user can setup a different list view per document type. Defaults columns per document type ECCAIRS2 has setup a series of default attributes in the custom column templates for each document type. These attributes will be shown in the respective list views. # Original Reports Validated Reports Occurrences *Safety Recommendations 1 Notify Notify Notify Notify 2 E2ID E2ID E2ID E2ID 3 Reporting entity Reporting entity Reporting entity SRIS number 4 File number File number File number SR status 5 Report identification Report identification Report identification Addressee 6 Headline Headline Headline Local SR number 7 Occurrence class Occurrence class Occurrence class Headline 8 UTC date UTC date UTC date E2 Status 9 Manufacturer/model Manufacturer/model Manufacturer/model Occurrence class 10 Aircraft registration Aircraft registration Aircraft registration Date issued 11 Location name Location name Location name Manufacturer/model 12 Responsible entity Responsible entity Responsible entity Registration 13 State/area of occ State/area of occ State/area of occ Location 14 Local date Local date Local date Version 15 Operator Operator Operator Report link 16 Operation type Operation type Operation type State/area 17 Call sign Call sign Call sign Local date 18 Injury level Injury level Injury level Operator 19 Fatal, passengers Fatal, passengers Fatal, passengers Operation type 20 Fatal, crew total Fatal, crew total Fatal, crew total Response status 21 Total fatalities Total fatalities Total fatalities Last Shared ECR 22 Aircraft damage Aircraft damage Aircraft damage Receiving Date 23 E2 Status E2 Status E2 Status   24 Flight phase Flight phase Flight phase   25 Occurrence moderator Occurrence moderator Occurrence moderator   26 Version Version Version   27 Report status Report status Report status   28 Sent date Receiving Date Last Shared ECR   29     Receiving Date   30     Sent date   *Safety Recommendations only become visible if the Authority is also a SIA NAA What attributes can be selected? ECCAIRS2 doesn’t distinguish between ECCAIRS attributes, custom attributes or exposed meta data fields. All attributes and fields, up to 30, can be added to the custom column templates. Setup at Authority level Depending on the permissions the option to manage custom columns at Authority level becomes available on the home page.  Setup at user level Every user can configure the custom columns per document type by himself. Interface Although there are small nuances between the Authority and the ECCAIRS user’s setup, the interface is the same. 1.       Allows to search through the available attributes and meta data fields. 2.       Exposed meta data fields than be added to the template. 3.       Available attributes. Clicking on “>” expand the entity revealing its attributes. 4.       Allows the attributes to be sorted in ascending or descending order and allows to expand or collapse the full entity tree view. 5.       The selected attributes in the template 6.       Attribute options a.       Sort order. b.       View/hide. c.       Remove. 7.       Shows how many attributes have been added to the template out of 30. 8.       Interface Actions These actions only apply to the template that is being edited a.       Cancel, will revert to the previously saved version. b.       Reset                                                    i.      For the Authority, it will set the selected attributes back to their original values.                                                  ii.      For the user, it will copy the Authority settings to the user’s template. c.       Save, will save the settings. How to add, remove, sort, hide, and change the position of attributes and fields? Adding Adding an attribute or a field is done by putting a tick box in the tick box of the attribute in the list of available attributes/fields. Removing Removing an attribute or a field can either be done by unticking the tick box of the attribute is the list of available attributes/fields. Or by clicking on the trash can icon in the list of selected attributes Sorting It is possible to sort the list view according to multiple attributes/fields. By clicking on the ^ of an attribute/field the sort order will be set. A small digit will appear next to the ^ indicating that the column will be sorted. The number indicates in the sorting sequence. For example a small digit 1 indicates that the column will be sorted first according to that column, a 2 will indicate that it will be first sorted by another column and then sorted by that. Changing the sort order from ascending to descending can be done by clicking on the ^ again. Viewing/hiding. The Authority may make certain attributes and fields available to the users, yet it may decide not to show them by default. It is the user who can then decide to show them. Changing the position of the Attributes in the list view. When an attribute or field is added to the template it is always added at the end. Changing the position of the attribute or fields in the template can be done by dragging the attributes or field in to the right position. What are the effects on user’s list views? The custom column settings may influence the list views of users. There are Three cases that the custom column settings, set by the Authority, can  have an influence on the Eccairs2 users. 1.       A new user. The custom column settings will automatically be copied into the new user’s custom column settings. The user can modify them whenever necessary. 2.       An existing user without having changed his custom column settings. The custom column settings will automatically be updated in the user’s custom column settings. The user can modify them whenever necessary. 3.       An existing user having changed his custom column settings. The changed authority settings do NOT have an influence on the personal preferences of the user’s custom column settings. When a user modifies a sort order, adds/removes an attribute, or changes the order of a column, it will automatically be reflected in the user’s custom column template.