Name ACTIVITY_METEOROLOGICAL_DETAIL
Comment Activity meteorological detail table

Column
Name Is PK Is FK UDP Datatype Null Option Comment
PRIMARY_KEY Yes No NUMBER(20) NOT NULL Unique System Assigned ID
RECORD_TYPE No No VARCHAR2(2) NULL A code that identifies the type of Record
STATE_AND_COUNTY_FIPS_CODE No No VARCHAR2(5) NULL 
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).
STATE_FACILITY_IDENTIFIER No No VARCHAR2(15) NULL Unique ID number used by a state/local/tribal agency to identify a facility.
EMISSION_UNIT_ID No No VARCHAR2(6) NULL Emission Unit ID
EMISSION_RELEASE_POINT_ID No No VARCHAR2(6) NULL Emission Release Point ID
PROCESS_ID No No VARCHAR2(6) NULL Process ID
SCC No No VARCHAR2(10) NULL EPA Source Category Code for Area and Mobile Sources.
START_DATE No No VARCHAR2(15) NULL Start Date
END_DATE No No VARCHAR2(15) NULL End Date
START_TIME No No NUMBER(4) NULL 
Start time of the activity.  Format: HHMM
END_TIME No No NUMBER(4) NULL 
End time of the activity.  Format: HHMM
ACTIVITY_ID No No VARCHAR2(10) NULL FIRE ID
ACTIVITY_TYPE_CODE No No VARCHAR2(20) NULL Activity Type Code
ACTIVITY_NAME No No VARCHAR2(50) NULL Fire NAME
TEMPERATURE No No NUMBER NULL Average temperature in degrees Celcius during period
WIND_SPEED No No NUMBER NULL 
Average wind speed in kilometers per hour during 
period
WIND_DIRECTION No No NUMBER NULL Average wind direction out of 360 degrees during period
BAROMETRIC_PRESSURE No No NUMBER NULL Average barometric pressure in millibars
HUMIDITY No No NUMBER NULL Averge relative percent humidity during period
CONDITIONS No No VARCHAR2(20) NULL 
Description of weather conditions   "Clear, Windy, Rain, Snow, Sleet, Tornado,
Hurricane,Partly Sunny, Cloudy"
DROUGHT No No NUMBER NULL 
Number of days of drought preceeding emission period
RAINFALL No No NUMBER NULL 
Inches of rainfall during period
CLOUD_COVER_FRACTION No No NUMBER NULL Cloud Cover Fraction
VISIBLE_RADIATION No No NUMBER NULL Visible Radiation
DIURNAL_TEMPERATURE_CHANGE No No NUMBER NULL Diurnal Temperature Change
SUBMITTAL_FLAG No No VARCHAR2(4) NULL 
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.
TRIBAL_CODE No No VARCHAR2(3) NULL 
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).
CREATED_BY No No VARCHAR2(20) NULL Created by User ID
CREATED_DATE No No DATE NULL Created Date
MODIFIED_BY No No VARCHAR2(20) NULL Modified by User ID
MODIFIED_DATE No No DATE NULL Modified date
LOG_ID No No NUMBER(20) NULL Unique System Assigned ID
DISPOSITION_STATUS No No VARCHAR2(1) NULL Status of the record
APPLY_STATUS No No VARCHAR2(1) NULL Status of the record
TRANSFER_JOB_ID No Yes NUMBER(20) NULL Transfer job ID
RECORD_NUMBER No No NUMBER(20) NULL Unique System Assigned ID
FK_TABLE_NAME No No VARCHAR2(32) NULL Foreign Key Table Name
FK_PRIMARY_KEY No No NUMBER(20) NULL Unique System Assigned ID
STATE_FIPS No No VARCHAR2(2) NULL FIPS code of the state
COUNTY_FIPS No No VARCHAR2(3) NULL FIPS code of the county
SOURCE_INVENTORY_ID No No NUMBER(20) NULL Unique System Assigned ID
SOURCE_INVENTORY_PK No No NUMBER(20) NULL Unique System Assigned ID
COUNTRY_CODE No No VARCHAR2(10) NULL Country Code
INVENTORY_ID No Yes NUMBER(20) NULL Unique System Assigned ID
ORGANIZATION_ID No Yes NUMBER(20) NULL Unique System Assigned ID
UDP(s) of "PRIMARY_KEY" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "RECORD_TYPE" Column
Range Check Null Check Valid Table/Values
None None Valid Table/List
UDP(s) of "STATE_AND_COUNTY_FIPS_CODE" Column
Range Check Null Check Valid Table/Values
None None Valid Table/Values
UDP(s) of "STATE_FACILITY_IDENTIFIER" Column
Range Check Null Check Valid Table/Values
None Mandatory None
UDP(s) of "EMISSION_UNIT_ID" Column
Range Check Null Check Valid Table/Values
None Mandatory None
UDP(s) of "EMISSION_RELEASE_POINT_ID" Column
Range Check Null Check Valid Table/Values
None Mandatory None
UDP(s) of "PROCESS_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "SCC" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "START_DATE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "END_DATE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "START_TIME" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "END_TIME" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ACTIVITY_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ACTIVITY_TYPE_CODE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ACTIVITY_NAME" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "TEMPERATURE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "WIND_SPEED" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "WIND_DIRECTION" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "BAROMETRIC_PRESSURE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "HUMIDITY" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "CONDITIONS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "DROUGHT" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "RAINFALL" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "CLOUD_COVER_FRACTION" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "VISIBLE_RADIATION" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "DIURNAL_TEMPERATURE_CHANGE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "SUBMITTAL_FLAG" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "TRIBAL_CODE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "CREATED_BY" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "CREATED_DATE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "MODIFIED_BY" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "MODIFIED_DATE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "LOG_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "DISPOSITION_STATUS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "APPLY_STATUS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "TRANSFER_JOB_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "RECORD_NUMBER" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "FK_TABLE_NAME" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "FK_PRIMARY_KEY" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "STATE_FIPS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "COUNTY_FIPS" Column
Range Check Null Check Valid Table/Values
None Mandatory None
UDP(s) of "SOURCE_INVENTORY_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "SOURCE_INVENTORY_PK" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "COUNTRY_CODE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "INVENTORY_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ORGANIZATION_ID" Column
Range Check Null Check Valid Table/Values
None None None
Index
Name Member
XPKACTIVITY_METEOROLOGICAL_DET
XAK1ACTIVITY_METEOROLOGICAL_DE
XIE1ACTIVITY_METEOROLOGICAL_DE
XIE2ACTIVITY_METEOROLOGICAL_DE
XIF1ACTIVITY_METEOROLOGICAL_DE
XIF2ACTIVITY_METEOROLOGICAL_DE
XIF3ACTIVITY_METEOROLOGICAL_DE
Member(s) of "XPKACTIVITY_METEOROLOGICAL_DET" Index
Column
Name
PRIMARY_KEY
Member(s) of "XAK1ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
TRANSFER_JOB_ID
Column
Name
RECORD_NUMBER
Member(s) of "XIE1ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
FK_TABLE_NAME
Column
Name
FK_PRIMARY_KEY
Member(s) of "XIE2ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
STATE_FIPS
Column
Name
COUNTY_FIPS
Column
Name
TRIBAL_CODE
Member(s) of "XIF1ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
TRANSFER_JOB_ID
Member(s) of "XIF2ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
INVENTORY_ID
Member(s) of "XIF3ACTIVITY_METEOROLOGICAL_DE" Index
Column
Name
ORGANIZATION_ID
Child Relationship
Parent Relationship
Parent Table
Name
ORGANIZATION
Parent Table
Name
INVENTORY
Parent Table
Name
TRANSFER_FILE
Script
Name Code
BI_SPLIT 
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 ;

/
BU 
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 ;

/