Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
DONWCGU_PROT_UNIT_IDENTIFIER NUMBER(9,0) Yes null 1 The PK of the NWCG Unit / Dispatch Office mapping for this WF Activity record.
UNAME VARCHAR2(100 BYTE) Yes null 2 The unit name for this WF Activity record.
AGENCY VARCHAR2(10 BYTE) Yes null 3 The agency abbreviation (code) for this WF Activity record.
UNIT VARCHAR2(10 BYTE) Yes null 4 The NWCG Unit identifier of the Geographic Area for this WF Activity record.
USTATE VARCHAR2(2 BYTE) Yes null 5 The unit state postal code (ex. AK) for this WF Activity record.
REPORT_DATE DATE Yes null 6 The latest SIT Fire Statistics report date for this WF Activity record.
PROT_OWN_FLAG VARCHAR2(1 BYTE) Yes null 7 Flag indicating whether this record is reporting "P"rotection or "O"wnership statistics for this WF Activity record.
DANGER VARCHAR2(10 BYTE) Yes null 8 The Fire Danger level for the Unit / Dispatch Office this WF Activity record.
PREP VARCHAR2(10 BYTE) Yes null 9 The level of fire preparation for the Unit / Dispatch Office for this WF Activity record.
NEWHUMANFIRES NUMBER Yes null 10 The daily total number of Human-caused fires for this WF Activity record.
NEWHUMANACRES NUMBER Yes null 11 The daily total acres of Human-caused fires for this WF Activity record.
NEWLIGHTNINGFIRES NUMBER Yes null 12 The daily total number of Lightning-caused fires for this WF Activity record.
NEWLIGHTNINGACRES NUMBER Yes null 13 The daily total acres of Lightning-caused fires for this WF Activity record.
NEWRXFIRES NUMBER Yes null 14 The daily total number of Prescribed fires for this WF Activity record.
NEWRXACRES NUMBER Yes null 15 The daily total acres of Prescribed fires for this WF Activity record.
FIRES NUMBER Yes null 16 The daily total number of fires for this WF Activity record.
ACRES NUMBER Yes null 17 The daily total acres of fires for this WF Activity record.
UNCTRLD NUMBER Yes null 18 The daily total of uncontrolled fires for this WF Activity record.
D_FIRES NUMBER Yes null 19 The total of "D" uncontrolled fires (from count of "active" wildfire ICS-209 incidents where area >= 100 acres) for this WF Activity record.
YTDHFIRES NUMBER Yes null 20 The YTD total number of Human-caused fires for this WF Activity record.
YTDHACRES NUMBER Yes null 21 The YTD total acres of Human-caused fires for this WF Activity record.
YTDLFIRES NUMBER Yes null 22 The YTD total number of Lightning-caused fires for this WF Activity record.
YTDLACRES NUMBER Yes null 23 The YTD total acres of Lightning-caused fires for this WF Activity record.
YTDRXFIRES NUMBER Yes null 24 The YTD total number of Prescribed fires for this WF Activity record.
YTDRXACRES NUMBER Yes null 25 The YTD total acres of Prescribed fires for this WF Activity record.
USER_NAME VARCHAR2(30 BYTE) Yes null 26 The FAMWEB user that created this WF Activity record.
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



Columns


PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
SELECT FAMWEBREADONLY NO SIT209 SIT_WF_ACTIVITY_TEMP
NAME VALUE
NUM_ROWS null
BLOCKS null
AVG_ROW_LEN null
SAMPLE_SIZE null
LAST_ANALYZED null
LAST_ANALYZED_SINCE null



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME




OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 LOAD_SIT_WF_ACTIVITY_TEMP FUNCTION SIT209 SIT_WF_ACTIVITY_TEMP TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 10-JUL-15 16:56:37
LAST_DDL_TIME 04-MAY-16 09:33:32
OWNER SIT209
TABLE_NAME SIT_WF_ACTIVITY_TEMP
TABLESPACE_NAME null
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED 40
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT null
NEXT_EXTENT null
MIN_EXTENTS null
MAX_EXTENTS null
PCT_INCREASE null
FREELISTS 1
FREELIST_GROUPS 1
LOGGING NO
BACKED_UP N
NUM_ROWS null
BLOCKS null
EMPTY_BLOCKS null
AVG_SPACE null
CHAIN_CNT null
AVG_ROW_LEN null
AVG_SPACE_FREELIST_BLOCKS null
NUM_FREELIST_BLOCKS null
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE null
LAST_ANALYZED null
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY Y
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS NO
USER_STATS NO
DURATION SYS$SESSION
SKIP_CORRUPT DISABLED
MONITORING NO
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS An Oracle temporary "scratch" table of SIT Detail Report Daily and YTD fire Wildfire statistics.  Records in the table are auto-deleted at the end of the session (report)
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