NP Input Templates - Batch Input Format Report
The NP Input Templates - Batch Input Format Report provides Nonpoint Input Templates data in a CSV file in a format ready for batch processing to upload template data in the Gateway.
The following report criteria are required when generating a NP Input Templates - Batch Input Format Report
Report Criteria
-
Agency Organization
The following filters are available to select from within the accordion style tables: (Filter Name – Table Column Headings)
Available Filters
- Agency Organization
- Templates
- Inventory Year
- Columns
The following Columns will always be defaulted and included at a minimum in the report
Defaulted and Included
- Agency
Name
- Template
Name
- FIPS Code
- SCC
- MSN Code
- Template NAICS Code
- Month
- Age Group
- FWHA Road Types
- Fuel Sub Type ID
- Data Type
- End Use
- Pollutant Code
- Unit of Measure Code
- Template Value Code
- Agency Value
- Agency Source
- Agency Source Year
- Agency Note
- Default Value
- Default Source
- Default Source Year
- Default Note
- Data Tags
Columns in the NP Input Templates - Batch Input Format Report
| Column Header | Database Definition | Output Sample Value | Defaulted | Required |
|---|---|---|---|---|
| Agency Name | Description of the State, Tribal or Local Agency. | ADEM | Yes | Yes |
| Template Name | Central Database - Sulfur and Ash Content | Yes | Yes | |
| FIPS Code | Numeric codes representing all states, outlying areas of the United States, freely associated states, and trust territories of the United States, as listed in FIPS publication 10-4 | 1091 | Yes | Yes |
| SCC | Source classification code, which identifies the major industrial classification of a source. | 2802004001 | Yes | Yes |
| MSN Code | Code that identifies or defines State Energy Data System (SEDS) Mnemonic Series Names (MSN) for energy consumptions variables. | Yes | Yes | |
| SIC | Yes | Yes | ||
| NAICS Code | Yes | Yes | ||
| Month | Yes | Yes | ||
| Age Group | Code that defines age brackets used in certain Nonpoint input templates. | Yes | Yes | |
| Road Type Code | Yes | Yes | ||
| Fuel Sub Type Code | Yes | Yes | ||
| Data Type | Data Type Code defines the type of activity the data represents in the Input Template. | Yes | Yes | |
| End Use | End Use Code defines the type of activity the data represents in the Input Template. | Yes | Yes | |
| Pollutant Code | Unique identifier of an EIS pollutant code record. | Yes | Yes | |
| Unit of Measure Code | Yes | Yes | ||
| Template Value Code | FACTOR | Yes | Yes | |
| Agency Value | Yes | Yes | ||
| Agency Source | Yes | Yes | ||
| Agency Source Year | Yes | Yes | ||
| Agency Note | Yes | Yes | ||
| Default Value | 0.0131 | Yes | Yes | |
| Default Source | See Residential Heating and ICI Tool NEMOs | Yes | Yes | |
| Default Source Year | 2020 | Yes | Yes | |
| Default Note | Yes | Yes | ||
| Data Tag | Yes | Yes |