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).

Start time of the activity.  Format: HHMM

End time of the activity.  Format: HHMM

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;   If LATLON measure, report value in decimal degrees.

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;  If LATLON measure, report value in decimal degrees.

Distance from coordinates in kilometers - only valid 
when Coordinate_Designation = "Centroid"

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).

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.

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 ;

/