Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
INCIDENT_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this incident (sequence: SIT209_SEQ)
INCIDENT_NUMBER VARCHAR2(20 BYTE) No null 2 The user-assigned number assigned to this incident based on current guidance.  The incident number may vary by jurisdiction and discipline.  Examples include: A computer-aided dispatch (CAD) number;  An accounting number;  A county number;  A disaster declaration number;  A combination of the State, unit/agency ID, and a dispatch system number;  A mission number;  Any other unique number assigned to the incident and derived by means other than those above.
DONWCGU_PROT_UNIT_IDENTIFIER NUMBER(9,0) Yes null 3 FK to DISPATCH_OFFICE_NWCG_UNITS for protection unit and dispatch office for this incident.  This is a transitory key (part of a mandatory-exclusive arc) used for incidents created within the SIT-209 application or downloaded from iRWIn after instantiation of an "initial" ICS-209, at (and after) which time the Dispatch Office for this incident becomes known and use of this key supplants the FK to NWCG_UNITS.
INCIDENT_NAME VARCHAR2(50 BYTE) No null 4 The the full name assigned to this incident.
INCTYP_IDENTIFIER NUMBER(9,0) No null 5 FK to SIT209_LOOKUP_CODES for the most current type of incident for this incident.  Note that incident type can change over time, such as a prescribed burn (planned ingition) changing to a wildfire if the burn goes out of control.
CAUSE_IDENTIFIER NUMBER(9,0) Yes null 6 FK to SIT209_LOOKUP_CODES for the current known cause of this incident.
DISCOVERY_DATE DATE Yes null 7 The most current date/time that this incident was discovered/started (not the report date/time or operational period).
POO_LATITUDE NUMBER(10,7) Yes null 8 The most current latitude of the point-of-origin for this Incident - Datum should be NAD83.
POO_LONGITUDE NUMBER(10,7) Yes null 9 The most current longitude of the point-of-origin for this Incident - Datum should be NAD83.
POO_STATE_CODE VARCHAR2(2 BYTE) Yes null 10 FK to COMMONDATA.STATES for most current point-of-origin State for this Incident.
POO_CITY VARCHAR2(50 BYTE) Yes null 11 The most current city (nearest) location of the point-of-origin for this Incident.
POO_SHORT_LOCATION_DESC VARCHAR2(80 BYTE) Yes null 12 The most current short (<80 characters) description of the location of the point-of-origin for this Incident.
POO_US_NGR_ZONE VARCHAR2(5 BYTE) Yes null 13 The most current National Grid Reference (NGR) zone of the point-of-origin for this Incident - Datum should be NAD83.
POO_US_NGR_XCOORD NUMBER(9,0) Yes null 14 The most current National Grid Reference (NGR) x-coordinate of the point-of-origin for this Incident - Datum should be NAD83.
POO_US_NGR_YCOORD NUMBER(9,0) Yes null 15 The most current National Grid Reference (NGR) y-coorindate of the point-of-origin for this Incident - Datum should be NAD83.
POO_LD_TWP VARCHAR2(5 BYTE) Yes null 16 The most current PLSS township (tier) of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_RGE VARCHAR2(5 BYTE) Yes null 17 The most current PLSS range of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_SEC NUMBER(2,0) Yes null 18 The most current PLSS section of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_QTR_SEC VARCHAR2(2 BYTE) Yes null 19 The most current PLSS quarter-section of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_QTR_QTR_SEC VARCHAR2(2 BYTE) Yes null 20 The most current PLSS quarter-quarter-section of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_QTR_QTR_QTR_SEC VARCHAR2(2 BYTE) Yes null 21 The most current PLSS quarter-quarter-quarter-section of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_LD_QTR_QTR_QTR_QTR_SEC VARCHAR2(2 BYTE) Yes null 22 The most current PLSS quarter-quarter-quarter-quarter-section of the point-of-origin for this Incident. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
POO_UTM_ZONE VARCHAR2(5 BYTE) Yes null 23 The most current UTM Zone of the point-of-origin for this Incident.
POO_UTM_EASTING NUMBER(6,0) Yes null 24 The most current UTM Easting of the point-of-origin for this Incident - Datum should be NAD83.
POO_UTM_NORTHING NUMBER(7,0) Yes null 25 The most current UTM Northing of the point-of-origin for this Incident - Datum should be NAD83.
INCIDENT_AREA NUMBER(20,6) Yes null 26 The most current total area involved for this incident (could be Initial, Updated, or Final area).
INC_AREA_UOM_IDENTIFIER NUMBER(9,0) Yes null 27 FK to SIT209_LOOKUP_CODES for Area unit of measure.
EST_IM_COST_TO_DATE NUMBER(11,2) Yes null 28 The most current estimated total incident costs to date for the entire incident based on currently available information for this incident.  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.
PCT_CONTAINED_COMPLETED NUMBER(3,0) Yes null 29 The most recent %-Contained/Completed for this Incident.  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 30 The most recent %-Contained/Completed Unit of Measure Identifier (FK to SIT209_LOOKUP_CODES) for this Incident.
POO_COUNTY_CODE VARCHAR2(3 BYTE) Yes null 31 FK to COMMONDATA.COUNTIES for most current point-of-origin County for this Incident.
CREATED_BY VARCHAR2(30 BYTE) No null 32 The FAMWEB user that created this record.  This is an audit column that will most generally be populated via row-level database trigger(s).
CREATED_DATE DATE No null 33 The date this record was created.  This is an audit column that will most generally be populated via row-level database trigger(s).
LAST_MODIFIED_BY VARCHAR2(30 BYTE) No null 34 The FAMWEB user that last modified this record.  This column will also reflect the created_by user between the time of record creation (insert) and next modification (update).  This is an audit column that will most generally be populated via row-level database trigger(s).
LAST_MODIFIED_DATE DATE No null 35 The date this record was last modified.  This column will also reflect the created_date between the time of record creation (insert) and next modification (update).  This is an audit column that will most generally be populated via row-level database trigger(s).
PLANNED_START_DATE DATE Yes null 36 The most current planned start date/time for a planned incident (eg. prescribed burn, etc.).
PLANNED_DURATION NUMBER Yes null 37 The most current projected time duration of a planned incident (eg. prescribed burn, etc.).
PLANNED_DUR_UOM_IDENTIFIER NUMBER(9,0) Yes null 38 FK to SIT209_LOOKUP_CODES for planned duration unit-of-measure of a planned incident (eg. prescribed burn, etc.).
PLANNED_INCIDENT_SIZE NUMBER Yes null 39 The most current planned incident size (eg. planned burn area, etc.) for a planned incident (eg. prescribed burn, etc.).
PLANNED_INC_SZ_UOM_IDENTIFIER NUMBER(9,0) Yes null 40 FK to SIT209_LOOKUP_CODES for incident size unit-of-measure for a planned incident (eg. prescribed burn, etc.).
POO_DONWCGU_OWN_IDENTIFIER NUMBER(9,0) Yes null 41 FK to DISPATCH_OFFICE_NWCG_UNITS for the most current Ownership Unit at point-of-origin of this Incident.
POO_LD_PM_IDENTIFIER NUMBER(9,0) Yes null 42 FK to SIT209_LOOKUP_CODES for the most recent point-of-origin Principal Meridian for this Incident
SINGLE_COMPLEX_FLAG VARCHAR2(1 BYTE) No 'S'  43 Flag indicating whether this incident is a "S"ingle incident or an incident "C"omplex.
IRWIN_IDENTIFIER VARCHAR2(40 BYTE) Yes null 44 The unique identifier (GUID) of this incident as identified within iRWIn. Used as a "soft FK" to the corresponding incident in the iRWIn database.
EXT_SYSTEM_LAST_MODIFIED_BY VARCHAR2(30 BYTE) Yes 'ics209' 45 The name/abbreviation/identifier of the application system (from iRWIn) that last modified this incident (ex. WFDSS, WildCAD, FireCode, etc.).  Definition from iRWIn: "ArcGIS Server Username of system that last modified the IRWIN Incident record."
EXT_SYSTEM_LAST_MODIFIED_DATE DATE Yes sysdate 46 The date this incident was last modified (from iRWIn) by the external system specified in EXT_SYSTEM_LAST_MODIFIED_BY.  Definition from iRWIn: "Date/time that the IRWIN Incident record was last modified."
FIRECODE VARCHAR2(6 BYTE) Yes null 47 The alphanumeric code used to track costs for incident suppression expenditures. Example: fireCode = K1B4 (Definition and example from iRWIn)
NWCG_PROT_UNIT_IDENTIFIER NUMBER(9,0) Yes null 48 The FK to NWCG Units for the protection unit for this incident.  This is a transitory key (part of a mandatory-exclusive arc) used for incidents downloaded from iRWIn prior to instantiation of an "initial" ICS-209, at (and after) which time the Dispatch Office for this incident becomes known and use of this key is supplanted by the FK to DISPATCH_OFFICE_NWCG_UNITS (an associative entity that resolves the M:M relationship between Dispatch Offices and NWCG Units).
LOCAL_TIMEZONE_IDENTIFIER NUMBER(9,0) Yes null 49 The FK to SIT209_LOOKUP_CODES for the local timezone used for all time values in the most recent ICS-209 report for this Incident.
COMPLEXITY_LEVEL_NARR VARCHAR2(4000 BYTE) Yes null 50 Any narrative/text about the most recent incident complexity for this Incident as determined by Unified/Incident Commanders, if available or used.  Most of the time the incident management team managing the incident will determine the complexity (e.g. a T-1 team assigned makes it a T-1 incident, etc.).
INCIDENT_COMMANDERS_NARR VARCHAR2(4000 BYTE) Yes null 51 Any narrative/text describing the latest Incident Commanders for this Incident. Typically the last name of the Incident Commander is entered.  If the incident is under a Unified Command, it is the primary Incident Commanders listed by last name separated by a comma. (For example: "Hendrix - St. Paul PD, Plant - St. Paul FD,...").
COMPLEXITY_LEVEL_IDENTIFIER NUMBER(9,0) Yes null 52 The most recent Fire Management Complexity Level Identifier (FK to SIT209_LOOKUP_CODES) for this Incident.
UNIFIED_COMMAND_FLAG VARCHAR2(1 BYTE) No 'N'  53 A Y/N flag indicating whether there is more than one agency with incident jurisdiction or when incidents cross political jursidictions for this Incident. Under Unified Command, agencies work together through their designated Incident Commanders at a single incident command post to estalish common objectives and issue a single Incident Action Plan.
INC_MGMT_ORG_IDENTIFIER NUMBER(9,0) Yes null 54 The Incident Management Organization (type) Identifier (FK to SIT209_LOOKUP_CODES) for this Incident.
COMPLEX_PARENT_PLACEHOLDER NUMBER(9,0) Yes null 55 A temporary placeholder to hold parent complex incident ids after new incident created via background Irwin update
MERGE_PARENT_ID NUMBER(9,0) Yes null 56 The id of the parent merge incident.
IRWINIRID VARCHAR2(40 BYTE) Yes null 57 The Irwin relationship id.
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
INC_CNTY_FK Foreign_Key null COMMONDATA COUNTIES CTY_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_LUCODES_CAUSE_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
INC_LUCODES_CPXL_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:08:11 null null null null
INC_LUCODES_IAUOM_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
INC_LUCODES_IMO_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 03-JUN-15 16:46:58 null null null null
INC_LUCODES_ITYP_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
INC_LUCODES_LTZONE_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 16-OCT-14 18:34:43 null null null null
INC_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
INC_LUCODES_PDUOM_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
INC_LUCODES_PLSZUOM_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
INC_LUCODES_PMERIDIAN_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
INC_MERGE_PARENT_FK Foreign_Key null SIT209 INCIDENTS INC_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 30-MAR-17 11:12:56 null null null null
INC_NWCG_POO_OWN_UNIT_FK Foreign_Key null SIT209 DISPATCH_OFFICE_NWCG_UNITS DONWCGU_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
INC_NWCG_PROT_UNIT_FK Foreign_Key null SIT209 DISPATCH_OFFICE_NWCG_UNITS DONWCGU_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
INC_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:05 SIT209 INC_PK null null
INC_QQQQSEC_CK Check POO_LD_QTR_QTR_QTR_QTR_SEC IN ('NE','SE','NW','SW') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_QQQSEC_CK Check POO_LD_QTR_QTR_QTR_SEC IN ('NE','SE','NW','SW') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_QQSEC_CK Check POO_LD_QTR_QTR_SEC IN ('NE','SE','NW','SW') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_QSEC_CK Check POO_LD_QTR_SEC IN ('NE','SE','NW','SW') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_SCFLAG_CK Check SINGLE_COMPLEX_FLAG IN ('S','C') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_STATES_FK Foreign_Key null COMMONDATA STATES ST_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC_UC_CK Check UNIFIED_COMMAND_FLAG IN ('Y','N') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 03-JUN-15 16:46:58 null null null null
SYS_C00208210 Check "INCIDENT_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208211 Check "INCIDENT_NUMBER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208213 Check "INCIDENT_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208214 Check "INCTYP_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208215 Check "CREATED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208216 Check "CREATED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208217 Check "LAST_MODIFIED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208218 Check "LAST_MODIFIED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00208219 Check "SINGLE_COMPLEX_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:05 null null null null
SYS_C00279620 Check "UNIFIED_COMMAND_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 03-JUN-15 16:46:57 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
POO_STATE_CODE 1
POO_COUNTY_CODE 2
COLUMN_NAME COLUMN_POSITION
CAUSE_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
COMPLEXITY_LEVEL_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
INC_AREA_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
INC_MGMT_ORG_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
INCTYP_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
LOCAL_TIMEZONE_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PCT_CONT_COMPL_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PLANNED_DUR_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PLANNED_INC_SZ_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
POO_LD_PM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
MERGE_PARENT_ID 1
COLUMN_NAME COLUMN_POSITION
POO_DONWCGU_OWN_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
INCIDENT_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
POO_LD_QTR_QTR_QTR_QTR_SEC null
COLUMN_NAME COLUMN_POSITION
POO_LD_QTR_QTR_QTR_SEC null
COLUMN_NAME COLUMN_POSITION
POO_LD_QTR_QTR_SEC null
COLUMN_NAME COLUMN_POSITION
POO_LD_QTR_SEC null
COLUMN_NAME COLUMN_POSITION
SINGLE_COMPLEX_FLAG null
COLUMN_NAME COLUMN_POSITION
POO_STATE_CODE 1
COLUMN_NAME COLUMN_POSITION
UNIFIED_COMMAND_FLAG null
COLUMN_NAME COLUMN_POSITION
INCIDENT_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
INCIDENT_NUMBER null
COLUMN_NAME COLUMN_POSITION
INCIDENT_NAME null
COLUMN_NAME COLUMN_POSITION
INCTYP_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
CREATED_BY null
COLUMN_NAME COLUMN_POSITION
CREATED_DATE null
COLUMN_NAME COLUMN_POSITION
LAST_MODIFIED_BY null
COLUMN_NAME COLUMN_POSITION
LAST_MODIFIED_DATE null
COLUMN_NAME COLUMN_POSITION
SINGLE_COMPLEX_FLAG null
COLUMN_NAME COLUMN_POSITION
UNIFIED_COMMAND_FLAG null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 INCIDENTS
INSERT IMSRMGR NO SIT209 INCIDENTS
SELECT IMSRMGR NO SIT209 INCIDENTS
UPDATE IMSRMGR NO SIT209 INCIDENTS
SELECT FAMWEB_ETL NO SIT209 INCIDENTS
SELECT FAMWEBREADONLY NO SIT209 INCIDENTS
NAME VALUE
NUM_ROWS 6778
BLOCKS 874
AVG_ROW_LEN 188
SAMPLE_SIZE 6778
LAST_ANALYZED 10-JUN-19 22:01:30
LAST_ANALYZED_SINCE 10-JUN-19 22:01:30



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_INCIDENT_TRG BEFORE EACH ROW SIT209 INSERT ENABLED INCIDENTS
BRIU_AUDIT_INCIDENT_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE ENABLED INCIDENTS




