Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ICPXASC_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this incident complex association (sequence: SIT209_SEQ)
CPLX_INC209R_IDENTIFIER NUMBER(9,0) No null 2 FK to INCIDENT_209_REPORTS for "parent" Complex incident (209 report) of this incident complex association
MEMBER_INC_IDENTIFIER NUMBER(9,0) No null 3 FK to INCIDENTS for "member" incident of this incident complex association
STRATEGY_IDENTIFIER NUMBER(9,0) Yes null 4 FK to SIT209_LOOKUP_CODES to identify the management strategy of the member incident at a point-in-time associated with this incident complex.
AREA_INVOLVED NUMBER Yes null 5 The area involved of the member incident in this complex at a point-in-time.
AREA_INVOLVED_UOM_IDENTIFIER NUMBER(9,0) Yes null 6 The area involved unit of measure identifier (FK to SIT209_LOOKUP_CODES).
PCT_CONTAINED_COMPLETED NUMBER(4,1) Yes null 7 The %-Contained/Completed of the member incident in this complex at a point-in-time.  For example, a spill may be 65% contained, or flood response objectives may be 50% met.
PCT_CONT_COMPL_UOM_IDENTIFIER NUMBER(9,0) Yes null 8 The %-Contained/Completed unit of measure identifier (FK to SIT209_LOOKUP_CODES).
EST_IM_COST_TO_DATE NUMBER(11,2) Yes null 9 The estimated total incident costs to date associated with the member incident at a point-in-time for this incident complex 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_RESIDENCES_DESTROYED NUMBER(9,0) Yes null 10 The number of single residences destroyed.
MULTIPLE_RESIDENCES_DESTROYED NUMBER(9,0) Yes null 11 The number of multiple residences destroyed.
MIXED_COM_RES_DESTROYED NUMBER(9,0) Yes null 12 The number of mixed commercial/residential structures destroyed.
NON_RES_COM_PROPERTY_DESTROYED NUMBER(9,0) Yes null 13 The number of nonresidential commercial properties destroyed.
OTHER_MINOR_STRUCT_DESTROYED NUMBER(9,0) Yes null 14 The number of other minor structures destroyed.
CIVILIAN_FATALITIES NUMBER(9,0) Yes null 15 The number of civilian fatalities.
CIVILIAN_INJURIES NUMBER(9,0) Yes null 16 The number of civilian injuries.
RESPONDER_FATALITIES NUMBER(9,0) Yes null 17 The number of responder fatalities.
RESPONDER_INJURIES NUMBER(9,0) Yes null 18 The number of responder injuries.
ANTICIPATED_COMPLETION_DATE DATE Yes null 19 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 NUMBER(3,0) Yes null 20 The percent of the fire perimiter to be contained).
IRWINIRID VARCHAR2(40 BYTE) Yes null 21 The Irwin relationship id.
SINGLE_RESIDENCES_DAMAGED NUMBER(9,0) Yes null 22 The number of other minor structures damaged.
SINGLE_RESIDENCES_THREATENED NUMBER(9,0) Yes null 23 The number of other minor structures threatened.
MULTIPLE_RESIDENCES_DAMAGED NUMBER(9,0) Yes null 24 The number of multiple residences damaged.
MULTIPLE_RESIDENCES_THREATENED NUMBER(9,0) Yes null 25 The number of multiple residences threatened.
MIXED_COM_RES_DAMAGED NUMBER(9,0) Yes null 26 The number of mixed commercial/residential structures damaged.
MIXED_COM_RES_THREATENED NUMBER(9,0) Yes null 27 The number of mixed commercial/residential structures threatened.
NON_RES_COM_PROPERTY_DAMAGED NUMBER(9,0) Yes null 28 The number of nonresidential commercial properties damaged.
NON_RES_COM_PROPERTY_THREATEN NUMBER(9,0) Yes null 29 The number of nonresidential commercial properties threatened.
OTHER_MINOR_STRUCT_DAMAGED NUMBER(9,0) Yes null 30 The number of other minor structures damaged.
OTHER_MINOR_STRUCT_THREATENED 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
ICPXASC_INC209R_CPLX_FK Foreign_Key null SIT209 INCIDENT_209_REPORTS INC209R_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
ICPXASC_INC_MEMB_FK Foreign_Key null SIT209 INCIDENTS INC_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
ICPXASC_LUCODES_AIUOM_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
ICPXASC_LUCODES_PCUOM_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
ICPXASC_LUCODES_STGY_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
ICPXASC_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 ICPXASC_PK null null
ICPXASC_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 ICPXASC_UK null null
SYS_C00208281 Check "ICPXASC_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208282 Check "CPLX_INC209R_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208283 Check "MEMBER_INC_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
CPLX_INC209R_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
AREA_INVOLVED_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PCT_CONT_COMPL_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
STRATEGY_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
ICPXASC_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER 1
CPLX_INC209R_IDENTIFIER 2
COLUMN_NAME COLUMN_POSITION
ICPXASC_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
CPLX_INC209R_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
MEMBER_INC_IDENTIFIER null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 INCIDENT_COMPLEX_ASSOCS
INSERT IMSRMGR NO SIT209 INCIDENT_COMPLEX_ASSOCS
SELECT IMSRMGR NO SIT209 INCIDENT_COMPLEX_ASSOCS
UPDATE IMSRMGR NO SIT209 INCIDENT_COMPLEX_ASSOCS
SELECT FAMWEB_ETL NO SIT209 INCIDENT_COMPLEX_ASSOCS
SELECT FAMWEBREADONLY NO SIT209 INCIDENT_COMPLEX_ASSOCS
NAME VALUE
NUM_ROWS 0
BLOCKS 58
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_ICPXASC_TRG BEFORE EACH ROW SIT209 INSERT ENABLED INCIDENT_COMPLEX_ASSOCS




