Name ORGANIZATION
Comment Organization table

Column
Name Is PK Is FK UDP Datatype Null Option Comment
ORGANIZATION_ID Yes No NUMBER(20) NOT NULL Unique System Assigned ID
ORGANIZATION_NAME No No VARCHAR2(80) NULL 
The name of the organization that is affiliated with a facility or project
(i.e., this data submittal).  Name of organization submitting the dataset.
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
UDP(s) of "ORGANIZATION_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ORGANIZATION_NAME" 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
Index
Name Member
XPKORGANIZATION
Member(s) of "XPKORGANIZATION" Index
Column
Name
ORGANIZATION_ID
Child Relationship
Child Table
Name
POINT_ER
Child Table
Name
POINT_EP
Child Table
Name
INVENTORY
Child Table
Name
ACTIVITY_FIRE_DETAIL
Child Table
Name
ACTIVITY_GEOGRAPHIC_DETAIL
Child Table
Name
ACTIVITY_METEOROLOGICAL_DETAIL
Child Table
Name
ACTIVITY_DETAIL
Child Table
Name
ACTIVITY_PERMIT
Child Table
Name
POINT_PE
Child Table
Name
POINT_EM
Child Table
Name
POINT_CE
Child Table
Name
POINT_EU
Child Table
Name
POINT_SI
Child Table
Name
ONROAD_EM
Child Table
Name
ONROAD_PE
Child Table
Name
NOTE
Child Table
Name
LOG
Child Table
Name
BIOGENIC_EM
Child Table
Name
AREA_EM
Child Table
Name
AREA_CE
Child Table
Name
AREA_PE
Child Table
Name
AREA_EP
Child Table
Name
TR
Child Table
Name
TRANSFER_FILE
Child Table
Name
USER_ORGANIZATION
Parent Relationship
Script
Name Code
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 ;

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