United States Air and Radiation EPA420-B-00-002
Environmental Protection January 2000
Agency
vyEPA Mobile Source
Observation Data
User Guide and
Reference
> Printed on Recycled Paper
-------
EPA420-B-00-002
January 2000
Assessment and Standards Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
NOTICE
This technical report does not necessarily represent final EPA decisions or positions.
It is intended to present technical, analysis of issues using data, which are currently available.
The purpose in the release of such reports is to facilitate the exchange of
technical information and to inform the public of technical developments which
may form the basis for a final EPA decision, position, or regulatory action.
-------
Table of Contents
Section 1: Overview
Section 2: Top-Level Design Information
Section 3: Detailed Design Information
Section 4: Example Queries Using Structured Query Language (SQL)
Section 5: How to Request a CD-ROM Copy
-2-
-------
Section 1: Overview
Background-Purpose
Design Features
Basic design idea
The CAUSE Relationship
Replicate RESULTS
Composite RESULTS
Next implementation steps
How to begin using
(Note: This section currently applicable only to EPA employees
located in Ann Arbor, Michigan.)
Table indexes
Translation tables (Legal Value Lists)
Representation of Missing or Null data
Measurement types
Developers of the database need your ideas
-3-
-------
Background - Purpose
• Developed by the Assessment and Standards Division (ASD),
formerly the Assessment and Modeling Division (AMD), of the U.S.
EPA Office of Mobile Sources
• Purpose is to store data on observations of in-use mobile sources,
including data formerly stored in AMD's Mobile Source Emission
Factor (EF) Database
• Currently stores general-purpose emission factor data collected since
1982, will eventually store data collected for more specific purposes.
• General design enables storage of any mobile source observation
data, e.g. emission tests, activity measurements, etc.
• This document is intended to provide enough information to
understand and use the database.
• ASD is asking for your comments and questions.
-4-
-------
Design Features
• Relational design has led to an economy of tables and fields. Most
data is stored in only one place.
• Low cost to implement
• Tables easily linked together
• Easy to understand:
- Meaningful field names
- Coded or "categorized" field values are mostly character form, and
their legal values and meanings are explained within the database
itself.
- Documentation. Every table and field has a definition.
• Contains information besides just "bare" test results
- About the EPA, EPA-contracted, and other efforts, termed "work
assignments", that produced the data.
- Driving schedules, diurnal temperature evaporative test cycles, etc.
- About the fuels used.
• Broad scope, e.g. contains engine as well as vehicle test data
• Easy to maintain and adapt, design knowledge resides with EPA
• Modern database design methods used, portable, and compatible
with other modern tools
-5-
-------
Design is an Elaboration of a Basic Idea that
Observations of Mobile Sources Produce RESULTS
Different kinds of mobile sources
- Vehicles
- Engines
Different kinds of RESULTS
- Procurement
- Inspection
- Owner's report
- Repair
- Tailpipe emission test
- Running loss emission test
- Evaporative emission test
- On-Road emission measurements
- Engine power MAP
- Engine dynamometer emission test
- Tank fuel measurement
-Etc.
Some added "Bells and Whistles"
- Test work assignment information
- Driving schedules
- Fuel type information
- Categorized or coded fields have translation tables
- All tables have indexes to improve performance
-6-
-------
The CAUSE Relationship between RESULTS
• Represents the fact that some RESULTS affect subsequent ones.
• Currently only PROCURE and REPAIR-type RESULTS are
considered to have this effect.
• Currently all RESULTS, except Procurements, are related via the
CAUSE attribute to the Procurement or Repair-type RESULT that
most immediately affected it. Procurements have CAUSE = 0 which
means "none".
• The CAUSE attribute can be used to distinguish post-repair
observations from pre-repair observations.
• RESULTS which have different values of CAUSE either pertain to
different mobile sources, pertain to different procurements of the
same mobile source, or have intervening repairs, and so may not be
comparable for some purposes.
• Not part of entity-relationship data model and not fully SQL
searchable.
-7-
-------
Replicate RESULTS
• Represent repeated observations of the same thing.
• Are often performed to investigate the repeatability of measurements.
• Are stored in the MSOD.
• The PREV_REP and NEXT_REP attributes of RESULT link replicate
RESULTS together in a forward chain (via NEXT_REP), and a
backward chain (via PREV_REP).
• PREV_REP and NEXT_REP chains end with a value of 0.
• Not part of entity-relationship data model and not fully SQL
searchable
• To eliminate multiple replicates from query outcomes specify
PREV REP = 0 or NEXT REP = 0 as a selection criteria.
-8-
-------
Composite RESULTS
• A group of RESULTS can be considered a RESULT in its own right.
• In MSOD this is termed a "Composite RESULT" or a "RESULT
Group".
• The RESULTGRP attribute joins individual RESULTS to the
Composite RESULT they are a part of.
• Most RESULTS are not part of a Result Group and have
RESULTGRP = 0.
• An example use of this feature is that the component portions of the
Supplemental Federal Test Procedure (SFTP) are joined in this
fashion to a Composite RESULT which contains the composite
results of the SFTP.
-9-
-------
Likely Next Implementation Steps
• Load data from additional historical and future test programs.
• Develop user interface aids. (A customized browser program is
being developed for this database.)
• Migrate to more powerful, client/server, data base management
system (DBMS)
• Convert the Tables to Visual FoxPro (VFP) format. (They are
currently stored as FoxPro versio 2.6 tables which are essentially
generic .DBFs.) VFP's distinct Null value could then be used to
represent missing data.
• User feedback is needed to make best decisions about what's
needed!
-10-
-------
How to Begin Using
the Mobile Source Observation Database
[Note: The production copy of the database is currently accessible only by
employees with access to EPA's local area network at the National Vehicle
and Emissions Laboratory at Ann Arbor, Michigan. Others may request a
copy and adapt the following procedures to their software and data storage
location.]
1. Start FoxPro 2.6 or Visual FoxPro
2. Enter the following commands:
SET DEFAULT TO H:\EMFACTOR\EF_PROTO
SET EXCLUSIVE OFF
3. Now you can:
- USE and query any single table
- USE and query multiple tables
- Take advantage of the categorized field translation tables
-Etc.
• Documentation on all features of the relational database follows in
this user guide.
• Please do NOT store your work on H:\EMFACTOR\EF_PROTO
• Open all tables SHARED. (This should be made the default by
issuing the command SET EXCLUSIVE OFF)
-11-
-------
Table Indexes
• Every table in the database has been indexed on its Primary Key in
what FoxPro terms a "compound structural index" stored in a .CDX file.
These are maintained automatically and will speed some operations
automaticly.
• To use for other purposes, however, such as to order records in a
Browse window display, the indexes need to be explicitly invoked e.g.
USE RESULT ORDER TAG RESULT
Note that tagname of the primary key index matches tablename.
• Key expression(s) can be determined using FoxPro by
?KEY(1), ?KEY(2), etc.
-12-
-------
Translation Tables or Legal Value Lists
for Categorized Fields
• Document the database in a platform-independent fashion
• Help implement data quality by defining all legal values of categorized
fields.
• Every categorized field, which includes most character-type fields in
the database, has a "translation table" not shown in the entity-
relationship diagrams which follow.
- Name of table is same as name of field, truncated if necessary to
eight characters.
- First column of table is same as name of field.
- Second column of table is typically Fieldname_N and can be used to
express the category as a number e.g. to carry the category
information into SPSS.
- Third column of table is typically Fieldname_D and contains a
character definition of the category value.
- Additional columns are sometimes present for special purposes.
• The TEST_PRO table is an example of a field translation table, for the
test procedure field.
-13-
-------
Representation of Missing or Null Data
In the current version of MSOD each field in each table has a specific
null value. This value can be found in the table QC_SPECS which has
a row for each field in the database. Some fields, such as primary key
fields, are not allowed to assume their null value. The null value of
categorized fields in MSOD is usually the character string "NULL" or,
for three character fields, "NUL", and this value is not generally
included in the translation table (legal value list) for the field. For
character fields which function as comments, the null value is usually
to fill the field with blank characters. For numeric fields the null value
is either zero or, if this could be confused with real data, the largest
number the field can store.
EPA plans to convert the database soon to Visual FoxPro's table
format, which has a distinct null value, usually represented in external
documentation as .NULL., for fields of every data type. EPA's plans
include converting all null data values to VFP's distinct null value when
this conversion is made.
Users should attach no meaning whatsoever to data values which are
null. The value simply means that the data for this field is not present
in the record which can occur for many reasons.
-14-
-------
MEASTYPEs
• Information items that are only gathered occasionally and are not
considered of central importance are stored one item per row in
separate tables.
• These are sometimes also referred to as "Non-Core Measurements"
• Avoids having to create additional columns for data items only
occasionally needed.
• Makes it easy to extend design to accommodate new items.
• The MEASTYPE table lists items which are handled in this fashion.
• Tables with names like xxxxMEAS and VEH MISC contain such data.
-15-
-------
Database Developers Need Your Ideas
What user queries should be facilitated?
What further user documentation is needed?
Etc.?
Jot Down Questions when they occur to you. Comments or questions
can be sent to:
Mitch Cumberworth
EPA National Vehicle and Fuels Laboratory
2000 Traverwood Drive
Ann Arbor, Ml 48105
(734)214-4342
cumberworth.mitch@epa.gov
-16-
-------
Section 2: Top-Level Design Information
"Logical-Level" Diagram Showing all Entities Currently Designed
More readable diagram showing top level entities, and their attributes.
Definitions for all Entities
-17-
-------
EFTOP10- Display! /All Implemented
Mobile Source Observation Database - Implementation
January 3, 2000
ROADTEST ROADTRIP
-18-
-------
EFTOP10 -- Display"! / Metadata
Mobile Source Observation Database
Metadata Portion (Where did the Data Come From?)
January 3, 2000
M SOURCE
ms_id
ms_type
except
ex_comm
fueltype
company
highway
disp_cid
dispjiter
fuel_deliv
Venturis
fi_type
aspirated
var_vent
cylinder
airjnj
cat_type
closedloop
ignition
Is observed or tested
WKASSIGN
wa id
wa_desc
epa_contno
epa_wano
contractor
fiscalyr
epacontact
alternate
sow_fname
wp_fname
abstract
nojnsource
frpt_fname
p_criteria
TASK
Produced
Produces
RESULT
resultid
test_proc (FK)
wajd (FK)
schedjd (FK)
cause.resultid (FK)
prev_rep.resultid (FK)
next_rep.resultid (FK)
resultgrp.resultid (FK)
ms_type (FK)
msjd (FK)
res_kind
fueljd (FK)
test_date
test_tod
site
nom_temp
nom_humid
disable
ctr_tst_id
No_bags
No_modes
old_rkey(AK.1)
proto_id (FK)
test modif
T
Affects;
Replicates
l_ Has replicatej
Has_mernbers J
-19-
-------
Entity/Definitions : Simplified Entity Definition Report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:33:26, 69 rows, 60
Simplified Entity Definition Report
Entity Name
BAG MEAS
DYNO_BAG
DYNOMODE
DYNORATE
DYNOTEST
DYNOTIME
EMODMEAS
ENG FAM
ENGINE
ENGINMAP
ENGMODE
ENGTEST
ETSTMODE
EVAP FAM
EVAPSTAN
EVAPTEST
EVAPTIME
EXSTSTAN
Entity Definition
Used to store a MEASTYPE measurement at the test bag level.
One bag set of a DYNOTEST or RUNLOSS test. (A bag set usually results from two physical bags: one
sample and one background, with the background measurements subtracted from the sample
measurements to yield the bag set measurements).
For DYNOTESTs having a single bag set the bag results are stored here, in addition to being the
summary results for the test as a whole.
One "mode" of a possibly multimode DYNOTEST whose results are expressed in mass units. The set
modes is defined at any point in time by the translation table for the MODE_ID attribute.
Examples of a "mode" include IDLE, IDLE with engine running at 2500 rpm, etc.
One "mode" of a possibly multimode DYNOTEST whose results are expressed in mass/time units. The
set of possible modes is defined at any point in time by the translation table for the MODEJD attribute.
Examples of a "mode" include IDLE, IDLE with engine running at 2500 rpm, etc.
This result subtype stores the results of a vehicle chassis exhaust emission test, or in some cases a group
of tests. This table stores information pertaining to the test, or test group as a whole.
Note: The emission summary result fields in this entity are used only to summarize the results of bagged
exhaust emission tests.
This result subtype is identified in RESULT by RES_KIND = "DYNOTEST".
The entity name DYNOTEST reflects the fact that a chassis dynamometer is used in most of these tests.
The subtype includes exhaust emission tests for which a dynomometer could be used, but is not required,
such as idle emission measurements. This subtype does not include "running loss" tests, which are
performed on a chassis dynamometer, but which measure both exhaust and evaporative emissions.
A point in time during a DYNOTEST.
Used to store a MEASTYPE measurement at the engine test mode level.
Exhaust Engine Family. These engine families result from the Vehicle Emission Certification process.
An engine or motor used to power an M_SOURCE, exclusive of other components of the M_SOURCE
such as its structural frame, wheels, etc.
Additional Notes:
1 . Since MS_TYPE = 2 for all instances of this entity the MS_TYPE field is not physically implemented in
this table.
2. MS_ID will likely be the engine serial number for instances of this entity, though if some small engines
do not bear unique serial numbers then another solution will have to be found for them.
Sample Queries: To access ENGINE fields in conjunction with their RESULT information the following join
condition would typically be used:
WHERE RESULT.MS TYPE = 2 AND RESULT.MS ID = ENGINE. MS ID
This result subtype stores an engine "MAP". Maximum available power or torque as a function of RPM.
This result subtype is idenfified in RESULT by RES KIND = "ENGINMAP".
Steady-state mode used in engine testing on an engine dynamometer. Characterized by a speed,
expressed as a percentage of one of several maximum speeds (rated, idle, or governed central speed,
etc), and a load, expressed as a percentage of the mapped torque at that speed.
This result subtype stores the results of an engine test performed on an engine dynomometer, exclusive
of smoke opacity measurement. This subtype is identified by RES_KIND = "ENGTEST".
The results of one steady-state mode of an engine dynomometer test. (Only used to store steady-state
results.)
Evaporative Engine Family. These families are a product of the vehicle emission certification process.
Evaporative Emission Standard. Used to store standards applicatble to late model (1994 and later)
vehicles. (Earlier standard information was simpler and is stored within the Vehicle Table itself.)
The design of this table is very much influenced by the need to obtain this information from EPA's
Certification and Fuel Economy Information System (CFEIS ), for this reason this should be considered a
"foreign" design whose attributes are not well integrated with the MSOD.
This result subtype stores the results of an evaporative emission test. This table stores information
pertaining to the test as a whole.
This result subtype is identified in RESULT by RES_KIND = "EVAPTEST".
This subtype does not include "running loss" tests, which are performed on a chassis dynamometer and
which measure both exhaust and evaporative emissions.
One point in time during an evaporative emission test.
Exhaust Emission Standard. Used to store standards applicatble to late model (1994 and later) vehicles.
(Earlier standard information was simpler and is stored within the Vehicle Table itself.)
The design of this table is very much influenced by the need to obtain this information from EPA's
Certification and Fuel Economy Information System (CFEIS ). For this reason this table design should be
considered a "foreign" design whose attributes are not well integrated with the MSOD.
Rows 1 to 19
-20-
-------
Entity/Definitions : Simplified Entity Definition Report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:33:26, 69 rows, 60
Entity Name
FUEL
FUELCHEM
INSPECT
KIND_OF_RESULT
M_SOURCE
MAPPOINT
MEASTYPE
MODEMEAS
MODETIME
OBD2CODE
OBDSCAN
OWNERQST
P INSP
PART
Entity Definition
A kind of fuel used to power a mobile source during a particular test.
Example instances:
Diesel Fuel, Indolene, Tank fuel (whatever was present in the fuel tank when the vehicle was obtained),
etc.
While some kinds of fuel may be purchased or blended to nominal specifications for octane, volatility,
alchohol content etc., e.g. "clean air act baseline fuel", instances of this entity are always a conceptual
"kind" of fuel and not a physical batch of fuel.
This result subtype stores the results of an analysis of the fuel being used in the mobile source. This
result subtype is indentified in RESULT by RES_KIND = "FUELCHEM".
This result subtype is idenfified in RESULT by RES_KIND = "INSPECT".
This result subtype is used to store the results of the emission component inspection often referred to as
the M1 maintenance inspection, or just M1 maintenance. This top level subtype entity is used to store
information about the inspection as a whole.
This result subtype can also be used to store observational comments pertaining to a Mobile Source,
even when no parts or systems are actually inspected.
This area contains information organized by particular kinds of RESULTS. We often refer to these as
RESULT subtypes. Every process which records information about or which modifies a mobile source of
air pollution such as a VEHICLE or ENGINE is considered to be some kind of a RESULT.
So kinds of results include subtypes like PROCUREments which are not normally considered test results.
This is because information such as the procurement date and the odometer reading of the vehicle, etc.
is recorded when the vehicle is obtained.
Each row in the RESULT table includes the res_kind field, which identifies what kind of a RESULT it is.
A physical object which can move, and which produces outdoor air pollution. Historically interest has
been in passenger cars and trucks designed to be driven on roadways, and the internal combustion
engines used to power such vehicles. Future data will pertain to other types of mobile sources such as
off-road vehicles, boats, farm and construction equipment, etc., and the engines used to power such
equipment.
Additional Notes:
1 . EPA and the principal air- pollution-regulating statutes make a fundamental distinction between mobile
and stationary sources of air pollution such as factories and power plants.
2. This entity is broken down into subtype entities based on MS_TYPE. Fields common to all or most
types of mobile sources will be stored in this table. Fields particular to certain types of mobile sources will
be stored in subtype tables.
Sample Queries: To access M_SOURCE fields in conjunction with their RESULT information the following
join condition would typically be used:
WHERE RESULT.MS TYPE = M SOURCE. MS TYPE AND
RESULT.MSJD = M_SOURCE.MS_ID
Example Instances:
Passenger cars, trucks, busses, farm tractors, locomotives, ships, airplanes, portable generators, and
power lawnmowers are all M_SOURCES.
A trailer is not (does not produce air pollution). A gasoline service station is not (can not move). A
transportation activity such as "shipping" is not (not an object). A class of mobile sources such as "LDTs"
(light duty trucks), about which we might collect for example population, activity, or usage data, is likewise
not an M SOURCE.
A single point within an engine map.
A type of numeric, "non-core", emission-related measurement, e.g. methane emissions in grams per
mile, not usually performed.
Note: This table does not store a result measurement, but information about a kind of measurement.
Used to store a MEASTYPEmeasurement at the test mode level.
A point in time within a DYNOMODE.
OBD2 scan code. Contains information about the code itself, e.g. its meaning.
This result subtype is used to store summary level information pertanent to a scan of a vehicle's on board
diagnostic system. While both level 1 and level 2 on board diagnostic systems scans are supported by
this data structure, data collected on level 1 systems prior to 1999 are stored as part of the vehicle
inspection data.
This result subtype is idenfified in RESULT by RES_KIND = "OBDSCAN".
This table is used to store information pertaining to the scan as a whole.
This result subtype stores information from the Owner's questionnaire, and, where collected, summary
information from the fuel economy postcard survey.
This result subtype is idenfified in RESULT by RES KIND = "OWNERQST".
Emission component part inspection.
Emission Component Part e.g. E1 01 , etc. Other values represent the MIL light, OBD1 , codes, etc.
Rows 20 to 33
-21-
-------
Entity/Definitions : Simplified Entity Definition Report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:33:26, 69 rows, 60
Entity Name
PARTCODE
PC INSP
PRESSTST
PROCURE
RATEMEAS
REP MEAS
REPAIR
RESULT
ROADPHAS
ROADTEST
ROADTIME
ROADTRIP
RUNL BAG
RUNLOSS
S INSP
SCANSYS1
SCANSYS2
SCHED_PT
SCHEDULE
Entity Definition
Numeric value representing a status or failure of an emission component system part.
Emission component part code inspection.
This Result Subtype stores the outcome of an evaporative system pressure check. In cases where an
attempt was made to perform a pressure check, but it could not be performed, the reason for this is
stored.
This result subtype is idenfified in RESULT by RES_KIND = "PRESSTST".
The obtaining of an M_SOURCE for testing. Usually a series of tests is performed during the
M SOURCE'S stay at a test facility.
This result subtype is idenfified in RESULT by RES_KIND = "PROCURE".
Historically AMD's emission factor testing program can be considered to have always "procured" a vehicle
or engine prior to testing it, but it is not a logical requirement of the database that a PROCURE instance
exist for every RESULT if no information of this nature is collected, e.g. Vehicles observed driving on the
road would not have to be "procured".
Used to store a rate MEASTYPEmeasurement at the test mode level.
Used to store a MEASTYPEmeasurement at the test time point level.
A repair is a procedure performed on a Mobile_Source intended to improve its performance, which is
assumed to affect all subsequent RESULTS on that Mobile Source.
This result subtype is idenfified in RESULT by RES_KIND = "REPAIR".
Any observation, measurement, or modification to an M_SOURCE including...
Information pertinent to the procurement of the M_SOURCE.
An outcome of any test procedure performed on an M_SOURCE, such as an exhaust emissions test or an
evaporative emissions test.
Observations of the M_SOURCE, e.g. a questionnaire about the M_SOURCE submitted by the owner.
Repairs or modifications made to the M_SOURCE which could effect future measurements.
Additional Notes:
1 . This entity is broken down into an incomplete collection of dependent subtype entities based on its
RES_KIND field. Additional result subtypes will be added as are needed.
A portion of a roadtest. This portion must correspond to a single, contiguous period of time within the time
period of the complete test.
This result subtype stores the results of a vehicle exhaust emission test performed during on-road driving.
This table stores information pertaining to the test as a whole.
This result subtype is identified in RESULT by RES_KIND = "ROADTEST".
The entity name ROADTEST reflects the fact that the vehicle has been equipped with on board exhaust
emission measurement instrumentation and that the emission measurements can therefore be made
during actual use rather than in a laboratory.
A point in time during a ROADTEST.
A trip travelled by an on-road vehicle.
This result subtype is identified in RESULT by RES_KIND = "ROADTRIP".
This result subtype is similar to a ROADTEST. The primary purpose of a ROADTEST is to measure
exhaust emissions. The purpose of a ROADTRIP is to measure other aspects of the vehicle's usage or
activity.
The evaporative emissions for a portion of a "running loss" test, identified by "bag number" within the test.
This result subtype stores the results of a vehicle chassis running loss emission test. Like DYNOTESTs,
these are performed on a chassis dynamometer and exhaust emission measurements are taken. Unlike
DYNOTESTS, however:
1 . Evaporative running losses are measured during portions of the test.
2. An attempt is made to heat or cool the vehicle's fuel tank as necessary to simulate the temperature
pattern it would experience in on-road driving.
This result subtype is identified in RESULT by RES_KIND = "RUNLOSS".
This table is used to store results which pertain to the test as a whole; no attempt is usually made to
summarize the emission results, exhaust or evaporative, for the test as a whole.
Emission component system inspection.
Individual scan code resulting from a scan of a level 1 on board diagnostic system.
Individual scan code resulting from a scan of a level 2 on board diagnostic system.
A time point in a SCHEDULE.
Sample Queries: ..To use this table in conjuction with the SCHEDULE table the following join condition
would be used.
. where sched_pt.sched_id = schedule. schedjd
Example Instances: 1 ) For schedule cdh226, the speed should be 23.5 mph at 20 seconds 2) for
schedule rtd2, the temperature should be
83.9 F at 90 minutes.
Functional relation which gives values for one or more controlling test parameters, such as the speed a
vehicle should be traveling, the temperature that a SHED should maintain, or the torque and rpm of an
engine throughout the time of a test procedure.
Rows 34 to 51
-22-
-------
Entity/Definitions : Simplified Entity Definition Report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:33:26, 69 rows, 60
Entity Name
SMOKETST
SYSTEM
TASK
TEST_PRO
TESTMEAS
TIMEMEAS
VEH MISC
VEHICLE
WKASSIGN
Entity Definition
Schedules are often also referred to as "cycles" though the Schedule term is considered preferable since
there is nothing circular, regular or repeating about most test schedules.
Additional notes: Only items pertaining to the schedule as a whole belong in this table, e.g.
descriptions, average or maximum values of the entire schedule.
Sample Queries: To use this table in conjunction with the RESULT entity the following join condition
would be used
where schedule. schedjd = result. schedjd
Example Instances:
(1) EPA Urban Dynamometer Driving Schedule for Light-Duty Vehicles and Light-Duty Trucks.
(2) EPA Engine Dynamometer Schedules for Heavy-Duty Otto-Cycle engines.
(3) Temperature schedules for evaporative emission tests.
This result subtype stores the results of an engine smoke test. This subtype is identified by RES_KIND =
"SMOKETST".
Emission Component System e.g. "Induction", etc. "OBD", etc.
Work effort which produced the RESULT as classified historically. Usually corresponded to a contract
task or analogous internal effort.
Note: The WKASSIGN entity was intended to subsume this TASK entity. Until WKASSIGN is fully
populated, however, this TASK entity will be used to store more sparse information which is available from
the "old database" about the work efforts which produced the older RESULTS.
Test procedure used to produce a RESULT.
An example would the Federal Test Procedure (FTP), though most other test procedures are not as
completely defined.
Note! : Historically this concept was termed "Test_Type" by AMD. Instances of this entity are an
evolution of the domain of the former Test_Type field, though in some cases multiple Test_Type values
have been combined into a single Test Procedure instance and visa versa.
Note2: Conceptually Test Procedure is a different idea from Test Schedule. For example if two test
procedures differ only in the Schedule used then ideally they should be considered the same Test
Procedure. In practice, however, this has not been fully implemented because of the strong identity of
some Test Procedures with Test Schedules and the lack of identification of true test "Procedures". Some
grouping of Schedules into Test Procedures has been achieved, however, where identifiable groups of
Schedules are involved, such as the "Facility" driving schedules for exhaust emission tests, or EPA's set
of "Speed Correction" cycles.
Used to store a MEASTYPEmeasurement at the summary test level.
Used to store a MEASTYPE measurement pertaining to a particular time in a test.
Used to store a MEASTYPE measurement about a vehicle.
A motor vehicle, inclusive of its engine and chassis, having a unique (within this entity) vehicle
identification number (VIN).
Additional Notes:
1 . It may be necessary at some point to distinguish between light duty and heavy duty vehicles. If made
such a distinction would probably be based on the vehicle certification regulations at CFR 40 Part 86
section 082-2. Most fundamentally if this distinction were made a light duty vehicle instance, if certified for
compliance with air emission regulations, would be certified as an entire vehicle or "chassis", whereas a
heavy duty vehicle instance, would have its engine certified.
2. Since MS_TYPE = 1 for all instances of this entity the MS_TYPE field is not physically implemented in
this table.
3. MSJD is the Vehicle's Identification Number (VIN) for instances of this entity.
Sample Queries: To access VEHICLE fields in conjunction with their RESULT information the following
join condition would typically be used:
WHERE RESULT.MS_TYPE = 1 AND RESULT.MSJD = VEHICLE. MSJD
Example Instances:
This entity includes motorcycles and off road vehicles.
A work assignment, whether contracted or performed in_house, which produces RESULTS. Often also
referred to as a "test program".
These efforts have often been performed by vehicle testing contractors under work assignment contracts.
This entity represents a broader view of this fundamental construct.
Rows 52 to 60
-23-
-------
Section 3: Detailed Design Information
• "Physical-Level" Diagram showing all tables currently implemented
• More readable diagrams showing specific areas of the design and their
attributes.
• Definitions for all columns
• Listings of some important tables.
• Relationship to "old" EF Database; Information not carried forward
-24-
-------
EFTOP10- Display! /All Implemented
Mobile Source Observation Database - Implementation
January 3, 2000
nsjd Character! 17) W
n^peNumeric(2)J
iiOHntHiliihE
' VE
EVAPSTAN
sales_area Character(2)
tier Character(4]
usefullife Character^]
esfueltype Character]3)
evap_emiBB Character(16)
+-
I—1
I
SINSP ^
("system Chs
[resultid Nu
->r -,TB \
•j tnni h
ystem Character(12)~j| [part Charactnii4
-25-
-------
EFTOP10 - Display"! / Core Model
WKASSIGN
Mobile Source Observation Database - Implementation
Core Model (Exclusive of Most Result Subtypes)
January 3, 2000
M SOURCE
msjd: Character(17)
ms_type: Numeric(2)
except: Character(S)
ex_comm: Character(20)
fueltype: Character(4)
company: Character(12)
highway: Character(S)
disp_cid: Numeric(4)
disp_liter: Numeric(4,1)
fuel_deliv: Character(G)
Venturis: Numeric(2)
fijype: Character(6)
aspirated: Character(7)
var_vent: Character(S)
cylinder: Numeric(2)
airjnj: Character(S)
cat_type: Character(4)
closedloop: Character(S)
ignition: Character(2)
VEHICLE
ms_id:Character(17)(FK)
evapjam: Character(12) (FK)
engjam: Character(19) (FK)
vehclass: Characters)
model_yr: Numeric(4)
make: Character(12)
model_name: Character(20)
overdrive: Character(S)
tran_type: Character(G)
creeper: Character(S)
lockup: Characters)
gears: Character(6)
gvwr: Numeric(6)
curbweight: Numeric(6)
ac: Character(3)
bld_date: Date
thcstd: Numeric(6,3)
nmhcstd: Numeric(6,3)
costd: Numeric(6,3)
noxstd: Numeric(6,3)
thcestd: Numeric(6,3)
pmstd: Numeric(6,3)
nmhcestd: Numeric(6,3)
evapstd: Numeric(6,3)
fueltanks: Numeric(1)
tank_cap: Numeric(3)
canister: Character(IO)
egr: Character(S)
city_fe: Numeric(2)
hway_fe: Numeric(2)
drv_trn: Character(4)
modelsize: Character(IO)
axle_ratio: Numeric(5,2)
standards: Character(6)
engmount: Character(10)
purpose: Character(IOO)
sec: Character(14)
wa_id: Character(IO)
wa_desc: Character(254)
epa_contno: Character(11)
epa_wano: Character(4)
contractor: Character(20)
fiscalyr: Numeric(4)
epacontact: Character(20)
alternate: Character(20)
sow_fname: Character(S)
wp_fname: Character(S)
abstract: Memo
no_msource: Numeric(4)
frpt_fname: Character(S)
p_criteria: Character(11)
TASK
RESULT
FUEL
fuel_id: Numeric(3)
fuelname: Character(SO)
oxygenate: Character(15)
wtoxygen: Numeric(4,1)
rvp: Numeric(4,1)
sulferlow: Numeric(5)
sulferhigh: Numeric(5)
SCHEDULE
schedjd: Character(6)
sched_name: Character(90)
schedjen: Numeric(6)
sched_avg: Numeric(6,2)
sched_max: Numeric(6,2)
sched_acc: Numeric(6,2)
SCHED PT
sched_id: Character(6) (FK)
sched_type: Numeric(1)
test_time: Numeric(6)
sched_val: Numeric(6,2)
VEH MISC
ms_id: Character(17) (FK)
meas_id: Character(IO) (FK)
vehmeas: Numeric(10,3)
resultid: Numeric(8)
test_proc: Character(S) (FK)
wajd: Character(IO) (FK)
sched_id: Character(6) (FK)
cause: Numeric(8) (FK)
prev_rep: Numeric(8) (FK)
next_rep: Numeric(S) (FK)
resultgrp: Numeric(S) (FK)
ms_type: Numeric(2) (FK)
ms_id: Character(17) (FK)
res_kind: Character(S)
fuel_id: Numeric(3) (FK)
test_date: Date
test_tod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(S)
disable: Numeric(S)
ctr_tst_id: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22) (AK.1)
protojd: Numeric(3) (FK)
test_modif: Numeric(2)
T
protojd: Numeric(S)
contract: Numeric(2)
program: Character(4)
task_d: Character(SO)
p_criteria: Character(11)
TEST PRO
ENGINE
ms_id: Character(17) (FK)
camefrom: Character(17) (FK)
engseries: Character(20)
eng_fam: Character(19)
eng_class: Character(7)
bld_date: Date
eng_mod_yr: Numeric(4)
cooling: Character(7)
fi_meth: Character(4)
injectors: Numeric(1)
fi_press: Numeric(5)
rate_shape: Character(S)
maxadvance: Numeric(5,2)
maxretard: Numeric(5,2)
egr_type: Character(G)
airfuel: Character(4)
parttrap: Character(S)
eng_cycle: Character(l)
ratedpower: Numeric(7,1)
ratedspeed: Numeric(5)
idle_rpm: Numeric(5)
tech_confg: Character(SO)
pump_type: Character(SO)
ecs_descpt: Character(SO)
elect_cont: Character(IOO)
test_proc: Character(S)
test_pro_n: Numeric(S)
test_pro_d: Character(SO)
hc_method: Character(20)
has_start: Logical
nom_soak: Character(S)
PROCURE
resultid: Numeric(8) (FK)
veh_no: Numeric(5)
vehjane: Numeric(5)
procmeth: Character(IO)
fixes: Numeric(2)
recruit_no: Character(15)
proc_odom: Numeric(6)
fuel_pb: Numeric(6,3)
plumb_test: Character(4)
tankneck: Character(4)
rep_time: Numeric(4)
ecmptime: Numeric(4)
conpart: Numeric(4)
twypart: Numeric(4)
statetest: Character(S)
im240_pf: Character(4)
purge: Character(7)
pressure: Character(7)
proc_match: Character(7)
tiresize: Character(11)
tire_mfr: Character(IO)
lf_psi: Numeric(2)
rf_psi: Numeric(2)
lr_psi: Numeric(2)
rr_psi: Numeric(2)
fpsi_spec: Numeric(2)
rpsi_spec: Numeric(2)
lf_wear: Character(4)
rf_wear: Character(4)
cuthc: Numeric(5,2)
cutco: Numeric(6,2)
cutnox: Numeric(5,2)
cutpoints: Numeric(2)
hour_meter: Numeric(6)
rebuild_ct: Numeric(2)
rebuild_dt: Date
rebuildwhy: Character(SO)
modifs: Character(IOO)
-26-
-------
EFTOP10 - Display! /Vehicle Standards
Mobile Source Observation Database - Implementation
Vehicle Standards Portion
January 3, 2000
EXSTSTAN
VEHICLE
msjd: Character(17)
evap_fam: Character(12)
eng_fam: Character(19)
vehclass: Character(S)
model_yr: Numeric(4)
make: Character(12)
model_name: Character(20)
overdrive: Character(S)
tran_type: Character(6)
creeper: Character(S)
lockup: Character(3)
gears: Character(6)
gvwr: Numeric(6)
curbweight: Numeric(6)
ac: Character(S)
bld_date: Date
thcstd: Numeric(6,3)
nmhcstd: Numeric(6,3)
costd: Numeric(6,3)
noxstd: Numeric(6,3)
thcestd: Numeric(6,3)
pmstd: Numeric(6,3)
nmhcestd: Numeric(6,3)
evapstd: Numeric(6,3)
fueltanks: Numeric(1)
tank_cap: Numeric(3)
canister: Character(10)
egr: Character(S)
city_fe: Numeric(2)
hway_fe: Numeric(2)
drv_trn: Character(4)
modelsize: Character(IO)
axle_ratio: Numeric(5,2)
standards: Character(6)
engmount: Character(IO)
purpose: Character(IOO)
sec: Character(14)
ENG FAM
eng_fam: Character(19)
EVAP FAM
eng_fam: Character(19)
certjnuse: Character(l)
sales_area: Character(2)
tier: Character(4)
usefullife: Character(S)
esfueltype: Character(S)
exst_emiss: Character(16)
standard: Numeric(8,4)
EVAPSTAN
evap_fam: Character(12)
evap_fam: Character(12)
sales_area: Character(2)
tier: Character(4)
usefullife: Character(S)
esfueltype: Character(S)
evap_emiss: Character(16)
standard: Numeric(8,4)
-27-
-------
EFTOP10 - Displayl / Chassis Exhaust Emission Result Subtype
resultid: Numeric(8)
test_proc: Character^) (FK)
wa_id:Character(10)(FK)
schedjd: Character(G) (FK)
cause: Numeric(8) (FK)
prev_rep: Numeric(8) (FK)
next_rep: Numeric(8) (FK)
resultgrp: Numeric(8) (FK)
msjype: Numeric(2) (FK)
msjd:Character(17)(FK)
res_kind: Character(S)
fueljd: Numeric(S) (FK)
test_date: Date
testjod: Character(S)
site: Character(12)
nomjemp: Numeric(S)
nom_humid: Numeric(S)
disable: Numeric(3)
ctr_tst_id:Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22) (AK.1)
proto_id: Numeric(S) (FK)
test_modif: Numeric(2)
L
4 -
Mobile Source Observation Database - Implementation
Chassis Exhaust Emission Test Result Subtype
January 3, 2000
resultid: Numeric(8) (FK)
the: Numeric(7,3)
co: Numeric(8,3)
co2: Numeric(8,3)
nox: Numeric(7,3)
mpg: Numeric(6,2)
testwght: Numeric(6)
road_hp: Numeric(5,1)
ac_hp: Character(S)
dynotype: Character(IO)
odometer: Numeric(6)
precond: Character(IO)
test_order: Numeric(S)
initjemp: Numeric(5,1)
init_baro: Numeric(5,2)
init_humid: Numeric(6,2)
measjd: Character(IO) (FK) I
resultid: Numeric(8) (FK) I
measure: Numeric(10,3)
resultid: Numeric(8) (FK)
bag_num: Numeric(2)
bag_baro: Numeric(5,2)
bag_humid: Numeric(6,2)
bag_dist: Numeric(7,3)
bag_thc: Numeric(7,3)
bag_co: Numeric(8,3)
bag_co2: Numeric(8,3)
bagjemp: Numeric(5,1)
bag_nox: Numeric(7,3)
bag_mpg: Numeric(6,2)
modejd: Character(IO) (FK)
measjd: Character(IO) (FK)
resultid: Numeric(8) (FK)
modemeas: Numeric(10,3)
modejd: Character(10) (FK)
resultid: Numeric(8) (FK)
modesecs: Numeric(4)
rep_cjhc: Numeric(4)
rep_c_co: Numeric(6,2)
rep_c_co2: Numeric(6,2)
rep_c_no: Numeric(4)
rep_c_nou: Numeric(4)
rep_rpm: Numeric(4)
rep_speed: Numeric(6,2)
-28-
-------
EFTOP10 - Display! / Engine Testing
Mobile Source Observation Database - Implementation
Portions Relevant to Engine Testing
January 3, 2000
msjd: Character(17)
evapjam: Character(12)
engjam: Character(19)
vehclass: Character(5)
model_yr: Numeric(4)
make: Character(12)
model_name: Character(20)
overdrive: Character(3)
tran_type: Character(6)
creeper: Character^)
lockup: Character(S)
gears: Character^)
gvwr: Numeric(6)
curbweight: Numeric(6)
ac: Character^)
bld_date: Date
thcstd: Numeric(6,3)
nmhcstd: Numeric(6,3)
costd: Numeric(6,3)
noxstd: Numeric(6,3)
thcestd: Numeric(6,3)
pmstd: Numeric(6,3)
nmhcestd: Numeric(6,3)
evapstd: Numeric(6,3)
fijeltanks:Numeric(1)
tank_cap: Numeric(S)
canister: Character(10)
egr: Character(S)
city_fe: Numeric(2)
hway_fe: Numeric(2)
drv_trn: Character(4)
modelsize: Character(IO)
axle_ratio: Numeric(5,2)
standards: Character(6)
engmount: Character(10)
purpose: Character(IOO)
sec: Character(14)
rnsjd: Character^ 7)
msjype: Numeric(2)
except: Character^)
ex_comm: Character(20)
fueltype: Character^)
company: Character(12)
highway: Character(S)
disp_cid: Numeric(4)
dispjiter: Numeric(4,1)
fuel_deliv: Character(6)
Venturis: Numeric(2)
fi_type: Character^)
aspirated: Character(7)
var_vent: Character(3)
cylinder: Numeric(2)
airjnj: Character(S)
cat_type: Character(4)
closedloop: Character(3)
ignition: Character^)
e^
msjd: Character(17)
camefrom: Character(17)
engseries: Character(20)
eng_fam: Character(19)
eng_class: Character^)
bld_date: Date
eng_mod_yr: Numeric(4)
cooling: Character(7)
fi_meth: Character(4)
injectors: Numeric(l)
fi_press: Numeric(S)
rate_shape: Character(S)
maxadvance: Numeric(5,2)
maxretard: Numeric(5,2)
egr_type: Character(6)
airfuel: Character(4)
parttrap: Character(S)
eng_cycle: Character(l)
ratedpower: Numeric(7,1)
ratedspeed: Numeric(S)
idle_rpm: Numeric(S)
tech_confg: Character(SO)
pump_type: Character(50)
ecs_descpt: Character(50)
elect_cont: Character(100)
veh_no: Numeric(S)
vehjane: Numeric(S)
procmeth: Character(IO)
fixes: Numeric(2)
recruit_no: Character(15)
proc_odom: Numeric(6)
fijel_pb: Numeric(6,3)
plumbjest: Character(4)
tankneck: Character(4)
rep_time: Numeric(4)
ecmptime: Numeric(4)
conpart: Numeric(4)
twypart: Numeric(4)
statetest: Character(S)
im240_pf: Character(4)
purge: Character(7)
pressure: Character(7)
proc_match: Character(7)
tiresize: Character(11)
tire_mfr: Character(10)
lf_psi: Numeric(2)
rf_psi: Numeric(2)
lr_psi: Numeric(2)
n^_psi: Numeric(2)
1psi_spec: Numeric(2)
npsi_spec: Numeric(2)
lf_wear: Character(4)
rf_wear: Character(4)
cuthc:Numeric(5,2)
cutco: Numeric(6,2)
cutnox: Numeric(5,2)
cutpoints: Numeric(2)
hour_meter: Numeric(6)
rebuild_ct: Numeric(2)
rebuild_dt: Date
rebuildwhy: Characterise)
modife: Character(100)
resultid: Numeric(8)
test_proc: Character(S)
wajd: Character(10)
schedjd: Character(6)
cause: Numeric(8)
prev_rep: Numeric(8)
next_rep: Numeric(8)
resultgrp: Numeric(8)
ms_type: Numeric(2)
ms_id:Character(17)
res_kind: Characters)
fueljd: Numeric(S)
test_date: Date
testjod: Character(S)
site:Character(12)
nom_temp: Numeric(S)
nom_humid: Numeric(S)
disable: Numeric(S)
ctr_tst_id: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22)
protojd: Numeric(S)
test_modif: Numeric(2)
!= = =. Jl
1
E ^
Mumeric(8) - REPAIR c,,c,^uc.7
,
ENGINMAP
resultid: Numeric(8)
modename: Character(10)
measjd: Character(IO)
resultid: Numeric(8)
usesmap: Numeric(8)
p_ch4: Numeric(7,2)
p_thc: Numeric(7,2)
p_co: Numeric(7,2)
p_co2:Numeric(7,2)
p_nox: Numeric(7,2)
p_pm: Numeric(7,2)
total_work: Numeric(7,2)
bsfc_meas: Numeric(9,4)
bsfc_calc: Numeric(9,4)
et_baro: Numeric(5,2)
et_humid:Numeric(5,2)
etjnair: Numeric(5,1)
et_exrestr: Numeric(5,2)
et_exhaust: Numeric(5,1)
et_cooler: Numeric(5,1)
et_coolin: Numeric(5,1)
et_coolout: Numeric(5,1)
et_chiller: Numeric(5,1)
resultid: Numeric(S)
modename: Character(IO)
rpm: Numeric(4)
torque: Numeric(4)
bhp: Numeric(S)
r_ch4_gph: Numeric(7,2)
r_thc_gph:Numeric(7,2)
r_co_gph: Numeric(7,2)
r_co2_gph: Numeric(9,2)
r_nox_gph: Numeric(7,2)
r_pm_gph: Numeric(7,2)
fc_meas: Numeric(6,2)
fc_calc: Numeric(6,2)
etm_baro: Numeric(5,2)
etm_humid: Numeric(5,2)
etmjnair: Numeric(5,1)
etmexrestr: Numeric(5,2)
etmexhaust: Numeric(5,1)
etm_cooler: Numeric(5,1)
etm_coolin: Numeric(5,1)
etmcoolout: Numeric(5,1)
etmchiller: Numeric(5,1)
resultid: Numeric(S)
mapjpm: Numeric(S)
map Jerque: Numeric(4)
-29-
-------
EFTOP10 - Display! / Running Loss
Mobile Source Observation Database - Implementation
Running Loss Emission Test Result Subtype
January 3, 2000
RESULT
resultid: Numeric(8)
test_proc: Character(S)
wajd: Character(IO)
schedjd: Character(6)
cause: Numeric(8)
prev_rep: Numeric(8)
next_rep: Numeric(8)
resultgrp: Numeric(8)
msjype: Numeric(2)
msjd: Character(17)
res_kind: Character(S)
fuel_id: Numeric(3)
test_date: Date
testjod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(3)
disable: Numeric(3)
ctr_tst_id: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22)
protojd: Numeric(3)
test_modif: Numeric(2)
RUNLOSS
resultid: Numeric(8)
testwght: Numeric(6)
road_hp: Numeric(5,1)
ac_hp: Character(3)
dynotype: Character(IO)
odometer: Numeric(6)
precond: Character(IO)
tarcanwght: Numeric(4)
norcanwght: Numeric(4)
endcanwght: Numeric(4)
targiftemp: Numeric(3)
obsiftemp: Numeric(3)
n
RUNL BAG
DYNO BAG
resultid: Numeric(8)
bag_num: Numeric(2)
w_runl_thc: Numeric(7,2)
targ_ftemp: Numeric(3)
obs_ftemp: Numeric(3)
tank_press: Numeric(5,1)
purg flow: Numeric(7,1)
resultid: Numeric(8)
bag_num: Numeric(2)
bag_baro: Numeric(5,2)
bag_humid: Numeric(6,2)
bag_dist: Numeric(7,3)
bagjhc: Numeric(7,3)
bag_co: Numeric(8,3)
bag_co2: Numeric(8,3)
bag_temp: Numeric(5,1)
bag_nox: Numeric(7,3)
bag_mpg: Numeric(6,2)
BAG MEAS
measjd: Character(IO)
resultid: Numeric(8)
bag_num: Numeric(2)
bag_meas: Numeric(10,3)
MEASTYPE
meas_id: Character(IO)
meas_descr: uharacter(50)
meas_unit: Character(30)
-30-
-------
EFTOP10 - Display! / Evaporative Result Subtype
Mobile Source Observation Database - Implementation
Evaporative Emission Result Subtype
RESULT
January 3, 2000
resultid: Numeric(8)
test_proc: Character(S) (FK)
wajd: Character(IO) (FK)
schedjd: Character(6) (FK)
cause: Numeric(8) (FK)
prev_rep: Numeric(8) (FK)
next_rep: Numeric(8) (FK)
resultgrp: Numeric(8) (FK)
ms_type: Numeric(2) (FK)
msjd: Character(17) (FK)
res_kind: Character(S)
fueljd: Numeric(3) (FK)
test_date: Date
testjod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(3)
disable: Numeric(3)
ctrjstjd: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22) (AK.1)
protojd: Numeric(3) (FK)
test_modif: Numeric(2)
EVAPTEST
TESTMEAS
MEASTYPE
resultid: Numeric(8) (FK)
w_evap_thc: Numeric(6,2)
precond: Character(IO)
rmeas id: Character(IO) (FK)
resultid: Numeric(8) (FK)
measure: Numeric(10,3)
it>
nil
measjd: Character(IO)
meas_descr: Character(SO)
meas_unit: Character(SO)
EVAPTIME
(.1
/K
evapmins: Numeric(5)
resultid: Numeric(8) (FK)
evap_barom: Numeric(5,2)
shed_temp: Numeric(5,1)
fuel_temp: Numeric(5,1)
w_cum_thc: Numeric(6,2)
-31-
-------
EFTOP10 -- Display"! / roadtest
Mobile Source Observation Database - Implementation
On-Road Exhaust Emission Test Result Subtype
January 3, 2000
RESULT
resultid: Numeric(8)
test_proc: Character(S)
wajd: Character(10)
schedjd: Character(6)
cause: Numeric(8)
prev_rep: Numeric(8)
next_rep: Numeric(8)
resultgrp: Numeric(8)
ms_type: Numeric(2)
msjd: Character(17)
res_kind: Character(S)
fueljd: Numeric(3)
test_date: Date
testjod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(3)
disable: Numeric(3)
ctrjstjd: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22)
protojd: Numeric(3)
test_modif: Numeric(2)
0-
ROADTEST
resultid: Numeric(8)
route: Character(12)
instrsys: Character(12)
actweight: Numeric(6)
avg_temp: Numeric(5,1)
avg_humid: Numeric(6,2)
avg_baro: Numeric(5,2)
odometer: Numeric(6)
precond: Character(IO)
timeonroad: Numeric(6)
distance: Numeric(7,3)
totalwork: Numeric(8,2)
gallons: Numeric(6,3)
wjhc: Numeric(10,3)
w_co: Numeric(9,3)
w_co2: Numeric(10,3)
w_o2: Numeric(10,3)
w_no: Numeric(9,3)
ROADPHAS
resultid: Numeric(8)
phase_no: Numeric(1)
start_emis: Character(S)
veh_state: Character(S)
avg_temp: Numeric(5,1)
avg_humid: Numeric(6,2)
avg_baro: Numeric(5,2)
timeonroad: Numeric(6)
totalwork: Numeric(8,2)
distance: Numeric(7,3)
gallons: Numeric(6,3)
wjhc: Numeric(10,3)
w_co: Numeric(9,3)
w_co2: Numeric(10,3)
w_o2: Numeric(10,3)
w_no: Numeric(9,3)
t
ROADTIME
resultid: Numeric(S)
roadsecs: Numeric(6)
phase_no: Numeric(1)
roadspeed: Numeric(6,2)
enginerpm: Numeric(4)
roadtorque: Numeric(4)
roadtemp: Numeric(5,2)
r_thc: Numeric(7,5)
r_co: Numeric(6,4)
r_no: Numeric(6,4)
r_co2: Numeric(6,3)
r_o2: Numeric(6,3)
-32-
-------
EFTOP10 - Display! / Inspection
Mobile Source Observation Database - Implementation
Emission Component Inspection Result Subtype
January 3, 2000
RESULT
resultid: Numeric(8)
test_proc: Character(S) (FK)
wajd: Character(IO) (FK)
schedjd: Character(6) (FK)
cause: Numeric(8) (FK)
prev_rep: Numeric(8) (FK)
next_rep: Numeric(8) (FK)
resultgrp: Numeric(8) (FK)
ms_type: Numeric(2) (FK)
msjd: Character(17) (FK)
res_kind: Character(S)
fueljd: Numeric(3) (FK)
test_date: Date
testjod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(3)
disable: Numeric(3)
ctr_tst_id: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: Character(22) (AK.1)
proto_id: Numeric(3) (FK)
test_modif: Numeric(2)
INSPECT
resultid: Numeric(8) (FK)
comments: Character(254)
comments2: Character(254)
insp_odom: Numeric(6)
g_can_init: Numeric(7,1)
g_can_purg: Numeric(7,1)
g_can_ioad: Numeric(7,1)
S INSP
r
P INSP
PC INSP
system: Character(12) (FK)
resultid: Numeric(S) (FK)
system_sta: Character(4)
'part:Character(4)(FK) li
resultid: Numeric(S) (FK) I
part_stat: Character(4) P
>
f
SYSTEM
PART
part: Character(4) (FK)
part code: Numeric(2) (FK)
resultid: Numeric(S) (FK)
I
J
J
system: Character(12) (AK.1)
system_d: Character(SO)
old_syst: Character(S)
part: Character(4)
system: Character(12) (FK)
part_d: Character(SO)
PARTCODE
part_code: Numeric(2)
part: Character(4) (FK)
partcode_d: Character(60)
-33-
-------
EFTOP10-Display! /obdscan
Mobile Source Observation Database - Implementation
On Board Diagnostic Scan Result Subtype
January 3, 2000
SCANSYS1
resultid: Numeric(8)
obdlcode: Numeric(3)
obdldescr: Character(SO)
RESULT
resultid: Numeric(8)
test_proc: Character(S)
wajd: Character(IO)
schedjd: Character(6)
cause: Numeric(8)
prev_rep: Numeric(8)
next_rep: Numeric(8)
resultgrp: Numeric(8)
ms_type: Numeric(2)
msjd: Character(17)
res_kind: Character(S)
fueljd: Numeric(3)
test_date: Date
testjod: Character(S)
site: Character(12)
nom_temp: Numeric(3)
nom_humid: Numeric(3)
disable: Numeric(3)
ctrjstjd: Character(12)
No_bags: Numeric(2)
No_modes: Numeric(2)
old_rkey: character(22)
protojd: Nilimeric(3)
test_modif: Numeric(2)
OBDSCAN
resultid: Numeric(8)
comment: Character(254)
obd_odom: Numeric(6)
obdlevel: Numeric(1)
SCANSYS2
II
7\\
resultid: Numeric(S)
obd2code: Character(S)
OBD2CODE
obd2code: Character(S)
obd2code_d: Character(SO)
Note: This table is not yet populated.
-34-
-------
EFTOP10 - Display! / Miscellaneous Result Subtypes
Mobile Source Observation Database - Implementation
Miscellaneous Result Subtypes
January 3, 2000
RESULT
PROCURE
resultid: Numeric(S) (FK)
veh_no: Numeric(5)
veh_lane: Numeric(5)
procmeth: Character(IO)
fixes: Numeric(2)
recruit_no: Character(15)
proc_odom: Numeric(6)
fuel_pb: Numeric(6,3)
plumbjBst Character(4)
tankneck: Character(4)
rep_time: Numeric(4)
ecmptime: Numeric(4)
conpart: Numeric(4)
twypart: Numeric(4)
statetest: Character(S)
im240_pf: Character(4)
purge: Character(7)
pressure: Character(7)
proc_match: Character(7)
tiresize: Character(11)
tire_mfr: Character(IO)
lf_psi: Numeric(2)
rf_psi: Numeric(2)
lr_psi: Numeric(2)
rr_psi: Numeric(2)
fpsi_spec: Numeric(2)
rpsi_spec: Numeric(2)
lf_wear: Character(4)
rf_wear: Character(4)
cuthc: Numeric(5,2)
cutco: Numeric(6,2)
cutnox: Numeric(5,2)
outpoints: Numeric(2)
hour_meter: Numeric(6)
rebuild_ct: Numeric(2)
rebuild_dt: Date
rebuildwhy: Character(SO)
modifs: Character(IOO)
resultid: Numeric(S)
test proc: Character(5) (FK)
wa id: Character(IO) (FK)
sched_id: Character(6) (FK)
cause: Numeric(S) (FK)
prev rep: Numerc(8) (FK)
next_rep: Numeric(S) (FK)
resultgrp: Numeric(S) (FK)
ms type: Numeric(2) (FK)
ms_id: Character(17) (FK)
res kind: Character(S)
fuel id: Numeric(S) (FK)
test_date: Date
test tod: Character(5)
site:Character(12)
nom_temp: Numeric(3)
nom humid: Numerc(3)
disable: Numeric(S)
ctr_tst_id: Character(12)
No_bags: Numeric(2)
No modes: Numerc(2)
old rkey:Character(22)(AK.1)
protojd: Numeric(S) (FK)
test_modif: Numeric(2)
-0
pRESSTST
resultid: Numeric(S) (FK)
fuel_cap: Character(S)
capokstant: Character(S)
filler_ok: Characters)
canist:conCharacte3,
press_1min: Numeric(4,1)
press_2min: Numeric(4,1)
comment: Character(SO)
press_odonr Numeric(6)
presstat Character(15)
REPAIR
FUELCHEM
ROADTRIP
resultid- Numeric(8) (FK)
repa^dom:Nume,
resultid: Numenc(8) (FK)
meas id: Character(IO) (FK)
MEASTYPE
1 fr-
meas-id: Character(IO)
meas_descr: Character(50)
meas_unit: Character(SO)
meas id: Character(IO) (FK)
resultid: Numeric(S) (FK)
measure: Numeric(10,3)
resultid: Numeric(S) (FK)
timeonroad: Numeric(6)
distance: Numeric(7,3)
idle: Numeric(5,1)
per_0mph: Numeric(5,1)
per_5mph: Numeric(5,1)
per_10mph: Numeric(5,1)
per_15mph: Numeric(5,1)
per_20mph: Numeric(5,1)
per_25mph: Numeric(5,1)
per_30mph: Numeric(5,1)
per_35mph: Numeric(5,1)
per_40mph: Numeric(5,1)
per_45mph: Numeric(5,1)
per_50mph: Numeric(5,1)
per_55mph: Numeric(5,1)
per_60mph: Numeric(5,1)
per_65mph: Numeric(5,1)
per_70mph: Numeric(5,1)
per_75mph: Numeric(5,1)
per_80mph: Numeric(5,1)
ac_time: Numeric(6)
comp_time: Numeric(6)
temp: Numeric(5,1)
humidity: Numeric(6,2)
rel_humid: Numeric(5,1)
heat index: Nur
-35-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
attribute definition report
Entity Name
BAG MEAS
DYNO BAG
DYNOMODE
DYNORATE
DYNOTEST
Entity Attribute Name
bag_meas
bag_num
measjd
resultid
bag baro
bag_co
bag_co2
bag_dist
bag_humid
bag_mpg
bag_nox
bag_num
bag_temp
bag_thc
resultid
C CO
c co2
c_no
c nou
c the
mode_baro
mode_hp
mode_humid
mode id
mode_temp
resultid
rpm
baro
duration
humid
modeid
rate co
rate co2
rate_nox
rate the
resultid
temp
ac_hp
CO
co2
dynotype
Entity Attribute Definition
Bag-level measurement.
Bag number.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Barometric pressure. Expressed in inches of mercury.
Carbon monoxide emissions.Expressed in grams per mile.
Carbon dioxide emissions.Expressed in grams per mile.
Distance travelled. Expressed in miles.
Humidity. Expressed in grains of water per pound of dry air.
Fuel economy. Expressed in miles per gallon.
Emissions of oxides of nitrogen. Expressed in grams per mile.
Bag number.
Temperature, Expressed in degrees Fahrenheit.
Total hydocarbon emissions. Expressed in grams per mile.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Carbon monixide concentration. Expressed in percent.
Carbon dioxide concentration. Expressed in percent.
NO concentration. Expressed in parts per million. Corrected for humidity via
humidity correction factor.
NO concentration. Expressed in parts per million. Not corrected for humidity.
Total hydrocarbon concentration. Expressed in parts per million.
Barometric pressure measured during test mode. Expressed in inches of
mercury.
Load horsepower.
Humidity measured during test mode. Expressed in grains of water per pound
of dry air.
Mode identification. Legal values defined by MODEJD translation table.
Measured ambient temperature during this test mode. Expressed in degrees
Fahrenheit.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Measured Engine RPM.
Barometric pressure during mode. Expressed in inches of mercury.
Length of test mode in seconds
Absolute humidity. Expressed in grains of water per pound of dry air.
Mode identification. Legal values defined by MODE ID translation table.
Total carbon monoxide emissions during mode. Expressed in grams per hour.
Total carbon dioxide emissions during mode. Expressed in grams per hour.
Total oxides of nitrogen emissions during mode. Expressed in grams per
hour.
Total hydrocarbon emissions during mode, Expressed in grams per hour.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Ambient temperature during mode. Expressed in degrees Fahrenheit.
Did dynamometer road load setting for this test include air conditioning load
factor? YES, NO, or NUL.
Carbon monoxide emissions. Expressed in grams per mile. (Composite bag
result for the entire test)
Carbon dioxide emissions. Expressed in grams per mile. (Composite bag
result for the entire test)
Type of dynomometer used. Legal values defined by DYNOTYPE translation
table.
Rows 1 to 42
-36-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
DYNOTEST
DYNOTIME
EMODMEAS
ENG FAM
ENGINE
Entity Attribute Name
init_baro
init_humid
init_temp
mpg
nox
odometer
precond
resultid
road_hp
test_order
testwght
the
dist
dynosecs
r co
r co2
r nox
r the
resultid
speed
test_phase
w_co
w_co2
w_nox
w_thc
emodmeas
measjd
modename
resultid
eng_fam
airfuel
bid date
camefrom
Entity Attribute Definition
Barometric pressure measured at the beginning of the test. Expressed in
inches of mercury. This will often have the null value of 0 since it was usually
reported at the bag level.
Absolute humidity measured at beginiing of test. Expressed in grains of water
per pound of dry air. Often assumes null value of zero in this table, since it is
often reported at the bag level.
Initial test temperature in degrees F. For bag tests this will often have the null
value of 0, since it is reported at the bag level.
Fuel economy. Expressed in miles per gallon. (Composite bag result for the
entire test)
Oxides of nitrogen emissions. Expressed in grams per mile. (Composite bag
result for the entire test)
Approximate odometer reading of vehicle at beginning of test. Expressed in
miles.
Type of preconditioning performed on the vehicle prior to the test. Legal
values defined by PRECOND translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Dynamometer road load horsepower setting used for this test.
A specialized field used to date only for facility cycle testing. Indicates the
numerical position of individual tests in a sequence of tests run. Value of zero
represents NULL.
Dynamometer inertia weight setting used for this test. Expressed in pounds.
Total hydocarbon emissions. Expressed in grams per mile . (Composite bag
result for the entire test)
Distance travelled in miles, cumulative from beginning of test phase.
Time within dynomometertest, expressed in seconds, beginning of test has
dynosecs = 0.
Carbon monoxide emissions measurment. Expressed in grams per second.
Carbon dioxide emissions measurment. Expressed in grams per second.
Oxides of nitrogen emissions measurement. Expressed in grams per sec.
Total hydocarbon emissions measurment. Expressed in grams per second.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Measured speed in miles per hour.
Phase of the test to which this measurement belongs. This might be used for
example to divide a repeated measurement test into time periods
corresponding to bag samples, even though no bag samples were taken.
Carbon monoxide emissions emitted up to this time in the test phase.
Expressed in grams.
Carbon dioxide emissions up to this time of the test phase. Expressed in
grams.
Oxides of nitrogen, emitted up to this time in the test phase. Expressed in
grams.
Total hydorcarbon emissions emitted up to this time in the test phase.
Expressed in grams.
Engine test mode level measurement of this MEASJD
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Name of engine test mode. Based on its reference speed, speed fraction,
and load fraction. Legal values defined by ENGMODE translation table
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Exhaust emission certification family to which this vehicle belongs.
Air fuel mixture method. Values defined by AIRFUEL translation table.
Approximate date engine was manufactured.
Mobile source identifier. For vehicles their VIN would be used. For
engines, their serial number, probably in conjunction with their manufacturer
code.
Rows 43 to 75
-37-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
ENGINE
ENGINMAP
ENGMODE
Entity Attribute Name
cooling
ecs_descpt
egrjype
elect cont
eng_class
eng_cycle
eng_fam
eng_mod_yr
engseries
fi meth
fi_press
idle_rpm
injectors
maxadvance
maxretard
msjd
ms_type
parttrap
pumpjype
rate_shape
ratedpower
ratedspeed
tech_confg
baro
chiller
coolant in
coolantout
cooler out
exhaust
exrestrict
gov_speed
humidity
inlet air
maptype
maxtorque
msdrtdpwr
msdrtdsped
msdtrqsped
resultid
load_frac
modeSnum
modeSwght
Entity Attribute Definition
Type of after cooling. Legal values defined by COOLING translation table.
Desscription of emission control system.
Type of exhaust gas recirculation (EGR). Values defined by EGR_TYPE
translation table.
Description of electronic control.
Intended engine service class. (In conjunction with engine type (SI or Cl),
and model year, this field allows determination of the emission standards to
which many engines were certified; for small spark ignition engines,
displacement class, which can be determined from displacement, may be
used instead.) Legal values defined ENG CLAS by translation table.
Engine cycle. Legal values defined by ENG CYCL translation table.
Engine family for emission certification purposes. A value of "NONE"
indicates the engine does not belong to an engine family, which in turn means
that it was not certified.
Engine model year.
Engine series or product line name.
Method of fuel injection. Legal values defined by FIJV1ETH translation table.
Fuel injection pressure. Expressed in kpa.
Idle rpm as declared by the oem.
Number of injectors per cylinder.
Maximum advance Expressed in degrees.
Maximum retard. Expressed in degrees.
Mobile source identifier. For vehicles their VIN would be used. For
engines, their serial number, probably in conjunction with their manufacturer
code.
General kind of mobile source:
1 = Vehicle
2 = Engine.
Is particulate trap used? "YES", "NO", or "NUL".
Type of fuel pump. (Not categorized.)
Is rate shaping used? "YES", "NO", or "NUL"
Rated horsepower of engine.
Rated rpm of engine.
Description of technical configuration. (Not categorized.)
Barometric pressure. Expressed in inches of mercury.
Chiller water temperature. Expressed in degrees F.
Engine coolant input temperature. Expressed in degrees F.
Engine coolant output temperature. Expressed in degrees F.
Air temperature after intercooler. Expressed in degrees F.
Exhaust temperature, after emission controls. Expressed in degrees F.
Exhaust restriction pressure. Expressed in inches of mercury.
Governed central speed (rpm)
Absolute humidity. Expressed in grains of water per pound of dry air.
Engine inlet air temperature. Expressed in degrees F.
Type of Engine Map. Legal values defined by MAPTYPE translation table.
Measured peak torque. Expressed in foot pounds
Measured rated horsepower.
Measured rated speed (rpm)
Measured torque speed. Expressed in rpm.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Fraction of the mapped load at this engine speed at which this mode is run.
Expressed as a percentage.
Identifies which of the 8 modes of the heavy-duty engine certification test
corresponds to this mode. Contains 0 if mode is not part of 8 mode
certification test.
If mode is included in the 8 mode certification test, contains the weighting
factor used to calculate the summary result. Expressed as a percentage.
The 8 percentages add to 1 00.
Contains 0 if mode is not included in the 8 mode test.
Rows 76 to 117
-38-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
ENGMODE
ENGTEST
ETSTMODE
Entity Attribute Name
modedur
modename
modenum
refspeed
speed_frac
bsfc calc
bsfc meas
et_baro
et_chiller
et_cooler
et_coolin
et_coolout
et_exhaust
et_exrestr
et_humid
et_inair
p_ch4
p_co
p_co2
p_nox
p_pm
p_thc
resultid
total work
usesmap
bhp
etm_baro
etm cooler
etm coolin
etm_humid
etm inair
etmchiller
etmcoolout
etmexhaust
etmexrestr
fc calc
fc meas
modename
r_ch4_gph
Entity Attribute Definition
Minimum duration of the mode. Expressed in seconds.
Name of engine test mode. Based on its reference speed, speed fraction,
and load fraction. Legal values defined by ENGMODE translation table
Mode number. Added for convenience, e.g. to facilitate exporting data to
software such as SAS which expects keys to be numeric. Should be
considered an arbitrary number, but the first 28 modes are numbered as in
SWRI work assignment 2-2.
Reference speed. Identifies which of several speeds the speed aspect of the
mode is based on. Legal values defined by REFSPEED translation table.
Fraction of the reference speed at which this mode is run. Expressed as a
percentage.
Calculated brake-specific fuel consumption. Expressed in grams per bhp-hr.
Measured brake-specific fuel consumption. Expressed in grams per bhp-hr.
Average barometric pressure during test. Expressed in inches of Hg. Not
meaningful for multi-mode steady-state tests.
Chiller water temperature. Expressed in degrees F. Not meaningful for
multi-mode steady-state tests.
Air temperature after intercooler. Expressed in degrees F. Not meaningful for
multi-mode steady-state tests.
Engine coolant input temperature. Expressed in degrees F. Not meaningful
for multi-mode steady-state tests.
Engine coolant output temperature. Expressed in degrees F. Not meaningful
for multi-mode steady-state tests.
Exhaust temperature, after emission controls. Expressed in degrees F. Not
meaningful for multi-mode steady-state tests.
Exhaust restriction pressure. Expressed in inches of mercury. Not meaningful
for multi-mode steady-state tests.
Average absolute humidity during test. Expressed in grains of water per
pound of dry air. Not meaningful for multi-mode steady-state tests.
Engine inlet air temperature. Expressed in degrees F. Not meaningful for
multi-mode steady-state tests.
Methane emissions. Expressed in grams per bhp-hr.
CO emissions. Expressed in grams per bhp-hr.
CO2 emissions. Expressed in grams per bhp-hr.
NOx emissions. Expressed in grams per bhp-hr.
Total particulate emissions. Expressed in grams per bhp-hr.
Total HC emissions. Expressed in grams per bhp-hr.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Total work performed in test. Expressed in bhp-hrs.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Brake horsepower.
Average barometric pressure during engine test mode. Expressed in inches of
Hg.
Air temperature after intercooler. Expressed in degrees F.
Engine coolant input temperature. Expressed in degrees F.
Average absolute humidity during engine test mode. Expressed in grains of
water per pound of dry air.
Engine inlet air temperature. Expressed in degrees F.
Chiller water temperature. Expressed in degrees F.
Engine coolant output temperature. Expressed in degrees F.
Exhaust temperature, after emission controls. Expressed in degrees F.
Exhaust restriction pressure. Expressed in inches of Hg.
Calculated fuel consumption. Expressed in kg per hour.
Measured fuel consumption. Expressed in kg. per hour.
Name of engine test mode. Based on its reference speed, speed fraction,
and load fraction. Legal values defined by ENGMODE translation table
Methane emission rate. Expressed in grams per hour.
Rows 118 to 156
-39-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
ETSTMODE
EVAP FAM
EVAPSTAN
EVAPTEST
EVAPTIME
EXSTSTAN
Entity Attribute Name
r co2 gph
r_co_gph
r_nox_gph
r_pm_gph
r_thc_gph
resultid
rpm
torque
evap_fam
esfueltype
evap_emiss
evap_fam
sales_area
standard
tier
usefullife
precond
resultid
w_evap_thc
evap barom
evapmins
fuel_temp
resultid
shed_temp
w cum the
cert inuse
eng_fam
esfueltype
exst_emiss
sales_area
Entity Attribute Definition
Carbon dioxide emission rate. Expressed in grams per hour.
Carbon monoxide emission rate. Expressed in grams per hour.
Oxides of nitrogen emission rate. Expressed in grams per hour.
Total particulate emission rate. Expressed in grams per hour.
Total hydrocarbon emission rate. Expressed in grams per hour.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Measured engine rpm.
Measured torque. Expressed in foot-pounds.
EPA standardized evaporative family name as defined in CFR40 Part 86
Emission standards fuel type code. Values are defined in the CFEIS
Manufacturers' User Guide (CMUG), Appendix D (Input data records),
Evaporative/Refueling Systems Information.
Evaporative emission name. Values are defined in the CFEIS Manufacturers'
User Guide (CMUG), Appendix D (Input data records), Evaporative/refueling
Systems Information.
Warning: Some emission names also embody information about the test
procedure used to measure the emission.
EPA standardized evaporative family name as defined in CFR40 Part 86
Sales area code. Values are defined in the CFEIS Manufacturers' User Guide
(CMUG), Appendix D (Input data records), Evaporative/Refueling Systems
Information.
Warning 1 : Name of this attribute is somewhat misleading since not all values
represent an "area" in a geographic sense. Concepts of authority (e.g.
California vs US.) and emission level (e.g. NLEV or Clean fuel) partially
determine the domain.
Warning 2: Some domain values represent combinations of others.
Numerical emission standard.
Warning: Engineering units vary among standard instances and are not
defined in CMUG.
Tier code. Values are defined in the CFEIS Manufacturers' User Guide
(CMUG), Appendix D (Input data records), Engine Systems Information.
Useful life. Expressed as a three digit number, in character form,
representing thousands of miles or "N/A"
Type of preconditioning. Values defined by PRECOND translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Total hydrocarbon emissions of test. Expressed in grams.
Barometric pressure. Expressed in inches of Hg.
Time of measurment. Expressed in minutes after start of test.
Temperature of vehicle's fuel. Expressed in degrees F.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Temperature of SHED or air surrounding vehicle. Expressed in degrees F.
Cumulative hydrocarbon emissions, since start of test. Expressed in grams.
Indicates whether standard is a "certification" (C) or "in-use" (I) standard.
Exhaust emission certification family to which this vehicle belongs.
Emission standards fuel type code. Values are defined in the CFEIS
Manufacturers' User Guide (CMUG), Appendix D (Input data records), Engine
Systems Information.
Exhaust emission name. Values are defined in the CFEIS Manufacturers'
User Guide (CMUG), Appendix D (Input data records), Engine Systems
Information.
Warning: Some emission names also embody information about the test
procedure used to measure the emission.
Sales area code. Values are defined in the CFEIS Manufacturers' User Guide
(CMUG), Appendix D (Input data records), Engine Systems Information.
Warning 1 : Name of this attribute is somewhat misleading since not all values
represent an "area" in a geographic sense. Concepts of authority (e.g.
California vs US.) and emission level (e.g. NLEV or Clean fuel) partially
determine the domain.
Rows 157 to 185
-40-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
FUEL
FUELCHEM
INSPECT
KIND OF RESULT
M_SOURCE
Entity Attribute Name
standard
tier
usefullife
fueljd
fuelname
oxygenate
rvp
sulferhigh
sulferlow
wtoxygen
fuelmeas
measjd
resultid
comments
comments2
g_can_init
g_can_load
g_can_purg
insp_odom
resultid
airjnj
aspirated
cat_type
closedloop
company
cylinder
disp_cid
dispjiter
ex comm
except
fijype
Entity Attribute Definition
Warning 2: Some domain values represent combinations of others.
Numerical emission standard.
Warning: Engineering units vary among standard instances and are not
defined in CMUG.
Tier code. Values are defined in the CFEIS Manufacturers' User Guide
(CMUG), Appendix D (Input data records), Engine Systems Information.
Useful life. Expressed as a three digit number, in character form,
representing thousands of miles or "N/A"
Numeric code uniquely identifying the general type of fuel used. Sometimes
referred to as the "gross fuel type".
Name of fuel.
Oxygen enriched chemical.
Nominal vapor pressure of this kind of fuel.
Upper bound sulfer content specification. Expressed in parts per million.
Lower bound sulfer content specification. Expressed in parts per million.
Weight of oxygen in this type of fuel.
Test level fuel measurement.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Inspection comments, first portion.
Inspection comments, second portion.
Weight of evaporative emission canister as vehicle was received. Expressed
in grams. If vehicle has multiple canisters weight entered is total of all
canisters present. Zero if null.
Weight of evaporative emission canister after full loading. Expressed in
grams. If vehicle has multiple canisters weight entered is total of all canisters
present. Zero if null.
Weight of evaporative emission canister after canister purge. Expressed in
grams. If vehicle has multiple canisters weight entered is total of all canisters
present. Zero if null.
Approximate odometer reading, in miles, at time of mechanics M1 emission
component inspection. Zero represents NULL. (This item not collected prior
to FY98).
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Represents what method, if any, is used to introduce supplemental air into the
exhaust stream. Legal values defined by AIRJNJ translation table.
Indicates how engine is aspirated. Legal values defined by ASPIRATE
translation table.
What type catalyst, if any, is present on the mobile source. Legal values
defined by CAT TYPE translation table.
"YES" indicates a "closed loop" configuration in which the exhaust sensing is
used to help control the fuel combustion process. "No means this is not done
on the vehicle.
Mobile source manufacturer. Is designed to align with the MFR_ fields in
CFEIS. Has extended translation table in which COMPANY_N will contain the
same numeric code as CFEIS for this manufacturer. Legal values defined by
COMPANY translation table. NONROAD manufacturers will also be included
in the COMPANY table.
Number of cylinders or rotors.
Nominal Engine displacement. Expressed in cubic inches.
Nominal engine displacement. Expressed in liters.
Used if except is true. Comment as to why vehicle is exceptional.
YES if something is exceptional about this mobile source that would make it
an outlier for most analysis, (e.g. engine has been replaced, etc.)
Type of fuel injection. Legal values defined by FI_TYPE translation table.
Rows 186 to 218
-41-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
M_SOURCE
MAPPOINT
MEASTYPE
MODEMEAS
MODETIME
OBD2CODE
OBDSCAN
Entity Attribute Name
fuel_deliv
fueltype
highway
ignition
msjd
ms_type
var_vent
Venturis
map_rpm
map_torque
resultid
meas descr
measjd
meas unit
measjd
mode id
modemeas
resultid
mode id
mode_speed
modesecs
rep_c_co
rep_c_co2
rep_c_no
rep_c_nou
rep_c_thc
rep_rpm
resultid
obd2code
obd2code d
comment
obd_odom
obdlevel
Entity Attribute Definition
Kind of fuel delivery system. Legal values defined by FUEL_DEL translation
table.
Type of fuel mobile source is designed to use. Legal values defined by
FUELTYPE translation table.
Yes if mobile source is intended for highway use. No for non-road mobile
sources.
Ignition type of engine in mobile source. Legal values defined by IGNITION
translation table.
Mobile source identifier. For vehicles their VIN would be used. For
engines, their serial number, probably in conjunction with their manufacturer
code.
General kind of mobile source:
1 = Vehicle
2 = Engine.
YES if size of carburator Venturis is designed to vary. Otherwise NO. (or
NUL).
Intend to convert to a logical type field when good tool is available.
Number of Venturis. Not meaningful for fuel injected mobile sources.
Speed. Expressed in rpm.
Torque. Expressed in foot pounds
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Measurement description.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Engineering units applicable to this measurement type.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Mode identification. Legal values defined by MODEJD translation table.
Mode level measurment of this MEAS ID
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Mode identification. Legal values defined by MODEJD translation table.
Measured speed. Expressed in miles per hour.
Identifies point in time within a Mode of an chassis exhaust emissions test.
Expressed in seconds.
Second-by-second measurement of carbon monoxide concentration.
Expressed as a percentage.
Second-by-second measurement of carbon dioxide concentration. Expressed
as a percentage.
Second-by-second measurement of nitric oxide (NO) concentration, corrected
for humidity. Expressed in parts per million.
Second-by-second measurement of nitric oxide (NO) concentration, not
corrected for humidity. Expressed in parts per million.
Second-by-second measurement of total hydrocarbon concentration.
Expressed in parts per million.
Second-by-second measurement of engine speed. Expressed in revolutions
per minute.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Character string code resulting from a scan of a level 2 on board diagnostic
system.
Meaning of a particular level 2 on board diagnostic code.
Comment associated with scan of vehicle's on board diagnostic system.
Approximate odometer reading, in miles, at time of OBD scan. Zero
represents NULL value.
Type of on board diagnostic system. Level 1 systems are present on many
older vehicles and produce 2 digit numeric codes particular to the vehicle
manufacturer and model year. Level 2 system produce 5 character codes
some of which have industry standardized significance.
Legal values defined by OBDLEVEL translation table.
Rows 219 to 251
-42-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
OBDSCAN
OWNERQST
PJNSP
PART
PARTCODE
PCJNSP
PRESSTST
Entity Attribute Name
resultid
checkjite
drv_type
howjong
im_status
lastjm
liteaction
miles2lab
mpg_dist
new_cat
odom_ok
quest_odom
resultid
survey_mpg
trip2lab
trips
true_miles
part
part_stat
resultid
part
part_d
system
part
part_code
partcode_d
part
part_code
resultid
canhose ok
canist_acc
Entity Attribute Definition
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Response to question: "Has the 'check engine' light or any other warning light
ever come on while you were driving your vehicle?"
Responses are coded as "yes", "no", or "nul"
"Type of driving" as indicated on the fuel economy postcard survey.
Characterized driving during period of fuel purchases as to degree of city
versus highway driving. Legal values defined by DRV_TYPE translation table.
Response to question: "How long ago did you purchase the vehicle to be
tested?" Legal values defined by HOW_LONG translation table.
Response to question: "Did your vehicle pass or fail the inspection?" Legal
values defined by IM STAT translation table.
Response to question: " Date of last city or state emissions inspection?"
{99/99/99} if never inspected.
Response to question: "What did you do after the light came on?" Legal
values defined by LITEACT translation table.
Response to question: "Approximate mileage to get here today?"
Distance, in miles, over which fuel economy was measured in the fuel
economy postcard survey.
Response to question: "Has the catalytic converter ever been replaced on this
vehicle?" Coded as YES, NO, NONE or NULL.
Response to question: "Does the odometer indicate the true number of miles
on your vehicle?" Values coded as YES, NO, or NUL.
Approximate odomoeter reading at time vehicle owner questionnaire was
filled out. Zero if NULL. This item only began to be collected in FY98.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Fuel economy calculated from the fuel economy postcard survey. Expressed
in miles per gallon.
Response to question: "How did you get here today?" Legal values defined by
TRIP2LAB translation table.
Response to question: "On a typical day, how many trips are made with this
vehicle?"
Response to question: "If no, what are the true miles?" (0 indicates missing or
thatODOM OK = YES.)
Identification of emission component
usually a field name from the emission component worksheet e.g. E101.
Status of this emission component part. Legal values defined by PART_STA
translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Identification of emission component
usually a field name from the emission component worksheet e.g. E101.
More full description of the emission component.
Identitifcation of an emission component system.
Identification of emission component
usually a field name from the emission component worksheet e.g. E101.
Numeric code which can be used to describe the status of an emission
component.
Full description of what the part_code means
Identification of emission component
usually a field name from the emission component worksheet e.g. E101.
Numeric code which can be used to describe the status of an emission
component.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Did canister and hose look ok? "YES", "NO", or "NUL".
Was the canister accessible? " YES"," NO", or "NUL".
Rows 252 to 282
-43-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
PRESSTST
PROCURE
Entity Attribute Name
canist con
capokstant
comment
filler ok
fuel_cap
hose_ok
press_1 min
press_2min
pressjnit
press_odom
presstat
resultid
conpart
cutco
cuthc
cutnox
cutpoints
ecmptime
fixes
fpsi_spec
fuel_pb
hour_meter
im240_pf
lf_psi
lf_wear
lr_psi
modifs
plumb_test
pressure
proc_match
Entity Attribute Definition
Was the cannister connected to the fuel tank? "YES", "NO", or "NUL".
Did gas cap pass the Stant test? "YES", "NO", or "NUL".
Comment.
Did filler neck look ok? "YES", "NO", or "NUL".
Fuel cap present? "YES", "NO", or "NUL".
Were the canister hoses ok, in terms of not being frayed? "YES", "NO", or
"NUL".
Pressure reading after one minute. Expressed in inches of water.
Null value is 99. 9.
Pressure reading after two minutes. Expressed in inches of water.
Null value is 99. 9.
Initial pressure reading. Expressed in inches of water.
Approximate odometer reading at time of pressure test. Expressed in miles .
Zero represents NULL value. (This information item was not collected prior to
FY98.)
Indicates whether evaporative system pressure check could be performed
and if not, categorizes reason why. Legal values defined by PRESSTAT
translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Cost of conventional parts in U.S. dollars. If multiple repairs were conducted
this field represents the total cost of these parts.
Recruitment "cut point" or threshold value for carbon monoxide emissions.
Expressed in terms of grams/mile as measured by an IM240 test. Null value
of this field is zero.
Recruitment "cut point" or threshold value for hydocarbon emissions.
Expressed in terms of grams/mile as measured by an IM240 test. Null value
of this field is zero.
Recruitment "cut point" or threshold value for oxides of nitrogen emissions.
Expressed in terms of grams/mile as measured by an IM240 test. Null value
of this field is zero.
Information pertaining to the set of IM240 emission "outpoint" values which
governed this procurement. These emission outpoint levels do not generally
correspond to the emission standards to which the vehicle was certified.
Legal values defined by CUTPOI NT translation table.
Time required to perform the emission components inspections on this
vehicle. Expressed in minutes.
Identifies minor corrections made to the mobile source to enable testing.
These things, such as fixing post catalyst exhaust leaks or brakes would not
be expected to affect emission results, but may affect lab test to l/m lane test
comparability for those vehicles that were tested in l/m lane before being
recruited to the test laboratory. This field was added to the database to
accomodate historical data and is nul (0) for most records. Legal values
defined by FIXES translation table.
Front tire pressure specification. Expressed in pounds per square inch.
Used to represent the lead content of fuel in vehicle tank as received.
Expressed in grams per gallon.
Hours of operation (usually available only for off-road mobile sources). Null
value is Zero.
Indicates whether a recruited vehicle passed or failed an EPA-conducted
IM240 test. Legal values defined by IM240 PF translation table.
Left front tire pressure. Expressed in pounds per square inch.
Left front tire wear description. Legal values defined by LF_WEAR translation
table.
Left rear tire pressure. Expressed in pounds per square inch.
Description of significant post-OEM additions or modifications.
Whether or not lead was detected on the vehicle exhaust tailpipe with
plumbtesmo paper. Values are "PASS", "FAIL", and "NULL"
Results of evaporative system pressure check procedure. Legal values
defined by PRESSURE translation table.
Relationship between originally specified procurment criteria and vehicle
actually recruited. Legal values defined by PROC_MAT translation table.
Rows 283 to 312
-44-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
PROCURE
RATEMEAS
REP_MEAS
REPAIR
Entity Attribute Name
proc_odom
procmeth
purge
rebuild_ct
rebuild dt
rebuildwhy
recruit_no
rep_time
resultid
rf_psi
rf_wear
rpsi_spec
rr_psi
statetest
tankneck
tire mfr
tiresize
twypart
vehjane
veh no
measjd
modeid
ratemeas
resultid
dynosecs
measjd
rep_meas
resultid
comments
comments2
repjype
repar_odom
Entity Attribute Definition
Approximate odometer reading at time of vehicle recruitment. Expressed in
miles.
Procurement method. Legal values defined by PROCMETH translation table.
Contains results of evaporative system purge check procedure. Legal values
defined by PURGE translation table.
Number of times mobile source was rebuilt, generally applicable only to
engines. Null value is 99.
Date of last rebuild.
Purpose or reason for last rebuild.
This field would be rarely used for analysis purposes.
Vehicle recruitment number. Previously known as "Recall_Number" in some
datasets this is the "vehicle recruitment control number" which can be used to
link back to paper record recruitment information outside of this database
such as the recruitment class. In historical data where "Recall Number was
not available" this field will contain the 4 character "vehicle run number"
assigned by the recruitment contractor, which was rarely used.
Time required to perform repairs on this vehicle. Expressed in minutes. If
multiple repairs were performed this represents the total time required.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Right front tire pressure. Expressed in pounds per square inch.
Right front tire wear description. Legal values defined by RF_WEAR
translation table.
Rear tire pressure specification. Expressed in pounds per square inch.
Right read tire pressure. Expressed in pounds per square inch.
Indicates whether the vehicle recruited passed or failed a state IM test. Legal
values defined by STATETES translation table.
Whether the fuel tank inlet restrictor, if present, was damaged. Legal values
defined by translation table. Values are "YES", "NO", "NA" or "NULL".
Tire manufacturer.
Tiresize. Expressed as a character string. There is no translation table for
this field and data may not be well coded.
Cost of three way catalyst parts in U.S. dollars. If multiple repairs were
conducted this field represents the total cost of these parts.
Number historically used to identify procurment of a vehicle from an I/M lane
(as compared with VEH_NO which identified a physical vehicle.) Vehicles
were recruited for a series of tests, typically a purge-pressure, IM240 and
FTP.
Vehicle number historically assigned sequentially by recruitment contractor.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Mode identification. Legal values defined by MODE ID translation table.
Mode level measurment of this MEAS ID
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Time within dynomometertest, expressed in seconds, beginning of test has
dynosecs = 0.
Measurement type identification. Legal values defined by MEASTYPE
translation table.
Repeated measurement.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Repair description - first portion. 50 character field.
Repair description - second portion. 50 character field.
Type of repair performed. Legal values defined by REP_TYPE translation
table.
Approximate odometer reading at time repair was made. Expressed in miles.
Zero represents NULL value. This informatin item was not collected prior to
FY98.
Rows 313 to 344
-45-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
REPAIR
RESULT
Entity Attribute Name
resultid
syst_rep
cause
ctrjstjd
disable
fueljd
msjd
ms_type
next_rep
No_bags
No_modes
nom_humid
nomjemp
old_rkey
prev_rep
proto_id
res_kind
resultgrp
Entity Attribute Definition
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
System(s) affected by the repair. Legal values defined by SYST_REP
translation table.
A foreign key back into RESULT. Identifies the most immediately preceding
RESULT instance (e.g. a PROCURE or REPAIR on this mobile source
instance) affecting the outcome of this one. A departure from the relational
model.
Identification number assigned to the RESULT by a test contractor.
(Hopefully uniquely identifes RESULT instances within a given contractor.)
Not used for analytical purposes. But could help locate contractor's records
pertinent to this RESULT.
Indication of any special conditions or "disablements" performed on the
mobile source for particular tests. A value of zero indicates that no special
condition or disablement to the vehicle was performed. Positive values
indicate a particular disablement or set of disablements. Legal values defined
by DISABLE translation table.
Numeric code uniquely identifying the general type of fuel used. Sometimes
referred to as the "gross fuel type".
Mobile source identifier. For vehicles their VIN would be used. For
engines, their serial number, probably in conjunction with their manufacturer
code.
General kind of mobile source:
1 = Vehicle
2 = Engine.
A foreign key back into RESULT. Identifies any most immediately following
RESULT instance which is a replicate (repeat) of this one. A departure from
the relational model.
Number of bags involved in this RESULT. Data for individual bags is stored
in the BAG DATA table.
Number of test modes involved in this result. Data for individual chassis test
modes is stored in the DYNOMODE table; data for individual engine
dynomometertest modes is stored in the ETSTMODE table.
Nominal absolute humidity at which test was to be conducted. Expressed in
grains of water per pound of dry air.
Nominal temperature at which test was to be conducted. Expressed in
degrees Fahrenheit.
Old result key in previous database. This field is intended for data
administrator use only. It contains sufficient information to uniquely locate a
result-type record in the old database as follows:
Site code - 3 columns
Program - 4 columns
Contract - 4 columns (upper two columns sometimes used for other special
key info,
e.g. nom-speed in STSTEF98.)
Veh_no - 5 columns
Test_seq - 3 columns
TesMype (test procedure) - 2 columns
Lane/lab indicator (Larry Landman) - 1 column
A foreign key back into RESULT. Identifies any most immediately preceding
RESULT instance for which this RESULT is a replicate (repeat). A departure
from the relational model.
Task number. Field has this name because thought at one point was to call
these "protocols".
RESULT kind. Used to identify which subtype this result belongs to. Overall
intent is to aggregate RESULT instances into as few different subtypes as
practical. E.g. all vehicle dynamometer tests may be one subtype, all SHED
tests another. Legal values defined by RES_KIND translation table.
May be used to relate a RESULT to another RESULT of which it considered
a part. This relationship was originally established to relate the FTP, US06
and SC03 portions of the SFTP to the SFTP summary calculations (All four
being considered DYNOTESTs.) The SFTP is considered the Result Group
and the FTP, US06 and SC03 are considered to belong to this Result Group.
Rows 345 to 362
-46-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
RESULT
ROADPHAS
ROADTEST
Entity Attribute Name
resultid
sched id
site
test date
test_modif
test_proc
test tod
wa id
avg_baro
avg_humid
avgjemp
distance
gallons
phase_no
resultid
start_emis
timeonroad
total work
veh_state
w_co
w co2
w no
w o2
w_thc
actweight
avg_baro
avg_humid
avgjemp
distance
gallons
instrsys
odometer
precond
resultid
Entity Attribute Definition
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Schedule identification.
Location where test was conducted. Legal values defined by SITE translation
table.
Result date.
Identifies any minor deviation from normal test procedure indicated by
"test proc". Legal values defined by TEST MOD translation table.
Identifies the specific test procedure used. A more detailed classification than
RES_KIND. Based largely upon values of TEST_TYPE in earlier design.
Conceptually distinct from the driving or operational schedule used.
Time of day of the start of the result. Stored as a 5 character string HH:MM.
Work Assignment (or equivalent for TSD) name.
Average barometric pressure during the test phase. Expressed in inches of
mercury.
Average absolute humidity of ambient air during the test phase. Expressed in
grains of water per pound of dry air.
Average ambient air temperature during the test phase. Expressed in degrees
Fahrenheit.
Total distance traveled during the test phase. Expressed in miles.
Gallons of fuel consumed during the test phase.
Numerically identifies the phase or portion of the test.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Indicates whether the vehicle start emissions are included in the test phase.
Possible values are "YES", "NO" and "NUL".
Duration of the exhaust measurement period of this test phase. Expressed in
seconds.
Total amount of work performed by the vehicle during the test phase.
Expressed in brake horsepower hours.
State of the vehicle at the start of the road test phase. Legal values defined by
VEH_STAT translation table.
A blank value of the field is its NUL value.
Total carbon monoxide emissions emitted during the test phase. Expressed in
grams.
Total carbon dioxide emissions during the test phase. Expressed in grams.
Nitric oxide (NO) emissions during the test phase. Expressed in grams.
Total oxygen emissions during the test phase. Expressed in grams.
Total hydorcarbon emissions emitted during the test phase. Expressed in
grams.
Actual weight of the vehicle, including driver, fuel , passengers, and cargo,
during the test. Averaged if necessary . Expressed in pounds.
Average barometric pressure during the test. Expressed in inches of mercury.
Average absolute humidity of ambient air during the test. Expressed in grains
of water per pound of dry air.
Average ambient air temperature during the test .Expressed in degrees
Fahrenheit.
Total distance traveled during the exhaust measurement period. Expressed in
miles.
Gallons of fuel consumed during the test measurement period.
Onboard exhaust emission measurement system with which the vehicle has
been equipped for this test. Legal values defined by INSTRSYS translation
table.
Approximate odometer reading of vehicle at beginning of test. Expressed in
miles.
Type of preconditioning performed on the vehicle prior to the test. Legal
values defined by PRECOND translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Rows 363 to 396
-47-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
ROADTEST
ROADTIME
ROADTRIP
Entity Attribute Name
route
timeonroad
total work
w_co
w_co2
w_no
w_o2
w_thc
enginerpm
phase_no
r co
r_co2
r no
r o2
r the
resultid
roadsecs
roadspeed
roadtemp
roadtorque
ac_time
comp_time
distance
heatjndex
humidity
idle
per_0mph
peMOmph
per_15mph
per_20mph
per_25mph
per_30mph
per_35mph
per_40mph
per_45mph
per_50mph
Entity Attribute Definition
Route traveled by the vehicle during the test measurement period. Legal
values defined by ROUTE translation table.
Duration of the exhaust measurement period of this test. Expressed in
seconds.
Total amount of work performed by the vehicle during the test measurement
period. Expressed in brake horsepower hours.
Total carbon monoxide emissions emitted during the test measurement
period. Expressed in grams.
Total carbon dioxide emissions during the test measurement period.
Expressed in grams.
Nitric oxide (NO) emissions during the test measurement period. Expressed
in grams.
Total oxygen emissions during the test measurement period. Expressed in
grams.
Total hydorcarbon emissions emitted during the test measurement period.
Expressed in grams.
Engine revolutions per minute.
Numerically identifies the phase or portion of the test.
Rate of carbon monoxide emissions. Expressed in grams per second
Rate of carbon dioxide emissions measurement. Expressed in grams per
second.
Rate of nitric oxide (NO) emissions. Expressed in grams per second.
Rate of oxygen emissions measurement. Expressed in grams per second.
Rate of total hydocarbon emissions. Expressed in grams per second
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Time within road exhaust emission test, expressed in seconds, beginning of
test has roadsecs = 0.
Vehicle speed. Expressed in miles per hour.
Ambient temperature. Expressed in degrees Fahrenheit.
Engine output torque. Expressed in foot pounds.
Total time the vehicle's air conditioning was turned on by the vehicle operator.
Expressed in seconds.
Total time the vehicle's air conditioning compressor was running. Expressed
in seconds.
Total distance traveled during the trip. Expressed in miles.
Heat index of ambient air associated with this trip. Expressed in equivalent
degrees Fahrenheit.
Absolute ambient air humidity associated with this trip. Expressed in grains
of water per pound of dry air.
Percentage of time at idle
Percentage of time spent traveling at speed greater than 0 but less than 5
miles per hour.
Percentage of time spent traveling at least 10 miles per hour but less than 15
miles per hour.
Percentage of time spent traveling at least 15 miles per hour but less than 20
miles per hour.
Percentage of time spent traveling at least 20 miles per hour but less than 25
miles per hour.
Percentage of time spent traveling at least 25 miles per hour but less than 30
miles per hour.
Percentage of time spent traveling at least 30 miles per hour but less than 35
miles per hour.
Percentage of time spent traveling at least 35 miles per hour but less than 40
miles per hour.
Percentage of time spent traveling at least 40 miles per hour but less than 45
miles per hour.
Percentage of time spent traveling at least 45 miles per hour but less than 50
miles per hour.
Percentage of time spent traveling at least 50 miles per hour but less than 55
miles per hour.
Rows 397 to 432
-48-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
ROADTRIP
RUNL_BAG
RUNLOSS
SJNSP
SCANSYS1
Entity Attribute Name
per_55mph
per_5mph
per_60mph
per_65mph
per_70mph
per_75mph
per_80mph
rel_humid
resultid
temp
timeonroad
bag_num
obs_ftemp
purg_flow
resultid
tank_press
targ_ftemp
w_runl_thc
ac_hp
dynotype
endcanwght
norcanwght
obsiftemp
odometer
precond
resultid
road_hp
tarcanwght
targiftemp
testwght
resultid
system
system_stat
obdlcode
obdldescr
resultid
Entity Attribute Definition
Percentage of time spent traveling at least 55 miles per hour but less than 60
miles per hour.
Percentage of time spent traveling at leasts miles per hour but less than 10
miles per hour.
Percentage of time spent traveling at least 60 miles per hour but less than 65
miles per hour.
Percentage of time spent traveling at least 65 miles per hour but less than 70
miles per hour.
Percentage of time spent traveling at least 70 miles per hour but less than 75
miles per hour.
Percentage of time spent traveling at least 75 miles per hour but less than 80
miles per hour.
Percentage of time spent traveling 80 miles per hour or more.
Relative ambient air humidity associated with this trip. Expressed as a
percentage of maximum.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Ambient air temperature associated with this trip. Expressed in degrees
Fahrenheit.
Duration of the trip. Expressed in seconds.
Bag number.
Observed fuel tank temperature. Expressed in degrees Fahrenheit.
Purge air flow volume during this portion of the test. Expressed in liters.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Fuel tank pressure. Expressed in pounds per square inch.
Target fuel tank temperature. Expressed in degrees Fahrenheit.
Total hydrocarbon evaporative emissions, (for this portion of the test).
Expressed in grams. Often termed "running loss" emissions.
Did dynamometer road load setting for this test include air conditioning load
factor? YES, NO, orNUL.
Type of dynomometer used. Legal values defined by DYNOTYPE translation
table.
Observed canister weight at end of test. Expressed in grams.
Normalized canister weight. Expressed in grams
Observed initial fuel tank temperature. Expressed in degrees Fahrenheit.
Approximate odometer reading of vehicle at beginning of test. Expressed in
miles.
Type of preconditioning performed on the vehicle prior to the test. Legal
values defined by PRECOND translation table.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Dynamometer road load horsepower setting used for this test.
Target canister weight. Expressed in grams
Target initial fuel tank temperature. Expressed in degrees Fahrenheit.
Dynamometer inertia weight setting used for this test. Expressed in pounds.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Identitifcation of an emission component system.
Status of the emission component system.
Legal values defined by SYSTEM_S translation table.
Numeric code resulting from a scan of level 1 on board diagnostic system.
Narrative explaining significance of individual code resulting from scan of a
level 1 on board diagnostic system.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Rows 433 to 468
-49-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
SCANSYS2
SCHED PT
SCHEDULE
SMOKETST
SYSTEM
TASK
Entity Attribute Name
obd2code
resultid
sched id
schedjype
sched val
test time
sched_acc
sched_avg
sched id
schedjen
sched_max
sched name
resultid
smoke_acc
smokejug
smoke_peak
old_syst
system
system_d
contract
p_criteria
program
Entity Attribute Definition
Character string code resulting from a scan of a level 2 on board diagnostic
system.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Schedule identification.
Schedule type. Legal values defined by SCHED_TY translation table.
Value of the scheduled test parameter at this time in the schedule.
Number of seconds from the beginning of the schedule.
Maximum acceleration. A calculated summary value which is meaningful only
for schedules which have a single schedule type.
More generally the maximum value of the slope or first derivative of the
schedule.
Calculated as the maximum difference between two successive schedule
points divided by the number of seconds between successive schedule
points.
Average value of schedule parameter. A calculated summary value which is
meaningful only for schedules which have a single schedule type.
Schedule identification.
Number of seconds in schedule. Not necessarily the number of schedule
points.
Maximum schedule value. A calculated summary value which is meaningful
only for schedules which have a single schedule type.
Complete schedule name.
Unique number sequentially assigned to each RESULT instance (including
all RESULT subtype instances) as it is entered into this database. Number
has no other significance.
Smoke opacity during acceleration portion of test. Expressed as a percentage
of light blocked.
Smoke opacity during lugging portion of test. Expressed as a percentage of
light blocked.
Smoke opacity during peak operation portion of test. Expressed as a
percentage of light blocked.
Name of field describing this emission component "system" in the old
database.
Identitifcation of an emission component system.
More lengthy description of the emission component system.
A number intended to identify the contract, as historically classified, to which
a Task belongs.
Procurement criteria. A categorical attribute with two valid entries: GENERAL
or CONDITIONAL.
GENERAL pertains to projects where vehicles were accepted for testing
without additional, vehicle-condition-specific criteria. For example, a task
might intend to recruit 1997 model year light-duty trucks with less than 6,000
pounds gross vehicle weight. If the first truck meeting these criteria and
willing to be tested is accepted for testing, then the procurement would be
considered GENERAL. (Rejecting vehicles for testing safety reasons is not
considered as an additional criteria.)
Most EPA test data is usually not procured in a purely random manner.
Vehicle class criteria (i.e., model year) is commonly used as a criteria to limit
the scope of the procurement and maximize the data sample in the areas of
interest. This "non-random" procurement is normally not a problem as long as
the analysis of the data is stratified by the vehicle class criteria.
CONDITIONAL refers to tasks which included additional,
vehicle-condition-specific criteria in addition to any vehicle class criteria. The
additional criteria is based on the condition of the vehicle (i.e., mileage,
emission level, vehicle owner, etc.) and not the vehicle as manufactured (i.e.,
fuel injection, catalyst type, model year, etc.). Users should refer to the text of
the work assignment which recruited the vehicle to determine the precise
conditions used for recruitment.
Test program, as historically classified, to which the Task belonged. This
data element formed the "SUFFIX" portion of tablenames in an older,
non-relational, implementation of this database.
Rows 469 to 490
-50-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
TASK
TEST_PRO
TESTMEAS
TIMEMEAS
VEH_MISC
VEHICLE
Entity Attribute Name
protojd
task d
has_start
hc_method
nom_soak
test_pro_d
test_pro_n
test_proc
measjd
measure
resultid
evapmins
measjd
resultid
time meas
measjd
msjd
msjype
vehmeas
ac
axle ratio
bld_date
canister
city_fe
costd
creeper
curbweight
drv trn
egr
engjam
engmount
Entity Attribute Definition
Task number. Field has this name because thought at one point was to call
these "protocols".
Brief task title or description.
True for test procedures which measure exhaust emissions and which include
one or more engine starts. False otherwise.
Hydrocarbon emission measurement method normally used when this test
procedure is conducted, e.g. Propane equivalent or hexane equivalent.
Categorical field characterizing the amount of soak time prior to any engine
starts included in the test procedure.
Meaningful only for exhaust emission test procedures that include an engine
start (HAS_START = T.).
Legal values defined by NOMJ3OAK translation table.
Brief description of the test procedure.
Unique number associated with a test procedure.
Identifies the specific test procedure used. A more detailed classification than
RESJ
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
VEHICLE
WKASSIGN
Entity Attribute Name
evap fam
evapstd
fueltanks
gears
gvwr
hway_fe
lockup
make
model name
model_yr
modelsize
msjd
ms_type
nmhcestd
nmhcstd
noxstd
overdrive
pmstd
purpose
sec
standards
tank_cap
thcestd
thcstd
tran_type
vehclass
abstract
alternate
contractor
epa_contno
epa_wano
epacontact
fiscalyr
frpMtiame
no_msource
Entity Attribute Definition
EPA standardized evaporative family name as defined in CFR40 Part 86
Evaporative emissions standard to which vehicle was certified. Expressed in
grams per mile.
Number of fuel tanks on vehicle.
Number of forward gears in vehicle transmission.
Legal values defined by GEARS translation table.
Gross vehicle weight rating in pounds.
Represents the highway fuel economy rating in miles per gallon from the fuel
economy guide.
Indicates whether vehicle has lockup transmission.
Vehicle make e.g. Buick, as distinct from vehicle manufacturer, GM. Legal
values defined by MAKE translation table.
Model name.
Model year.
Represents the EPA Fuel Economy Guide model size category for the vehicle.
Legal values defined by MODELSIZ translation table.
Mobile source identifier. For vehicles their VIN would be used. For
engines, their serial number, probably in conjunction with their manufacturer
code.
General kind of mobile source:
1 = Vehicle
2 = Engine.
Non-methane hydrocarbon equivalent standard to which vehicle was certified.
Expressed in grams per mile.
Non methane hydrocarbon standard level to which vehicle was certified.
Expressed in grams per mile.
Oxides of nitrogen standard level to which vehicle was certified.
Expressed in grams per mile.
Indicates whether vehicle has overdrive gear.
Particulate matter standard to which vehicle was certified. Expressed in grams
per mile.
Purpose or use of the mobile source. Addition of this field was motivated by
the need to describe the function of non-road vehicles and equipment and
will likely be blank for othermobile sources.
Source classification code.
Identifies set of emission standards applicable to this vehicle. This field is
collected only for older data where there were only a few different standards in
existence. Field is not adequate to characterize emission standards
applicable to later model year vehicles. Legal values defined by STANDARDS
translation table.
Total fuel tank capacity to nearest gallon. (Includes all tanks.)
Total hydrocarbon equivalent standard to which vehicle was certified.
Expressed in grams per mile.
Total hydrocarbon standard level to which vehicle was certified.
Expressed in grams per mile.
Transmission type. Legal values defined by TTRNTRAN translation table.
Vehicle class. Legal values defined by VEHCLASS translation table.
DAMT final report for this work effort.
Alternate EPA contract person, initially the alternate work assignment
manager, responsible for the work assignment and who can be contacted for
additional information about it.
Name of contractor.
EPA Contract Number of the contract to which the work assignment belongs.
Work assignment number, as it appears in EPA contracts function.
e.g. "2 05"
EPA contract person, initially the work assignment manager or WAM,
responsible for the work assignment and who can be contacted for additional
information about it.
Fiscal Year of work assignment.
Name of file containing contractor's final report.
Number of mobile sources the work assignment is intended to procure or test.
Rows 523 to 557
-52-
-------
Entity Name/Table Name : attribute definition report (H:\AMD\AMDTEAMS\DBCOORD\eftop10.er1, Tuesday, January 04, 2000 10:37:19, 623 rows, 561
Entity Name
WKASSIGN
Entity Attribute Name
p_criteria
sow_fname
wa desc
wa id
wp_fname
Entity Attribute Definition
Procurement criteria. A categorical attribute with two valid entries: GENERAL
or CONDITIONAL.
GENERAL pertains to projects where vehicles were accepted for testing
without additional, vehicle-condition-specific criteria. For example, a task
might intend to recruit 1997 model year light-duty trucks with less than 6,000
pounds gross vehicle weight. If the first truck meeting these criteria and
willing to be tested is accepted for testing, then the procurement would be
considered GENERAL. (Rejecting vehicles for testing safety reasons is not
considered as an additional criteria.)
Most EPA test data is usually not procured in a purely random manner.
Vehicle class criteria (i.e., model year) is commonly used as a criteria to limit
the scope of the procurement and maximize the data sample in the areas of
interest. This "non-random" procurement is normally not a problem as long as
the analysis of the data is stratified by the vehicle class criteria.
CONDITIONAL refers to tasks which included additional,
vehicle-condition-specific criteria in addition to any vehicle class criteria. The
additional criteria is based on the condition of the vehicle (i.e., mileage,
emission level, vehicle owner, etc.) and not the vehicle as manufactured (i.e.,
fuel injection, catalyst type, model year, etc.). Users should refer to the text of
the work assignment which recruited the vehicle to determine the precise
conditions used for recruitment.
Name of file containing the SOW for this work assignment. Additional filing
conventions at any point in time, would be combined with this information to
find the actual document. The SOW is not as likely to be updated as the
project progresses as the workplan and the work assignment report.
Longer, descriptive name of the work assignment.
Work Assignment (or equivalent for TSD) name.
Name of file containing the contractor's approved work plan for this work
assignment. Filing conventions in effect at a given point in time, in
combination with this file name, would allow one to find the document.
Rows 558 to 561
-53-
-------
Listings of Some Important Tables
Listing of All Category Translation Tables (Legal Value Lists)
Work Assignments (WKASSIGN)
Test Procedures (TEST_PRO)
Test Schedules (SCHEDULE)
Kinds of Fuel (FUEL)
Disablements (DISABLE)
Test Procedure Modifications (TEST_MOD)
Special Measurements (MEASTYPE)
Chassis Test Modes (MODEJD)
Engine Dynamometer Test Modes (ENGMODE)
-54-
-------
Listing of Category Tables in MSOD
01/04/2000
Fieldname
AIRFUEL
AIRJNJ
ASPIRATED
CANISTER
CAT_TYPE
COMPANY
COOLING
CUTPOINTS
DISABLE
DRV_TRN
DRV_TYPE
DYNOTYPE
DYNOTYPE
EGR
EGR_TYPE
ENGMOUNT
ENG_CLASS
ENG_CYCLE
FIXES
FI_METH
FI_TYPE
FUELTYPE
FUEL_DELIV
FUEL_ID
GEARS
Tablename
ENGINE
M_SOURCE
M_SOURCE
VEHICLE
M_SOURCE
M_SOURCE
ENGINE
PROCURE
RESULT
VEHICLE
OWNERQST
DYNOTEST
RUNLOSS
VEHICLE
ENGINE
VEHICLE
ENGINE
ENGINE
PROCURE
ENGINE
M_SOURCE
M_SOURCE
M_SOURCE
RESULT
VEHICLE
Categtable
AIRFUEL
AIRJNJ
ASPIRATE
CANISTER
CAT_TYPE
COMPANY
COOLING
CUTPOINT
DISABLE
DRV_TRN
DRV_TYPE
DYNOTYPE
DYNOTYPE
YESNO
EGR_TYPE
ENGMOUNT
ENG_CLAS
ENG_CYCL
FIXES
FI_METH
FI_TYPE
FUELTYPE
FUEL_DEL
FUEL
GEARS
Categfield
AIRFUEL
AIRJNJ
ASPIRATED
CANISTER
CAT_TYPE
COMPANY
COOLING
CUTPOINTS
DISABLE
DRV_TRN
DRV_TYPE
DYNOTYPE
DYNOTYPE
YESNO
EGR_TYPE
ENGMOUNT
ENG_CLASS
ENG_CYCLE
FIXES
FIJVIETH
FI_TYPE
FUELTYPE
FUELJDELIV
FUELJD
GEARS
-55-
-------
Fieldname
HOW_LONG
IGNITION
IM240_PF
IM_STATUS
INSTRSYS
LF_WEAR
LITEACTION
MAKE
MAPTYPE
MEASJD
MEAS_ID
MEAS_ID
MEAS_ID
MEAS_ID
MEASJD
MEASJD
MEASJD
MODEID
MODEID
MODELSIZE
MODENAME
MODENAME
MODEJD
MODEJD
MODEJD
NOM_SOAK
OBDLEVEL
-56-
Tablename
OWNERQST
M_SOURCE
PROCURE
OWNERQST
ROADTEST
PROCURE
OWNERQST
VEHICLE
ENGINMAP
BAG_MEAS
EMODMEAS
FUELCHEM
MODEMEAS
RATEMEAS
REP_MEAS
TESTMEAS
VEHJVIISC
DYNORATE
RATEMEAS
VEHICLE
EMODMEAS
ETSTMODE
DYNOMODE
MODEMEAS
MODETIME
TEST_PRO
OBDSCAN
Categtable
HOWJJDNG
IGNITION
IM240_PF
IM_STAT
INSTRSYS
LF_WEAR
LITEACT
MAKE
MAPTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MEASTYPE
MODEJD
MODEJD
MODELSIZ
ENGMODE
ENGMODE
MODEJD
MODEJD
MODEJD
NOM_SOAK
OBDLEVEL
Categfield
HOWJ.ONG
IGNITION
IM240_PF
IM_STATUS
INSTRSYS
LF_WEAR
LITEACTION
MAKE
MAPTYPE
MEASJD
MEASJD
MEASJD
MEASJD
MEASJD
MEASJD
MEASJD
MEASJD
MODEJD
MODEJD
MODELSIZE
MODENAME
MODENAME
MODEJD
MODEJD
MODEJD
NOM_SOAK
OBDLEVEL
-------
Fieldname
PART
PART
PART_CODE
PART_STAT
PRECOND
PRECOND
PRECOND
PRESSTAT
PRESSURE
PROCMETH
PROC_MATCH
PROTOJD
PURGE
P_CRITERIA
P_CRITERIA
REFSPEED
REP_TYPE
RES_KIND
RF_WEAR
ROUTE
SCHEDJD
SCHED_TYPE
SITE
STANDARDS
START_EMIS
STATETEST
SYSTEM
-57-
Tablename
PCJNSP
P_INSP
PC_INSP
P_INSP
DYNOTEST
EVAPTEST
RUNLOSS
PRESSTST
PROCURE
PROCURE
PROCURE
RESULT
PROCURE
TASK
WKASSIGN
EMGMODE
REPAIR
RESULT
PROCURE
ROADTEST
RESULT
SCHED_PT
RESULT
VEHICLE
ROADPHAS
PROCURE
SJNSP
Categtable
PART
PART
PARTCODE
PART_STA
PRECOND
PRECOND
PRECOND
PRESSTAT
PRESSURE
PROCMETH
PROC_MAT
TASK
PURGE
P_CRITER
P_CRITER
REFSPEED
REP_TYPE
RES_KIND
RF_WEAR
ROUTE
SCHEDULE
SCHED_TY
SITE
STANDARD
YESNO
STATETES
SYSTEM
Categfield
PART
PART
PART_CODE
PART_STAT
PRECOND
PRECOND
PRECOND
PRESSTAT
PRESSURE
PROCMETH
PROC_MATCH
PROTOJD
PURGE
P_CRITERIA
P_CRITERIA
REFSPEED
REP_TYPE
RES_KIND
RF_WEAR
ROUTE
SCHEDJD
SCHED_TYPE
SITE
STANDARDS
YESNO
STATETEST
SYSTEM
-------
Fieldname
Tablename Categtable
Categfield
SYSTEM_STA
SYST_REP
TEST_MODIF
TEST_PROC
TRAN_TYPE
TRIP2LAB
VEHCLASS
VEH_STATE
WA ID
S INSP
REPAIR
RESULT
RESULT
VEHICLE
VEHICLE
ROADPHAS
RESULT
SYSTEM S
SYST REP
TEST MOD
TEST PRO
TRAN TYP
OWNERQST TRIP2LAB
VEHCLASS
VEH STAT
WKASSIGN
SYSTEM_STA
SYST_REP
TEST_MODIF
TEST_PROC
TRAN_TYPE
TRIP2LAB
VEHCLASS
VEH_STATE
WA ID
-58-
-------
WA ID
EPA CONTNO EPA WANO CONTRACTOR
FISCALYR NO MSOURCE
WORK ASSIGNMENT DESCRIPTION
AAMA_A
78T081LDVS
NEW_TEC_DC
NEW TEC MD
WAIVER_VEH
IM VARIABL
OBD_TYPE_I
AFTER MRK
RUNLOSS_Y
RUNLOSS Z
AC_ACTIV_A
I M+ HAMMOND
IM+SBEND
RWHS 01
RWHS_02
RWHS 03
LDV_A
LDV AC A
HIMILE_A
EVAP A
CYCLES_A
GRANT 9 7 NY
LHDT_LDT
OBD A
CRCE 24 1G
CRCE_24_1C
CRCE_24_2G
CRCE 24 2C
GRANT98_CO
LDV AC B
TIER_1
LHDT A
LHDT_EVAP
98N20A
NONROAD 1
68-03
68-03
68-03
68-03
68-03
68-03
-3024
-3202
-3222
-3222
-3222
-3436
3380/3436
68-C9
68-C9
68-C2
68-C3
68-C3
68-C5
68-C5
68-C5
68-C5
68-C5
68-C5
EPA
EPA
68-C5
68-C5
NONE
NONE
NONE
NONE
X-
EPA
EPA
EPA
EPA
68-C5
-0041
-0041
-0125
-0370
-0370
-0006
-0006
-0006
-0006
-0006
-0006
-0006
-0006
-0077
1
1 & 2
3
4
1
?&2
2-01
2-02
1-01
0-5
0-6
0-02
0-07
0-11
1-06
1-03
1-04
97-2
97-1
2-05
2-10
NONE
NONE
NONE
NONE
98-1
98-2
98-3
98-4
2-02
EG&G
EG&G
EG&G
EG&G
EG&G
EG&G
EG&G
ATL
ATL
ATL
ATL
ATL
ATL
ATL
ATL
ATL
ATL
ATL
NVFEL
NVFEL
NYSTATE
ATL
ATL
CDPHE
CDPHE
CE-CERT
CE-CERT
CIFER
GM
NVFEL
NVFEL
NVFEL
NVFEL
SWRI
1981
1984
1985
1986
1986
1987
1987
1992
1992
1994
1994
1994
1995
1996
1996
1997
1997
1997
1997
1997
1997
1998
1998
1998
1998
1998
1998
1998
1998
1998
1998
1998
1998
1998
3534
300
80
107
43
103
27
24
36
28
19
2175
121
180
6
15
25
62
25
4
44
35
46
48
171
24
109
39
1
35
10
4
23
10
AAMA in uses vehicle FTP test data used for Mobile
A Study of Emissions from Light Duty Vehicles in
Inspection and Maintenance of New Technology ehic
Inspection and Maintenance of New Technology Vehic
Incremental Emission Benefits of Repairing I/M Wai
I/M Test Variability (Task 45)
Comparison of On-Board I Diagnostics to Tailpipe I
TESTING FOR EFFECTIVENESS OF NEW AFTERMARKET CATA
CONTINUED EFFORTS TOWARDS "FUEL, CYCLE, TEMPERATUR
CONTINUED EFFORTS TOWARDS "FUEL, CYCLE, TEMPERATUR
Study of In-Use Air-Conditioner Operation in Phoen
Operation of an Enhanced I/M Lane in Indiana
Laboratory Testing of IM-Lane Recruited Vehicles i
Real World Hot Soak Testing - First Work Assignmen
Real World Hot Soak Testing - Second Work Assignme
Real World Hot Soak Testing - Third Work Assignmen
25 LDVs/LDTs MY1991+ exhaust emissions using FTP a
LDVs/LDTs on 14 different driving cycles with both
25 LDVs/LDTs with high mileage (>100,000 miles) be
4 LDTs and 1 LHDT with evaporative emission tests
LDVs and LDTs on 14 different driving cycles with
Characterization and Control of HD Diesel Vehicle
Task 1: 26 LHDTs tested on 8 facility cycles & FT
55 OBD Equipped MY96+ that failed IM240 in AZ are
Measurement of Exhaust Particulate Matter Emission
Measurement of Exhaust Particulate Matter Emission
Measurement of Primary Particulate Matter Emission
Measurement of Primary Particulate Matter Emission
To Determine the Emissions Benefits and Costs of a
One EPA'S LDV (correlation vehicle) sent to GM's R
35 LDVs/LDTs (15 lLDVs/20 LDTs) Having Tier 1 emi
10 LHDTs (40 originally planned) on 8 driving cy
LHDTs with evaporative emission tests at 3 differe
Nitrous Oxide (N20) Study on Tier 1 LDVs, LDTs, a
10 HDEs (agricultural/construction) tested on nonr
-59-
-------
WA ID
EPA CONTNO EPA WANO CONTRACTOR
FISCALYR NO MSOURCE
WORK ASSIGNMENT DESCRIPTION
CRCE 24 3G
CRCE_24_3C
NONR_RECMA
GRANT 9 9 NR
LHDT_C
CE CERT B
CE_CERT_A
LHDT B
LHDT_EVAPB
LDV EVAPB
LDVJT1SA
NONROAD 2
ROVER_A
LHDDT A
NONROAD_3
CDHOT PM A
TIER_1_B
TRUCK DFOO
HD_PM_FAIL
LHDDT B
NONE
NONE
X-
68-C5-0006
CX827312010
CX827312010
EPA 99-3
EPA 99-1
EPA 99-2
EPA 99-4
68-C-98-158
68-C-98-158
68-C-98-158
68-C-98-169
68-C9-0041
68-C-99-241
68-C-99-241
68-C-98-169
68-C-98-158
NONE
NONE
3-
0-
0-
0-
0-
0-
0-
0-
0-
1-
11
01
03
02
03
1
03
07
13
01
SwRI
SwRI
ATL
CECERT
CECERT
NVFEL
NVFEL
NVFEL
NVFEL
SWRI
SWRI
SWRI
SWRI
ATL
ATL
ATL
SWRI
SWRI
1998
1998
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
2000
2000
2000
2000
2000
61 Measurement of Primary Particulate Matter Emission
7 Measurement of Primary Particulate Matter Emission
0 Study on nonroad recreational vehicles/engines (SI
Methods for Estimating Construction Equipment Acti
18 18 LHDTs (GVWR 8,500 - 14,000 Ibs) on 99efset plu
7 Investigation of Exhaust Emissions from LHDVs (Die
1 Correlation of Diesel Truck In-Use Emission Test P
2 12 LHDTs (GVWR 8,500 - 10,000 Ibs) on 99efset plu
0 10 LHDTs (GVWR 8,500 - 14,000 Ibs) with evaporati
0 30 LDVs (15 LDVs and 15 LDTs) with evaporative emi
0 10 Tier 1 (LDVs and LDTs) on 99efset plus 8 differ
8 Development of Excavator emission duty cycle;
8 Study on determine the viability of gathering onbo
6 Testing 6 vehicles (GVWR8,501-19,500 Ibs) over 10
10 EPCD's 10 nonroad engine dyno tests on nonroad fue
600 The testing of 600 in-use vehicles at Phoenix IM 1
15 Testing 15 gasoline vehicles/trucks/SUVs over diff
23 The re-recruitment and re-testing of 23 previously
1 Investigation of Exhaust Emissions on Induced PM F
8 Testing 8 diesel vehicles (GVWR8,501-19,500 Ibs) o
-60-
-------
TEST PROC TEST PRO N TEST PRO D
IDLEI
FTP
BL_1A
BGID
50MPH
HFET
4MID
L2M
RSID
SPEED
NYCC
BGDR
C226
XSI
STOHS
STOHR
MLA4
MNYCC
MHFET
IM24
UFTP
IM24B
C226B
505HS
FLA4
3REST
IM387
ATD
4HD
HSOAK
CASPD
US06
LA9HR
ST01
505HR
ASM
FACIL
3
5
6
7
8
9
10
11
17
20
22
23
24
31
33
34
46
50
51
52
53
56
58
62
63
64
65
66
67
68
70
81
93
96
97
98
100
SC36)
Mechanic's Idle Inspection - usually prior to FTP
Federal Test Procedure
1 Hour Breathing Loss Evap Test - Gas Cap Left On
Bag Idle Test
50 MPH Cruise Mode Test
Highway Fuel Economy Test
Four Mode Idle Test (Idle, Idle @2500, Idle again, Idle in Drive
Loaded 2 mode test, idle and 30mph.
Restart Idle Test Data (as defined by 40 CFR 85-2210)
EPA Speed Correction Cycle Test (Any of Several, e.g. LSP1-3 or SC12,
New York City Cycle Test
Bag Idle-in-Drive Test
Colorado Dept. of Health 226 Second Test
Extended special idle test; Involves 24 steps; Data stored at MODETIME level.
Hot start ST01
Hot Running ST01
Running loss evap/exhaust emission test,
Running loss evap/exhaust emission test,
Running loss evap/exhaust emission test,
IM240 Test Data
Uncut Federal Test Procedure
IM240 Test - Restricted Range of Test Weight Values
Colorado Dept of Health 226 Second Test - Restricted Range of Test Weight Values
Hot Start 505
Facilty cycle LA4
3 Hour Resting Loss Evap Emissions Test (Follows 1 Hour Hot Soak)
IM387 Test Results (3 bag IM240)
Ambient temp diurnal evap test , shed temp const.
Four Hour Diurnal Test
1 Hour Hot Soak Evap Test
California Speed Correction Cycle Test (any of 10 driving schedules)
High Speed 4th Bag of FTP
California unified cycle test , conducted as a
Engine Start cycle test
First bag of FTP - engine on
Acceleration Simulation Mode Test Procedure
Roadway Facility Cycle Test
based on repeated runs of LA4 Schedule
based on repeated runs of NYCC Schedule
based on repeated runs of HFET Schedule
vehicle begins 24 deg cooler
1 bag test , without start
-61-
-------
TWOSP
2 SOAK
48RTD
IRTD
HSLA4
BL_1B
24RTD
STEAD
33RTD
72RTD
IMIDL
IM2MO
ASMTK
IM2LO
XRSID
38RTD
XIM24
ACSUR
DROVE
SROVE
RROVE
CRLOS
HD_DT
USMOK
SMOKI
SIACC
40MOD
8M_C1
28MOD
NONR2
NONR1
PRESC
PREST
SC03
SC03A
SC03B
SFTP
SMILE
CBD
HD DR
101
102
103
104
105
106
107
108
109
110
111
112
113
114
117
118
152
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
Two Speed Idle Test
2 Hour Hot Soak Evap Test
48 Hour Real Time Diurnal
Interrupted 24 hour real time diurnal
Hot Start LA4, LA4 is first two bags of FTP
1 Hour Breathing Loss Evap Test - Canister As Reed
24 Hour Real Time Diurnal
Steady State Driving
33 Hour Real Time Diurnal
72 Hour Real Time Diurnal
Official State I/M Idle Emissions Test
Official State I/M 2 Mode Idle Emissions Test (Idle@2500 plus Idle)
ASM Performed On LHDTs With Emissions Averaged On Last 10 Seconds Of Each Mode
Official State I/M 2 Mode Loaded Emissions Test (30mph plus idle)
Restart Idle Test - No Exhaust Measurements Taken
38 Hour Real Time Diurnal
IM240 Test - No Exhaust Measurements Taken
Air conditioning activity survey as performed in WA_ID = "AC_ACTIV_A"
Vehicle with on-board exhaust instruments, driven on chassis dynomometer
Vehicle with on-board exhaust instruments, driven on schedule-like road route
Vehicle with on-board exhaust instruments, driven on road route
Vehicle Certification Running Loss Emissions Test
Heavy Duty Diesel Transient Test as def by 40 CFR Part 86
U.S. Smoke Cycle Test, as def by 40 CFR 86.884, Subpart I
opacity smoke test procedure as def by ISO 8178-9
Snap-Idle Acceleration test procedure as def by SAE J-1667
40 mode, steady state engine dyno test. (1 idle, 3 E3 marine, 36 load matrix)
8 mode, steady state engine certification test as defined in CFR
28 mode, steady state engine dyno test as def. by Contract 68-65-0077, Task 2-2
Engine dyno transient test as defined by Contract 68-65-0077; amended Task 2-2
Engine dyno transient test as defined by Contract 68-65-0077; orig. Task 2-2
Evap system pressure check - Done at fuel cap.
Evap System Pressure Check - Done at fuel tank.
SC03 Air Conditioning Simulation as specified in 40 CFR 86.160-00 thru 161-00
SC03 AC1 Air Conditioning Simulation as specified in 40 CFR 86.160-00 to 162-00
SC03 AC2 Air Conditioning Simulation as specified in 40 CFR 86.160-00 to 162-00
Calculation (only) of composite SFTP emissions as specified in 40 CFR 86.164
Chassis dynamometer test using West Virginia 5 Mile Route
Chassis dynamometer test using the Central Business District Schedule
Heavy Duty Diesel Transient Test with driving schedule "routinized"
-62-
-------
SCHED ID
SCHEDULE DESCRIPTION
20_40
20 MPH
30_MPH
3LA4
40_MPH
45 MPH
50_MPH
55 MPH
5HWFET
SMILE
60_MPH
65 MPH
6NYCC
SCHED ID
70_MPH
75 MPH
80_MPH
85 MPH
90_MPH
95 MPH
AGRIC
ARE 02
ART-AB
ART -CD
ART-EF
BAKHO
CAART1
CAART2
SCHED_ID
CAART3
CACYC1
CACYC2
CACYC3
CACYC4
CACYC5
dr
20
30
th
40
45
50
55
fi
We
60
65
si
EX
70
75
80
85
90
95
ag
AR
le
le
le
ba
ca
ca
EX
ca
ca
ca
ca
ca
ca
ve first half at 20 miles per hour, second half at 40 mph steady state d
mile per hour steady state driving
mile per hour steady state driving
ee LA4 schedules, run in succession
mile per hour steady state driving
45 mile per hour steady state driving
mile per hour steady state driving
55 mile per hour steady state driving
•e HWFET schedules, run in succession
t Virginia 5 Mile Route
mile per hour steady state driving
65 mile per hour steady state driving
c NYCC schedules, run in succession
} 2
mile per hour steady state driving
mile per hour steady state driving
mile per hour steady state driving
mile per hour steady state driving
mile per hour steady state driving
95 mile per hour steady state driving
agricultural tractor cycle
ARE weighted aggressive driving(non-FTP) cycle
of service A & B arterial/collector simulation inventory cycle(24.8mp
of service C & D arterial/collector simulator inventory cycle(19.2mph
of service E & F arterial/collector simulation inventory cycle(11.6mp
backhoe-loader cycle
California arteriall(14.35mph)
California arteria!2(24.OSmph)
2
California arteria!3(34.22mph)
California freeway speed correctionl(60.09mph)
California freeway speed correction2(53.37mph)
California freeway speed corrections(40.89mph)
California freeway speed correction4(31.35mph)
California freeway speed corrections(23.92mph)
-63-
-------
CACYC6
CACYC7
CBD
CDH226
CRAWL
CRLOS
CY106
CY6084
SCHED_ID
CY7296
CY8210
CY84
CY8484
CY96
DIURB2
DIURB3
DIURBL
F505
FTP
FWY-AC
FWY-D
FWY-E
FWY-F
SCHED_ID
FWY-G
FWY-HI
HWFET
IM240
IM386
LA4
LA92
LOCAL
LSP1
LSP2
LSP3
NA
NONFRW
NYCC
SCHED ID
California freeway speed corrections(16.SOmph)
California freeway speed correction?(9.llmph)
Central Business District
Colorado department of health(22.32mph)
crawler tractor cycle
light duty vehicle certification running loss emission test schedule
shed temperature pattern - nominally constant at 106 degrees F.
real time diurnal temperature pattern - range 60 to 84 degrees Fahrenheit
EXP_2
real time diurnal temperature pattern - range 72 to 96 degrees Fahrenheit
real time diurnal temperature pattern - range 82 to 106 degrees Fahrenhei
shed temperature pattern - nominally constant at 84 degrees F.
real time diurnal temperature pattern - temperature range 72 to 96 degrees
shed temperature pattern - nominally constant at 96 degrees F.
temperature rise for 1 hour diurnal evap emission test at elevated tempera
temperature rise for 1 hour diurnal evap emission test at elevated tempera
standard temperature rise for 1 hour diurnal (or breathing loss) evaporativ
bag 1 of federal test procedure(25.55mph)
federal test procedure(19.53mph), also referred to as the UDDP schedule
level of service A through C(free flow) freeway simulation inventory eyelet
level of service D freeway simulation inventory cycle(52.9mph)
E freeway simulation inventory cycle(30.5mph)
F freeway simulation inventory cycle(18.6mph)
EXP_2
level of service G freewat simulation inventory cycle(13.Imph)
high-speed freeway cycle(63.ISmph)
highway fuel economy test(48.14mph) -control cycle
inspection/maintenance 240(29.38mph)
inspection/maintenance 386(31.3Imph)
Bags 1 and 2 of the FTP, also referred to as the UDDP schedule
California unified cycle(areawide driving simulation inventory cycle
urban local facility driving simulation inventory cycle(12.9mph)
low speed l(2.51mph)
low speed 2(3.54mph)
low speed 3(4.llmph)
No schedule is applicable to this RESULT
areawide non-freeway cycle(19.35mph)
(new york city cycle(7.04mph)
EXP 2
level of service
level of service
-64-
-------
RAMP freeway ramp simulation inventory cycle(34.58mph)
REM01 EPA weighted "FTP-like" cycle
REP05 EPA weighted aggressive driving(non-FTP) cycle
RTLHSP RUBBER TIRE LOADER HIGH SPEED TRANSIENT DUTY SCHEDULE
RTLHTQ RUBBER TIRE LOADER HIGH TORQUE TRANSIENT DUTY SCHEDULE
RTLJT1 RUBBER TIRE LOADER TYPICAL 1 DUTY SCHEDULE
RTLJT2 RUBBER TIRE LOADER TYPICAL 2 DUTY SCHEDULE
SC03 SFTP air conditioning compliance cycle(EPA and ARE)
SCC12 speed correction cycle!2(11.67mph)
SCC36 speed correction cycle36(36.47mph)
SSLHSP SKID STEER LOADER HIGH SPEED TRANSIENT SCHEDULE
SSLHTQ SKID STEER LOADER HIGH TORQUE TRANSIENT DUTY SCHEDULE
SSLJT1 SKID STEER LOADER TYPICAL 1 DUTY SCHEDULE
SSLJT2 SKID STEER LOADER TYPICAL 2 DUTY SCHEDULE
SCHED_ID EXP_2
ST01 EPA start cycle - first 1.4 miles of SC03
UDDS_D URBAN DYNAMOMETER DRIVING SCHEDULE FOR HEAVY DUTY VEHICLES
UNCFTP uncut federal test procedure(21.25mph)
UNIF01 EPA unified cycle
US06 SFTP aggressive driving compliance cycle(EPA and ARE)
WELHSP ARC WELDER HIGH SPEED TRANSIENT DUTY SCHEDULE
WELHTQ ARC WELDER HIGH TORQUE TRANSIENT DUTY SCHEDULE
WELJT1 ARC WELDER TYPICAL 1 DUTY SCHEDULE
WELJT2 ARC WELDER TYPICAL 2 DUTY SCHEDULE
X CAV EXCAVATOR SCHEDULE
-65-
-------
FUEL_ID
0
1
2
3
6
9
10
11
16
18
22
30
31
32
33
43
44
45
46
48
49
50
51
60
61
62
63
64
65
66
67
69
70
71
72
FUELNAME
Tank (Whatever came with vehicle)
Low RVP Test Gasoline
Low RVP Test Gasoline
Low RVP Test Gasoline
Unleaded Test Gasoline
Diesel Fuel
California Phase II Gasoline
California Diesel
Unleaded Test Gasoline (11.7 RVP)
Gasohol (8.8 RVP)
Unleaded Test Gasoline (10.5 RVP)
Non-Oxygenated Baseline Fuel - 7.7
Oxygenated Baseline Fuel, 8.7 RVP,
ethanol splash-blended into Fuel_Id
Gasahol (10 % ethanol) , RVP =7.7
Gasoline with MTBE, RVP =7.7
Clean Air Act Baseline Gasoline
Federal Phase II Gasoline
Oxygenated Test Gasoline
Oxygenated Test Gasoline
Phase I Low Sulfur Gasoline
Phase I Gasoline
Low T-90 Unleaded Gasoline
Gasohol (9.0 RVP)
Unleaded Test Gasoline
Unleaded Test Gasoline
Unleaded Test Gasoline
Unleaded Test Gasoline
Oxynol 50 MeOH, EtOH
Oxynol MeOH, TEA
Unleaded Test Gasoline
Unleaded Test Gasoline
(96 RON) (CFR 86.113 - 91(a))
RVP
10%
30
(96 RON)
(96 RON)
(96 RON)
(96 RON)
50-80 PPM SULFUR
140-160 PPM SULFUR
330-370 PPM SULFUR
620-680 PPM SULFUR
(7.0 RVP)
(11.0 RVP)
[id EM-616-F)
Commercial Fuel Used by Southwest
High RVP Gasoline
Special gasoline, with T40 point = 160 deg F
Special gasoline, with T40 point = 160 deg F
1ENATE WTOXYGEN
none
none
none
MTBE
none
none
ethanol
none
none
ethanol
ethanol
MTBE
none
MTBE
MTBE
MTBE
MTBE
MTBE
none
ethanol
none
none
none
none
none
none
none
99.
0.
0.
0.
0.
99.
2.
99.
0.
3 .
0.
0.
3 .
3.
99.
0.
2.
3.
99.
2.
2.
0.
3 .
0.
0.
0.
0.
2.
2.
0.
0.
0.
99.
99.
99.
.9
.0
.0
.0
.0
.9
.0
.9
.0
.4
.0
.0
.4
.4
.9
.0
.0
.0
.9
.3
.0
.0
.4
.0
.0
.0
.0
.6
.7
.0
.0
.0
.9
.9
.9
RVP
99
6
6
6
9
99
7
99
11
8
10
7
8
7
7
8
7
9
9
8
8
8
9
9
9
9
9
9
8
7
11
9
14
10
9
.9
.3
.7
.9
.0
.9
.0
.9
.7
.8
.5
.7
.7
.7
.7
.8
.0
.0
.0
.8
.0
.7
.0
.0
.0
.0
.0
.1
.8
.0
.0
.2
.6
.4
.0
SULFERLOW SULFERHIGH
99999
99999
99999
99999
0
800
99999
99999
99999
99999
99999
99999
99999
99999
99999
304
130
99999
99999
99999
99999
99999
99999
50
140
330
620
99999
99999
99999
99999
99999
99999
99999
99999
99999
1000
99999
99999
1000
1200
40
500
99999
99999
99999
99999
99999
99999
99999
354
140
99999
99999
99999
99999
99999
99999
80
160
370
680
99999
99999
99999
99999
99999
99999
99999
99999
-66-
-------
FUEL ID FUELNAME
OXYGENATE
WTOXYGEN
RVP
SULFERLOW
SULFERHIGH
73 Gasohol (11.8 RVP)
74 Special gasoline (with MTBE, 12.2 RVP)
75 Special gasoline (10 RVP)
76 Gasohol (9.8 RVP)
77 Oxygenated Test Gasoline
78 Diesel(0.034WT% SULFUR)40 CFR86.1313 - 94(b) (2) Type
79 Non-Road Grade Diesel (high sulfer)
80 Base formula fuel
81 Low RVP Fuel
82 Low Sulfur Fuel
83 Low Sulfur, Low RVP, Low T90 Fuel
84 Baseline Fuel, 32% aromatics, 1.5% benzene
85 Formula Fuel with Ethanol
86 Formula Fuel with MTBE
87 High T50 Fuel with MTBE
88 High T90 Fuel with MTBE
89 MTBE, Heavy Ends, Predominately Aromatics
90 MTBE, High T90, Cutting out Heaviest 10%,
float olefin and aromatic level.
91 MTBE, Low Olefins (2% max)
92 MTBE, Low Olefins, (2% max), Low Sulfur (65ppm)
93 Low RVP, MTBE, Low Olefins, Low Sulfur
94 Calif. Phase II, low RVP and Sulfur,
Olefins 5-7%, Aromatics 20-25%, From ARCO
95 Low RVP, With MTBE, Low Olefins, Low Sulfur
96 Diesel 40 CFR86.1313-94(b)(2) Type 2-D
97 ULTRA LOW DIESEL TYPE 2,1.1 PPM SULFUR(EM-2866-F)
ethanol
MTBE
none
ethanol
MTBE
2-D none
none
none
none
none
none
none
ethanol
MTBE
MTBE
MTBE
MTBE
MTBE
MTBE
MTBE
MTBE
MTBE
3 .
99.
0.
3.
99.
99.
99.
0.
0.
0.
0.
0.
99.
99.
99.
99.
99.
99.
99.
99.
99.
99.
99.
99.
0.
.4
.9
.0
.4
.9
.9
.9
.0
.0
.0
.0
.0
.9
.9
.9
.9
.9
.9
.9
.9
.9
.9
.9
.9
.0
11
12
10
9
9
99
99
8
8
8
8
8
8
8
8
8
8
8
8
8
7
7
7
99
0
.8
.2
.0
.8
.5
.9
.9
.7
.0
.7
.0
.7
.1
.1
.1
.1
.1
.1
.1
.1
.0
.0
.0
.9
.0
99999
99999
99999
99999
99999
300
500
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
300
0
99999
99999
99999
99999
99999
500
5000
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
99999
65
99999
50
9999
500
10
-67-
-------
DISABLE DISABLE_N DISABLE_D
0 0 NO DISABLEMENT
1 1 FUEL CAP REMOVED
2 2 EVAP CANISTER REMOVED
3 3 FUEL CAP AND EVAP CANISTER REMOVED
4 4 CATALYST REMOVED
5 5 AIR CONDITIONING TURNED ON
6 6 WET TIRES
7 7 TEST WEIGHT = ETW + 1/3 (GVWR-ETW)
8 8 TEST WEIGHT = ETW + 2/3(GVWR-ETW)
9 9 TEST WEIGHT = GVWR
10 10 TEST WEIGHT = ETW + 1/2(GVWR-ETW)
11 11 EGR DISABLED
12 12 AIR PUMP REMOVED
13 13 CATALYST AND AIR PUMP REMOVED
14 14 AIR PUMP DISABLED
15 15 EVAP CANISTER ISOLATED OUTSIDE SHED
16 16 OXYGEN SENSOR DISCONNECTED
17 17 OXYGEN SENSOR DISCONNECTED, LEAD SHORTED
18 18 COOLANT TEMPERATURE SENSOR DISCONNECTED
19 19 THROTTLE POSITION SENSOR DISCONNECTED
20 20 EVAP CANISTER DISCONNECTED/OPEN
TEST_MODIF TEST_MOD_D
0 None
1 Auxiliary Fan Used
2 Old EOD Drain Hosing Used
3 20% Fuel Fill
4 60% Fuel Fill
5 80% Fuel Fill
6 Tested at much less than curbweight
7 Solar Loading Used (CFR 86.161-00)
-------
ME AS ID
MEAS DESCR
ENGINEERING UNITS
Degrees API
%volume
%volume
Brake horsepower-hour
Milligrams/Mile
Micrograms/Mile
Micrograms/Mile
Micrograms/Mile
Milligrams/Mile
Micrograms/Mile
Micrograms/Mile
Micrograms/Mile
Micrograms/Mile
Milligrams/Mile
API_GRAVIT Degrees API
AROMATICS Aromatic Content
BENZENE Benzene Content
BHPH Work performed
CO 00050000 Formaldehyde
C000050328 Benzo(a)pyrene emissions
C000053703 Dibenz(a,h)anthracene
C000056553 Benz(a)anthracene emissions
C000075070 Acetaldehyde
C000193395 Indeno(1,2,3-c,d)pyrene
C000205492 Benzo(b)fluoranthene emissions
C000207089 Benzo(k)fluoranthene emissions
C000218019 Chrysene emissions
C007664417 Ammonia
CETINDEX Cetane Index
CETNUM Cetane number
CHOKEMEAS Choke notch setting observed
CHOKESPEC Choke notch setting specified
CLOUDPOINT Cloudpoint
C_02 Oxygen concentration
DENSITY Density @ 60 deg F
DURATION Duration of Test
E000050000 Formaldehyde
E000075070 Acetaldehyde
E007664417 Ammonia
FINLCANWGT Final weight of vehicle's evap canister
FLASHPOINT Flashpoint
INITCANWGT Initial weight of vehicle's evap canister
METHANE Methane (CH4) Emissions
N20 Nitrous Oxide (N20) Emissions
NOXU Oxides of Nitrogen, Uncorrected for Humidity
OLEFIN Olefin Content %volume
OXYGENATE Oxygenate Content %volume
PMEC_DRI Elemental Carbon by Thermal Reflectance (DRI) Milligrams/Mile
MEAS ID MEAS DESCR ENGINEERING UNITS
Notches lean (-) , On index
Notches lean (-) , On index
deg. F
Percent
g/cm-03 @ 60 deg F
Seconds
Grams
Grams
Grams
grams
deg. F
grams
Grams/Mile
Grams/Mile
,y Grams/Mile
(0) , or Rich (+) ; -99=s
(0) , or Rich (+) ; -99=s
-69-
-------
PMHC_DRI
PMHC_SAE
PMIO_SAE
PMSO_SAE
PMT_CFR110
PM_<10.0u
PM_AG
PM_AL
PM_AU
PM_BA
PM_BR
PM_CA
PM_CD
PM_CL
PM_CU
PM_FE
PM_GA
PM_HG
PM_K
PM_LA
PM_MG
PM_MN
PM_MO
PM_NA
PM_NI
PM_NITRATE
PM_P
PM_PB
PM_PD
PM_S
PM_SB
PM_SI
PM_SN
PM_SR
PM_TI
PM_Y
PM_ZN
PM ZR
Organic Carbon by Thermal Reflectance (DRI)
Organic fraction of particulate matter SAE 872136
Inorganic fraction of pariculate matter SAE 872136
Sulfate fraction of particulate matter SAE 872136
Total particulate matter per CFR86.110-94
Particulate less than 10.0 micons in diameter
Silver in Particulate
Aluminum in Particulate
Gold in Particulate
Barium in Particulate
Bromine in Particulate
Calcium in Particulate
Cadmium in Particulate
Chlorine in Particulate
Copper in Particulate
Iron in Particulate
Gallium in Particulate
Mercury in Particulate
Potassium in Particulate
Lanthanum in Particulate
Magnesium in Particulate
Manganese in Particulate
Molybdenum in Particulate
Sodium in Particulate
Nickel in Particulate
Nitrates in Particulate
Phosphorus in Particulate
Lead in Particulate
Palladium in Particulate
Sulfur in Particulate
Antimony in Particulate
Silicon in Particulate
Tin in Particulate
Strontium in Particulate
Titanium in Particulate
Yttrium in Particulate
Zinc in Particulate
Zirconium in Particulate
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
Milligrams/Mile
-70-
-------
PPM_SULFUR
PSIA_RVP
PURGE_RATE
PURGE_STAT
PURGE_VOL
P_PMHC_SAE
P_PMIO_SAE
P_PMSO_SAE
RPMSPEC
R_METHANE
SATURATES
MEAS_ID
SOAK_MINS
SPECIFIC_G
T10
T50
T90
T95
TANK_LEVEL
TIMING
TIMING2
TIMINGSPEC
T_EP
T_IBP
VISCOSITY
V_ETHANOL
MEAS_ID
V_MTBE
V_TAME
WT% 02
Sulfur in Fuel by ASTM D 2622
Vapor Pressure by Appendix E Method 3
Parts Per Million
PSIA
Rate of airflow to evaporative emissions canister
1= PERFORMED; 2= INNACCESSIBLE; 3= EQUIPMENT DOWN
Volume of air going to evaporative canister
Organic fraction of particulate matter SAE 872136
Inorganic fraction of pariculate matter SAE 872136
Sulfate fraction of particulate matter SAE 872136
Liters/Minute
Liters
Milligrams/BHP
Milligrams/BHP
Milligrams/BHP
CATEGORIZED
Engine idle speed specification
Methane Emission Rate
Saturated Hydrocarbon Content
MEAS_DESCR
Soak time, (time since engine turned off)
Specific Gravity @ 60 Degrees
Temperature -- 10% Recovery
Temperature -- 50% Recovery
Temperature -- 90% Recovery
Temperature -- 95% Recovery
Fuel tank fill level (100=FULL)
Revolutions per minute
Grams/Hour
%volume
EXP_3
MINUTES
Specific Gravity
deg. F
deg.
deg.
deg.
F
F
F
Percent
Vacuum Disconnected)
Vacuum Connected)
Initial Engine Timing (with
Initial Engine Timing (with
Initial timing specification
Temperature -- End Point --100% Recovery
Temperature -- Initial Boiling Point --0
Viscosity at 40 Degrees C
Ethanol by OFID
MEAS_DESCR
MTBE by OFID
TAME by OFID
Weight Percent Oxygen
Degrees before
deg. F
Recovery deg. F
Centistokes
Volume Percent
EXP_3
Volume Percent
Volume Percent
Weight Percent
Degrees before(+) or after
Degrees before (+) or after
(+) or after (-) TDC
-) TDC
-) TDC
-71-
-------
MODE ID
MODE ID N MODE ID D
ASM_5015
ASM_2525
IDLE
IDLE_DRIVE
IDLE_2500
IDLE_AGAIN
50MPH
30MPH
IDLE_25X04
IDLE X05
IDLE X07
IDLE_25X08
IDLE X09
IDLE_25X11
IDLE X12
IDLE_25X14
IDLE X15
IDLE_25X17
IDLE X18
IDLE_25X19
IDLE_25X21
IDLE X22
30MPH X23
IDLE X24
1 ASM Test Procedure - 50% Load at 15 mph.
2 ASM Test Procedure - 25% Load at 25 mph.
3 Idle in Neutral
4 Idle in Drive, Assumes Automatic Transmission
5 Unloaded idle at 2500 rpm
6 Repeated Idle in Neutral, Needed for 4 Mode Tests
7 Steady speed driving at 50 miles per hour
8 Steady speed driving at 30 miles per hour
14 Unloaded idle at 2500 rpm; following 15 minute soak; step 4 of TEST_PROC = "XSI"
15 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 5 of TEST_PROC = "XSI"
17 Idle in Neutral; following 505 cycle; step 7 of TEST_PROC = "XSI"
18 Unloaded idle at 2500 rpm; following 30 sees of idle; step 8 of TEST_PROC = "XSI"
19 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 9 of TEST_PROC = "XSI"
21 Unloaded idle at 2500 rpm; following engine restart; step 11 of TEST_PROC = "XSI"
22 Idle in Neutral; following 30 sees of idle at 2500 rpm; steps 12-13 of TEST_PROC="XSI"
24 Unloaded idle at 2500 rpm; following 30 mins of idle; step 14 of TEST_PROC = "XSI"
25 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 15 of TEST_PROC = "XSI"
27 Unloaded idle at 2500 rpm; following engine restart; step 17 of TEST_PROC = "XSI"
28 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 18 of TEST_PROC = "XSI"
29 Unloaded idle at 2500 rpm; following 60 sees of idle; step 19 of TEST_PROC = "XSI"
31 Unloaded idle at 2500 rpm; previous step varies; step 21 of TEST_PROC = "XSI"
32 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 22 of TEST_PROC = "XSI"
33 Loaded (7 HP) cruise at 28-32 mph; following 1 min of idle; step 23 of TEST_PROC = "XSI1
34 Idle in Neutral; following 30 sees of 30mph cruise; step 24 of TEST_PROC = "XSI"
-72-
-------
MODE ID
MODE ID N MODE ID D
ASM_5015
ASM_2525
IDLE
IDLE_DRIVE
IDLE_2500
IDLE_AGAIN
50MPH
30MPH
IDLE_25X04
IDLE X05
IDLE X07
IDLE_25X08
IDLE X09
IDLE_25X11
IDLE X12
IDLE_25X14
IDLE X15
IDLE_25X17
IDLE X18
IDLE_25X19
IDLE_25X21
IDLE X22
30MPH X23
IDLE X24
1 ASM Test Procedure - 50% Load at 15 mph.
2 ASM Test Procedure - 25% Load at 25 mph.
3 Idle in Neutral
4 Idle in Drive, Assumes Automatic Transmission
5 Unloaded idle at 2500 rpm
6 Repeated Idle in Neutral, Needed for 4 Mode Tests
7 Steady speed driving at 50 miles per hour
8 Steady speed driving at 30 miles per hour
14 Unloaded idle at 2500 rpm; following 15 minute soak; step 4 of TEST_PROC = "XSI"
15 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 5 of TEST_PROC = "XSI"
17 Idle in Neutral; following 505 cycle; step 7 of TEST_PROC = "XSI"
18 Unloaded idle at 2500 rpm; following 30 sees of idle; step 8 of TEST_PROC = "XSI"
19 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 9 of TEST_PROC = "XSI"
21 Unloaded idle at 2500 rpm; following engine restart; step 11 of TEST_PROC = "XSI"
22 Idle in Neutral; following 30 sees of idle at 2500 rpm; steps 12-13 of TEST_PROC="XSI"
24 Unloaded idle at 2500 rpm; following 30 mins of idle; step 14 of TEST_PROC = "XSI"
25 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 15 of TEST_PROC = "XSI"
27 Unloaded idle at 2500 rpm; following engine restart; step 17 of TEST_PROC = "XSI"
28 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 18 of TEST_PROC = "XSI"
29 Unloaded idle at 2500 rpm; following 60 sees of idle; step 19 of TEST_PROC = "XSI"
31 Unloaded idle at 2500 rpm; previous step varies; step 21 of TEST_PROC = "XSI"
32 Idle in Neutral; following 30 sees of idle at 2500 rpm; step 22 of TEST_PROC = "XSI"
33 Loaded (7 HP) cruise at 28-32 mph; following 1 min of idle; step 23 of TEST_PROC = "XSI1
34 Idle in Neutral; following 30 sees of 30mph cruise; step 24 of TEST_PROC = "XSI"
-73-
-------
MODENAME
REFSPEED
SPEED FRAC
LOAD FRAC
MODENUM
MODE8NUM
MODE8WGHT
100R100
100R075
100R050
100R025
100R010
090R100
090R075
090R050
090R025
090R010
075R100
075R075
075R050
075R025
075R010
060R100
060R075
060R050
060R025
060R010
050R100
050R075
050R050
050R025
050R010
1001000
1001100
100G100
100R085
075R085
060R085
050R085
025R100
025R085
025R075
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
IDLE
IDLE
GCS
RATED
RATED
RATED
RATED
RATED
RATED
RATED
100
100
100
100
100
90
90
90
90
90
75
75
75
75
75
60
60
60
60
60
50
50
50
50
50
100
100
100
100
75
60
50
25
25
25
100
75
50
25
10
100
75
50
25
10
100
75
50
25
10
100
75
50
25
10
100
75
50
25
10
0
100
100
85
85
85
85
100
85
75
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
15
15
15
10
10
10
10
10
10
10
15
-74-
-------
025R050
025R025
025R010
010R100
010R085
010R075
010R050
010R025
010R010
091RE82
080RE63
063RE40
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
RATED
25
25
25
10
10
10
10
10
10
91
80
63
50
25
10
100
85
75
50
25
10
82
63
40
36
37
38
39
40
41
42
43
44
45
46
47
-75-
-------
Relationship to "old" Emission Factor (EF) Database;
Information not carried forward
• "Old" AMD Emission Factor (EF) Database is located at
I:\PROJECT\EMFACTOR\EF_FOXPRO
• Contains data collected from 1972 -1998 for a variety of purposes
• Data stored in approximately 500 essentially-separate tables.
• Tables named by "Prefix" indicating a type of data, and "Suffix"
indicating a test program.
• Explained further in top-level user document: EFREADME.TXT
• Data from EF82, EF90, EF98, IM89, IM90, IM91, IM92, NOX_ EV95,
API_, EF80, IM83, OF93, RL88, MI82, and IM80 programs already
loaded into MSOD. SP96 and SP86 programs being loaded.
• Some data items from old database not being carried into the MSOD:
- Long form owner questionnaire (QEST) data items, except those
included in short form (QST_)
- Vehicle driveability observation data (DRV_)
- Propane gain test result data (PROP)
- IM240 Test Results performed after repairs for which repair
description is lacking.
- Vehicle Preconditioning (PREC) data for IM240 Tests.
- 4M24IM89, and 4M24IM91, (which duplicates other data).
- Data with TEST_SEQ values of 27, 28, and 30 from IM89 Program
- FTP_RL88 and CAL_EF80 which contained questionable or
duplicate data
• Non-EPA Users can request copy of "old" database on CD-ROM.
-------
Section 4: Some Example SQL Queries
-77-
-------
********************************************************************************
* EXAMPLE QUERIES FOR MOBILE SOURCE OBSERVATION DATABASE
********************************************************************************
*
* 1 . ALL FTP TESTS OF FORD PRODUCTS
*
SELECT MS.MS_ID, MS.COMPANY, RES.TEST_PROC, DT.THC ;
FROM M_SOURCE MS, RESULT RES, DYNOTEST DT ;
WHERE MS.MS_ID = RES.MS_ID AND MS.MSJTYPE = RES.MSJTYPE ;
AND RES.RESULTID = DT.RESULTID;
AND RES.TEST_PROC = "FTP" AND MS.COMPANY = "FORD"
*
*
* 2. "AS RECEIVED" FTP TESTS
* DEPEND DIRECTLY ON A PROCUREMENT
* HAS NO PREVIOUS REPLICATE
* DONE AT STANDARD TEMPERATURE
* WITH VEHICLE NOT DISABLED
* ON STANDARD FUEL
*
SELECT RES.RESULTID ;
FROM RESULT RES, RESULT PRES ;
WHERE PRES.RESULTID = RES.CAUSE AND PRES.RES_KIND = "PROCURE";
AND RES.PREV_REP = 0 AND RES.NOMJTEMP = 75 AND RES.DISABLE = 0;
AND RES.TEST_PROC = "FTP" AND RES.FUEL_ID =06
*
*
* 3. CALCULATION OF NON-METHANE HYDROCARBON EMISSION RESULTS
* AT SUMMARY TEST LEVEL
*
SELECT DT.RESULTID, DT.THC, TM.MEASURE AS CH4, (DT.THC - TM.MEASURE) AS NMHC ;
FROM DYNOTEST DT, TESTMEAS TM ;
WHERE DT.RESULTID = TM.RESULTID AND TM.MEAS_ID = "METHANE" ;
AND DT.RESULTID = 5277
*
*
* 4. JOINING TOGETHER BAG LEVEL AND SUMMARY LEVEL RESULT INFORMATION
*
SELECT DB.RESULTID, DB.BAG_NUM, DT.THC, DB.BAGJTHC ;
FROM DYNOTEST DT, DYNO_BAG DB ;
WHERE DT.RESULTID = DB.RESULTID ;
AND DB.RESULTID = 5277;
ORDER BY DB.BAG_NUM
*
* 5. JOINING M_SOURCE, VEHICLE AND RESULT TO
* SELECT VEHICLES WITH HIGH MILEAGE
*
SELECT M.MS_ID, R.RESULTID, P.PROC_ODOM ;
FROM M_SOURCE M, RESULT R, PROCURE P ;
WHERE M.MS_ID = R.MS_ID AND ;
R.RESULTID = P.RESULTID AND P.PROC ODOM > 100000
-------
Section 5: How to Request a CD-ROM Copy of MSOD
Send an email message to mobile@epa.gov
Make reference to MSOD in subject line of message
Include your name, affiliation, and mailing address in
your message
Limit requests to one copy per office.
While EPA has made considerable effort to assure the
validity of the data in this database, the Agency is not
responsible for the validity of conclusions reached by
others using the data. New records are added
continuously to the data sample, though EPA cannot
guarantee that all currently relevant data is included in
the database.
Because additions and changes are being made to the
database, those using it regularly may wish to request
an updated copy every year or so.
-79-
------- |