Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
INC209R_IDENTIFIER NUMBER(9,0) No null 1 Pseudo-FK to sit209.INCIDENT_209_REPORTS.
ROW_TYPE VARCHAR2(5 BYTE) No null 2 The type of data for this row.  Valid values are "HEAD" - Header;  "RSRC" - Resources line;  "PERS" - Personnel line;  "TOTAL" - Resources total line.
SORT_POSITION NUMBER(2,0) No null 3 Relative sort position for this record (within an ICS-209).
COL1 VARCHAR2(20 BYTE) Yes null 4 Content for column 1
COL2 VARCHAR2(10 BYTE) Yes null 5 Content for column 2
COL3 VARCHAR2(10 BYTE) Yes null 6 Content for column 3
COL4 VARCHAR2(10 BYTE) Yes null 7 Content for column 4
COL5 VARCHAR2(10 BYTE) Yes null 8 Content for column 5
COL6 VARCHAR2(10 BYTE) Yes null 9 Content for column 6
COL7 VARCHAR2(10 BYTE) Yes null 10 Content for column 7
COL8 VARCHAR2(10 BYTE) Yes null 11 Content for column 8
COL9 VARCHAR2(10 BYTE) Yes null 12 Content for column 9
COL10 VARCHAR2(10 BYTE) Yes null 13 Content for column 10
COL11 VARCHAR2(10 BYTE) Yes null 14 Content for column 11
COL12 VARCHAR2(10 BYTE) Yes null 15 Content for column 12
COL13 VARCHAR2(10 BYTE) Yes null 16 Content for column 13
COL14 VARCHAR2(10 BYTE) Yes null 17 Content for column 14
COL15 VARCHAR2(10 BYTE) Yes null 18 Content for column 15
COL16 VARCHAR2(10 BYTE) Yes null 19 Content for column 16
COL17 VARCHAR2(10 BYTE) Yes null 20 Content for column 17
COL18 VARCHAR2(10 BYTE) Yes null 21 Content for column 18
COL19 VARCHAR2(10 BYTE) Yes null 22 Content for column 19
COL20 VARCHAR2(10 BYTE) Yes null 23 Content for column 20
COL21 VARCHAR2(10 BYTE) Yes null 24 Content for column 21
COL22 VARCHAR2(10 BYTE) Yes null 25 Content for column 22
COL23 VARCHAR2(10 BYTE) Yes null 26 Content for column 23
COL24 VARCHAR2(10 BYTE) Yes null 27 Content for column 24
COL25 VARCHAR2(20 BYTE) Yes null 28 Content for column 25
USER_NAME VARCHAR2(30 BYTE) Yes null 29 The FAMWEB user that created this ICS-209 resources 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
SYS_C00289463 Check "INC209R_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 26-AUG-15 12:52:43 null null null null
SYS_C00289464 Check "ROW_TYPE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 26-AUG-15 12:52:43 null null null null
SYS_C00289465 Check "SORT_POSITION" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 26-AUG-15 12:52:43 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
INC209R_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
ROW_TYPE null
COLUMN_NAME COLUMN_POSITION
SORT_POSITION null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
SELECT FAMWEBREADONLY NO SIT209 SIT209_ICS209_RESOURCES_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_ICS209_RESOURCES_TEMP FUNCTION SIT209 SIT209_ICS209_RESOURCES_TEMP TABLE
SIT209 LOAD_ICS209_RESOURCES_TEMP_MLT FUNCTION SIT209 SIT209_ICS209_RESOURCES_TEMP TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 26-AUG-15 12:52:43
LAST_DDL_TIME 04-MAY-16 09:33:32
OWNER SIT209
TABLE_NAME SIT209_ICS209_RESOURCES_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 resources utilized used to facilitate the ICS-209 Report.  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