Computer Associates's Report Template Builder - DataModelDictionary Document

Name	ACTIVITY_FIRE_DETAIL
Comment	Activity fire 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)	NOT 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).
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(15)	NULL	FIRE ID
ACTIVITY_TYPE_CODE	No	No		VARCHAR2(20)	NULL	Activity Type Code
ACTIVITY_NAME	No	No		VARCHAR2(15)	NULL	Fire NAME
FUEL_TYPE	No	No		VARCHAR2(50)	NULL	Fuel Type
PRE_BURN_FUEL_LOADING	No	No		NUMBER	NULL	Pre Burn Fueld Loading
TYPE_OF_BURN	No	No		VARCHAR2(50)	NULL	Type of Burn
CLASSIFICATION	No	No		VARCHAR2(50)	NULL	Classification
DAILY_TRACKING	No	No		VARCHAR2(50)	NULL	Daily Tracking
FUEL_CONSUMPTION	No	No		NUMBER	NULL	Fuel Consumption
NON_BURNING_TECHNIQUES	No	No		VARCHAR2(50)	NULL	Non Burning Techniques
GENERAL_CAUSE	No	No		VARCHAR2(50)	NULL	General Cause
SPECIFIC_CAUSE	No	No		VARCHAR2(50)	NULL	Specific Cause
TIME_DISCOVERED	No	No		NUMBER(4)	NULL	Time Discovered
DATE_CONTROLLED	No	No		NUMBER(8)	NULL	Date Controlled
TIME_CONTROLLED	No	No		NUMBER(4)	NULL	Time Controlled
FUEL_LOADING_FACTOR	No	No		NUMBER	NULL	Fuel Loading Factor
STATE_SMOLDERING_AUG_FACTOR	No	No		NUMBER	NULL	State Smoldering Aug Factor
PILE_FRACTION	No	No		NUMBER	NULL	Pile Fraction
NON_PILE_FRACTION	No	No		NUMBER	NULL	Non Pile Fraction
FUEL_LOADING_FACTOR_SOURCE	No	No		VARCHAR2(2)	NULL	FUEL LOADING FACTOR SOURCE
EMISSION_FACTOR_SOURCE_CO	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_NH3	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_NOX	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM_FIL	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM_PRI	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM10FIL	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM10PRI	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM25FIL	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM25PRI	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_PM_CON	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_SO2	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_VOC	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_EC	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_OC	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
EMISSION_FACTOR_SOURCE_CH4	No	No		VARCHAR2(2)	NULL	EMISSION FACTOR SOURCE
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).
COUNTRY_CODE	No	No		VARCHAR2(10)	NULL	Country Code
STATE_FIPS	No	No		VARCHAR2(2)	NULL	FIPS code of the state
COUNTY_FIPS	No	No		VARCHAR2(3)	NULL	FIPS code of the county
TRANSFER_JOB_ID	No	Yes		NUMBER(20)	NULL	Transfer job ID
RECORD_NUMBER	No	No		NUMBER(20)	NULL	Unique System Assigned ID
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
FK_TABLE_NAME	No	No		VARCHAR2(32)	NULL	Tablename where Foreign_Key relates
FK_PRIMARY_KEY	No	No		NUMBER(20)	NULL	Primary_Key of foreign table
SOURCE_INVENTORY_ID	No	No		NUMBER(20)	NULL	Unique System Assigned ID
SOURCE_INVENTORY_PK	No	No		NUMBER(20)	NULL	Unique System Assigned ID
INVENTORY_ID	No	Yes		NUMBER(20)	NULL	Unique System Assigned ID
ORGANIZATION_ID	No	Yes		NUMBER(20)	NULL	Unique System Assigned ID
SECTOR_CODE	No	Yes		VARCHAR2(2)	NULL	Sector Code

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 "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 "FUEL_TYPE" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "PRE_BURN_FUEL_LOADING" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "TYPE_OF_BURN" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "CLASSIFICATION" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "DAILY_TRACKING" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "FUEL_CONSUMPTION" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "NON_BURNING_TECHNIQUES" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "GENERAL_CAUSE" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "SPECIFIC_CAUSE" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "TIME_DISCOVERED" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "DATE_CONTROLLED" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "TIME_CONTROLLED" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "FUEL_LOADING_FACTOR" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "STATE_SMOLDERING_AUG_FACTOR" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "PILE_FRACTION" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "NON_PILE_FRACTION" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "FUEL_LOADING_FACTOR_SOURCE" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_CO" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_NH3" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_NOX" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM_FIL" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM_PRI" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM10FIL" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM10PRI" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM25FIL" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM25PRI" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_PM_CON" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_SO2" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_VOC" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_EC" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_OC" Column

Range Check	Null Check	Valid Table/Values
None	None	None

UDP(s) of "EMISSION_FACTOR_SOURCE_CH4" 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 "COUNTRY_CODE" 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 "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 "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 "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 "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 "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

UDP(s) of "SECTOR_CODE" Column

Range Check	Null Check	Valid Table/Values
None	None	None

Index

Name	Member
XPKACTIVITY_FIRE_DETAIL
XAK1ACTIVITY_FIRE_DETAIL
XIE1Activity_Fire_Detail
XIF1ACTIVITY_FIRE_DETAIL
XIF2ACTIVITY_FIRE_DETAIL
XIF3ACTIVITY_FIRE_DETAIL
XIF4ACTIVITY_FIRE_DETAIL

Member(s) of "XPKACTIVITY_FIRE_DETAIL" Index

Column

Name

PRIMARY_KEY

Member(s) of "XAK1ACTIVITY_FIRE_DETAIL" Index

Column

Name

TRANSFER_JOB_ID

Column

Name

RECORD_NUMBER

Member(s) of "XIE1Activity_Fire_Detail" Index

Column

Name

STATE_AND_COUNTY_FIPS_CODE

Column

Name

SCC

Column

Name

START_DATE

Column

Name

END_DATE

Member(s) of "XIF1ACTIVITY_FIRE_DETAIL" Index

Column

Name

INVENTORY_ID

Member(s) of "XIF2ACTIVITY_FIRE_DETAIL" Index

Column

Name

ORGANIZATION_ID

Member(s) of "XIF3ACTIVITY_FIRE_DETAIL" Index

Column

Name

TRANSFER_JOB_ID

Member(s) of "XIF4ACTIVITY_FIRE_DETAIL" Index

Column

Name

SECTOR_CODE

Child Relationship

Parent Relationship

Parent Table

Name

SECTOR

Parent Table

Name

TRANSFER_FILE

Parent Table

Name

ORGANIZATION

Parent Table

Name

INVENTORY

Script

Name

Code

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 ;

/

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 ;

/