View slot9.WORLD.TSTA.JS_DS_NIBRS_OFFENSES_VW
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
DS_ICR_HEADERID number 0
DS_ICR_UNIQUE_KEY varchar2 255
DS_ICR_REC_NUM varchar2 255
DS_ICR_GENERIC_KEY1 varchar2 0  √  null
IBR_SEGMENT varchar2 100
DS_IBR_SEGMENTS.IBR_SEGMENT Implied Constraint R
ACTION varchar2 2000  √  null
DE_1 varchar2 2000  √  null
DE_2 varchar2 255  √  null
DE_6 varchar2 2000  √  null
DE_7 varchar2 2000  √  null
DE_8 varchar2 4000  √  null
DE_8A varchar2 4000  √  null
DE_9 varchar2 2000  √  null
DE_10 varchar2 2000  √  null
DE_11 varchar2 2000  √  null
DE_12 varchar2 4000  √  null
DE_13 varchar2 4000  √  null
POSTED varchar2 1
TIMEMADE date 7  √  null
TIMEMARKED date 7  √  null
TIMERECVED date 7  √  null
TIMESENT date 7  √  null
OPEN_STATUS varchar2 1
RECSFINLED number 0  √  null
RECSSENT number 0  √  null
USERMADE varchar2 255  √  null
USERMARKED varchar2 255  √  null
USERRECVED varchar2 255  √  null
USERSENT varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT DIFV.DATASETID, DIFV.DS_ICR_HEADERID, DIFV.DS_ICR_UNIQUE_KEY, DIFV.DS_ICR_REC_NUM, NULL AS DS_ICR_GENERIC_KEY1, -- Only Used for PROPERTY DIFV.IBR_SEGMENT, MAX ( DECODE (DIFV.DATA_ELEMENT_PROMPT, 'Segment Action Type', TRIM (DIFV.DATA_VALUE))) AS ACTION, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '1', TRIM (DIFV.data_value))) DE_1, MAX (DIFV.INCIDENT_NBR) DE_2, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '6', TRIM (DIFV.data_value))) DE_6, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '7', TRIM (DIFV.data_value))) DE_7, STRAGG (DECODE (DIFV.DATA_ELEMENT_NUM, '8', TRIM (DIFV.data_value))) DE_8, STRAGG (DECODE (DIFV.DATA_ELEMENT_NUM, '8A', TRIM (DIFV.data_value))) DE_8A, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '9', TRIM (DIFV.data_value))) DE_9, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '10', TRIM (DIFV.data_value))) DE_10, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '11', TRIM (DIFV.data_value))) DE_11, STRAGG (DECODE (DIFV.DATA_ELEMENT_NUM, '12', TRIM (DIFV.data_value))) DE_12, STRAGG (DECODE (DIFV.DATA_ELEMENT_NUM, '13', TRIM (DIFV.data_value))) DE_13, DIFV.POSTED AS POSTED, DIDS.TIMEMADE AS TIMEMADE, DIDS.TIMEMARKED AS TIMEMARKED, DIDS.TIMERECVED AS TIMERECVED, DIDS.TIMESENT AS TIMESENT, DIDS.OPEN_STATUS AS OPEN_STATUS, DIDS.RECSFINLED AS RECSFINLED, DIDS.RECSSENT AS RECSSENT, DIDS.USERMADE AS USERMADE, DIDS.USERMARKED AS USERMARKED, DIDS.USERRECVED AS USERRECVED, DIDS.USERSENT AS USERSENT FROM DS_IBR_FIELD_VALUES_VW DIFV JOIN DS_ICR_DATA_SETS DIDS ON DIDS.DATASETID = DIFV.DATASETID WHERE DIFV.IBR_SEGMENT = 'OFFENSES' GROUP BY DIFV.DATASETID, DIFV.DS_ICR_HEADERID, DIFV.DS_ICR_UNIQUE_KEY, DIFV.DS_ICR_REC_NUM, DIFV.IBR_SEGMENT, DIFV.POSTED, DIDS.TIMEMADE, DIDS.TIMEMARKED, DIDS.TIMERECVED, DIDS.TIMESENT, DIDS.OPEN_STATUS, DIDS.RECSFINLED, DIDS.RECSSENT, DIDS.USERMADE, DIDS.USERMARKED, DIDS.USERRECVED, DIDS.USERSENT
 
Possibly Referenced Tables/Views:
DS_IBR_FIELD_VALUES_VW DS_ICR_DATA_SETS OFFENSES 


Close relationships: