Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
SIT209AG_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier of this agency (sequence: SIT209_SEQ)
AID VARCHAR2(4 BYTE) No null 2 The unique identifier of this agency
ANAME VARCHAR2(30 BYTE) No null 3 The name of this agency
ALEVEL VARCHAR2(3 BYTE) Yes null 4 The level (FED or STO) of this agency
WF_REPORTING VARCHAR2(1 BYTE) Yes null 5 A Y/N flag indicating wildfire reporting for this agency
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
SIT209AG_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:07 SIT209 SIT209AG_PK null null
SIT209AG_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:07 SIT209 SIT209AG_UK null null
SIT209AG_WFREP_CK Check WF_REPORTING IN ('Y','N') null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:14 null null null null
SYS_C00208323 Check "SIT209AG_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:07 null null null null
SYS_C00208324 Check "AID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:07 null null null null
SYS_C00208325 Check "ANAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:07 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
SIT209AG_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
AID 1
COLUMN_NAME COLUMN_POSITION
WF_REPORTING null
COLUMN_NAME COLUMN_POSITION
SIT209AG_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
AID null
COLUMN_NAME COLUMN_POSITION
ANAME null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 SIT209_AGENCIES
INSERT IMSRMGR NO SIT209 SIT209_AGENCIES
SELECT IMSRMGR NO SIT209 SIT209_AGENCIES
UPDATE IMSRMGR NO SIT209 SIT209_AGENCIES
SELECT FAMWEB_ETL NO SIT209 SIT209_AGENCIES
SELECT FAMWEBREADONLY NO SIT209 SIT209_AGENCIES
NAME VALUE
NUM_ROWS 18
BLOCKS 5
AVG_ROW_LEN 35
SAMPLE_SIZE 18
LAST_ANALYZED 11-DEC-13 22:00:35
LAST_ANALYZED_SINCE 11-DEC-13 22:00:35



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_SIT209AG_TRG BEFORE EACH ROW SIT209 INSERT ENABLED SIT209_AGENCIES




TRIGGER SIT209.BRI_SIT209AG_TRG
 BEFORE
  INSERT
 ON SIT209.SIT209_AGENCIES
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set SIT209AG_IDENTIFIER on insert if not supplied.
    begin
      if :new.sit209ag_identifier IS NULL then
        :new.sit209ag_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 BRI_SIT209AG_TRG TRIGGER SIT209 SIT209_AGENCIES TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 13-DEC-12 10:15:07
LAST_DDL_TIME 04-JAN-18 16:40:46
OWNER SIT209
TABLE_NAME SIT209_AGENCIES
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 18
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 35
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 18
LAST_ANALYZED 11-DEC-13 22:00:35
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 The table of Agencies as used by (from the perspective of) the SIT/209 business domain/application for upward reporting purposes.  Data initially sourced from IMSR.AGENCIES.  This perspective into federal agencies adds attributes specific to wildfire reporting and comingles federal departments, state offices, and other "upward reporting units" with the list of formally-defined federal agencies.
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 SIT209AG_PK UNIQUE VALID NORMAL N NO null NO SIT209AG_IDENTIFIER null
SIT209 SIT209AG_UK UNIQUE VALID NORMAL N NO null NO AID null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SIT209AG_PK SIT209 SIT209_AGENCIES SIT209AG_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 SIT209AG_UK SIT209 SIT209_AGENCIES AID 1 4 4 ASC