Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
IMRG_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this incident merge (sequence: SIT209_SEQ)
MEMBER_INC_IDENTIFIER_IMRG NUMBER(9,0) No null 2 FK to INCIDENTS for "member" incident of this incident merge
STRATEGY_IDENTIFIER_IMRG NUMBER(9,0) Yes null 3 FK to SIT209_LOOKUP_CODES to identify the management strategy of the member incident at a point-in-time associated with this merge.
AREA_INVOLVED_IMRG NUMBER Yes null 4 The area involved of the member incident in this merge at a point-in-time.
AREA_INVOLVED_IMRG_UOM_ID NUMBER(9,0) Yes null 5 The area involved unit of measure identifier (FK to SIT209_LOOKUP_CODES).
PCT_CONTAINED_COMPLETED_IMRG NUMBER(4,1) Yes null 6 The %-Contained/Completed of the member incident in this merge at a point-in-time.  For example, a spill may be 65% contained, or flood response objectives may be 50% met.
PCT_CONT_COMPL_IMRG_UOM_ID NUMBER(9,0) Yes null 7 The %-Contained/Completed unit of measure identifier (FK to SIT209_LOOKUP_CODES).
EST_IM_COST_TO_DATE_IMRG NUMBER(11,2) Yes null 8 The estimated total incident costs to date associated with the member incident at a point-in-time for this incident merge based on currently available information.  Incident costs include estimates of all costs for the response, including all management and support activities per discipline, agency, or organizational guidance and policy. Damage assessment figures are not included, as they are impacts from the incident and not response costs.
SINGLE_RES_DESTROYED_IMRG NUMBER(9,0) Yes null 9 The number of single residences destroyed.
MULTIPLE_RES_DESTROYED_IMRG NUMBER(9,0) Yes null 10 The number of multiple residences destroyed.
MIXED_COM_RES_DESTROYED_IMRG NUMBER(9,0) Yes null 11 The number of mixed commercial/residential structures destroyed.
NON_RES_COM_PROP_DSTRYD_IMRG NUMBER(9,0) Yes null 12 The number of nonresidential commercial properties destroyed.
OTHER_MINOR_STRUCT_DSTRYD_IMRG NUMBER(9,0) Yes null 13 The number of other minor structures destroyed.
CIVILIAN_FATALITIES_IMRG NUMBER(9,0) Yes null 14 The number of civilian casualties.
CIVILIAN_INJURIES_IMRG NUMBER(9,0) Yes null 15 The number of civilian injuries.
RESPONDER_FATALITIES_IMRG NUMBER(9,0) Yes null 16 The number of responder casualties.
RESPONDER_INJURIES_IMRG NUMBER(9,0) Yes null 17 The number of responder injuries.
ANTICIPATED_COMP_DATE_IMRG DATE Yes null 18 The the date (month/day/year) at which time it is expected that incident objectives will be met for this Incident (209 Report).  This is often explained similar to incident containment or control, or the time at which the incident is expected to be closed or when significant incident support will be discontinued.
PCT_PERIM_TO_BE_CONTAINED_IMRG NUMBER(3,0) Yes null 19 The percent of the fire perimiter to be contained).
TO_EXPIRE VARCHAR2(1 BYTE) Yes null 20 Marks a merge relationship that is to be expired in Irwin.
IRWINIRID VARCHAR2(40 BYTE) Yes null 21 The Irwin relationship id.
SINGLE_RES_DAMAGED_IMRG NUMBER(9,0) Yes null 22 The number of other minor structures damaged.
SINGLE_RES_THREAT_IMRG NUMBER(9,0) Yes null 23 The number of other minor structures threatened.
MULTIPLE_RES_DAMAGED_IMRG NUMBER(9,0) Yes null 24 The number of multiple residences damaged.
MULTIPLE_RES_THREAT_IMRG NUMBER(9,0) Yes null 25 The number of multiple residences threatened.
MIXED_COM_RES_DAMAGED_IMRG NUMBER(9,0) Yes null 26 The number of mixed commercial/residential structures damaged.
MIXED_COM_RES_THREAT_IMRG NUMBER(9,0) Yes null 27 The number of mixed commercial/residential structures threatened.
NON_RES_COM_PROP_DAMAGED_IMRG NUMBER(9,0) Yes null 28 The number of nonresidential commercial properties damaged.
NON_RES_COM_PROP_THREAT_IMRG NUMBER(9,0) Yes null 29 The number of nonresidential commercial properties threatened.
OTHER_MINOR_STRUC_DAMAGED_IMRG NUMBER(9,0) Yes null 30 The number of other minor structures damaged.
OTHER_MINOR_STRUC_THREAT_IMRG NUMBER(9,0) Yes null 31 The number of other minor structures threatened.
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
IMRG_INC_MEMB_FK Foreign_Key null SIT209 INCIDENTS INC_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 null null null null
IMRG_LUCODES_AIUOM_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 null null null null
IMRG_LUCODES_PCUOM_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 null null null null
IMRG_LUCODES_STGY_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 null null null null
IMRG_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 SIT209 IMRG_PK null null
IMRG_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:13:20 SIT209 IMRG_UK null null
SYS_C00349891 Check "IMRG_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 30-MAR-17 11:13:20 null null null null
SYS_C00349892 Check "MEMBER_INC_IDENTIFIER_IMRG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 30-MAR-17 11:13:20 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER_IMRG 1
COLUMN_NAME COLUMN_POSITION
AREA_INVOLVED_IMRG_UOM_ID 1
COLUMN_NAME COLUMN_POSITION
PCT_CONT_COMPL_IMRG_UOM_ID 1
COLUMN_NAME COLUMN_POSITION
STRATEGY_IDENTIFIER_IMRG 1
COLUMN_NAME COLUMN_POSITION
IMRG_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER_IMRG 1
COLUMN_NAME COLUMN_POSITION
IMRG_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER_IMRG null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS 0
BLOCKS 5
AVG_ROW_LEN 0
SAMPLE_SIZE 0
LAST_ANALYZED 24-APR-19 22:20:56
LAST_ANALYZED_SINCE 24-APR-19 22:20:56



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_IMRG_TRG BEFORE EACH ROW SIT209 INSERT ENABLED INCIDENT_MERGE




TRIGGER "SIT209"."BRI_IMRG_TRG" 
 BEFORE
  INSERT
 ON SIT209.INCIDENT_MERGE
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set IMRG_IDENTIFIER on insert if not supplied.
    begin
      if :new.IMRG_identifier IS NULL then
        :new.IMRG_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 BRI_IMRG_TRG TRIGGER SIT209 INCIDENT_MERGE TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 30-MAR-17 11:13:20
LAST_DDL_TIME 24-APR-19 20:37:15
OWNER SIT209
TABLE_NAME INCIDENT_MERGE
TABLESPACE_NAME SIT209_DATA
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT null
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING YES
BACKED_UP N
NUM_ROWS 0
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 0
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 0
LAST_ANALYZED 24-APR-19 22:20:56
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS A table of associations between Incidents to capture information about incident "complexes" at a point-in-time.  It is used to capture data about the consolidation of individual incidents into a single "complex" incident due to merging of individual fire boundaries into a single fire or for consolidated management of distinct fires due to resource limitations or other management considerations.  Non-key attributes such as management (fire suppression) strategy, area involved, and estimated cost-to-date allow for the persistence of "member" incident-by-incident values of these attributes.  The relationship of the "parent" (complex) incident back to the parent incident ICS-209 report (INCIDENT_209_REPORTS) rather than directly back to the parent inicdent (INCIDENTS) allows for the persistence of "point-in-time" member incidents and aformentioned non-key attributes.  Note that member incidents referenced by the parent complex incident may or may not have ICS-209 Reports (child rows in the INCIDENT_209_REPORTS table) associated with them.
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
SIT209 IMRG_PK UNIQUE VALID NORMAL N NO null NO IMRG_IDENTIFIER null
SIT209 IMRG_UK UNIQUE VALID NORMAL N NO null NO MEMBER_INC_IDENTIFIER_IMRG null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 IMRG_PK SIT209 INCIDENT_MERGE IMRG_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 IMRG_UK SIT209 INCIDENT_MERGE MEMBER_INC_IDENTIFIER_IMRG 1 22 0 ASC