BADD DATA MAPPING
Transportation planning
- APPORTNI: Apportioned forces
- (APPORTIONED_FORCES [80] -> APPORTIONED-FORCE) providing operation plan
and force participation therein
- ASSETSI: Specific transportation assets
- (AIRCRAFT_AIRFIELD_CHARS [29] -> CIVILIAN-TRANSPORT-AIRCRAFT,
MILITARY-TRANSPORT-AIRCRAFT) various on-ground operational
requirements for aircraft given their types
- (AIRCRAFT_GENERAL_CHARS [44] ->TRANSPORT-AIRCRAFT) various
general/in-air operational requirements for aircraft given their types
- (AIRLIFT_PLANNING_FCTRS [32] ->TRANSPORT-AIRCRAFT,
MILITARY-TRANSPORT-AIRCRAFT) various load capabilities for aircraft
given their types
- (NOTIONAL_SHIP [35] -> NOTIONAL-TRANSPORT-SHIP) speed,
capabilities, requirements, specifications for ship given type
- (NOTIONAL_SHIP_CODES [35] -> NOTIONAL-TRANSPORT-SHIP) maps names
to codes for ships
- (SHIP_CLASS [41] -> CLASSIFIED-TRANSPORT-SHIP) similar to
notional_ship but for classified ships.
- FMLIBI: Force modules
- (FM_ELEMENTS [1228] -> FORCE-MODULE-ELEMENT) associate fm ULN
(element) to type
- (FM_ROLL_UP [50] -> FM-ROLL-UP) space/weight requirements for FM
- (FORCE_MODULES [95] -> FORCE-MODULE) characteristics of FM
- (ULNS [1232] -> FORCE-MODULE-ELEMENT) characteristics of ULNs
- GEOI: Geographic locations, etc. reference data
- (AIRPORTS [10] -> AIRPORT) airports in Tunisia, Long Beach
- (BERTHS [15] -> BERTH) berth requirements for typical vessel types
- (CHANNELS [4] -> CHANNEL) channels in Long Beach
- (CHANNEL_HARBORS [6] -> CHANNEL-HARBOR) channels (Long Beach) associated with
which harbor
- (COUNTRY_STATE [375] -> COUNTRY) interpret cy_cd (country code) used elsewhere
- (GEOLOC [52687] -> GEOGRAPHIC-LOCATION, CITY)
geographic locations worldwide
- (HARBORS [3] -> HARBOR) harbors in long beach
- (PIERS [9] -> CARGO-PIER) cargo piers in harbors of long beach
- (PORT_BERTHS [150] -> PORT-BERTHS) qty of berths of given type in given
port (by geoloc). Not just Long beach
- (RUNWAYS [10] -> RUNWAY) Runways in tunisia
- (SEAPORTS [11] -> SEAPORT) Seaports in Tunisia, Long Beach
- (WHARVES [18] -> CARGO-WHARF) Wharves in Long Beach
- TPFDDI: TPFDDs
- (OPLAN [1] -> OPERATION-PLAN) a single operation plan
- UNITCHRI: Unit Characteristics (5 tables, not well understood)
Logistics
- CVI: Operational snapshot for US forces in Korea (CINCVIEW)
- (SAASMF [18170] -> CLASS-5-ITEM) catalog information about class 5
(ammunition) items
- (UNITMF [627] -> UNIT) units having some logistical function in Korea,
the pacific, and a few in CONUS
- (ABFSUM [45207] -> ARMY-STOCK) large amount of stocked items (mostly repair
parts and troop support articles) stored with Korea logistics units
- (ABFSAAS [29787] -> ARMY-CLASS-5-STOCK) large amount of ammuntion stocks grouped
into DODIC equivalence classes
- (SAILSABF [5000] -> ARMY-SAILS-STOCK) stocks from SAILS accounting system (Korea)
- (ABFAR7 [932] -> ARMY-CLASS-7-STOCK) stocks of class 7 (major end items) (Korea)
- (AMDF [1499292] -> ITEM) huge catalog of reference data about items of
all classes
- (SB70020 [20285] -> ITEM) smaller catalog of reference data including
line item numbers, focused on cl7 items
- LOGAUXI: reference info from Lou Mason (SRA/MITRE), PD web
sources, ALPINE/GLAD
- (CONDITION_CODES [16] ->) meta-data interpreting stock
condition codes
- (INSTALLATION_TYPE_CODES [67] ->) meta-data interpreting
geographic location installation type codes
- (CL1 [12] ->) meta-data interpreting class of supply codes
- (CL2 [101] ->) meta-data interpreting secondary class of
supply codes
- (FSC2 [100] ->) meta-data interpreting 2 digit prefix of
FSC (under development)
- (FSC4 [1419] ->) meta-data interpreting FSC (federal
supply class) (under development)
- ALPI: Advanced Logistics Data for forces countering biological/chemical
threats; from Jeff Berliner, BBN/GLAD (67 tables, not well understood)
- GITI8I: Advanced Logistics Program Data from Global InfoTek
(45 tables, only partially understood)
DMIF specific data
- TRACI: TRAC exercise scenario - Supplied by Walt Breen etc. of
Raytheon/E-Systems
- (UNIT_BLUE [188] -> UNIT, BLUE-UNIT) All friendly units in the TRAC DMIF
scenario by designation, src, location, hq, and activity.
- (UNIT_RED [1564] -> RED-UNIT) All enemy units in the TRAC DMIF
scenario by designation, src, location, hq, and activity. (under
development)
- (SRC_BLUE [55] -> BLUE-SRC) Details about src types for friendly units
- (SRC_RED [1491] -> RED-SRC) Details about src types for enemy units
(under development)
- DMIFAUXI: manufactured by ISI for visualization
purposes
- (DODAAC_BLUE [188] -> UNIT, BLUE-UNIT) Associates a logistics unit in
Korea with each friendly unit in DMIF
- (DODAAC_RED [] -> RED-UNIT) Associates a logistics unit in
Korea with each enemy unit in DMIF (under development)
- (SOCAL_AMDF [129] -> ITEM) Projection from CVI%AMDF
providing catalog information only about those items needed possessed
by blue units. Efficiency only.
- (WEATHER_IMAGE [20] -> WEATHER-IMAGE) local cache of dummy weather
data imagery referred to using URL pointers
BADD specific data
- MIDBI: MIDB data from Marc Zec
- DD_VALID_VALUES [] meta data?
- IDBF [] facilities?
- IDBU [] units?
- IDBUL [] locations?
- BADDAUXI: copy of DMIFAUXI for meta data mappings etc.
- SMF: CGI-to-ODBC (or KQML) interface, SIGINT data. TBD.
Legend
DBNAME -- Database name
TABLENAME [123] -- Table or view name [possessing 123 rows]
within given database
-> CONCEPT-NAME -- SIMS domain concept provided (in part or whole)
by a given table