The FIPS code for the state and county.  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).

The height (in feet) of a stack.  Report value as measured in feet.

The diameter (in feet) of a stack.  Report value as measured in feet.

Numeric value for stack to fenceline distance (in feet).  Report value as
measured in feet.

The temperature of an exit gas stream (degree Fahrenheit).  Report value as
measured in Fahrenheit.

The velocity of an exit gas stream (feet per second).   Report value as
measured in feet/second.

Numeric value of stack gas flow rate in actual cubic feet per second.   Report
value as measured in cubic feet/second.

Longitude measure in decimal degrees of the angular distance on a meridian east
or west of the prime meridian.  Negative (-) data point for N America. Include
(-) sign, Ex. -123.234561; or UTM Easting in kilometers.    If LATLON measure,
report value in decimal degrees.  If UTM, report value for UTM zone.

strAttributeDescription
Latitude measure in decimal degrees of the angular distance on a meridian north
or south of the equator.  Positive (+) data point for N America. Include (+)
sign, Ex. +78.123456; or UTM Northing in kilometers. If LATLON measure, report
value in decimal degrees.  If UTM, report value for UTM zone.

Zone number in UTM coordinate system.  Required if XY COORDINATE TYPE = UTM.

Type of coordinate system used, eg., LATLON or UTM.    Code table -
XY_COORD_TYPE

Horizontal area of fugitive emissions.  Numeric value of horizontal dimension.

Release height (above terrain) of fugitive emissions.  Numeric value of release
height.

Submittal status of record when providing data corrections to NEI.  Add;
Delete; Revise/ Del;or Revise/ Add   See User's guide instruction. Enter
applicable code - A; D; RD; or RA.

Method used to determine the lat and lon coordinates for a point on the earth. 
Code table - HORIZONTAL_COLLECTION_METHOD

Code that represents the reference datum used to determine the lat / lon
coordinates.

The code that represents the place for which geographic coordinates were
established.  Code value should be 106 (e.g., Point where substance is
released).  Code table - REFERENCE_POINT

The number that represents the proportional distance on the ground for one unit
of measure on the map or photo.  Applicable only when a map has been used to
determine lat / lon.

The code that represents the party responsible for providing the lat / lon
coordinates. Code table - COORDINATE_DATA_SOURCE

Codes that represent American Indian tribes and Alaskan Native entities  Key
field and Code table implementation.  Code table - TRIBAL_CODES.  If Tribal Code
does not apply, enter value = 000 (e.g., 3 zeroes).

create or replace trigger  %TableOwner.%Substr(%TableName,1,15)_BI_Split
before insert on %TableOwner.%TableName for each row
declare new_id number;
begin

      select  %TableOwner.SEQ_%TableName.nextval into new_id from dual;
      :new.%PK() := new_id;
      :new.created_by := user;
      :new.created_date := sysdate;
      :new.modified_by := user;
      :new.modified_date :=sysdate;
      :new.state_fips := substr(:new.state_and_county_fips_code,1,2);
      :new.county_fips := substr(:new.state_and_county_fips_code,3);

end ;

/

create or replace trigger  %TableOwner.%Substr(%TableName,1,21)_BU
before update on %TableOwner.%TableName for each row
begin

      :new.modified_by := user;
      :new.modified_date :=sysdate;
end ;

/