TRIGGER SIT209.BRI_ICPXASC_TRG
 BEFORE
  INSERT
 ON SIT209.INCIDENT_COMPLEX_ASSOCS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set ICPXASC_IDENTIFIER on insert if not supplied.
    begin
      if :new.icpxasc_identifier IS NULL then
        :new.icpxasc_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_ICPXASC_TRG TRIGGER SIT209 INCIDENT_COMPLEX_ASSOCS TABLE
SIT209 SIT209_UTIL PACKAGE BODY SIT209 INCIDENT_COMPLEX_ASSOCS TABLE
SIT209 INCIDENT_COMPLEX_MEMBERS_V VIEW SIT209 INCIDENT_COMPLEX_ASSOCS TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 13-DEC-12 10:15:06
LAST_DDL_TIME 24-APR-19 20:37:13
OWNER SIT209
TABLE_NAME INCIDENT_COMPLEX_ASSOCS
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 58
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 ENABLED
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 ICPXASC_PK UNIQUE VALID NORMAL N NO null NO ICPXASC_IDENTIFIER null
SIT209 ICPXASC_UK UNIQUE VALID NORMAL N NO null NO MEMBER_INC_IDENTIFIER, CPLX_INC209R_IDENTIFIER null
SIT209 ICPXASC_INC_MEMB_FK_I NONUNIQUE VALID NORMAL N NO null NO MEMBER_INC_IDENTIFIER null
SIT209 ICPXASC_INC209R_CPLX_FK_I NONUNIQUE VALID NORMAL N NO null NO CPLX_INC209R_IDENTIFIER null
SIT209 ICPXASC_LUCODES_STGY_FK_I NONUNIQUE VALID NORMAL N NO null NO STRATEGY_IDENTIFIER null
SIT209 ICPXASC_LUCODES_AIUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO AREA_INVOLVED_UOM_IDENTIFIER null
SIT209 ICPXASC_LUCODES_PCUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PCT_CONT_COMPL_UOM_IDENTIFIER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_PK SIT209 INCIDENT_COMPLEX_ASSOCS ICPXASC_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_UK SIT209 INCIDENT_COMPLEX_ASSOCS MEMBER_INC_IDENTIFIER 1 22 0 ASC
SIT209 ICPXASC_UK SIT209 INCIDENT_COMPLEX_ASSOCS CPLX_INC209R_IDENTIFIER 2 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_INC_MEMB_FK_I SIT209 INCIDENT_COMPLEX_ASSOCS MEMBER_INC_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_INC209R_CPLX_FK_I SIT209 INCIDENT_COMPLEX_ASSOCS CPLX_INC209R_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_LUCODES_STGY_FK_I SIT209 INCIDENT_COMPLEX_ASSOCS STRATEGY_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_LUCODES_AIUOM_FK_I SIT209 INCIDENT_COMPLEX_ASSOCS AREA_INVOLVED_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 ICPXASC_LUCODES_PCUOM_FK_I SIT209 INCIDENT_COMPLEX_ASSOCS PCT_CONT_COMPL_UOM_IDENTIFIER 1 22 0 ASC