DBRATDBRATICAO DATA BASE RELATEDICAO DATA BASE RELATED

TO AIR TRANSPORTTO AIR TRANSPORTACTIVITIESACTIVITIES

ContentContent

� Introduction to Introduction to DBRATDBRAT�� The The ICAO portalICAO portal�� The DBRAT The DBRAT welcome pagewelcome page�� Introduction to Introduction to Guidance and instructionsGuidance and instructions�� Manipulating dataManipulating data�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

DBRATDBRATa collaborative sitea collaborative site

States

Airports

Air carriers

ANS

Intl Orgs.

ICAOATB & ROs

DBRAT

DBRATDBRATa collaborative & a collaborative &

comprehensive sitecomprehensive site�� Exchange of informationExchange of information on air transport on air transport

activities and developmentsactivities and developments amongstamongst�� ICAO ATBICAO ATB’’s offices, s offices, �� Regional Offices,Regional Offices,�� Member States andMember States and�� Intl organizations Intl organizations with activities that may affect airwith activities that may affect air transport transport

operations and/or evolution operations and/or evolution

�� Share worldwide air transport knowledge and Share worldwide air transport knowledge and data availabledata available

DBRAT DBRAT –– Information ElementsInformation Elements(Main definitions)(Main definitions)

�� Lists – records may contain files attached� Libraries – each record contains a file� Data records (edit through icon/key field)� Field types:

� Information: Text, Choice, Date� linking fields

� Linking IEs – link other records� Linked IEs – records linked to a Linking IE� Folders – contain docs/info dealing with a

particular issue� Access permissions by groups of users� Targeting audience – individual users/group of

users authorized to see a doc/record.

DBRAT DBRAT –– Security & access Security & access rightsrights

�� Two Two groups of usersgroups of users(Members & visitors) for(Members & visitors) for�� ICAO (ATB & ICAO (ATB & ROsROs))�� StatesStates�� Intl organizationsIntl organizations�� AirportsAirports**�� ANS providersANS providers**�� Air carriersAir carriers**

�� AVSEC expertsAVSEC experts�� DBRAT ownersDBRAT owners

** Upcoming usersUpcoming users

�� Member usersMember users�� Read all information included Read all information included

in in IEsIEs where they have where they have permissionpermission

�� Modify only their own recordsModify only their own records

�� Visitor usersVisitor users�� Read all information included Read all information included

in in IEsIEs where they have where they have permissionpermission

�� ICAO ICAO usersusers�� Read all nonRead all non--restricted restricted

information included in information included in IEsIEs�� Modify only their own recordsModify only their own records

Content (cont.)Content (cont.)�� The ICAO portalThe ICAO portal

�� All users must have a portal account (user ID All users must have a portal account (user ID and password)and password)

�� DBRATDBRAT�� All users must request a DBRAT membership All users must request a DBRAT membership

after obtaining a portal accountafter obtaining a portal account�� Introduction to Guidance and instructionsIntroduction to Guidance and instructions�� Manipulating dataManipulating data�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

Requesting an account Requesting an account in the ICAO Portalin the ICAO Portal

ICAO Portal ICAO Portal –– Group subscription requestGroup subscription request

Requesting an account in the ICAO PortalRequesting an account in the ICAO PortalApplication formApplication form

Content (cont.)Content (cont.)�� The ICAO portalThe ICAO portal

�� The User ID gives access to all the Portal sites The User ID gives access to all the Portal sites where the user has a membershipwhere the user has a membership

�� DBRATDBRAT�� Requesting a DBRAT membership when the Requesting a DBRAT membership when the

user already has access to other Portal sitesuser already has access to other Portal sites�� Introduction to Guidance and instructionsIntroduction to Guidance and instructions�� Manipulating dataManipulating data�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

The ICAO portalThe ICAO portal

Logging in Logging in the ICAO Portalthe ICAO Portalfor users with a portal accountfor users with a portal account

Logged in Logged in the ICAO Portalthe ICAO PortalRequesting a new membershipRequesting a new membership

