Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
DISPOFCP_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier of this Dispatch Office profile record (sequence: SIT209_SEQ).
DISPOFC_IDENTIFIER NUMBER(9,0) No null 2 The FK to sit209.DISPATCH_OFFICES that identifies the Dispatch Office to which this profile record applies.
LUCODES_IDENTIFIER NUMBER(9,0) No null 3 The FK to sit209.SIT209_LOOKUP_CODES that identifies the Code Type/Value to which this profile record applies.  Initially this code reference will be to Resource Type ('RESOURCE_TYPE')
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
DISPFCP_DISPFC_FK Foreign_Key null SIT209 DISPATCH_OFFICES DISPOFC_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:15 null null null null
DISPFCP_LUCODES_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
DISPFCP_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:04 SIT209 DISPFCP_PK null null
DISPFCP_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13-DEC-12 10:15:04 SIT209 DISPFCP_UK null null
SYS_C00208197 Check "DISPOFCP_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:04 null null null null
SYS_C00208198 Check "DISPOFC_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:04 null null null null
SYS_C00208199 Check "LUCODES_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13-DEC-12 10:15:04 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
DISPOFC_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
LUCODES_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
DISPOFCP_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
DISPOFC_IDENTIFIER 1
LUCODES_IDENTIFIER 2
COLUMN_NAME COLUMN_POSITION
DISPOFCP_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
DISPOFC_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
LUCODES_IDENTIFIER null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
DELETE IMSRMGR NO SIT209 DISPATCH_OFFICE_PROFILES
INSERT IMSRMGR NO SIT209 DISPATCH_OFFICE_PROFILES
SELECT IMSRMGR NO SIT209 DISPATCH_OFFICE_PROFILES
UPDATE IMSRMGR NO SIT209 DISPATCH_OFFICE_PROFILES
SELECT FAMWEB_ETL NO SIT209 DISPATCH_OFFICE_PROFILES
SELECT FAMWEBREADONLY NO SIT209 DISPATCH_OFFICE_PROFILES
NAME VALUE
NUM_ROWS 3102
BLOCKS 13
AVG_ROW_LEN 13
SAMPLE_SIZE 3102
LAST_ANALYZED 02-FEB-17 22:00:53
LAST_ANALYZED_SINCE 02-FEB-17 22:00:53



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_DISPOFCP_TRG BEFORE EACH ROW SIT209 INSERT ENABLED DISPATCH_OFFICE_PROFILES




TRIGGER SIT209.BRI_DISPOFCP_TRG
 BEFORE
  INSERT
 ON SIT209.DISPATCH_OFFICE_PROFILES
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set DISPOFCP_IDENTIFIER on insert if not supplied.
    begin
      if :new.dispofcp_identifier IS NULL then
        :new.dispofcp_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 TU_DISPOFCP_IO_TRG TRIGGER SIT209 DISPATCH_OFFICE_PROFILES TABLE
SIT209 BRI_DISPOFCP_TRG TRIGGER SIT209 DISPATCH_OFFICE_PROFILES TABLE
SIT209 SIT209_UTIL PACKAGE BODY SIT209 DISPATCH_OFFICE_PROFILES 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:04
LAST_DDL_TIME 04-MAY-16 09:33:30
OWNER SIT209
TABLE_NAME DISPATCH_OFFICE_PROFILES
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 3102
BLOCKS 13
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 13
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 3102
LAST_ANALYZED 02-FEB-17 22:00:53
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 Dispatch Office (to look-up codes) SIT/209 application profiles.  It is used within the SIT/209 application to filter look-up codes based on Dispatch Office preferences.  Initially, it is used to identify the set of resource types typically deployed by a Dispatch Office to all-risk incidents, thus is used by the application to filter the list of resource types, by Dispatch Office, available to the user within the 209 "Resource Utilizations" data entry screen.  It's use can be extended to filter other lookup code types if needed.
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 DISPFCP_PK UNIQUE VALID NORMAL N NO null NO DISPOFCP_IDENTIFIER null
SIT209 DISPFCP_UK UNIQUE VALID NORMAL N NO null NO DISPOFC_IDENTIFIER, LUCODES_IDENTIFIER null
SIT209 DISPFCP_DISPFC_FK_I NONUNIQUE VALID NORMAL N NO null NO DISPOFC_IDENTIFIER null
SIT209 DISPFCP_LUCODES_FK_I NONUNIQUE VALID NORMAL N NO null NO LUCODES_IDENTIFIER null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 DISPFCP_PK SIT209 DISPATCH_OFFICE_PROFILES DISPOFCP_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 DISPFCP_UK SIT209 DISPATCH_OFFICE_PROFILES DISPOFC_IDENTIFIER 1 22 0 ASC
SIT209 DISPFCP_UK SIT209 DISPATCH_OFFICE_PROFILES LUCODES_IDENTIFIER 2 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 DISPFCP_DISPFC_FK_I SIT209 DISPATCH_OFFICE_PROFILES DISPOFC_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 DISPFCP_LUCODES_FK_I SIT209 DISPATCH_OFFICE_PROFILES LUCODES_IDENTIFIER 1 22 0 ASC