View slot9.WORLD.TSTA.JS_DS_NIBRS_OFFENDERS_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_36 varchar2 2000  √  null
DE_37 varchar2 2000  √  null
DE_38 varchar2 2000  √  null
DE_39 varchar2 2000  √  null
DE_39A varchar2 2000  √  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 (data_value))) DE_1, MAX (DIFV.INCIDENT_NBR) DE_2, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '36', TRIM (DIFV.data_value))) DE_36, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '37', TRIM (DIFV.data_value))) DE_37, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '38', TRIM (DIFV.data_value))) DE_38, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '39', TRIM (DIFV.data_value))) DE_39, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '39A', TRIM (DIFV.data_value))) DE_39A, DIFV.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 = 'OFFENDERS' 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 


Close relationships: