(XLS 51K)

Document Sample
(XLS       51K) Powered By Docstoc
					NEI Input Format - Area and Non Road Mobile Sources Version 3.0 Released April 2003, Revised Nov 2003 Record: Transmittal
Position
Mandatory / Necessary

If Using MSAccess Table: tblAreaTR Data Element RECORD TYPE Data Type Length Data Definitions CHARACTER 2 A code that identifies the type of Record Use Convention Notes See User's Guide for more information TR
Code table STATE_AND_COUNTY_FIPS_CODE. Also see notes for Tribal Code. If State and County FIPS code does not apply, enter value = 0000 (e.g., 5 zeroes). ] Code table - TRANSACTION_TYPES A four digit year, ie. 1998 Code table - INVENTORY_TYPES Format: YYYYMMDD The initial number is 1 and it is incremented by 1 for every submission per transaction type. Report percent value with 2 decimal places. EPA's single point of contact for questions that may arise concerning how the data in the file was developed. See also Affiliation Type.

Begin End Criteria 1 2 M

Toxics M

Field Name strRecordType

Field Type Text

3 8 88 90

7 87 89 93

M M M M M M M

M M M M M M M

STATE AND COUNTY FIPS CODE ORGANIZATION NAME TRANSACTION TYPE INVENTORY YEAR INVENTORY TYPE CODE TRANSACTION CREATION DATE

CHARACTER CHARACTER CHARACTER NUMBER CHARACTER NUMBER

5 The FIPS code for the state and county. The name of the organization that is affiliated with a 80 facility or project (i.e., this data submittal). 2 Original or Correction (replacement) data set. 4 Year of inventory data in dataset.
Indicates that the data set contains criteria data, toxics

strStateCountyFIPs strOrganizationName strTransactionType intInventoryYear strInventoryTypeCode lngTransactionCreationDate

Text Text Text Integer Text Lng Intgr

94 103 104 111 112 115 116 120 121 200

10 data, or both. 8 Creation date of transmittal data.
A unique report number that differentiates this submission

INCREMENTAL SUBMISSION NUMBER NUMBER RELIABILITY INDICATOR DECIMAL TRANSACTION COMMENTS CHARACTER

201 270 271 285

M M

M M

CONTACT PERSON NAME CONTACT PHONE NUMBER

CHARACTER CHARACTER

286 295

M

M

TELEPHONE NUMBER TYPE NAME

CHARACTER

296 395

M

M

ELECTRONIC ADDRESS TEXT

CHARACTER

396 405 406 430

M M

M M

ELECTRONIC ADDRESS TYPE NAME SOURCE TYPE

CHARACTER CHARACTER

4 from others. 5 DARS Numeric (composite) score for overall inventory. 80 General comments regarding transmittal. The complete name of the contact person, including first name, middle name or initial, and surname. Lead 70 contact for organization transmitting dataset. 15 The phone number for the contact name. The name that describes telephone number type, e.g., the CONTACT PHONE NUMBER. Valid values 10 include: Office, Fax, Mobile, Pager, Home. A resource address usually consisting of the access protocol, the domain name, and optionally, the path to 100 a file or location. The name that describes the type of electronic address reported. Valid values include: Email, 10 Internet, Intranet, HTTP, FTP, Telnet, and WAIS. 25 Source type = Area or Nonroad Mobile.

intIncrementalSubmissionNumber Integer sngReliabilityIndicator Single strTransactionComments Text

strContactPersonName strContactPhoneNumber

Text Text

Report a voice communication number available during normal work hours, i.e., Office.

strTelephoneNumberTypeName

Text

Report Email.

strElectronicAddressText

Text

Report Email. Code table - SOURCE_TYPES Code table - AFFILIATION_TYPE. Report Certifier for NEI is EPA's point of contact to either answer

strElectronicAddressTypeName strSourceType

Text Text

431 470 471 474

M M

M M

AFFILIATION TYPE FORMAT VERSION

CHARACTER DECIMAL

The name that describes the capacity or function that questions or identify whom to forward EPA an organization or individual serves for a facility or program questions concerning the data content in the file. 40 project. Report value = Report Certifier.
Indicates the NEI Input Format version number 4 of the dataset. Key field and Code table implementation. Code table - TRIBAL_CODES. If Tribal Code does not apply, enter value = 000 (e.g., 3 zeroes).

strAffiliationType sngFormatVersion

Text Single

475 477

M

M

TRIBAL CODE

CHARACTER

Codes that represent American Indian tribes and 3 Alaskan Native entities.

strTribalCode

Text

NEI Input Format - Area and Non Road Mobile Sources Version 3.0 Released April 2003, Revised Nov 2003 Record: Emission Process
Position
Mandatory / Necessary

If Using MSAccess Table: tblAreaEP Data Type Length Data Definitions CHARACTER 2 A code that identifies the type of Record Use Convention Notes See User's Guide for more information EP
Code table - STATE_AND_COUNTY_FIPS_CODE. Also see notes for Tribal Code. If State and County FIPS code does not apply, enter value = 0000 (e.g., 5 zeroes).

Begin End Criteria 1 2 M

Toxics M

Data Element RECORD TYPE

Field Name strRecordType

Field Type Text

3 8

7 17

M M

M M N

STATE AND COUNTY FIPS CODE SCC PROCESS MACT CODE EMISSION PROCESS DESCRIPTION SIC NAICS WINTER THROUGHPUT PCT SPRING THROUGHPUT PCT SUMMER THROUGHPUT PCT FALL THROUGHPUT PCT ANNUAL AVG DAYS PER WEEK ANNUAL AVG WEEKS PER YEAR ANNUAL AVG HOURS PER DAY ANNUAL AVG HOURS PER YEAR HEAT CONTENT SULFUR CONTENT ASH CONTENT

CHARACTER CHARACTER CHARACTER CHARACTER CHARACTER CHARACTER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER DECIMAL DECIMAL DECIMAL

5 The FIPS code for the state and county. 10 EPA Source Category Code for Area and Mobile Sources. 6 78 4 6
Maximum Achievable Control Technology for HAP regulated sources. A text description of the Emission Process. Standard Industrial Classification code system. North American Industry Classification code.

strStateCountyFIPs strSCC strProcessMACTCode strEmissionProcessDescription strSIC strNAICS intWinterThroughputPCT intSpringThroughputPCT intSummerThroughputPCT intFallThroughputPCT intAnnualAvgDaysPerWeek intAnnualAvgWeeksPerYear intAnnualAvgHoursPerDay intAnnualAvgHoursPerYear sngHeatContent sngSulfurContent sngAshContent

Text Text Text Text Text Text Integer Integer Integer Integer Integer Integer Integer Integer Single Single Single

Obtain current list of valid SCCs on http://www.epa.gov/ttn/chief/codes/index.html Code table - MACT_CATEGORY_CODE
Code table - SIC Code table - NAICS

18 23 24 101 102 105 106 111 112 114 115 117 118 120 121 123 124 124 125 126 127 128 129 132 133 140 141 145 146 150 151 156 N N N N N N N N

The percentage a process operates during the 3 spring months. Whole number between 0 to 100. The percentage a process operates during the 3 spring months. Whole number between 0 to 100. The percentage a process operates during the 3 spring months. Whole number between 0 to 100. The percentage a process operates during the 3 spring months. Whole number between 0 to 100.
Average number of days per week an emission process

1 is active within year.
Average number of weeks per year an emission process 2 is active. Average number of hours per day an emission process is 2 active within year. Average number of hours per year an emission process 4 is active.

N

PROCESS MACT COMPLIANCE STATUS CHARACTER

157 160

SUBMITTAL FLAG

CHARACTER

The heat content of a fuel in million BTU's per 8 Ton of coal, 1000 Gals of oil, or million SCF gas. 5 The sulfur content of a fuel (mass percent). 5 The ash content of a fuel (mass percent). Major/Area classification and status under CAAA 6 Sections 112&129. Submittal status of record when providing data corrections to NEI. Add; Delete; Revise/ Del;or 4 Revise/ Add Codes that represent American Indian tribes and 3 Alaskan Native entities.

Code table - MACT COMPLIANCE STATUS See User's guide instruction. Enter applicable code - A; D; RD; or RA.

strProcessMACTComplianceStatus Text

strSubmittalFlag

Text

161 163

M

M

TRIBAL CODE

CHARACTER

Key field and Code table implementation. Code table TRIBAL_CODES. If Tribal Code does not apply, enter value = 000 (e.g., 3 zeroes). strTribalCode

Text

NEI Input Format - Area and Non Road Mobile Sources Version 3.0 Released April 2003, Revised Nov 2003 Record: Emission Period
Position Begin End 1 2
Mandatory / Necessary

Criteria M

Toxics M

Data Element RECORD TYPE

Data Type Length Data Definitions CHARACTER 2 A code that identifies the type of Record

Use Convention Notes See User's Guide for more information PE
Code table - STATE_AND_COUNTY_FIPS_CODE. Also see notes for Tribal Code. If State and County FIPS code does not apply, enter value = 0000 (e.g., 5 zeroes).

If Using MSAccess Table: tblAreaPE Field Field Name Type strRecordType Text

3 8

7 17

M M

M M

STATE AND COUNTY FIPS CODE CHARACTER SCC CHARACTER

5 The FIPS code for the state and county. 10 EPA Source Category Code for Area and Mobile Sources.

strStateCountyFIPs strSCC

Text Text

Obtain current list of valid SCCs on http://www.epa.gov/ttn/chief/codes/index.html

18

25

M

M

START DATE

NUMBER

8 Start date of the period in which reported emissions occur.

26 34 36 40 44 54 64 68 78 79 81 83 87

33 35 39 43 53 63 67 77 78 80 82 86 90

M

M

END DATE START TIME END TIME

NUMBER NUMBER NUMBER DECIMAL CHARACTER NUMBER CHARACTER NUMBER NUMBER NUMBER NUMBER CHARACTER

8 End date of the period in which reported emissions occur. 2 4 Start time of the activity. 4 End time of the activity. 10 10 4 10
Numeric value of process activity. Throughput unit of measure. Material code for material processed. A descriptor indicating whether material is used or produced. Avg no. days/wk the process is active within 1 the time period specified. Avg no. wks/yperiod the process is active within 2 the time period specified. Avg no. hrs/day the process is active within 2 the time period specified. Avg no. hrs/period the process is active within 4 the time period specified.

Format: YYYYMMDD. See User's Guide instruction on how to designate time period for annual or average season day emissions. lngStartDate Format: YYYYMMDD. See User's Guide instruction on how to designate time period for annual or average season day emissions. lngEndDate Format: HHMM Format: HHMM Report actual throughput for the emission period designated, e.g., Start Date, End Date. Code table - UNITS Code table - MATERIALS_PROCESSED Code table - MATERIALS IO Operating parameter applied when emission period is less than annual. Operating parameter applied when emission period is less than annual. Operating parameter applied when emission period is less than annual. Operating parameter applied when emission period is less than annual.

Lng Integer

strBlankField intStartTime intEndTime sngActualThroughput strThroughputUnitNumerator intMaterial strMaterialIO intPeriodDaysPerWeek intPeriodWeeksPerPeriod intPeriodHoursPerDay intPeriodHoursPerPeriod strSubmittalFlag

Lng Integer Text Integer Integer Single Text Integer Text Integer Integer Integer Integer Text

N N N N N N N N

ACTUAL THROUGHPUT THROUGHPUT UNIT NUMERATOR MATERIAL MATERIAL I/O PERIOD DAYS PER WEEK PERIOD WEEKS PER PERIOD PERIOD HOURS PER DAY PERIOD HOURS PER PERIOD SUBMITTAL FLAG

Submittal status of record when providing data corrections 4 to NEI. Add; Delete; Revise/ Del;or Revise/ Add Codes that represent American Indian tribes and 3 Alaskan Native entities.

See User's guide instruction. Enter applicable code - A; D; RD; or RA.
Key field and Code table implementation. Code table TRIBAL_CODES. If Tribal Code does not apply, enter value = 000 (e.g., 3 zeroes).

91

93

M

M

TRIBAL CODE

CHARACTER

strTribalCode

Text

NEI Input Format - Area and Non Road Mobile Sources Version 3.0 Released April 2003, Revised Nov 2003 Record: Control Equipment
Position
Mandatory / Necessary

If Using MSAccess Table: tblAreaCE Data Type Length Data Definitions CHARACTER 2 A code that identifies the type of Record Use Convention Notes See User's Guide for more information CE
Code table - STATE_AND_COUNTY_FIPS_CODE. Also see notes for Tribal Code. If State and County FIPS code does not apply, enter value = 0000 (e.g., 5 zeroes).

Begin End Criteria 1 2 M

Toxics M

Data Element RECORD TYPE

Field Name strRecordType

Field Type Text

3 8 18 27 32 37 42 46 50

7 17 26 31 36 41 45 49 89

M M M N N N M

M M M N N N M

STATE AND COUNTY FIPS CODE SCC POLLUTANT CODE PRIMARY PCT CONTROL EFFICIENCY PCT CAPTURE EFFICIENCY TOTAL CAPTURE CONTROL EFFICIENCY PRIMARY DEVICE TYPE CODE SECONDARY DEVICE TYPE CODE CONTROL SYSTEM DESCRIPTION

CHARACTER CHARACTER CHARACTER DECIMAL DECIMAL DECIMAL CHARACTER CHARACTER CHARACTER

5 The FIPS code for the state and county. 10 EPA Source Category Code for Area and Mobile Sources. 9 Pollutant Code 5 The percent effectiveness of primary control device. 5 5 4 4 40
Numeric value for percentage capture efficiency of control system. Collective (aggregate) value for all controls. The primary type of control equipment used. Secondary control device type. Description of control equipment chain.

strStateCountyFIPs

Text

Obtain current list of valid SCCs on http://www.epa.gov/ttn/chief/codes/index.html
Code table - POLLUTANTS

strSCC Text strPollutantCode Text sngPrimaryPCTControlEfficiency Single sngPCTCaptureEfficiency sngTotalCaptureControlEfficiency strPrimaryDeviceTypeCode strSecondaryDeviceTypeCode strControlSystemDescription Single Single Text Text Text

Code table - CONTROL_DEVICE_TYPES Code table - CONTROL_DEVICE_TYPES

90

93

SUBMITTAL FLAG

CHARACTER

Submittal status of record when providing data corrections to NEI. Add; Delete; Revise/ Del;or 4 Revise/ Add Codes that represent American Indian tribes and 3 Alaskan Native entities.

See User's guide instruction. Enter applicable code - A; D; RD; or RA.
Key field and Code table implementation. Code table TRIBAL_CODES. If Tribal Code does not apply, enter value = 000 (e.g., 3 zeroes).

strSubmittalFlag

Text

94

96

M

M

TRIBAL CODE

CHARACTER

strTribalCode

Text

NEI Input Format - Area and Non Road Mobile Sources Version 3.0 Released April 2003, Revised Nov 2003 Record: Emission
Position Begin End 1 2
Mandatory / Necessary

If Using MSAccess Table: tblAreaEM Data Type Length Data Definitions CHARACTER 2 A code that identifies the type of Record Use Convention Notes See User's Guide for more information EM Code table STATE_AND_COUNTY_FIPS_CODE. Also see notes for Tribal Code. If State and County FIPS code does not apply, enter value = 0000 (e.g., 5 zeroes). Obtain current list of valid SCCs on http://www.epa.gov/ttn/chief/codes/index.html Code table - POLLUTANTS Format: YYYYMMDD. See User's Guide instruction on how to designate time period for annual or average season day emissions. Format: YYYYMMDD. See User's Guide instruction on how to designate time period for annual or average season day emissions. Format: HHMM Format: HHMM Unit for criteria emissions: annual = TON; average season day = LBS. Field Name strRecordType Field Type Text

