Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
SFSYS_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this YTD 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 YTD fire statistics summary record.
UNIT_NAME VARCHAR2(100 BYTE) No null 3 The NWCG Unit name for this YTD fire statistics summary record.
AGENCY_CODE VARCHAR2(10 BYTE) No null 4 The agency abbreviation (code) for this YTD fire statistics summary record.
UNIT_ID VARCHAR2(10 BYTE) No null 5 The NWCG Unit identifier of the Geographic Area for this YTD fire statistics summary record.
UNIT_STATE VARCHAR2(2 BYTE) No null 6 The NWCG Unit state postal code (ex. AK) for this YTD fire statistics summary record.
DISPOFC_ID VARCHAR2(10 BYTE) No null 7 The Dispatch Office identifier (code) for this YTD fire statistics summary record.
DISPOFC_STATE VARCHAR2(2 BYTE) No null 8 The Dispatch Office state postal code for this YTD fire statistics summary record.
DISPOFC_NAME VARCHAR2(100 BYTE) No null 9 The Dispatch Office name for this YTD fire statistics summary record.
GAID VARCHAR2(10 BYTE) No null 10 The GACC identifier (code) for this YTD fire statistics summary record.
GA_NAME VARCHAR2(100 BYTE) No null 11 The GACC name for this YTD fire statistics summary record.
REPORT_DATE DATE No null 12 The YTD report date for this NWCG Unit/Dispatch Office combination (DONWCGU_PROT_UNIT_IDENTIFIER) by Protection/Ownership (PROT_OWN_FLAG) for this YTD 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 YTD fire statistics summary record.
YTD_HUMAN_FIRES NUMBER Yes null 14 The YTD total number of Human-caused fires for this YTD fire statistics summary record.
YTD_HUMAN_ACRES NUMBER Yes null 15 The YTD total acres of Human-caused fires for this YTD fire statistics summary record.
YTD_LIGHTNING_FIRES NUMBER Yes null 16 The YTD total number of Lightning-caused fires for this YTD fire statistics summary record.
YTD_LIGHTNING_ACRES NUMBER Yes null 17 The YTD total acres of Lightning-caused fires for this YTD fire statistics summary record.
YTD_RX_FIRES NUMBER Yes null 18 The YTD total number of Prescribed fires for this YTD fire statistics summary record.
YTD_RX_ACRES NUMBER Yes null 19 The YTD total acres of Prescribed fires for this YTD fire statistics summary record.
CREATED_BY VARCHAR2(30 BYTE) No null 20 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 21 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 22 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 23 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
SFSYS_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 28-JAN-15 19:14:38 SIT209 SFSYS_PK null null
SFSYS_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:38 null null null null
SFSYS_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 28-JAN-15 19:14:38 SIT209 SFSYS_UK null null
SYS_C00266580 Check "SFSYS_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266581 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:38 null null null null
SYS_C00266582 Check "UNIT_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266583 Check "AGENCY_CODE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266584 Check "UNIT_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266585 Check "UNIT_STATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266586 Check "DISPOFC_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266587 Check "DISPOFC_STATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266588 Check "DISPOFC_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266589 Check "GAID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266590 Check "GA_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266591 Check "REPORT_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266592 Check "PROT_OWN_FLAG" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266593 Check "CREATED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266594 Check "CREATED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266595 Check "LAST_MODIFIED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null
SYS_C00266596 Check "LAST_MODIFIED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 28-JAN-15 19:14:38 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
SFSYS_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PROT_OWN_FLAG null
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER 1
PROT_OWN_FLAG 2
REPORT_DATE 3
COLUMN_NAME COLUMN_POSITION
SFSYS_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_YTD_SUMMARIES
NAME VALUE
NUM_ROWS 38222
BLOCKS 7678
AVG_ROW_LEN 186
SAMPLE_SIZE 38222
LAST_ANALYZED 10-JUN-19 22:01:56
LAST_ANALYZED_SINCE 10-JUN-19 22:01:56



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_SFSYS_TRG BEFORE EACH ROW SIT209 INSERT ENABLED SIT_FIRE_STAT_YTD_SUMMARIES
BRIU_AUDIT_SFSYS_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE ENABLED SIT_FIRE_STAT_YTD_SUMMARIES




TRIGGER SIT209.BRI_SFSYS_TRG
 BEFORE
  INSERT
 ON SIT209.SIT_FIRE_STAT_YTD_SUMMARIES
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set SFSYS_IDENTIFIER on insert if not supplied.
    begin
      if :new.sfsys_identifier IS NULL then
        :new.sfsys_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
TRIGGER SIT209.BRIU_AUDIT_SFSYS_TRG
 BEFORE
  INSERT OR UPDATE
 ON SIT209.SIT_FIRE_STAT_YTD_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 SIT_FIRE_STAT_YTD_SUMM_OWN_V VIEW SIT209 SIT_FIRE_STAT_YTD_SUMMARIES TABLE
SIT209 SIT_FIRE_STAT_YTD_SUMM_PROT_V VIEW SIT209 SIT_FIRE_STAT_YTD_SUMMARIES TABLE
SIT209 SIT209_FSTATS_UTIL PACKAGE BODY SIT209 SIT_FIRE_STAT_YTD_SUMMARIES TABLE
SIT209 BRI_SFSYS_TRG TRIGGER SIT209 SIT_FIRE_STAT_YTD_SUMMARIES TABLE
SIT209 BRIU_AUDIT_SFSYS_TRG TRIGGER SIT209 SIT_FIRE_STAT_YTD_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
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:38
LAST_DDL_TIME 04-MAY-16 09:33:31
OWNER SIT209
TABLE_NAME SIT_FIRE_STAT_YTD_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 38222
BLOCKS 7678
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 186
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 38222
LAST_ANALYZED 10-JUN-19 22:01:56
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS A table of YTD Wildfire and Rx 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 SFSYS_PK UNIQUE VALID NORMAL N NO null NO SFSYS_IDENTIFIER null
SIT209 SFSYS_UK UNIQUE VALID NORMAL N NO null NO DONWCGU_PROT_UNIT_IDENTIFIER, PROT_OWN_FLAG, REPORT_DATE null
SIT209 SFSYS_GAID_I NONUNIQUE VALID NORMAL N NO null NO GAID null
SIT209 SFSYS_AGENCY_I NONUNIQUE VALID NORMAL N NO null NO AGENCY_CODE null
SIT209 SFSYS_UNITID_I NONUNIQUE VALID NORMAL N NO null NO UNIT_ID null
SIT209 SFSYS_DISPOFC_I NONUNIQUE VALID NORMAL N NO null NO DISPOFC_STATE, DISPOFC_ID null
SIT209 SFSYS_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 SFSYS_PK SIT209 SIT_FIRE_STAT_YTD_SUMMARIES SFSYS_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSYS_UK SIT209 SIT_FIRE_STAT_YTD_SUMMARIES DONWCGU_PROT_UNIT_IDENTIFIER 1 22 0 ASC
SIT209 SFSYS_UK SIT209 SIT_FIRE_STAT_YTD_SUMMARIES PROT_OWN_FLAG 2 1 1 ASC
SIT209 SFSYS_UK SIT209 SIT_FIRE_STAT_YTD_SUMMARIES REPORT_DATE 3 7 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSYS_GAID_I SIT209 SIT_FIRE_STAT_YTD_SUMMARIES GAID 1 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SFSYS_AGENCY_I SIT209 SIT_FIRE_STAT_YTD_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 SFSYS_UNITID_I SIT209 SIT_FIRE_STAT_YTD_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 SFSYS_DISPOFC_I SIT209 SIT_FIRE_STAT_YTD_SUMMARIES DISPOFC_STATE 1 2 2 ASC
SIT209 SFSYS_DISPOFC_I SIT209 SIT_FIRE_STAT_YTD_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 SFSYS_REPDATE_I SIT209 SIT_FIRE_STAT_YTD_SUMMARIES REPORT_DATE 1 7 0 ASC