View slot9.WORLD.TSTA.JS_DS_NIBRS_VICTIMS_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_23 varchar2 2000  √  null
DE_24 varchar2 4000  √  null
DE_25 varchar2 2000  √  null
DE_25A varchar2 2000  √  null
DE_25B varchar2 2000  √  null
DE_25C varchar2 2000  √  null
DE_26 varchar2 2000  √  null
DE_27 varchar2 2000  √  null
DE_28 varchar2 2000  √  null
DE_29 varchar2 2000  √  null
DE_30 varchar2 2000  √  null
DE_31 varchar2 4000  √  null
DE_32 varchar2 2000  √  null
DE_33 varchar2 4000  √  null
DE_34 varchar2 4000  √  null
DE_35 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 DATASETID, DS_ICR_HEADERID, DS_ICR_UNIQUE_KEY, DS_ICR_REC_NUM, NULL AS DS_ICR_GENERIC_KEY1, -- Only Used for PROPERTY IBR_SEGMENT, MAX ( DECODE (DATA_ELEMENT_PROMPT, 'Segment Action Type', TRIM (DATA_VALUE))) AS ACTION, MAX (DECODE (DATA_ELEMENT_NUM, '1', TRIM (data_value))) DE_1, MAX (INCIDENT_NBR) DE_2 ,MAX(DECODE(DATA_ELEMENT_NUM, '23', TRIM(data_value))) DE_23 ,stragg(DECODE(DATA_ELEMENT_NUM, '24', TRIM(data_value))) DE_24 ,MAX(DECODE(DATA_ELEMENT_NUM, '25', TRIM(data_value))) DE_25 ,MAX(DECODE(DATA_ELEMENT_NUM, '25A', TRIM(data_value))) DE_25A ,MAX(DECODE(DATA_ELEMENT_NUM, '25B', TRIM(data_value))) DE_25B ,MAX(DECODE(DATA_ELEMENT_NUM, '25C', TRIM(data_value))) DE_25C ,MAX(DECODE(DATA_ELEMENT_NUM, '26', TRIM(data_value))) DE_26 ,MAX(DECODE(DATA_ELEMENT_NUM, '27', TRIM(data_value))) DE_27 ,MAX(DECODE(DATA_ELEMENT_NUM, '28', TRIM(data_value))) DE_28 ,MAX(DECODE(DATA_ELEMENT_NUM, '29', TRIM(data_value))) DE_29 ,MAX(DECODE(DATA_ELEMENT_NUM, '30', TRIM(data_value))) DE_30 ,stragg(DECODE(DATA_ELEMENT_NUM, '31', TRIM(data_value))) DE_31 ,MAX(DECODE(DATA_ELEMENT_NUM, '32', TRIM(data_value))) DE_32 ,stragg(DECODE(DATA_ELEMENT_NUM, '33', TRIM(data_value))) DE_33 ,stragg(DECODE(DATA_ELEMENT_NUM, '34', TRIM(data_value))) DE_34 ,stragg(DECODE(DATA_ELEMENT_NUM, '35', TRIM(data_value))) DE_35, 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 JOIN DS_ICR_DATA_SETS DIDS USING (DATASETID) WHERE IBR_SEGMENT = 'VICTIMS' GROUP BY DATASETID, DS_ICR_HEADERID, DS_ICR_UNIQUE_KEY, DS_ICR_REC_NUM, IBR_SEGMENT, 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 VICTIMS 


Close relationships: