Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
SFSDS_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this daily fire statistics summary record (sequence: SIT209_SEQ).
DONWCGU_PROT_UNIT_IDENTIFIER NUMBER(9,0) No null 2 The PK of the NWCG Unit / Dispatch Office mapping for this daily fire statistics summary record.
UNIT_NAME VARCHAR2(100 BYTE) No null 3 The NWCG Unit name for this daily fire statistics summary record.
AGENCY_CODE VARCHAR2(10 BYTE) No null 4 The agency abbreviation (code) for this daily fire statistics summary record.
UNIT_ID VARCHAR2(10 BYTE) No null 5 The NWCG Unit identifier of the Geographic Area for this daily fire statistics summary record.
UNIT_STATE VARCHAR2(2 BYTE) No null 6 The NWCG Unit state postal code (ex. AK) for this daily fire statistics summary record.
DISPOFC_ID VARCHAR2(10 BYTE) No null 7 The Dispatch Office identifier (code) for this daily fire statistics summary record.
DISPOFC_STATE VARCHAR2(2 BYTE) No null 8 The Dispatch Office state postal code for this daily fire statistics summary record.
DISPOFC_NAME VARCHAR2(100 BYTE) No null 9 The Dispatch Office name for this daily fire statistics summary record.
GAID VARCHAR2(10 BYTE) No null 10 The GACC identifier (code) for this daily fire statistics summary record.
GA_NAME VARCHAR2(100 BYTE) No null 11 The GACC name for this daily fire statistics summary record.
REPORT_DATE DATE No null 12 The YTD/Daily report date for this NWCG Unit/Dispatch Office combination (DONWCGU_PROT_UNIT_IDENTIFIER) by Protection/Ownership (PROT_OWN_FLAG) for this daily fire statistics summary record.
PROT_OWN_FLAG VARCHAR2(1 BYTE) No null 13 Flag indicating whether this record is reporting "P"rotection or "O"wnership statistics for this daily fire statistics summary record.
DANGER VARCHAR2(10 BYTE) Yes null 14 The Fire Danger level for the Unit / Dispatch Office this daily fire statistics summary record.
PREP VARCHAR2(10 BYTE) Yes null 15 The level of fire preparation for the Unit / Dispatch Office for this daily fire statistics summary record.
DAILY_HUMAN_FIRES NUMBER Yes null 16 The daily total number of Human-caused fires for this daily fire statistics summary record.
DAILY_HUMAN_ACRES NUMBER Yes null 17 The daily total acres of Human-caused fires for this daily fire statistics summary record.
DAILY_LIGHTNING_FIRES NUMBER Yes null 18 The daily total number of Lightning-caused fires for this daily fire statistics summary record.
DAILY_LIGHTNING_ACRES NUMBER Yes null 19 The daily total acres of Lightning-caused fires for this daily fire statistics summary record.
DAILY_RX_FIRES NUMBER Yes null 20 The daily total number of Prescribed fires for this daily fire statistics summary record.
DAILY_RX_ACRES NUMBER Yes null 21 The daily total acres of Prescribed fires for this daily fire statistics summary record.
DAILY_TOTAL_FIRES NUMBER Yes null 22 The daily total number of fires for this daily fire statistics summary record.
DAILY_TOTAL_ACRES NUMBER Yes null 23 The daily total acres of fires for this daily fire statistics summary record.
DAILY_UNCTRLD_FIRES NUMBER Yes null 24 The daily total of uncontrolled fires for this daily fire statistics summary record.
DAILY_D_FIRES NUMBER Yes null 25 The total of "D" uncontrolled fires (from count of "active" wildfire ICS-209 incidents where area >= 100 acres) for this daily fire statistics summary record.
CREATED_BY VARCHAR2(30 BYTE) No null 26 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 27 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 28 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 29 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).
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
SFSDS_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 28-JAN-15 19:14:24 SIT209 SFSDS_PK null null
SFSDS_PROTOWN_CK Check PROT_OWN_FLAG IN ('P','O') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 28-JAN-15 19:14:24 null null null null
SFSDS_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 28-JAN-15 19:14:24 SIT209 SFSDS_UK null null
SYS_C00266560 Check "SFSDS_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266561 Check "DONWCGU_PROT_UNIT_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266562 Check "UNIT_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266563 Check "AGENCY_CODE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266564 Check "UNIT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266565 Check "UNIT_STATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266566 Check "DISPOFC_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266567 Check "DISPOFC_STATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266568 Check "DISPOFC_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266569 Check "GAID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266570 Check "GA_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266571 Check "REPORT_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266572 Check "PROT_OWN_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266573 Check "CREATED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266574 Check "CREATED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266575 Check "LAST_MODIFIED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null
SYS_C00266576 Check "LAST_MODIFIED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:24 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
SFSDS_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PROT_OWN_FLAG null
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER 1
REPORT_DATE 2
PROT_OWN_FLAG 3
COLUMN_NAME COLUMN_POSITION
SFSDS_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
UNIT_NAME null
COLUMN_NAME COLUMN_POSITION
AGENCY_CODE null
COLUMN_NAME COLUMN_POSITION
UNIT_ID null
COLUMN_NAME COLUMN_POSITION
UNIT_STATE null
COLUMN_NAME COLUMN_POSITION
DISPOFC_ID null
COLUMN_NAME COLUMN_POSITION
DISPOFC_STATE null
COLUMN_NAME COLUMN_POSITION
DISPOFC_NAME null
COLUMN_NAME COLUMN_POSITION
GAID null
COLUMN_NAME COLUMN_POSITION
GA_NAME null
COLUMN_NAME COLUMN_POSITION
REPORT_DATE null
COLUMN_NAME COLUMN_POSITION
PROT_OWN_FLAG 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
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
SELECT FAMWEBREADONLY NO SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES
NAME VALUE
NUM_ROWS 48167
BLOCKS 11117
AVG_ROW_LEN 198
SAMPLE_SIZE 5468
LAST_ANALYZED 10-JUN-19 22:02:08
LAST_ANALYZED_SINCE 10-JUN-19 22:02:08



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_SFSDS_TRG BEFORE EACH ROW SIT209 INSERT ENABLED SIT_FIRE_STAT_DAILY_SUMMARIES
BRIU_AUDIT_SFSDS_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE ENABLED SIT_FIRE_STAT_DAILY_SUMMARIES




TRIGGER SIT209.BRI_SFSDS_TRG
 BEFORE
  INSERT
 ON SIT209.SIT_FIRE_STAT_DAILY_SUMMARIES
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set SFSDS_IDENTIFIER on insert if not supplied.
    begin
      if :new.sfsds_identifier IS NULL then
        :new.sfsds_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
TRIGGER SIT209.BRIU_AUDIT_SFSDS_TRG
 BEFORE
  INSERT OR UPDATE
 ON SIT209.SIT_FIRE_STAT_DAILY_SUMMARIES
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 SIT209_FSTATS_UTIL PACKAGE BODY SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES TABLE
SIT209 BRI_SFSDS_TRG TRIGGER SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES TABLE
SIT209 BRIU_AUDIT_SFSDS_TRG TRIGGER SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES 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 28-JAN-15 19:14:24
LAST_DDL_TIME 04-MAY-16 09:33:31
OWNER SIT209
TABLE_NAME SIT_FIRE_STAT_DAILY_SUMMARIES
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 48167
BLOCKS 11117
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 198
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 5468
LAST_ANALYZED 10-JUN-19 22:02:08
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS A table of Daily fire statistics summaries.  Records in the table are populated via after-action triggers on the SIT209_FIRE_STATS and SIT209_FIRE_STATS_CATEGORIES tables
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 SFSDS_PK UNIQUE VALID NORMAL N NO null NO SFSDS_IDENTIFIER null
SIT209 SFSDS_UK UNIQUE VALID NORMAL N NO null NO DONWCGU_PROT_UNIT_IDENTIFIER, REPORT_DATE, PROT_OWN_FLAG null
SIT209 SFSDS_GAID_I NONUNIQUE VALID NORMAL N NO null NO GAID null
SIT209 SFSDS_AGENCY_I NONUNIQUE VALID NORMAL N NO null NO AGENCY_CODE null
SIT209 SFSDS_UNITID_I NONUNIQUE VALID NORMAL N NO null NO UNIT_ID null
SIT209 SFSDS_DISPOFC_I NONUNIQUE VALID NORMAL N NO null NO DISPOFC_STATE, DISPOFC_ID null
SIT209 SFSDS_REPDATE_I NONUNIQUE VALID NORMAL N NO null NO REPORT_DATE null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_PK SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES SFSDS_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_UK SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES DONWCGU_PROT_UNIT_IDENTIFIER 1 22 0 ASC
SIT209 SFSDS_UK SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES REPORT_DATE 2 7 0 ASC
SIT209 SFSDS_UK SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES PROT_OWN_FLAG 3 1 1 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_GAID_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES GAID 1 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_AGENCY_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES AGENCY_CODE 1 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_UNITID_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES UNIT_ID 1 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_DISPOFC_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES DISPOFC_STATE 1 2 2 ASC
SIT209 SFSDS_DISPOFC_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES DISPOFC_ID 2 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSDS_REPDATE_I SIT209 SIT_FIRE_STAT_DAILY_SUMMARIES REPORT_DATE 1 7 0 ASC