Skip to main content

Archive Data Delivery

To access Archive Data select this link: ROSS Archive Data Delivery.

Note: A valid DMS username and password are required to access ROSS Archive Data Delivery.

Archive Data Dictionary

Presentations:

The following presentations will help users work with the data in Excel spreadsheets: (You may need a System Administrator to download these video files for viewing).

ROSS Archive Data Delivery is a repository which contains data, presented in Microsoft Excel spreadsheets and Microsoft Access databases and filtered by dispatch office (where appropriate) in the following categories:

 
Category
 
Definition
 
Affiliations
 
Provides details about Agency, Dispatch, Managed By, and Reporting affiliation hierarchies and the parent/child relationships between the organizations belonging to the hierarchies
 
Airports
 
 
Provides the list of airports.
 
Committed Resources
 
Provides summary level statistics for resources currently committed and resources committed year to date.
 
Contract Organizations
 
Provides information on contracts and the role(s) of dispatch centers in relation to those contracts.
 
Contract Resources
 
Provides information on resources assigned to contracts
 
All Documentation
 
Provides system generated and user entered documentation for incidents, requests and request actions.
 
Financial Code
 
 
Provides the list of incident financial codes.
 
Hazards
 
 
Provides the list of aviation hazards.
 
 
Incidents
 
Provides details for individual incidents.
 
Incident Documentation
 
Provides details about the system generated and user entered documentation for Incidents.
 
Incident Summary
 
 
Provides summary level statistical information for incidents and requests on those incidents.
 
Locations
 
Provides information about physical sites of significance.
 
National (All) Data Sets
 
Compilations of information using National data.
 
Organizations
 
Provides the list of organizations.
 
Pending Requests
 
 
Provides information for resource requests on incidents for which the requests are in a 'pending' state.
 
Request Documentation
 
Provides details about system generated and user entered documentation for requests and request actions.
 
Request Status
 
 
Provides details for resource requests on incidents down to the individual resource level.
 
Resources
 
 
Provides information for individual resources.
 
Resources Contacts
 
 
Provides contact information for overhead resources.
 
Resource History
 
 
Provides information for all the assignments preformed by individual resources.
 
Resource Qualifications
 
 
Provides information on the qualifications that resources have.
 
Rosters
 
Provides details about rosters and the resources that are members of the rosters.
 
Travel
 
 
Provides information for resources that are currently traveling.
 
Travel Plan
 
 
Provides information for the Transportation resource, Traveling resources, Administration passengers, and Untracked supplies associated with the Travel Plan.
 
Unlinked Resources
 
 
Provides information for overhead resources that do not have a managing organization.
 
User Roles
 
Provides details about users and the roles they have been assigned within an organization. Also displays the most recent login time. 
 
Relational Databases
 
ROSS Relational Databases
 
Databases where information in different tables can be related to information in other tables through the use of database "keys'.