Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
INC209R_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this incident (sequence: SIT209_SEQ)
INC_IDENTIFIER NUMBER(9,0) No null 2 The Incident Identifier (FK to INCIDENTS) for this Incident (209 Report).
DONWCGU_PROT_UNIT_IDENTIFIER NUMBER(9,0) No null 3 FK to DISPATCH_OFFICE_NWCG_UNITS for Protection Unit of this incident (209 Report)
REPORT_FROM_DATE DATE Yes null 4 The start of the time interval for this Incident (209 report).  This period includes all of the time since the last ICS 209 was submitted, or if it is the initial ICS 209, it covers the time lapsed since the incident started.  The time period may include one or more operational periods, based on agency/organizational reporting requirements.
REPORT_TO_DATE DATE Yes null 5 The end of the time interval for this Incident (209 report).  This period includes all of the time since the last ICS 209 was submitted, or if it is the initial ICS 209, it covers the time lapsed since the incident started.  The time period may include one or more operational periods, based on agency/organizational reporting requirements.
STATUS VARCHAR2(1 BYTE) No null 6 The Status for this Incident (209 Report).
INCIDENT_DESCRIPTION VARCHAR2(4000 BYTE) Yes null 7 Any narrative/text that describes this Incident (209 Report).
INCIDENT_COMMANDERS_NARR VARCHAR2(4000 BYTE) Yes null 8 Any narrative/text describing the Incident Commanders for this Incident (209 Report). 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,...").
CURR_INCIDENT_AREA NUMBER(20,6) Yes null 9 The magnitude of the most-recent area affected by this Incident (209 Report).
CURR_INC_AREA_UOM_IDENTIFIER NUMBER(9,0) Yes null 10 The Current Incident Area Unit of Measure Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
PCT_CONTAINED_COMPLETED NUMBER(3,0) Yes null 11 The %-Contained/Completed for this Incident (209 Report).  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 12 The %-Contained/Completed Unit of Measure Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
COMPLEXITY_LEVEL_IDENTIFIER NUMBER(9,0) Yes null 13 The Fire Management Complexity Level Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
CAUSE_IDENTIFIER NUMBER(9,0) Yes null 14 The Cause Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
POO_LATITUDE NUMBER(10,7) Yes null 15 The latitude of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_LONGITUDE NUMBER(10,7) Yes null 16 The longitude of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_STATE_CODE VARCHAR2(2 BYTE) Yes null 17 FK to COMMONDATA.STATES for point-of-origin State for this Incident (209 Report).
POO_CITY VARCHAR2(50 BYTE) Yes null 18 The city (nearest) location of the point-of-origin for this Incident (209 Report).
POO_SHORT_LOCATION_DESC VARCHAR2(80 BYTE) Yes null 19 A short (<80 characters) description of the location of the point-of-origin for this Incident (209 Report).
POO_US_NGR_ZONE VARCHAR2(5 BYTE) Yes null 20 The National Grid Reference (NGR) zone of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_US_NGR_XCOORD NUMBER(9,0) Yes null 21 The National Grid Reference (NGR) x-coordinate of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_US_NGR_YCOORD NUMBER(9,0) Yes null 22 The National Grid Reference (NGR) y-coorindate of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_LD_TWP VARCHAR2(5 BYTE) Yes null 23 The PLSS township (tier) of the point-of-origin for this Incident (209 Report). 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 24 The PLSS range of the point-of-origin for this Incident (209 Report). 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 25 The PLSS section of the point-of-origin for this Incident (209 Report). 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 26 The PLSS quarter-section of the point-of-origin for this Incident (209 Report). 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 27 The PLSS quarter-quarter-section of the point-of-origin for this Incident (209 Report). 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 28 The PLSS quarter-quarter-quarter-section of the point-of-origin for this Incident (209 Report). 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 29 The PLSS quarter-quarter-quarter-quarter-section of the point-of-origin for this Incident (209 Report). 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 30 The UTM Zone of the point-of-origin for this Incident (209 Report).
POO_UTM_EASTING NUMBER(6,0) Yes null 31 The UTM Easting of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
POO_UTM_NORTHING NUMBER(7,0) Yes null 32 The UTM Northing of the point-of-origin for this Incident (209 Report) - Datum should be NAD83.
INCIDENT_JURISDICTION VARCHAR2(50 BYTE) Yes null 33 Any narrative/text about the jurisdiction where this Incident (209 Report) originated (the entry may be general, such as Federal, city, or State, or may specifically identify agency names such as Warren County, U.S. Coast Guard, Panama City, NYPD).
ELEC_GEOSP_DATA_INCL VARCHAR2(4000 BYTE) Yes null 34 Any narrative/text indicating whether and how geospatial data is included or attached with this Incident (209 Report).  This should include a web URL to the location of any geospatial data related to the incident, followed by a description of what the data are.
SIGNIF_EVENTS_SUMMARY VARCHAR2(4000 BYTE) Yes null 35 Any summary narrative/text about significant progress made, evacuations, incident growth, etc. associated with this Incident (209 Report).
FUEL_MODEL_IDENTIFIER NUMBER(9,0) Yes null 36 The Fuel Model Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
HAZARDS_MATLS_INVOLVMENT_NARR VARCHAR2(4000 BYTE) Yes null 37 Any narrative/text about hazardous materials (hazardous chemicals, fuel types, infectious agents, radiation, etc.) involvment for this Incident (209 Report).
DAMAGE_ASSESSMENT_INFO VARCHAR2(4000 BYTE) Yes null 38 A summary of damage and/or restriction of use or availability to residential or commercial property, natural resources, critical infrastructure and key resources, etc.) for this Incident (209 Report).
LIFE_SAFETY_HEALTH_STATUS_NARR VARCHAR2(4000 BYTE) Yes null 39 Any narrative/text regarding illness, injuries, fatalities, and threat management for this Incident (209 Report).
WEATHER_CONCERNS_NARR VARCHAR2(4000 BYTE) Yes null 40 A synopsis of current and predicted weather, with discussion of related factors that may cause concern for this Incident (209 Report).
PROJECTED_ACTIVITY_12 VARCHAR2(4000 BYTE) Yes null 41 Any narrative/text about the Projected Activity (12-hrs) for this Incident (209 Report). Included is typically an estimate (when it is possible to do so) of the direction/scope in which the incident is expected to spread, migrate, or expand during the next indicated operational period, or other factors that may cause activity changes. Also, discussion of incident potential relative to values at risk, or values to be protected (such as human life), and the potential changes to those as the incident changes.
PROJECTED_ACTIVITY_24 VARCHAR2(4000 BYTE) Yes null 42 Any narrative/text about the Projected Activity (24-hrs) for this Incident (209 Report). Included is typically an estimate (when it is possible to do so) of the direction/scope in which the incident is expected to spread, migrate, or expand during the next indicated operational period, or other factors that may cause activity changes. Also, discussion of incident potential relative to values at risk, or values to be protected (such as human life), and the potential changes to those as the incident changes.
PROJECTED_ACTIVITY_48 VARCHAR2(4000 BYTE) Yes null 43 Any narrative/text about the Projected Activity (48-hrs) for this Incident (209 Report). Included is typically an estimate (when it is possible to do so) of the direction/scope in which the incident is expected to spread, migrate, or expand during the next indicated operational period, or other factors that may cause activity changes. Also, discussion of incident potential relative to values at risk, or values to be protected (such as human life), and the potential changes to those as the incident changes.
PROJECTED_ACTIVITY_72 VARCHAR2(4000 BYTE) Yes null 44 Any narrative/text about the Projected Activity (72-hrs) for this Incident (209 Report). Included is typically an estimate (when it is possible to do so) of the direction/scope in which the incident is expected to spread, migrate, or expand during the next indicated operational period, or other factors that may cause activity changes. Also, discussion of incident potential relative to values at risk, or values to be protected (such as human life), and the potential changes to those as the incident changes.
PROJECTED_ACTIVITY_GT72 VARCHAR2(4000 BYTE) Yes null 45 Any narrative/text about the Projected Activity (>72-hrs) for this Incident (209 Report). Included is typically an estimate (when it is possible to do so) of the direction/scope in which the incident is expected to spread, migrate, or expand during the next indicated operational period, or other factors that may cause activity changes. Also, discussion of incident potential relative to values at risk, or values to be protected (such as human life), and the potential changes to those as the incident changes.
CURRENT_THREAT_12 VARCHAR2(4000 BYTE) Yes null 46 Any narrative/text about Current Threats (12-hrs) for this Incident (209 Report). It summarizes major or significant threats due to incident activity based on currently available information.
CURRENT_THREAT_24 VARCHAR2(4000 BYTE) Yes null 47 Any narrative/text about Current Threats (24-hrs) for this Incident (209 Report). It summarizes major or significant threats due to incident activity based on currently available information.
CURRENT_THREAT_48 VARCHAR2(4000 BYTE) Yes null 48 Any narrative/text about Current Threats (48-hrs) for this Incident (209 Report). It summarizes major or significant threats due to incident activity based on currently available information.
CURRENT_THREAT_72 VARCHAR2(4000 BYTE) Yes null 49 Any narrative/text about Current Threats (72-hrs) for this Incident (209 Report). It summarizes major or significant threats due to incident activity based on currently available information.
CURRENT_THREAT_GT72 VARCHAR2(4000 BYTE) Yes null 50 Any narrative/text about Current Threats (>72-hrs) for this Incident (209 Report). It summarizes major or significant threats due to incident activity based on currently available information.
CRIT_RES_NEEDS_12 VARCHAR2(4000 BYTE) Yes null 51 Any narrative/text about the Critical Resource Needs (12-hrs) for this Incident (209 Report). It typically lists the specific critical resources and numbers needed (12 hrs later), in order of priority.
CRIT_RES_NEEDS_24 VARCHAR2(4000 BYTE) Yes null 52 Any narrative/text about the Critical Resource Needs (24-hrs) for this Incident (209 Report). It typically lists the specific critical resources and numbers needed (24 hrs later), in order of priority.
CRIT_RES_NEEDS_48 VARCHAR2(4000 BYTE) Yes null 53 Any narrative/text about the Critical Resource Needs (48-hrs) for this Incident (209 Report). It typically lists the specific critical resources and numbers needed (48 hrs later), in order of priority.
CRIT_RES_NEEDS_72 VARCHAR2(4000 BYTE) Yes null 54 Any narrative/text about the Critical Resource Needs (72-hrs) for this Incident (209 Report). It typically lists the specific critical resources and numbers needed (72 hrs later), in order of priority.
CRIT_RES_NEEDS_GT72 VARCHAR2(4000 BYTE) Yes null 55 Any narrative/text about the Critical Resource Needs (>72-hrs) for this Incident (209 Report). It typically lists the specific critical resources and numbers needed (>72 hrs later), in order of priority.
STRATEGIC_DISCUSSION VARCHAR2(4000 BYTE) Yes null 56 Any narrative/text about the relation of overall strategy, constraints, and current available information to: 1) identified critical resource needs:  2) the Incident Action Plan and management objectives and targets:  3) anticipated results for this incident, as known at the time of this ICS-209 report.  Included are explanations of major problems and concerns such as operational challenges, incident management problems, and social, political, economic, or environmental concerns or impacts.
PLANNED_ACTIONS VARCHAR2(4000 BYTE) Yes null 57 A short summary of actions planned for the next operational period for this Incident (209 Report). Examples: "The current Incident Management Team will transition out to a replacement IMT.": "Continue to review operational/engineering plan to facilitate removal of the partially collapsed west bridge supports.": etc.
PROJ_INCIDENT_AREA NUMBER Yes null 58 An estimate of the total area likely to be involved or affected over the course of the incident for this Incident (209 Report).
PROJ_INC_AREA_UOM_IDENTIFIER NUMBER(9,0) Yes null 59 The Projected Incident Area Unit-of-Measure Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
ANTICIPATED_COMPLETION_DATE DATE Yes null 60 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.
EXPECTED_CONTAINMENT_DATE DATE Yes null 61 The expected containment date (for wildfires only) for this Incident (209 Report).
PROJ_SIG_RES_DEMOB_START_DATE DATE Yes null 62 The date (month/day/year) when initiation of significant resource demobilization is anticipated for this Incident (209 Report).
EST_IM_COST_TO_DATE NUMBER(11,2) Yes null 63 The estimated total incident costs to date for the entire incident based on currently available information for this Incident (209 Report).  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.
MANAGEMENT_CODE VARCHAR2(6 BYTE) Yes null 64 The Management (Fire) Code for this Incident (209 Report).  For wildfires only.
PROJECTED_FINAL_IM_COST NUMBER(11,2) Yes null 65 An estimate of the total costs for the incident once all costs have been processed based on current spending and projected incident potential, per discipline, agency, or organizational guidance and policy for this Incident (209 Report).  This does not include damage assessment figures, as they are impacts from the incident and not response costs.
REMARKS VARCHAR2(4000 BYTE) Yes null 66 Any narrative/text that expands on information already captured elsewhere for this Incident (209 Report).  Additional information may include more detailed weather information, specifics on injuries or fatalities, threats to critical infrastructure or other resources, more detailed evacuation site locations and number of evacuated, information or details regarding incident cause, etc.
PREPARED_BY VARCHAR2(50 BYTE) Yes null 67 The preparer of this Incident (209 Report).  When an incident management organization is in place, this would be the Situation Unit Leader or Planning Section Chief at the incident.  On other incidents, it could be a dispatcher in the local emergency communications center, or another staff person or manager.
PREPARED_DATE DATE Yes null 68 The date this Incident (209 Report) was prepared.
SUBMITTED_DATE DATE Yes null 69 The date this Incident (209 Report) was submitted.
SUBMITTED_TO VARCHAR2(50 BYTE) Yes null 70 The individual/organization this Incident (209 Report) was submitted-to.  This most likely is the entity or office that ordered the incident management organization that is managing the incident.  This may be a dispatch center or a MACS element such as an emergency operations center.  If a dispatch center or other emergency center prepared the ICS 209 for the incident, indicate where it was submitted initially.
APPROVED_BY VARCHAR2(50 BYTE) Yes null 71 The approver of this Incident (209 Report). When an incident management organization is in place, this would be the Planning Section Chief or Incident Commander at the incident.  On other incidents, it could be the jurisdiction?s dispatch center manager, organizational administrator, or other manager.
APPROVED_DATE DATE Yes null 72 The date this Incident (209 Report) was approved.
INC_MGMT_ORG_IDENTIFIER NUMBER(9,0) Yes null 73 The Incident Management Organization (type) Identifier (FK to SIT209_LOOKUP_CODES) for this Incident (209 Report).
DATA_ENTRY_STATUS VARCHAR2(1 BYTE) No 'D'  74 Flag indicating the data entry status ("D"raft, "A"pproved, or "I"nvalid) of this (209 Report) record. A status of "A"pproved means that this 209 Report record cannot be edited. A status of "I"nvalid indicates that this 209 Report was approved but subsequently marked as invalid
DISCOVERY_DATE DATE Yes null 75 Date this incident was discovered/started as reported in this (209 report) record.
COMPLEXITY_LEVEL_NARR VARCHAR2(4000 BYTE) Yes null 76 Any narrative/text about incident complexity for this Incident (209 Report) 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.).
POO_COUNTY_CODE VARCHAR2(3 BYTE) Yes null 77 FK to COMMONDATA.COUNTIES for point-of-origin County for this Incident (209 Report).
REPORT_NUMBER VARCHAR2(20 BYTE) Yes null 78 An optional field for agencies or organizations that require the tracking of ICS 209 report numbers.  Agencies may also track the ICS 209 by the date/time submitted
INCTYP_IDENTIFIER NUMBER(9,0) No null 79 FK to SIT209_LOOKUP_CODES for Incident Type of this Incident (209 Report)
CREATED_BY VARCHAR2(30 BYTE) No null 80 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 81 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 82 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 83 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).
POO_DONWCGU_OWN_IDENTIFIER NUMBER(9,0) Yes null 84 FK to DISPATCH_OFFICE_NWCG_UNITS for Ownership Unit at point-of-origin of this incident (209 Report).
UNIT_OR_OTHER_NARR VARCHAR2(4000 BYTE) Yes null 85 The unit, sub-unit, unit identification (ID) number or code (if used), or other information about the primary agency with  jurisdiction or responsibility for this Incident (209 Report) (e.g., police, public works, etc.), or another type of organization.
PCT_PERIM_TO_BE_CONTAINED NUMBER Yes null 86 The percent of the fire perimiter to be contained for this Incident (209 Report).
GACC_PRIORITY NUMBER(3,0) Yes null 87 An ordinal number indicating the Dispatch Office priority of this incident as recorded in this Incident 209 Report by the GACC/Dispatch Office.
DISPATCH_PRIORITY NUMBER(3,0) Yes null 88 An ordinal number indicating the GACC priority of this incident as recorded in this Incident 209 Report by the GACC.
STRATEGIC_OBJECTIVES VARCHAR2(4000 BYTE) Yes null 89 Any narrative/text about the desired outcome for the incident based on currently available information. Includes any high-level objectives and any possible strategic benefits as well (especially for planned events). For example, contain, control, or monitor a wildfire incident. For non-fire incidents information could include repopulating an area, structure stabilization, mitigating a spill, etc.
POO_LD_PM_IDENTIFIER NUMBER(9,0) Yes null 90 FK to SIT209_LOOKUP_CODES for point-of-origin Principal Meridian for this Incident (209 Report)
ADDTNL_COOP_ASSIST_ORG_NARR VARCHAR2(4000 BYTE) Yes null 91 Any narrative/text about additional cooperating and assisting organizations not already listed for this Incident (209 Report). Examples may include ambulance services, Red Cross, utility companies, etc.
SINGLE_COMPLEX_FLAG VARCHAR2(1 BYTE) No 'S'  92 Flag indicating whether this Incident (209 Report) is a "S"ingle incident or an incident "C"omplex.
INCIDENT_NUMBER VARCHAR2(20 BYTE) No null 93 The user-assigned number assigned to this Incident (209 report) 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.
INCIDENT_NAME VARCHAR2(50 BYTE) No null 94 The full name assigned to this Incident (209 report).
LOCAL_TIMEZONE_IDENTIFIER NUMBER(9,0) Yes null 95 The FK to SIT209_LOOKUP_CODES for the local timezone used for all time values in this Incident (209 report).
SECNDRY_FUEL_MODEL_IDENTIFIER NUMBER(9,0) Yes null 96 The identifier (FK to SIT209_LOOKUP_CODES) of the secondary fuel model for this Incident (209 Report).
ADDNTL_FUEL_MODEL_IDENTIFIER NUMBER(9,0) Yes null 97 The identifier (FK to SIT209_LOOKUP_CODES) of the tertiary/additional fuel model for this Incident (209 Report).
GEN_FIRE_BEHAVIOR_IDENTIFIER NUMBER(9,0) Yes null 98 The identifier (FK to SIT209_LOOKUP_CODES) of the general fire behavior (broad characterization of fire behavior) for this Incident (209 Report).
FIRE_BEHAVIOR_1_IDENTIFIER NUMBER(9,0) Yes null 99 The identifier (FK to SIT209_LOOKUP_CODES) of the specific (1st) characterization of fire behavior for this Incident (209 Report).
FIRE_BEHAVIOR_2_IDENTIFIER NUMBER(9,0) Yes null 100 The identifier (FK to SIT209_LOOKUP_CODES) of the specific (2nd) characterization of fire behavior for this Incident (209 Report).
FIRE_BEHAVIOR_3_IDENTIFIER NUMBER(9,0) Yes null 101 The identifier (FK to SIT209_LOOKUP_CODES) of the specific (2nd) characterization of fire behavior for this Incident (209 Report).
ROAD_CLOSURE_FLAG VARCHAR2(1 BYTE) No 'N'  102 A Y/N flag indicating whether road(s) have been closed as a consequence of this Incident (209 Report).
AREA_CLOSURE_FLAG VARCHAR2(1 BYTE) No 'N'  103 A Y/N flag indicating whether recreation/special use/other area(s) have been closed as a consequence of this Incident (209 Report).
TRAIL_CLOSURE_FLAG VARCHAR2(1 BYTE) No 'N'  104 A Y/N flag indicating whether trail(s) have been closed as a consequence of this Incident (209 Report).
UNIFIED_COMMAND_FLAG VARCHAR2(1 BYTE) No 'N'  105 A Y/N flag indicating whether there is more than one agency with incident jurisdiction or when incidents cross political jursidictions for this Incident (209 Report). 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.
PHONE_NO VARCHAR2(20 BYTE) Yes null 106 The telephone number of the preparer.
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
INC209R_ACF_CK Check ROAD_CLOSURE_FLAG IN ('Y','N') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:04 null null null null
INC209R_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
INC209R_DESTAT_CK Check DATA_ENTRY_STATUS IN ('D','A','I') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC209R_INC_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
INC209R_LUCODES_AFMODL_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_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
INC209R_LUCODES_CIAUOM_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
INC209R_LUCODES_CPXL_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
INC209R_LUCODES_FB1_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_LUCODES_FB2_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_LUCODES_FB3_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_LUCODES_FM_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
INC209R_LUCODES_GENFB_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_LUCODES_IMORG_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
INC209R_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
INC209R_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:44 null null null null
INC209R_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
INC209R_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
INC209R_LUCODES_PRJAREAUOM_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
INC209R_LUCODES_SFMODL_FK Foreign_Key null SIT209 SIT209_LOOKUP_CODES LUCODES_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:03 null null null null
INC209R_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
INC209R_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
INC209R_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 INC209R_PK null null
INC209R_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
INC209R_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
INC209R_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
INC209R_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
INC209R_RCF_CK Check ROAD_CLOSURE_FLAG IN ('Y','N') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:04 null null null null
INC209R_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
INC209R_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
INC209R_STATUS_CK Check STATUS IN ('U','I','F') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
INC209R_TCF_CK Check TRAIL_CLOSURE_FLAG IN ('Y','N') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 02-APR-15 09:04:04 null null null null
INC209R_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:55 null null null null
INC209R_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 INC209R_UK null null
SYS_C00208247 Check "INC209R_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_C00208248 Check "INC_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_C00208249 Check "DONWCGU_PROT_UNIT_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_C00208250 Check "STATUS" 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_C00208251 Check "DATA_ENTRY_STATUS" 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_C00208252 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_C00208253 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_C00208254 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_C00208255 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_C00208256 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_C00208257 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_C00217370 Check "INCIDENT_NUMBER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11-JUL-13 11:16:46 null null null null
SYS_C00217371 Check "INCIDENT_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11-JUL-13 11:16:47 null null null null
SYS_C00273133 Check "ROAD_CLOSURE_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 02-APR-15 09:04:03 null null null null
SYS_C00273135 Check "AREA_CLOSURE_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 02-APR-15 09:04:04 null null null null
SYS_C00273137 Check "TRAIL_CLOSURE_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 02-APR-15 09:04:04 null null null null
SYS_C00279618 Check "UNIFIED_COMMAND_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 03-JUN-15 16:46:52 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
ROAD_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
POO_STATE_CODE 1
POO_COUNTY_CODE 2
COLUMN_NAME COLUMN_POSITION
DATA_ENTRY_STATUS null
COLUMN_NAME COLUMN_POSITION
INC_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
ADDNTL_FUEL_MODEL_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
CAUSE_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
CURR_INC_AREA_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
COMPLEXITY_LEVEL_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
FIRE_BEHAVIOR_1_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
FIRE_BEHAVIOR_2_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
FIRE_BEHAVIOR_3_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
FUEL_MODEL_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
GEN_FIRE_BEHAVIOR_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
POO_LD_PM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PROJ_INC_AREA_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
SECNDRY_FUEL_MODEL_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
POO_DONWCGU_OWN_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
INC209R_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
ROAD_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
SINGLE_COMPLEX_FLAG null
COLUMN_NAME COLUMN_POSITION
POO_STATE_CODE 1
COLUMN_NAME COLUMN_POSITION
STATUS null
COLUMN_NAME COLUMN_POSITION
TRAIL_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
UNIFIED_COMMAND_FLAG null
COLUMN_NAME COLUMN_POSITION
INC_IDENTIFIER 1
DONWCGU_PROT_UNIT_IDENTIFIER 2
REPORT_FROM_DATE 3
COLUMN_NAME COLUMN_POSITION
INC209R_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
INC_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
STATUS null
COLUMN_NAME COLUMN_POSITION
DATA_ENTRY_STATUS 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
INCIDENT_NUMBER null
COLUMN_NAME COLUMN_POSITION
INCIDENT_NAME null
COLUMN_NAME COLUMN_POSITION
ROAD_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
AREA_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
TRAIL_CLOSURE_FLAG null
COLUMN_NAME COLUMN_POSITION
UNIFIED_COMMAND_FLAG null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 INCIDENT_209_REPORTS
INSERT IMSRMGR NO SIT209 INCIDENT_209_REPORTS
SELECT IMSRMGR NO SIT209 INCIDENT_209_REPORTS
UPDATE IMSRMGR NO SIT209 INCIDENT_209_REPORTS
SELECT FAMWEB_ETL NO SIT209 INCIDENT_209_REPORTS
SELECT FAMWEBREADONLY NO SIT209 INCIDENT_209_REPORTS
NAME VALUE
NUM_ROWS 855
BLOCKS 6922
AVG_ROW_LEN 1230
SAMPLE_SIZE 855
LAST_ANALYZED 10-JUN-19 22:01:24
LAST_ANALYZED_SINCE 10-JUN-19 22:01:24



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
ASIUD_INC209R_TRG AFTER STATEMENT SIT209 INSERT OR UPDATE OR DELETE ENABLED INCIDENT_209_REPORTS
BRI_INC209R_TRG BEFORE EACH ROW SIT209 INSERT ENABLED INCIDENT_209_REPORTS
BRIU_AUDIT_INC209R_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE ENABLED INCIDENT_209_REPORTS
BRIUD_INC209R_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE OR DELETE ENABLED INCIDENT_209_REPORTS




TRIGGER SIT209.ASIUD_INC209R_TRG
 AFTER
  INSERT OR UPDATE OR DELETE
 ON SIT209.INCIDENT_209_REPORTS
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
  declare
    vAction varchar2(15);
  begin
    if Inserting then
      vAction := 'inserting';
    elsif Updating then
      vAction := 'updating';
    elsif Deleting then
      vAction := 'deleting';
    end if;
    sit209.sit209_util.updateIncident_asiud(vAction);
    --
  end;
END;
TRIGGER SIT209.BRI_INC209R_TRG
 BEFORE
  INSERT
 ON SIT209.INCIDENT_209_REPORTS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set INC209R_IDENTIFIER on insert if not supplied.
    begin
      if :new.inc209r_identifier IS NULL then
        :new.inc209r_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
TRIGGER SIT209.BRIU_AUDIT_INC209R_TRG
 BEFORE
  INSERT OR UPDATE
 ON SIT209.INCIDENT_209_REPORTS
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;
TRIGGER SIT209.BRIUD_INC209R_TRG
 BEFORE
  INSERT OR UPDATE OR DELETE
 ON SIT209.INCIDENT_209_REPORTS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  declare
    vrIncident209Report INCIDENT_209_REPORTS%rowtype;
  begin
    --
    -- Load incident record.
    if inserting or updating then
      --
      vrIncident209Report.inc209r_identifier := :new.inc209r_identifier;
      vrIncident209Report.inc_identifier := :new.inc_identifier;
      vrIncident209Report.donwcgu_prot_unit_identifier := :new.donwcgu_prot_unit_identifier;
      vrIncident209Report.incident_number := :new.incident_number;
      vrIncident209Report.incident_name := :new.incident_name;
      vrIncident209Report.report_from_date := :new.report_from_date;
      vrIncident209Report.report_to_date := :new.report_to_date;
      vrIncident209Report.status := :new.status;
      vrIncident209Report.incident_description := :new.incident_description;
      vrIncident209Report.incident_commanders_narr := :new.incident_commanders_narr;
      vrIncident209Report.curr_incident_area := :new.curr_incident_area;
      vrIncident209Report.curr_inc_area_uom_identifier := :new.curr_inc_area_uom_identifier;
      vrIncident209Report.pct_contained_completed := :new.pct_contained_completed;
      vrIncident209Report.pct_cont_compl_uom_identifier := :new.pct_cont_compl_uom_identifier;
      vrIncident209Report.complexity_level_identifier := :new.complexity_level_identifier;
      vrIncident209Report.cause_identifier := :new.cause_identifier;
      vrIncident209Report.poo_latitude := :new.poo_latitude;
      vrIncident209Report.poo_longitude := :new.poo_longitude;
      vrIncident209Report.poo_state_code := :new.poo_state_code;
      vrIncident209Report.poo_city := :new.poo_city;
      vrIncident209Report.poo_short_location_desc := :new.poo_short_location_desc;
      vrIncident209Report.poo_us_ngr_zone := :new.poo_us_ngr_zone;
      vrIncident209Report.poo_us_ngr_xcoord := :new.poo_us_ngr_xcoord;
      vrIncident209Report.poo_us_ngr_ycoord := :new.poo_us_ngr_ycoord;
      vrIncident209Report.poo_ld_twp := :new.poo_ld_twp;
      vrIncident209Report.poo_ld_rge := :new.poo_ld_rge;
      vrIncident209Report.poo_ld_sec := :new.poo_ld_sec;
      vrIncident209Report.poo_ld_qtr_sec := :new.poo_ld_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_sec := :new.poo_ld_qtr_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_qtr_sec := :new.poo_ld_qtr_qtr_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_qtr_qtr_sec := :new.poo_ld_qtr_qtr_qtr_qtr_sec;
      vrIncident209Report.poo_utm_zone := :new.poo_utm_zone;
      vrIncident209Report.poo_utm_easting := :new.poo_utm_easting;
      vrIncident209Report.poo_utm_northing := :new.poo_utm_northing;
      vrIncident209Report.incident_jurisdiction := :new.incident_jurisdiction;
      vrIncident209Report.elec_geosp_data_incl := :new.elec_geosp_data_incl;
      vrIncident209Report.signif_events_summary := :new.signif_events_summary;
      vrIncident209Report.fuel_model_identifier := :new.fuel_model_identifier;
      vrIncident209Report.hazards_matls_involvment_narr := :new.hazards_matls_involvment_narr;
      vrIncident209Report.damage_assessment_info := :new.damage_assessment_info;
      vrIncident209Report.life_safety_health_status_narr := :new.life_safety_health_status_narr;
      vrIncident209Report.weather_concerns_narr := :new.weather_concerns_narr;
      vrIncident209Report.projected_activity_12 := :new.projected_activity_12;
      vrIncident209Report.projected_activity_24 := :new.projected_activity_24;
      vrIncident209Report.projected_activity_48 := :new.projected_activity_48;
      vrIncident209Report.projected_activity_72 := :new.projected_activity_72;
      vrIncident209Report.projected_activity_gt72 := :new.projected_activity_gt72;
      vrIncident209Report.current_threat_12 := :new.current_threat_12;
      vrIncident209Report.current_threat_24 := :new.current_threat_24;
      vrIncident209Report.current_threat_48 := :new.current_threat_48;
      vrIncident209Report.current_threat_72 := :new.current_threat_72;
      vrIncident209Report.current_threat_gt72 := :new.current_threat_gt72;
      vrIncident209Report.crit_res_needs_12 := :new.crit_res_needs_12;
      vrIncident209Report.crit_res_needs_24 := :new.crit_res_needs_24;
      vrIncident209Report.crit_res_needs_48 := :new.crit_res_needs_48;
      vrIncident209Report.crit_res_needs_72 := :new.crit_res_needs_72;
      vrIncident209Report.crit_res_needs_gt72 := :new.crit_res_needs_gt72;
      vrIncident209Report.strategic_discussion := :new.strategic_discussion;
      vrIncident209Report.planned_actions := :new.planned_actions;
      vrIncident209Report.proj_incident_area := :new.proj_incident_area;
      vrIncident209Report.proj_inc_area_uom_identifier := :new.proj_inc_area_uom_identifier;
      vrIncident209Report.anticipated_completion_date := :new.anticipated_completion_date;
      vrIncident209Report.expected_containment_date := :new.expected_containment_date;
      vrIncident209Report.proj_sig_res_demob_start_date := :new.proj_sig_res_demob_start_date;
      vrIncident209Report.est_im_cost_to_date := :new.est_im_cost_to_date;
      vrIncident209Report.management_code := :new.management_code;
      vrIncident209Report.projected_final_im_cost := :new.projected_final_im_cost;
      vrIncident209Report.remarks := :new.remarks;
      vrIncident209Report.prepared_by := :new.prepared_by;
      vrIncident209Report.prepared_date := :new.prepared_date;
      vrIncident209Report.submitted_date := :new.submitted_date;
      vrIncident209Report.submitted_to := :new.submitted_to;
      vrIncident209Report.approved_by := :new.approved_by;
      vrIncident209Report.approved_date := :new.approved_date;
      vrIncident209Report.inc_mgmt_org_identifier := :new.inc_mgmt_org_identifier;
      vrIncident209Report.data_entry_status := :new.data_entry_status;
      vrIncident209Report.discovery_date := :new.discovery_date;
      vrIncident209Report.complexity_level_narr := :new.complexity_level_narr;
      vrIncident209Report.poo_county_code := :new.poo_county_code;
      vrIncident209Report.report_number := :new.report_number;
      vrIncident209Report.inctyp_identifier := :new.inctyp_identifier;
      vrIncident209Report.poo_donwcgu_own_identifier := :new.poo_donwcgu_own_identifier;
      vrIncident209Report.unit_or_other_narr := :new.unit_or_other_narr;
      vrIncident209Report.pct_perim_to_be_contained := :new.pct_perim_to_be_contained;
      vrIncident209Report.gacc_priority := :new.gacc_priority;
      vrIncident209Report.dispatch_priority := :new.dispatch_priority;
      vrIncident209Report.strategic_objectives := :new.strategic_objectives;
      vrIncident209Report.poo_ld_pm_identifier := :new.poo_ld_pm_identifier;
      vrIncident209Report.single_complex_flag := :new.single_complex_flag;
      vrIncident209Report.local_timezone_identifier := :new.local_timezone_identifier;
      vrIncident209Report.inc_mgmt_org_identifier := :new.inc_mgmt_org_identifier;
      vrIncident209Report.unified_command_flag := :new.unified_command_flag;
      --
      -- Populate PL/SQL table for after-... statement-level trigger
      sit209_util.gvInc209rCount := sit209_util.gvInc209rCount + 1;
      sit209_util.gtInc209r(sit209_util.gvInc209rCount) := vrIncident209Report;
      --
    elsif deleting then
      --
      vrIncident209Report.inc209r_identifier := :old.inc209r_identifier;
      vrIncident209Report.inc_identifier := :old.inc_identifier;
      vrIncident209Report.donwcgu_prot_unit_identifier := :old.donwcgu_prot_unit_identifier;
      vrIncident209Report.incident_number := :old.incident_number;
      vrIncident209Report.incident_name := :old.incident_name;
      vrIncident209Report.report_from_date := :old.report_from_date;
      vrIncident209Report.report_to_date := :old.report_to_date;
      vrIncident209Report.status := :old.status;
      vrIncident209Report.incident_description := :old.incident_description;
      vrIncident209Report.incident_commanders_narr := :old.incident_commanders_narr;
      vrIncident209Report.curr_incident_area := :old.curr_incident_area;
      vrIncident209Report.curr_inc_area_uom_identifier := :old.curr_inc_area_uom_identifier;
      vrIncident209Report.pct_contained_completed := :old.pct_contained_completed;
      vrIncident209Report.pct_cont_compl_uom_identifier := :old.pct_cont_compl_uom_identifier;
      vrIncident209Report.complexity_level_identifier := :old.complexity_level_identifier;
      vrIncident209Report.cause_identifier := :old.cause_identifier;
      vrIncident209Report.poo_latitude := :old.poo_latitude;
      vrIncident209Report.poo_longitude := :old.poo_longitude;
      vrIncident209Report.poo_state_code := :old.poo_state_code;
      vrIncident209Report.poo_city := :old.poo_city;
      vrIncident209Report.poo_short_location_desc := :old.poo_short_location_desc;
      vrIncident209Report.poo_us_ngr_zone := :old.poo_us_ngr_zone;
      vrIncident209Report.poo_us_ngr_xcoord := :old.poo_us_ngr_xcoord;
      vrIncident209Report.poo_us_ngr_ycoord := :old.poo_us_ngr_ycoord;
      vrIncident209Report.poo_ld_twp := :old.poo_ld_twp;
      vrIncident209Report.poo_ld_rge := :old.poo_ld_rge;
      vrIncident209Report.poo_ld_sec := :old.poo_ld_sec;
      vrIncident209Report.poo_ld_qtr_sec := :old.poo_ld_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_sec := :old.poo_ld_qtr_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_qtr_sec := :old.poo_ld_qtr_qtr_qtr_sec;
      vrIncident209Report.poo_ld_qtr_qtr_qtr_qtr_sec := :old.poo_ld_qtr_qtr_qtr_qtr_sec;
      vrIncident209Report.poo_utm_zone := :old.poo_utm_zone;
      vrIncident209Report.poo_utm_easting := :old.poo_utm_easting;
      vrIncident209Report.poo_utm_northing := :old.poo_utm_northing;
      vrIncident209Report.incident_jurisdiction := :old.incident_jurisdiction;
      vrIncident209Report.elec_geosp_data_incl := :old.elec_geosp_data_incl;
      vrIncident209Report.signif_events_summary := :old.signif_events_summary;
      vrIncident209Report.fuel_model_identifier := :old.fuel_model_identifier;
      vrIncident209Report.hazards_matls_involvment_narr := :old.hazards_matls_involvment_narr;
      vrIncident209Report.damage_assessment_info := :old.damage_assessment_info;
      vrIncident209Report.life_safety_health_status_narr := :old.life_safety_health_status_narr;
      vrIncident209Report.weather_concerns_narr := :old.weather_concerns_narr;
      vrIncident209Report.projected_activity_12 := :old.projected_activity_12;
      vrIncident209Report.projected_activity_24 := :old.projected_activity_24;
      vrIncident209Report.projected_activity_48 := :old.projected_activity_48;
      vrIncident209Report.projected_activity_72 := :old.projected_activity_72;
      vrIncident209Report.projected_activity_gt72 := :old.projected_activity_gt72;
      vrIncident209Report.current_threat_12 := :old.current_threat_12;
      vrIncident209Report.current_threat_24 := :old.current_threat_24;
      vrIncident209Report.current_threat_48 := :old.current_threat_48;
      vrIncident209Report.current_threat_72 := :old.current_threat_72;
      vrIncident209Report.current_threat_gt72 := :old.current_threat_gt72;
      vrIncident209Report.crit_res_needs_12 := :old.crit_res_needs_12;
      vrIncident209Report.crit_res_needs_24 := :old.crit_res_needs_24;
      vrIncident209Report.crit_res_needs_48 := :old.crit_res_needs_48;
      vrIncident209Report.crit_res_needs_72 := :old.crit_res_needs_72;
      vrIncident209Report.crit_res_needs_gt72 := :old.crit_res_needs_gt72;
      vrIncident209Report.strategic_discussion := :old.strategic_discussion;
      vrIncident209Report.planned_actions := :old.planned_actions;
      vrIncident209Report.proj_incident_area := :old.proj_incident_area;
      vrIncident209Report.proj_inc_area_uom_identifier := :old.proj_inc_area_uom_identifier;
      vrIncident209Report.anticipated_completion_date := :old.anticipated_completion_date;
      vrIncident209Report.expected_containment_date := :old.expected_containment_date;
      vrIncident209Report.proj_sig_res_demob_start_date := :old.proj_sig_res_demob_start_date;
      vrIncident209Report.est_im_cost_to_date := :old.est_im_cost_to_date;
      vrIncident209Report.management_code := :old.management_code;
      vrIncident209Report.projected_final_im_cost := :old.projected_final_im_cost;
      vrIncident209Report.remarks := :old.remarks;
      vrIncident209Report.prepared_by := :old.prepared_by;
      vrIncident209Report.prepared_date := :old.prepared_date;
      vrIncident209Report.submitted_date := :old.submitted_date;
      vrIncident209Report.submitted_to := :old.submitted_to;
      vrIncident209Report.approved_by := :old.approved_by;
      vrIncident209Report.approved_date := :old.approved_date;
      vrIncident209Report.inc_mgmt_org_identifier := :old.inc_mgmt_org_identifier;
      vrIncident209Report.data_entry_status := :old.data_entry_status;
      vrIncident209Report.discovery_date := :old.discovery_date;
      vrIncident209Report.complexity_level_narr := :old.complexity_level_narr;
      vrIncident209Report.poo_county_code := :old.poo_county_code;
      vrIncident209Report.report_number := :old.report_number;
      vrIncident209Report.inctyp_identifier := :old.inctyp_identifier;
      vrIncident209Report.poo_donwcgu_own_identifier := :old.poo_donwcgu_own_identifier;
      vrIncident209Report.unit_or_other_narr := :old.unit_or_other_narr;
      vrIncident209Report.pct_perim_to_be_contained := :old.pct_perim_to_be_contained;
      vrIncident209Report.gacc_priority := :old.gacc_priority;
      vrIncident209Report.dispatch_priority := :old.dispatch_priority;
      vrIncident209Report.strategic_objectives := :old.strategic_objectives;
      vrIncident209Report.poo_ld_pm_identifier := :old.poo_ld_pm_identifier;
      vrIncident209Report.single_complex_flag := :old.single_complex_flag;
      vrIncident209Report.local_timezone_identifier := :old.local_timezone_identifier;
      vrIncident209Report.inc_mgmt_org_identifier := :old.inc_mgmt_org_identifier;
      vrIncident209Report.unified_command_flag := :old.unified_command_flag;
      --
      -- Populate PL/SQL table for after-... statement-level trigger
      sit209_util.gvInc209rCount := sit209_util.gvInc209rCount + 1;
      sit209_util.gtInc209r(sit209_util.gvInc209rCount) := vrIncident209Report;
      --
    end if;
    --
  end;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 IMSR_R_GACC_ICS_209_PRIORITY PACKAGE BODY SIT209 INCIDENT_209_REPORTS TABLE