Criteria M

Toxics M

Data Element RECORD TYPE

3 8 18 27

7 17 26 37

M M M

M M M

STATE AND COUNTY FIPS CODE SCC POLLUTANT CODE

CHARACTER CHARACTER CHARACTER

5 The FIPS code for the state and county. EPA Source Category Code for 10 Area and Mobile Sources. 9 Pollutant Code 11 Start date of the period in which reported 8 emissions occur. End date of the period in which reported 8 emissions occur. 2 4 Start time of the activity. 4 End time of the activity. 10 Numeric value of emission. Unit of measure for reported emissions value. If criteria emissions, report unit: annual = TON; 10 average season day = LBS. Code describing temporal designation of emissions reported, i.e., Entire Period, Average 2 Weekday, etc. DARS Numeric (composite) score for SCC level emissions. The numeric value of the emission factor. Unit of measure for emission factor numerator. Unit of measure for emission factor denominator. Material code for material processed. A descriptor indicating whether material is used or 10 produced. 5 Code description of method used to derive 2 emissions. A reliability indicator code for emission factor 5 rating. Measure of the percent effectiveness of the 5 control strategy. The code identifying the rule effectiveness 2 method. Percent of source category emissions affected by 5 the applied rule. of record when providing data Submittal status corrections to NEI. Add; Delete; Revise/ Del;or 4 Revise/ Add 5 10 10 10 4 Codes that represent American Indian tribes and 3 Alaskan Native entities.

strStateCountyFIPs strSCC strPollutantCode strBlankField

Text Text Text Text

38

45

M

M

START DATE

NUMBER

lngStartDate

Lng Intgr

46 54 56 60 64

53 55 59 63 73

M

M

END DATE START TIME END TIME

NUMBER NUMBER NUMBER DECIMAL

lngEndDate strBlankField2 intStartTime intEndTime dblEmissionNumericValue

Lng Intgr Text Integer Integer Double

M

M

EMISSION NUMERIC VALUE

74

83

M

M

EMISSION UNIT NUMERATOR

CHARACTER

84

85

M

M

EMISSION TYPE

CHARACTER

Code table - UNITS. Code table - EMISSION_TYPES. See User's Guide instruction on how to designate time period & emission type for annual or average season day emissions.

strEmissionUnitNumerator

Text

strEmissionType

Text

86 91 101 111 121

90 100 110 120 124

N N N N N

EM RELIABILITY INDICATOR FACTOR NUMERIC VALUE FACTOR UNIT NUMERATOR FACTOR UNIT DENOMINATOR MATERIAL MATERIAL I/O

DECIMAL DECIMAL CHARACTER CHARACTER NUMBER CHARACTER

Report value with 2 decimal places. Code table - UNITS Code table - UNITS Code table - MATERIALS_PROCESSED Code table - MATERIAL IO

sngEMReliabilityIndicator sngFactorNumericValue strFactorUnitNumerator strFactorUnitDenominator intMaterial strMaterialIO strBlankField3

Single Single Text Text Integer Text Text

125 134 135 139 140 141 142 146 147 151 152 153 154 158 159 162

EMISSION CALCULATION METHOD CODE CHARACTER EF RELIABILITY INDICATOR N RULE EFFECTIVENESS RULE EFFECTIVENESS METHOD RULE PENETRATION SUBMITTAL FLAG CHARACTER DECIMAL CHARACTER DECIMAL CHARACTER

Code table - EMISSION_CALC_METHODS Code table -RELIABILITY_INDICATORS

strEmissionCalculationMethodCode Text strEFReliabilityIndicator sngRuleEffectivenss Text Single Text Single Text

Code table - RULE_EFFECT_METHODS

strRuleEffectivenessMethod sngRulePenetration

See User's guide instruction. Enter applicable code - A; D; RD; or RA.

strSubmittalFlag

163 165

M

M

TRIBAL CODE

CHARACTER

Key field and Code table implementation. Code table TRIBAL_CODES. If Tribal Code does not apply, enter value = 000 (e.g., 3 zeroes). strTribalCode

Text