View slot9.WORLD.TSTA.JS_DS_NIBRS_GROUPB_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_40 varchar2 2000  √  null
DE_41 varchar2 2000  √  null
DE_42 varchar2 2000  √  null
DE_43 varchar2 2000  √  null
DE_44 varchar2 2000  √  null
DE_45 varchar2 2000  √  null
DE_46 varchar2 4000  √  null
DE_47 varchar2 2000  √  null
DE_48 varchar2 2000  √  null
DE_49 varchar2 2000  √  null
DE_50 varchar2 2000  √  null
DE_51 varchar2 2000  √  null
DE_52 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 (DIFV.data_value))) DE_1, MAX (DIFV.INCIDENT_NBR) DE_2, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '40', TRIM (DIFV.data_value))) DE_40, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '41', TRIM (DIFV.data_value))) DE_41, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '42', TRIM (DIFV.data_value))) DE_42, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '43', TRIM (DIFV.data_value))) DE_43, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '44', TRIM (DIFV.data_value))) DE_44, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '45', TRIM (DIFV.data_value))) DE_45, stragg (DECODE (DIFV.DATA_ELEMENT_NUM, '46', TRIM (DIFV.data_value))) DE_46, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '47', TRIM (DIFV.data_value))) DE_47, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '48', TRIM (DIFV.data_value))) DE_48, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '49', TRIM (DIFV.data_value))) DE_49, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '50', TRIM (DIFV.data_value))) DE_50, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '51', TRIM (DIFV.data_value))) DE_51, MAX (DECODE (DIFV.DATA_ELEMENT_NUM, '52', TRIM (DIFV.data_value))) DE_52, 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 = 'GROUPB' 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: