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.
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).
- Working with Excel Spreadsheets
- Bolding and Sizing Columns
- Filtering Spreadsheet Data
- Freezing the Spreadsheet Columns
- Sorting Spreadsheet Columns
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'.
|