Transcription
UNCLASSIFIEDResource Ordering and Status System (ROSS) ProgramROSS Analytical ReportsData DictionaryROSS Suite Version 2.15.0.44/2/2012Prepared by: Lockheed Martin Enterprise Solutions & Services (ES&S)ROSS Project Office – Lakewood, CODISTRIBUTION STATEMENTThis document is intended to be distributed only to members of the ROSS project team, LMmanagement and customer representatives of this project. Distribution to other companies orindividuals requires the approval of the project office. See “Point of Contact” on next page forfurther information.GSA Contract: GS-35F-4863G-5069USFS Task Orders: 53-82X9-04-0021 and AG-82X9-C-05-5069
Independent Subject Areas . 4Airports Subject Area . 4Airport Types . 4Airports . 5Coordinates . 7Documentation . 9Special Conditions . 10Catalogs Subject Area . 11Pre-Defined Filters . 11Alias Catalog Items . 11Catalog Items . 12Catalogs . 13Categories . 14Configurations . 15Documentation . 16Features . 17Keywords . 18Reminders . 19Special Processing . 20Hazards Subject Area . 21Coordinates . 21Documentation . 23Hazards . 24Locations Subject Area . 25Coordinates . 25Documentation . 27Locations . 28Organizations Subject Area . 29Pre-Defined Filters . 29Affiliations . 29Contracts . 31Direct Order Affiliations . 32Documentation . 33Organization Address . 34Organization Contacts . 35Organizations . 36Place Up Affiliations . 40Pre-Orders . 41Pre-Orders Access Organizations . 42Selection Area . 43User Contacts . 44Users . 45Travel Plans Subject Area . 47Travel Plan Legs . 47Travel Plans. 49Traveling Resources . 51Integrated Subject Areas . 52Incidents Subject Area . 52Pre-Defined Filters . 52Airports . 52Documentation . 55Financial Code . 56Frequencies . 57Hazards . 58Incident Address . 60Incident Contacts . 61
Incident Related . 62Incident Transfers . 63Incidents . 64Locations . 69Requests Subject Area . 72Pre-Defined Filters . 72Assignment . 72Associated Requests . 77Catalog - Filled . 78Catalog - Requested . 79Contracts . 80Documentation . 81External Supply Cache Activity . 82Features . 84Financial Code . 85Manifest . 86Request Trans . 87Requests . 89Summary . 93Resources Subject Area . 98Pre-Defined Filters . 98Assignment History . 98Contacts . 101Contracts . 102Documentation . 103Features . 104Qualifications . 105Resource Status . 106Resources . 107Rosters . 111Travel. 113
Independent Subject AreasAirports Subject Area/Airport Types Query SubjectC:\starteamwf\ROSS\Source Code\Cognos\Analytical Reports\Data Dictionary\ROSS-AR DataDict Cover TOC.docIndependent Subject AreasThe Independent Subject Areas contains subject areas that were built to 'stand alone' and thustheir query items may not be combined with query items from other subject areas.Airports Subject AreaThe Airports subject area provides detailed information on Airports, similar to the Airports screenin ROSS. Fields from the various query subjects in this subject area may be combined in a singlereport; however, the fields may not be combined with fields from other subject areas.Airport TypesThe Airport Types query subject is intended to be used in conjunction with fields from the Airportsquery subject, allowing users to display the type(s) associated with a particular airport.Query ItemDescriptionAirport TypeDescription used to identify the type of airport (e.g., Heliport).Airport Type CodeAlphanumeric code used to identify the type of airport (e.g., HE).Record Source CodeIndicates the source system or origination of the data contained inthe airport type record (e.g., ROSS, FAA).4
Independent Subject AreasAirports Subject Area/Airports Query SubjectAirportsThe Airports query subject provides detailed information on an airport. Each record in this querysubject represents a single airport.Query ItemDescriptionAirport CityDescription used to identify the city in which the airport is located(e.g. Denver).Airport GACC Org NameName of the Geographic Area Coordination Center (GACC)associated with the organization that entered and maintainsinformation about the airport (e.g. Rocky Mountain AreaCoordination Center).Airport GACC Org UnitCodeUnit Code Prefix and Unit Code Suffix of the Geographic AreaCoordination Center (GACC) associated with the organization thatentered and maintains information about the airport.Airport IDSystem-generated number used to uniquely identify the airport.Airport NameDescription used to identify the name of the airport (e.g. DenverInternational).Airport Org NameName of the organization that entered and maintains informationabout the airport (e.g. National Interagency Coordination Center).Airport Org Unit CodeUnit Code Prefix and Unit Code Suffix of the organization thatentered and maintains information about the airport.Airport Removed FlagFlag field (Yes/No) indicating whether or not the airport has beenflagged for removal from the system.Airport StateAbbreviated description used to identify the state in which the airportis located (e.g. CO).Dispatched By GACC OrgNameName of the Geographic Area Coordination Center (GACC)associated with the organization that dispatches resources thatreference the airport as their current operating base (e.g. RockyMountain Area Coordination Center).Dispatched By GACC OrgUnit CodeUnit Code Prefix and Unit Code Suffix of the Geographic AreaCoordination Center (GACC) associated with the organization thatdispatches resources that reference the airport as their currentoperating base.Dispatched By Org NameName of the organization that dispatches resources that referencethe airport as their current operating base.Dispatched By Org UnitCodeUnit Code Prefix and Unit Code Suffix of the organization thatdispatches resources that reference the airport as their currentoperating base.FAA CodeThe Federal Aviation Administration mnemonic used to uniquelyidentify an airport (e.g. DEN).5
Independent Subject AreasAirports Subject Area/Airports Query SubjectQuery ItemDescriptionFuel TypeDescriptions used to identify the types of fuel available at the airport(e.g. 100 100LLMOGAS).Managed by GACC OrgNameName of the Geographic Area Coordination Center (GACC)associated with the organization that maintains information about theairport (e.g. Rocky Mountain Area Coordination Center).Managed By GACC OrgUnit CodeUnit Code Prefix and Unit Code Suffix of the Geographic AreaCoordination Center (GACC) associated with the organization thatmaintains information about the airport.Managed By Org NameName of the organization that maintains information about theairport.Managed By Org Unit CodeUnit Code Prefix and Unit Code Suffix of the organization thatmaintains information about the airport.Record Source CodeIndicates the source system or origination of the data contained inthe airport record (e.g., ROSS, FAA).Tanker Base NameName of the base for mixing, storing and loading of retardant forfixed-wing airtankers.Tower FlagFlag field (Yes/No) indicating whether or not the airport has a controltower.6
Independent Subject AreasAirports Subject Area/Coordinates Query SubjectCoordinatesThe Coordinates query subject contains fields pertaining to the location of an airport in theLat/Long, T/R/S and UTM coordinate systems.Query ItemDescriptionAirport Base MeridianUsed to identify the base meridian of an airport location in theTownship, Range, Section coordinate system.Airport Coordinate TypeDescription of coordinate type entered for the airport (e.g. is aLat/Long, T/R/S or UTM).Airport LatNumbers identifying the degrees, minutes, and seconds, and theshortened description used to identify direction, of the latitude of alocation of the airport in the Lat/Long coordinate system (e.g., 24,35, 30 N).Airport Lat DecimalNumber used to identify the latitudinal degrees, minutes, andseconds, expressed in decimal notation, of a location of the airport inthe Lat/Long coordinate system.Airport Lat DegreeNumber (from 0 to 89) used to identify the latitudinal degrees of alocation of the airport in the Lat/Long coordinate system.Airport Lat DirectionShortened description used to identify the latitudinal direction of alocation of the airport in the Lat/Long coordinate system (i.e., N orS).Airport Lat MinNumber (from 0 to 59) used to identify the latitudinal minutes of alocation of the airport in the Lat/Long coordinate system.Airport Lat SecNumber (from 0 to 59) used to identify the latitudinal seconds of alocation of the airport in the Lat/Long coordinate system.Airport Loc 1-4Number used to identify the quarter of a location in the Township,Range, Section coordinate system.Airport LongNumbers identifying the degrees, minutes, and seconds, and theshortened description used to identify direction, of the longitude of alocation of the airport in the Lat/Long coordinate system (e.g., 115,40, 50 E).Airport Long DecimalNumber used to identify the longitudinal degrees, minutes, andseconds, expressed in decimal notation, of a location of the airport inthe Lat/Long coordinate system.Airport Long DegreeNumber (from 0 to 179) used to identify the longitudinal degrees of alocation of the airport in the Lat/Long coordinate system.Airport Long DirectionShortened description used to identify the longitudinal direction of alocation of the airport in the Lat/Long coordinate system (i.e., E orW).Airport Long MinNumber (from 0 to 59) used to identify the longitudinal minutes of alocation of the airport in the Lat/Long coordinate system.7
Independent Subject AreasAirports Subject Area/Coordinates Query SubjectQuery ItemDescriptionAirport Long SecNumber (from 0 to 59) used to identify the longitudinal seconds of alocation of the airport in the Lat/Long coordinate system.Airport RangeNumber used to identify the range of a location in the Township,Range, Sectio
Resource Ordering and Status System (ROSS) Program . ROSS Analytical Reports . Data Dictionary . ROSS Suite Version 2.15.0.4 . 4/2/2012 . Prepared by: Lockheed Martin Enterprise Solutions & Services (ES&S) ROSS Project Office – Lakewood, CO . DISTRIBUTION STATEMENT . This document is i
