|
|
| 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 |
| DATASETID |
number |
0 |
|
|
|
|
|
| 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 |
|
|
|
|
|
| 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 |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT DISTINCT
datasetid AS datasetid
, ds_icr_headerid AS ds_icr_headerid
, ds_icr_unique_key AS ds_icr_unique_key
, ds_icr_rec_num AS ds_icr_rec_num
, NULL AS ds_icr_generic_key1
, ibr_segment AS ibr_segment
, MAX(DECODE(data_element_prompt,'Segment Action Type',TRIM(data_value))) AS action
, MAX(DECODE (data_element_num, '1', TRIM (data_value))) AS de_1
, MAX(incident_nbr) AS de_2
, MAX(DECODE(data_element_num,'6',TRIM(data_value))) AS de_6
, MAX(DECODE(data_element_num,'7',TRIM(data_value))) AS de_7
, STRAGG(DECODE(data_element_num,'8',TRIM (data_value))) AS de_8
, STRAGG(DECODE(data_element_num,'8A',TRIM (data_value))) AS de_8A
, MAX(DECODE(data_element_num,'9',TRIM (data_value))) AS de_9
, MAX(DECODE(data_element_num,'10',TRIM (data_value))) AS de_10
, MAX(DECODE(data_element_num,'11',TRIM (data_value))) AS de_11
, STRAGG(DECODE(data_element_num,'12',TRIM (data_value))) AS de_12
, STRAGG(DECODE(data_element_num,'13',TRIM (data_value))) AS de_13
FROM ds_ibr_field_values_vw
WHERE ibr_segment = 'OFFENSES'
AND posted = 'Y'
GROUP BY
datasetid
, ds_icr_headerid
, ds_icr_unique_key
, ds_icr_rec_num
, ibr_segment
ORDER BY
ds_icr_headerid
Possibly Referenced Tables/Views:
