Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
IMSR_DATE DATE No null 1 The date this incident 209 (to be displayed on the National Fire Map) report was added to the table.
INCIDENT_NUMBER VARCHAR2(25 BYTE) No null 2 The full identifier (ex: NV-HTF-123456) of this incident (to be displayed on the National Fire Map).
GAID VARCHAR2(4 BYTE) Yes null 3 The Geographic Area ID in which this incident 209 report (to be displayed on the National Fire Map) occurred.
GACC_ORDER NUMBER(5,0) Yes null 4 The GACC order of this incident 209 report (to be displayed on the National Fire Map).
INCIDENT_ORDER NUMBER(5,0) Yes null 5 The order of this incident 209 report (to be displayed on the National Fire Map) within a GACC.
REPORT_DATE DATE Yes null 6 The incident 209 report (to be displayed on the National Fire Map) "from" date.
HOUR VARCHAR2(4 BYTE) Yes null 7 The incident 209 report (to be displayed on the National Fire Map) "from" hour.
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
IMSR_NFM_INCIDENTS_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:05 SIT209 IMSR_NFM_INCIDENTS_PK null null
SYS_C00208207 Check "IMSR_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_C00208208 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



Columns


COLUMN_NAME COLUMN_POSITION
IMSR_DATE 1
INCIDENT_NUMBER 2
COLUMN_NAME COLUMN_POSITION
IMSR_DATE null
COLUMN_NAME COLUMN_POSITION
INCIDENT_NUMBER null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 IMSR_NFM_INCIDENTS
INSERT IMSRMGR NO SIT209 IMSR_NFM_INCIDENTS
SELECT IMSRMGR NO SIT209 IMSR_NFM_INCIDENTS
UPDATE IMSRMGR NO SIT209 IMSR_NFM_INCIDENTS
SELECT FAMWEB_ETL NO SIT209 IMSR_NFM_INCIDENTS
SELECT FAMWEBREADONLY NO SIT209 IMSR_NFM_INCIDENTS
NAME VALUE
NUM_ROWS 16404
BLOCKS 118
AVG_ROW_LEN 42
SAMPLE_SIZE 16404
LAST_ANALYZED 20-MAR-19 22:02:29
LAST_ANALYZED_SINCE 20-MAR-19 22:02:29



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME




OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 IMSR_IMSR_SAVE_NFM_IMT FUNCTION SIT209 IMSR_NFM_INCIDENTS TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 13-DEC-12 10:15:05
LAST_DDL_TIME 04-MAY-16 09:33:30
OWNER SIT209
TABLE_NAME IMSR_NFM_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 16404
BLOCKS 118
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 42
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 16404
LAST_ANALYZED 20-MAR-19 22:02:29
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT ENABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS A table of ICS-209 incidents to be displayed on the National Fire Map.
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 IMSR_NFM_INCIDENTS_PK UNIQUE VALID NORMAL N NO null NO IMSR_DATE, INCIDENT_NUMBER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 IMSR_NFM_INCIDENTS_PK SIT209 IMSR_NFM_INCIDENTS IMSR_DATE 1 7 0 ASC
SIT209 IMSR_NFM_INCIDENTS_PK SIT209 IMSR_NFM_INCIDENTS INCIDENT_NUMBER 2 25 25 ASC