User profile User profile ��Group subscribe/Group subscribe/unsuns

User profile User profile ��Group subscribeGroup subscribe

Content (cont.)Content (cont.)

�� The DBRAT welcome pageThe DBRAT welcome page�� Introduction to Guidance and instructionsIntroduction to Guidance and instructions�� Manipulating dataManipulating data�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

Content (cont.)Content (cont.)

��The DBRAT welcome pageThe DBRAT welcome page��Common navigation (left) columnCommon navigation (left) column��Similar but different welcome pages for:Similar but different welcome pages for:

•• ICAO SecretariatICAO Secretariat•• StatesStates•• International organizationsInternational organizations•• AirportsAirports**•• Air Navigation ServicesAir Navigation Services**•• Air carriersAir carriers**

** Upcoming usersUpcoming users

DBRAT welcome pageDBRAT welcome pageNavigation column and working areasNavigation column and working areas

Content (cont.)Content (cont.)

�� Introduction to Guidance and Introduction to Guidance and instructionsinstructions

�� Manipulating data (sorting and filtering Manipulating data (sorting and filtering data)data)

�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

DBRAT welcome pageDBRAT welcome pageGuidance and instructionsGuidance and instructions

Content (cont.)Content (cont.)

�� Manipulating data Manipulating data (sorting and filtering (sorting and filtering data)data)

�� How to work with DBRATHow to work with DBRAT�� Routine workRoutine work

Content (cont.)Content (cont.)

��Manipulating dataManipulating data��Sort dataSort data by selecting the sorting order by selecting the sorting order

(ascending/descending) required in a data (ascending/descending) required in a data field shown in the header of any IE displayed.field shown in the header of any IE displayed.

��Filter dataFilter data by choosing an specific by choosing an specific value/content in a data field shown in the value/content in a data field shown in the header of any IE displayed.header of any IE displayed.

Manipulating dataManipulating data (sorting/filtering)(sorting/filtering)

Click on the Click on the Field name Field name

to see to see optionsoptions

Content (cont.)Content (cont.)�� How to work with DBRATHow to work with DBRAT�� Upload your working page by clicking on theUpload your working page by clicking on the acronymacronym of of

your:your:�� ATBATB’’s office/Regional Office, ors office/Regional Office, or�� State, orState, or�� International organizationInternational organization

�� Choose the IE to work with by clicking on the Choose the IE to work with by clicking on the corresponding link.corresponding link.

�� Add/modify/delete data and/or IE records and or attach Add/modify/delete data and/or IE records and or attach files/delete attachments to records.files/delete attachments to records.

oror�� Choose in the Choose in the ““common navigation columncommon navigation column”” the IE you the IE you

want to see.want to see.

Content (cont.)Content (cont.)�� How to work with DBRATHow to work with DBRAT

�� Common working pages for Common working pages for each group of users:each group of users:��ICAO SecretariatICAO Secretariat�States�Intl organizations

� Individual working pages for each:�ICAO ATB’s office�Regional Office�State�International organization

�Routine work

ICAO working areaICAO working area

Tab to Tab to display display this partthis part

Tab to Tab to display display this partthis part

ICAO working area (upper part)ICAO working area (upper part)ICAO ATBICAO ATB’’s officess offices

ICAO working area (lower part)ICAO working area (lower part)Regional officesRegional offices

ICAO working area (middle part)ICAO working area (middle part)Common links to Common links to IEsIEs

Content (cont.)Content (cont.)�How to work with DBRAT

�� Common working pages for Common working pages for each group of users:each group of users:�ICAO Secretariat

��StatesStates�Intl organizations

� Individual working pages for each:�ICAO ATB’s office�Regional Office�State�International organization

�Routine work

Working with DBRATWorking with DBRATChoosing your working page Choosing your working page -- StateState

Content (cont.)Content (cont.)�� How to work with DBRATHow to work with DBRAT

�� Common working pages for Common working pages for each group of users:each group of users:�ICAO Secretariat�States��Intl organizationsIntl organizations

