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 name of the organization that is affiliated with a facility or project
(i.e., this data submittal).  Name of organization submitting the dataset.

Source type = Point.  Code table - SOURCE_TYPES

Year of inventory data in dataset.  A four digit year,  ie. 1998

Indicates that the data set contains criteria data, toxics data, or both.  Code
table - INVENTORY_TYPES

The complete name of the person, including first name, middle name or initial,
and surname.

The name that describes telephone number type, e.g., the CONTACT PHONE NUMBER.
Valid values include: Office, Fax, Mobile, Pager, Home.

A resource address usually consisting of the access protocol, the domain name,
and optionally, the path to a file or location.  Report Email.

The name that describes the type of electronic address reported.  Valid values
include: Email, Internet, Intranet, HTTP, FTP, Telnet, and WAIS. Report Email.

The name that describes the capacity or function that an organization or
individual serves for a facility or project.  Report value = Report Certifier. 
Code table - AFFILIATION_TYPE.  Report Certifier for NEI is EPA's point of
contact to either answer questions or identify whom to forward EPA program
questions concerning the data content in the file.

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 ;

/

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


      :new.created_by := user;
      :new.created_date := sysdate;
      :new.modified_by := user;
      :new.modified_date :=sysdate;

end ;
/