View slot9.WORLD.TSTA.JS_DS_NIBRS_HEADERS_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_SHORT varchar2 2000  √  null
DE_2 varchar2 255  √  null
DE_2A varchar2 2000  √  null
DE_3 varchar2 4000  √  null
DE_4 varchar2 2000  √  null
DE_5 varchar2 2000  √  null
EXCEP_OFF_CODE 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 AS DATASETID, DIFV.DS_ICR_HEADERID AS DS_ICR_HEADERID, DIFV.DS_ICR_UNIQUE_KEY AS DS_ICR_UNIQUE_KEY, DIFV.DS_ICR_REC_NUM AS DS_ICR_REC_NUM, NULL AS DS_ICR_GENERIC_KEY1 , -- Only Used for PROPERTY DIFV.IBR_SEGMENT AS 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))) AS DE_1, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '2', TRIM (DIFV.data_value))) AS DE_2_short, MAX (INCIDENT_NBR) AS DE_2, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '2A', TRIM (DIFV.data_value))) AS DE_2A, REPLACE ( STRAGG (DECODE (DIFV.DATA_ELEMENT_NUM, '3', TRIM (DIFV.data_value))), ', ', '') AS DE_3, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '4', TRIM (DIFV.data_value))) AS DE_4, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '5', TRIM (DIFV.data_value))) AS DE_5, MAX (DECODE (DIFV.NAV_ORDER, '12.01', TRIM (DIFV.DATA_VALUE))) AS EXCEP_OFF_CODE, -- RMS DOES NOT SUPPORT MORE THAN ONE OFFENSE CLEARED 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 = 'HEADERS' 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: