|
|
| 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_36 |
varchar2 |
2000 |
√ |
|
null |
|
|
| DE_37 |
varchar2 |
2000 |
√ |
|
null |
|
|
| DE_38 |
varchar2 |
2000 |
√ |
|
null |
|
|
| DE_39 |
varchar2 |
2000 |
√ |
|
null |
|
|
| DE_39A |
varchar2 |
2000 |
√ |
|
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,'36',TRIM(data_value))) AS de_36
, MAX(DECODE(data_element_num,'37',TRIM(data_value))) AS de_37
, MAX(DECODE(data_element_num,'38',TRIM(data_value))) AS de_38
, MAX(DECODE(data_element_num,'39',TRIM(data_value))) AS de_39
, MAX(DECODE(data_element_num,'39A',TRIM(data_value))) AS de_39a
FROM ds_ibr_field_values_vw
WHERE ibr_segment = 'OFFENDERS'
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:
