Data Draw

NOTE - 10/28/2007 Based on the DDS system limitations, DDS will be running on a modified schedule. Please to view the modified schedule. Run Time(s) Are the time the data update is started. Actual posting of refreshed data to DDS will normally be from 5 minutes to an hour depending on file size. This should be considered when automating downloads of DDS data. NOTE - DATA DELIVERY FILE ACCESS The 2004 and 2005 Data Delivery Files have been posted. Categories that are updated once daily are still on the indicated schedule. To access ROSS data select this link: ROSS Data Delivery. You must have a valid DMS username and password to use the ROSS Data Delivery System.
Presentations	Using the ROSS Data Delivery System 8.23.2004 Provides instructions for accessing your data. ROSS DDS Data Dictionary 12.14.2007 Definitions of the column headings and data categories.
The following presentations will help users work with the data in the 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

The ROSS Data Delivery System 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	Time updated (All times are CT)
Affiliations	Provides details about Agency, Dispatch, Managed By, and Reporting affiliation hierarchies and the parent/child relationships between the organizations belonging to the hierarchies	0400
Airports	Provides the list of airports.	0400
Committed Resources	Provides summary level statistics for resources currently committed and resources committed year to date.	0500, 1700
Contract Organizations	Provides information on contracts and the role(s) of dispatch centers in relation to those contracts.	0430
Contract Resources	Provides information on resources assigned to contracts	0430
All Documentation	Provides system generated and user entered documentation for incidents, requests and request actions.	0245
Financial Code	Provides the list of incident financial codes.	0400, 1500
Hazards	Provides the list of aviation hazards.	0400
Incidents	Provides details for individual incidents.	0345, 1545
Incident Documentation	Provides details about the system generated and user entered documentation for Incidents.	0245
Incident Summary	Provides summary level statistical information for incidents and requests on those incidents.	0200
Locations	Provides information about physical sites of significance.	0100
National (All) Data Sets	Compilations of information using National data.	0415
Organizations	Provides the list of organizations.	0400
Pending Requests	Provides information for resource requests on incidents for which the requests are in a 'pending' state.	0005, 0105, 0205, 0305, 0405, 0505, 0605, 0705, 0805, 0905, 1005, 1105, 1205, 1305, 1405, 1505, 1605, 1705, 1805, 1905, 2005, 2105, 2205, 2305
Request Documentation	Provides details about system generated and user entered documentation for requests and request actions.	0245
Request Status	Provides details for resource requests on incidents down to the individual resource level.	0345, 0545, 0945, 1145, 1345, 1545, 1745, 1945
Resources	Provides information for individual resources.	0455, 0655, 0855, 1055, 1255, 1455, 1655, 1855, 2055, 2255
Resources Contacts	Provides contact information for overhead resources.	0200
Resource History	Provides information for all the assignments preformed by individual resources.	0330, 1340
Resource Qualifications	Provides information on the qualifications that resources have.	0400
Rosters	Provides details about rosters and the resources that are members of the rosters.	0515
Travel	Provides information for resources that are currently traveling.	0500, 0700, 0900, 1100, 1300, 1500, 1700, 1900, 2100, 2300
Travel Plan	Provides information for the Transportation resource, Traveling resources, Administration passengers, and Untracked supplies associated with the Travel Plan.	0505, 0705, 0905, 1105, 1305, 1505, 1705, 1905, 2105, 2305
Unlinked Resources	Provides information for overhead resources that do not have a managing organization.	0100
User Roles	Provides details about users and the roles they have been assigned within an organization. Also displays the most recent login time.	0145
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'.	0500, 0900, 1300, 1700, 2100