Name INVENTORY
Comment Inventory table

Column
Name Is PK Is FK UDP Datatype Null Option Comment
INVENTORY_ID Yes No NUMBER(20) NOT NULL Unique System Assigned ID
INVENTORY_NAME No No VARCHAR2(20) NULL Name of Inventory
COMMENTS No No VARCHAR2(4000) NULL Inventory Comments
LOCKED No No VARCHAR2(1) NULL Status of inventory (locked/unlocked)
INVENTORY_TYPE_CODE No Yes NUMBER(20) NULL Unique System Assigned ID
INVENTORY_YEAR No Yes NUMBER(4) NULL 
Year of inventory data in dataset.  A four digit year,  ie. 1998
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
ORGANIZATION_ID No Yes NUMBER(20) NULL Unique System Assigned ID
UDP(s) of "INVENTORY_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "INVENTORY_NAME" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "COMMENTS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "LOCKED" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "INVENTORY_TYPE_CODE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "INVENTORY_YEAR" 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 "ORGANIZATION_ID" Column
Range Check Null Check Valid Table/Values
None None None
Index
Name Member
XPKINVENTORY
XIF1INVENTORY
XIF6INVENTORY
XIF7INVENTORY
Member(s) of "XPKINVENTORY" Index
Column
Name
INVENTORY_ID
Member(s) of "XIF1INVENTORY" Index
Column
Name
INVENTORY_YEAR
Member(s) of "XIF6INVENTORY" Index
Column
Name
INVENTORY_TYPE_CODE
Member(s) of "XIF7INVENTORY" Index
Column
Name
ORGANIZATION_ID
Child Relationship
Child Table
Name
ACTIVITY_METEOROLOGICAL_DETAIL
Child Table
Name
ACTIVITY_PERMIT
Child Table
Name
ACTIVITY_GEOGRAPHIC_DETAIL
Child Table
Name
ACTIVITY_FIRE_DETAIL
Child Table
Name
ACTIVITY_DETAIL
Child Table
Name
POINT_CE
Child Table
Name
POINT_EM
Child Table
Name
POINT_PE
Child Table
Name
POINT_EP
Child Table
Name
POINT_ER
Child Table
Name
POINT_EU
Child Table
Name
POINT_SI
Child Table
Name
TR
Child Table
Name
AREA_CE
Child Table
Name
AREA_EM
Child Table
Name
AREA_PE
Child Table
Name
AREA_EP
Child Table
Name
ONROAD_PE
Child Table
Name
ONROAD_EM
Child Table
Name
TRANSFER_FILE
Child Table
Name
NOTE
Child Table
Name
BIOGENIC_EM
Parent Relationship
Parent Table
Name
ORGANIZATION
Parent Table
Name
INVENTORY_TYPE
Parent Table
Name
INVENTORY_YEAR
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 ;
/