� Individual working pages for each:�ICAO HQ’s unit�Regional Office�State�International organization

�Routine work

Working with DBRATWorking with DBRATChoosing your working page Choosing your working page –– Intl org.Intl org.

Content (cont.)Content (cont.)�� How to work with DBRATHow to work with DBRAT

� Common working pages for each group of users:�ICAO Secretariat�States�Intl organizations

�� Individual working pages for Individual working pages for each:each:��ICAO ATBICAO ATB’’s offices office��Regional OfficeRegional Office�State�International organization

�Routine work

Working with DBRATWorking with DBRATATBATB’’s offices office working pageworking page

Working with DBRATWorking with DBRATRegional OfficeRegional Office working pageworking page

Content (cont.)Content (cont.)

�� How to work with DBRATHow to work with DBRAT� Common working pages for each

group of users:�ICAO Secretariat�States�Intl organizations

�� Individual working pages for each:Individual working pages for each:�ICAO ATB’s office�Regional Office��StateState��International organizationInternational organization

�Routine work

Working with DBRATWorking with DBRATState State working pageworking page

Working with DBRATWorking with DBRATIntl organizationIntl organization working pageworking page

Content (cont.)Content (cont.)

�� Routine workRoutine work�� ICAO SecretariatICAO Secretariat�� Non ICAO usersNon ICAO users

Routine work Routine work –– ICAO usersICAO users

����Review & update internal/external contacts in/of the ATB Review & update internal/external contacts in/of the ATB Office/RO/AT authoritiesOffice/RO/AT authorities1111

����Contribute posting AT news and developments related to Contribute posting AT news and developments related to the ATB office/the ATB office/RegReg. office/States. office/States1010

����Provide a list of new Intl orgs. involved in the ATB Provide a list of new Intl orgs. involved in the ATB officeoffice’’s/s/RORO’’ss work and/or new types of document content work and/or new types of document content and/or additional economic associations of States to and/or additional economic associations of States to DBRAT AdministratorDBRAT Administrator

99

��Update AT portfolioUpdate AT portfolio88

��Update AT publications & public documentsUpdate AT publications & public documents77

��Update AT policies and provisionsUpdate AT policies and provisions66

����Update AT meetings and missionsUpdate AT meetings and missions55

��Update AT advisory bodiesUpdate AT advisory bodies44

����Update AT newsUpdate AT news33

��Update State letters and/or repliesUpdate State letters and/or replies22

��Review & update AT subjects and AT issuesReview & update AT subjects and AT issues11

Reg. Reg. officesoffices

ATB ATB officesofficesTaskTaskNo.No.

Routine work Routine work –– Non ICAO usersNon ICAO users

����Upload AT correspondence, when appropriateUpload AT correspondence, when appropriate99

����Update the list of AT events organized by the State/Intl Org.Update the list of AT events organized by the State/Intl Org.88

����Update internal/external contacts in/of the Update internal/external contacts in/of the ATAsATAs/Intl Org./Intl Org.77

����Upload recent AT statistics and forecasts issued by the Upload recent AT statistics and forecasts issued by the StateState’’s s ATAs/CAAsATAs/CAAs, airports, air carriers and ANS providers , airports, air carriers and ANS providers or the Intl organization.or the Intl organization.

66

��Post AT news and economic/management developments Post AT news and economic/management developments related to the Staterelated to the State’’s policies/regulations, airports, air s policies/regulations, airports, air carriers and ANScarriers and ANS

55

��Upload AT documents containing disclosed info on Upload AT documents containing disclosed info on ownership & control and commercial alliances of the national ownership & control and commercial alliances of the national airports, air carriers and ANSairports, air carriers and ANS

44

����Update info related to national airports, air carriers and ANS Update info related to national airports, air carriers and ANS providersproviders

33

��Update info related to the national AT authorities (Update info related to the national AT authorities (ATAsATAs))22

��Update replies to State lettersUpdate replies to State letters11

Intl. Intl. Orgs.Orgs.StatesStatesTaskTaskNo.No.

The endThe end