TRIGGER SIT209.BRI_INCIDENT_TRG
 BEFORE
  INSERT
 ON SIT209.INCIDENTS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set INCIDENT_IDENTIFIER on insert if not supplied.
    begin
      if :new.incident_identifier IS NULL then
        :new.incident_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
TRIGGER SIT209.BRIU_AUDIT_INCIDENT_TRG
 BEFORE
  INSERT OR UPDATE
 ON SIT209.INCIDENTS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
DECLARE
  vAction varchar2(30) := null;
BEGIN
  if Inserting then
    vAction := 'inserting';
  elsif Updating then
    vAction := 'updating';
  end if;
  sit209.sit209_util.setAuditColumns(:new.created_by,
                                     :new.created_date,
                                     :new.last_modified_by,
                                     :new.last_modified_date,
                                     vAction);
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 INCIDENT_209_REPORTS_UV VIEW SIT209 INCIDENTS TABLE
SIT209 TUID_INC209R_IO_TRG TRIGGER SIT209 INCIDENTS TABLE
SIT209 INCIDENT_209_REPORTS_V VIEW SIT209 INCIDENTS TABLE
SIT209 BRI_INCIDENT_TRG TRIGGER SIT209 INCIDENTS TABLE
SIT209 BRIU_AUDIT_INCIDENT_TRG TRIGGER SIT209 INCIDENTS TABLE
SIT209 SIT209_UTIL PACKAGE BODY SIT209 INCIDENTS TABLE
SIT209 INCIDENT_COMPLEX_MEMBERS_V VIEW SIT209 INCIDENTS 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
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
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 13-DEC-12 10:15:05
LAST_DDL_TIME 30-MAR-18 10:40:15
OWNER SIT209
TABLE_NAME INCIDENTS
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 6778
BLOCKS 874
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 188
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 6778
LAST_ANALYZED 10-JUN-19 22:01:30
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 containing data about any event, either human-caused or naturally occurring, that is of management concern and/or requires management action.
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 INC_PK UNIQUE VALID NORMAL N NO null NO INCIDENT_IDENTIFIER null
SIT209 INC_CNTY_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_COUNTY_CODE, POO_STATE_CODE null
SIT209 INCIDENT_MERGE_FK_I NONUNIQUE VALID NORMAL N NO null NO MERGE_PARENT_ID null
SIT209 INC_LUCODES_ITYP_FK_I NONUNIQUE VALID NORMAL N NO null NO INCTYP_IDENTIFIER null
SIT209 INC_LUCODES_CAUSE_FK_I NONUNIQUE VALID NORMAL N NO null NO CAUSE_IDENTIFIER null
SIT209 INC_LUCODES_IAUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO INC_AREA_UOM_IDENTIFIER null
SIT209 INC_LUCODES_PCUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PCT_CONT_COMPL_UOM_IDENTIFIER null
SIT209 INC_LUCODES_PDUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PLANNED_DUR_UOM_IDENTIFIER null
SIT209 INC_NWCG_PROT_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO DONWCGU_PROT_UNIT_IDENTIFIER null
SIT209 INC_LUCODES_PLSZUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PLANNED_INC_SZ_UOM_IDENTIFIER null
SIT209 INC_LUCODES_PMERIDIAN_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_LD_PM_IDENTIFIER null
SIT209 INC_NWCG_POO_OWN_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_DONWCGU_OWN_IDENTIFIER null
SIT209 INC_NWCG_UNITS_PROT_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO NWCG_PROT_UNIT_IDENTIFIER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_PK SIT209 INCIDENTS INCIDENT_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_CNTY_FK_I SIT209 INCIDENTS POO_COUNTY_CODE 1 3 3 ASC
SIT209 INC_CNTY_FK_I SIT209 INCIDENTS POO_STATE_CODE 2 2 2 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INCIDENT_MERGE_FK_I SIT209 INCIDENTS MERGE_PARENT_ID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_ITYP_FK_I SIT209 INCIDENTS INCTYP_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_CAUSE_FK_I SIT209 INCIDENTS CAUSE_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_IAUOM_FK_I SIT209 INCIDENTS INC_AREA_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_PCUOM_FK_I SIT209 INCIDENTS PCT_CONT_COMPL_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_PDUOM_FK_I SIT209 INCIDENTS PLANNED_DUR_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_NWCG_PROT_UNIT_FK_I SIT209 INCIDENTS DONWCGU_PROT_UNIT_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_PLSZUOM_FK_I SIT209 INCIDENTS PLANNED_INC_SZ_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_LUCODES_PMERIDIAN_FK_I SIT209 INCIDENTS POO_LD_PM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_NWCG_POO_OWN_UNIT_FK_I SIT209 INCIDENTS POO_DONWCGU_OWN_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC_NWCG_UNITS_PROT_UNIT_FK_I SIT209 INCIDENTS NWCG_PROT_UNIT_IDENTIFIER 1 22 0 ASC