SIT209 VCGETMAX209REPORTDATE FUNCTION SIT209 INCIDENT_209_REPORTS TABLE
SIT209 GET_ICS209_PSS_PREV_RPT_TOTAL FUNCTION SIT209 INCIDENT_209_REPORTS TABLE
SIT209 LIFE_SAFETY_MGMTS_UV VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 CASUALTY_ILLNESSES_RESPNDR_UV VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 ASIUD_INC209R_TRG TRIGGER SIT209 INCIDENT_209_REPORTS TABLE
SIT209 BRIUD_INC209R_TRG TRIGGER SIT209 INCIDENT_209_REPORTS TABLE
SIT209 BRI_INC209R_TRG TRIGGER SIT209 INCIDENT_209_REPORTS TABLE
SIT209 BRIU_AUDIT_INC209R_TRG TRIGGER SIT209 INCIDENT_209_REPORTS TABLE
SIT209 SIT209_UTIL PACKAGE SIT209 INCIDENT_209_REPORTS TABLE
SIT209 INCIDENT_209_REPORTS_V VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 AFFECTED_STRUCTURES_UV VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 INCIDENT_209_REPORTS_UV VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 TUID_INC209R_IO_TRG TRIGGER SIT209 INCIDENT_209_REPORTS TABLE
SIT209 CASUALTY_ILLNESSES_PUBLIC_UV VIEW SIT209 INCIDENT_209_REPORTS TABLE
SIT209 SIT209_REPORT_UTIL PACKAGE BODY SIT209 INCIDENT_209_REPORTS TABLE
SIT209 SIT209_FSTATS_UTIL PACKAGE BODY SIT209 INCIDENT_209_REPORTS TABLE
SIT209 LOAD_SIT_WF_ACTIVITY_TEMP FUNCTION SIT209 INCIDENT_209_REPORTS TABLE
SIT209 SIT209_UTIL PACKAGE BODY SIT209 INCIDENT_209_REPORTS TABLE
SIT209 INCIDENT_COMPLEX_MEMBERS_V VIEW SIT209 INCIDENT_209_REPORTS 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
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
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 14-JUN-17 10:32:22
OWNER SIT209
TABLE_NAME INCIDENT_209_REPORTS
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 855
BLOCKS 6922
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 1230
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 855
LAST_ANALYZED 10-JUN-19 22:01:24
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 Incident Status Summary (ICS 209) data about an incident.  To support the needs of the incident, the Incident Status Summary (ICS 209) stores basic incident decision support information at the incident level at a "snapshot in time". It is the primary mechanism for reporting incident decision support information above the incident level to incident coordination and support organizations, including agency/organizational managers and executives. As such, the ICS 209 contains basic information elements needed to support decision-making at all levels above the incident to support the incident. Decision-makers may include the agency having jurisdiction, but also all multiagency coordination system (MACS) elements and parties, such as cooperating and assisting agencies/organizations, dispatch centers, emergency operations centers, administrators, elected officials, and local, tribal, county, State, and Federal agencies. Once ICS 209 information has been submitted from the incident, decision-makers and others at all incident support and coordination points may transmit and share the information (based on its sensitivity and appropriateness) for access and use at local, regional, State, and national levels as it is needed to facilitate support.
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 INC209R_PK UNIQUE VALID NORMAL N NO null NO INC209R_IDENTIFIER null
SIT209 INC209R_UK UNIQUE VALID NORMAL N NO null NO INC_IDENTIFIER, DONWCGU_PROT_UNIT_IDENTIFIER, REPORT_FROM_DATE null
SIT209 INC209R_INC_FK_I NONUNIQUE VALID NORMAL N NO null NO INC_IDENTIFIER null
SIT209 INC209R_CNTY_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_COUNTY_CODE, POO_STATE_CODE null
SIT209 INC209R_LUCODES_FM_FK_I NONUNIQUE VALID NORMAL N NO null NO FUEL_MODEL_IDENTIFIER null
SIT209 INC209R_LUCODES_CPXL_FK_I NONUNIQUE VALID NORMAL N NO null NO COMPLEXITY_LEVEL_IDENTIFIER null
SIT209 INC209R_LUCODES_ITYP_FK_I NONUNIQUE VALID NORMAL N NO null NO INCTYP_IDENTIFIER null
SIT209 INC209R_LUCODES_CAUSE_FK_I NONUNIQUE VALID NORMAL N NO null NO CAUSE_IDENTIFIER null
SIT209 INC209R_LUCODES_IMORG_FK_I NONUNIQUE VALID NORMAL N NO null NO INC_MGMT_ORG_IDENTIFIER null
SIT209 INC209R_LUCODES_PCUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PCT_CONT_COMPL_UOM_IDENTIFIER null
SIT209 INC209R_LUCODES_CIAUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO CURR_INC_AREA_UOM_IDENTIFIER null
SIT209 INC209R_NWCG_PROT_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO DONWCGU_PROT_UNIT_IDENTIFIER null
SIT209 INC209R_LUCODES_PMERIDIAN_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_LD_PM_IDENTIFIER null
SIT209 INC209R_LUCODES_PRJAREAUOM_F_I NONUNIQUE VALID NORMAL N NO null NO PROJ_INC_AREA_UOM_IDENTIFIER null
SIT209 INC209R_NWCG_POO_OWN_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_DONWCGU_OWN_IDENTIFIER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_PK SIT209 INCIDENT_209_REPORTS INC209R_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_UK SIT209 INCIDENT_209_REPORTS INC_IDENTIFIER 1 22 0 ASC
SIT209 INC209R_UK SIT209 INCIDENT_209_REPORTS DONWCGU_PROT_UNIT_IDENTIFIER 2 22 0 ASC
SIT209 INC209R_UK SIT209 INCIDENT_209_REPORTS REPORT_FROM_DATE 3 7 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_INC_FK_I SIT209 INCIDENT_209_REPORTS INC_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_CNTY_FK_I SIT209 INCIDENT_209_REPORTS POO_COUNTY_CODE 1 3 3 ASC
SIT209 INC209R_CNTY_FK_I SIT209 INCIDENT_209_REPORTS 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 INC209R_LUCODES_FM_FK_I SIT209 INCIDENT_209_REPORTS FUEL_MODEL_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_LUCODES_CPXL_FK_I SIT209 INCIDENT_209_REPORTS COMPLEXITY_LEVEL_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_LUCODES_ITYP_FK_I SIT209 INCIDENT_209_REPORTS INCTYP_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_LUCODES_CAUSE_FK_I SIT209 INCIDENT_209_REPORTS CAUSE_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_LUCODES_IMORG_FK_I SIT209 INCIDENT_209_REPORTS INC_MGMT_ORG_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 INC209R_LUCODES_PCUOM_FK_I SIT209 INCIDENT_209_REPORTS 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 INC209R_LUCODES_CIAUOM_FK_I SIT209 INCIDENT_209_REPORTS CURR_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 INC209R_NWCG_PROT_UNIT_FK_I SIT209 INCIDENT_209_REPORTS 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 INC209R_LUCODES_PMERIDIAN_FK_I SIT209 INCIDENT_209_REPORTS 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 INC209R_LUCODES_PRJAREAUOM_F_I SIT209 INCIDENT_209_REPORTS PROJ_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 INC209R_NWCG_POO_OWN_UNIT_FK_I SIT209 INCIDENT_209_REPORTS POO_DONWCGU_OWN_IDENTIFIER 1 22 0 ASC