Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
PIR_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this planned ingition report (sequence: SIT209_SEQ)
DONWCGU_PROT_UNIT_IDENTIFIER NUMBER(9,0) No null 2 FK to DISPATCH_OFFICE_NWCG_UNITS for Protection Unit of this planned ignition report.
REPORT_DATE DATE No null 3 The report date/time for this planned ignition report.
PLANNED_START_DATE DATE Yes null 4 The planned start date/time for this planned ignition as known at the time of this report.
PLANNED_DURATION NUMBER Yes null 5 The projected time duration of this planned ignition as known at the time of this report.
PLANNED_DUR_UOM_IDENTIFIER NUMBER(9,0) Yes null 6 FK to SIT209_LOOKUP_CODES for planned duration unit-of-measure of this planned ignition as known at the time of this report.
PLANNED_SIZE NUMBER Yes null 7 The planned size (eg. planned burn area, etc.) of this planned ignition as known at the time of this report.
PLANNED_SZ_UOM_IDENTIFIER NUMBER(9,0) Yes null 8 FK to SIT209_LOOKUP_CODES for planned size unit-of-measure for this planned ignition as known at the time of this report.
BURN_TYPE VARCHAR2(60 BYTE) Yes null 9 The burn type for this planned ignition as known at the time of this report.
VOR VARCHAR2(20 BYTE) Yes null 10 VOR degrees and distance for this planned ignition as known at the time of this report.
POO_LATITUDE NUMBER(10,7) Yes null 11 The latitude of the point-of-origin for this planned ignition as known at the time of this report - Datum should be NAD83.
POO_LONGITUDE NUMBER(10,7) Yes null 12 The longitude of the point-of-origin for this planned ignition as known at the time of this report - Datum should be NAD83.
POO_LD_TWP VARCHAR2(5 BYTE) Yes null 13 The PLSS township (tier) of the point-of-origin for this planned ignition as known at the time of this 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 14 The PLSS range of the point-of-origin for this planned ignition as known at the time of this 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 15 The PLSS section of the point-of-origin for this planned ignition as known at the time of this 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 16 The PLSS quarter-section of the point-of-origin for this planned ignition as known at the time of this 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 17 The PLSS quarter-quarter-section of the point-of-origin for this planned ignition as known at the time of this 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 18 The PLSS quarter-quarter-quarter-section of the point-of-origin for this planned ignition as known at the time of this 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 19 The PLSS quarter-quarter-quarter-quarter-section of the point-of-origin for this planned ignition as known at the time of this report. Since legal descriptions are most commonly derived from USGS quadrangle maps, most are still published in NAD27 (though being updated in NAD83).
CONTINGENT_RESOURCES_NARR VARCHAR2(4000 BYTE) Yes null 20 Any narrative/text about contingent resources for this planned ignition at the time of this report.
CREATED_BY VARCHAR2(30 BYTE) No null 21 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 22 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 23 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 24 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_LD_PM_IDENTIFIER NUMBER(9,0) Yes null 25 FK to SIT209_LOOKUP_CODES for point-of-origin Principal Meridian for this report.
PLANNED_IGNITION_NAME VARCHAR2(50 BYTE) No null 26 The full name assigned to this planned ignition.
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
PIR_LUCODES_PDUOM_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
PIR_LUCODES_PLSZUOM_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
PIR_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
PIR_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
PIR_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 PIR_PK null null
PIR_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
PIR_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
PIR_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
PIR_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
PIR_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:06 SIT209 PIR_UK null null
SYS_C00208309 Check "PIR_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208310 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:06 null null null null
SYS_C00208311 Check "REPORT_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208312 Check "CREATED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208313 Check "CREATED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208314 Check "LAST_MODIFIED_BY" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208315 Check "LAST_MODIFIED_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null
SYS_C00208316 Check "PLANNED_IGNITION_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:06 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
PLANNED_DUR_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PLANNED_SZ_UOM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
POO_LD_PM_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
PIR_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
PLANNED_IGNITION_NAME 1
DONWCGU_PROT_UNIT_IDENTIFIER 2
REPORT_DATE 3
COLUMN_NAME COLUMN_POSITION
PIR_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
DONWCGU_PROT_UNIT_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
REPORT_DATE 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
PLANNED_IGNITION_NAME null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 PLANNED_IGNITION_REPORTS
INSERT IMSRMGR NO SIT209 PLANNED_IGNITION_REPORTS
SELECT IMSRMGR NO SIT209 PLANNED_IGNITION_REPORTS
UPDATE IMSRMGR NO SIT209 PLANNED_IGNITION_REPORTS
SELECT FAMWEB_ETL NO SIT209 PLANNED_IGNITION_REPORTS
SELECT FAMWEBREADONLY NO SIT209 PLANNED_IGNITION_REPORTS
NAME VALUE
NUM_ROWS 1127
BLOCKS 73
AVG_ROW_LEN 147
SAMPLE_SIZE 1127
LAST_ANALYZED 06-JUN-19 22:01:31
LAST_ANALYZED_SINCE 06-JUN-19 22:01:31



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_PIR_TRG BEFORE EACH ROW SIT209 INSERT ENABLED PLANNED_IGNITION_REPORTS
BRIU_AUDIT_PIR_TRG BEFORE EACH ROW SIT209 INSERT OR UPDATE ENABLED PLANNED_IGNITION_REPORTS




TRIGGER SIT209.BRI_PIR_TRG
 BEFORE
  INSERT
 ON SIT209.PLANNED_IGNITION_REPORTS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set PIR_IDENTIFIER on insert if not supplied.
    begin
      if :new.pir_identifier IS NULL then
        :new.pir_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
TRIGGER SIT209.BRIU_AUDIT_PIR_TRG
 BEFORE
  INSERT OR UPDATE
 ON SIT209.PLANNED_IGNITION_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;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 BRI_PIR_TRG TRIGGER SIT209 PLANNED_IGNITION_REPORTS TABLE
SIT209 BRIU_AUDIT_PIR_TRG TRIGGER SIT209 PLANNED_IGNITION_REPORTS TABLE
SIT209 PLANNED_IGNITION_REPORTS_V VIEW SIT209 PLANNED_IGNITION_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
NAME VALUE
CREATED 13-DEC-12 10:15:06
LAST_DDL_TIME 27-MAY-16 10:45:51
OWNER SIT209
TABLE_NAME PLANNED_IGNITION_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 1127
BLOCKS 73
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 147
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 1127
LAST_ANALYZED 06-JUN-19 22:01:31
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 that stores data about planned ignitions at a point-in-time.  A planned ingition is a type of incident.
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 PIR_PK UNIQUE VALID NORMAL N NO null NO PIR_IDENTIFIER null
SIT209 PIR_UK UNIQUE VALID NORMAL N NO null NO PLANNED_IGNITION_NAME, DONWCGU_PROT_UNIT_IDENTIFIER, REPORT_DATE null
SIT209 PIR_LUCODES_PDUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PLANNED_DUR_UOM_IDENTIFIER null
SIT209 PIR_NWCG_PROT_UNIT_FK_I NONUNIQUE VALID NORMAL N NO null NO DONWCGU_PROT_UNIT_IDENTIFIER null
SIT209 PIR_LUCODES_PLSZUOM_FK_I NONUNIQUE VALID NORMAL N NO null NO PLANNED_SZ_UOM_IDENTIFIER null
SIT209 PIR_LUCODES_PMERIDIAN_FK_I NONUNIQUE VALID NORMAL N NO null NO POO_LD_PM_IDENTIFIER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 PIR_PK SIT209 PLANNED_IGNITION_REPORTS PIR_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 PIR_UK SIT209 PLANNED_IGNITION_REPORTS PLANNED_IGNITION_NAME 1 50 50 ASC
SIT209 PIR_UK SIT209 PLANNED_IGNITION_REPORTS DONWCGU_PROT_UNIT_IDENTIFIER 2 22 0 ASC
SIT209 PIR_UK SIT209 PLANNED_IGNITION_REPORTS REPORT_DATE 3 7 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 PIR_LUCODES_PDUOM_FK_I SIT209 PLANNED_IGNITION_REPORTS PLANNED_DUR_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 PIR_NWCG_PROT_UNIT_FK_I SIT209 PLANNED_IGNITION_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 PIR_LUCODES_PLSZUOM_FK_I SIT209 PLANNED_IGNITION_REPORTS PLANNED_SZ_UOM_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 PIR_LUCODES_PMERIDIAN_FK_I SIT209 PLANNED_IGNITION_REPORTS POO_LD_PM_IDENTIFIER 1 22 0 ASC