|
|
| 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 |
| IBR_FIELD_VALUE_ID |
number |
0 |
|
|
|
|
|
| IBR_FIELD_SYSTEM_ID |
number |
0 |
|
|
|
|
|
| EXTSYS_CODE |
varchar2 |
10 |
|
|
|
|
|
| DATASETID |
number |
0 |
|
|
|
|
|
| IBR_SEGMENT |
varchar2 |
100 |
|
|
|
|
|
| IBR_FIELD_ID |
number |
0 |
|
|
|
|
|
| DS_ICR_HEADERID |
number |
0 |
|
|
|
|
|
| DS_ICR_UNIQUE_KEY |
varchar2 |
255 |
|
|
|
|
|
| DS_ICR_REC_NUM |
varchar2 |
255 |
|
|
|
|
|
| DATA_ELEMENT_PROMPT |
varchar2 |
50 |
√ |
|
null |
|
|
| ORIG_IBR_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| TRANSLATED_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| MODIFIED_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| MODIFIED |
varchar2 |
1 |
|
|
|
|
|
| DATA_ELEMENT_NUM |
varchar2 |
30 |
√ |
|
null |
|
|
| NAV_ORDER |
number |
0 |
√ |
|
null |
|
|
| DATA_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| INCIDENT_NBR |
varchar2 |
255 |
√ |
|
null |
|
|
| POSTED |
varchar2 |
1 |
|
|
|
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
difv.ibr_field_value_id
, difs.ibr_field_system_id
, difs.extsys_code
, dih.datasetid
, difs.ibr_segment
, difs.ibr_field_id
, difv.ds_icr_headerid
, difv.ds_icr_unique_key
, difv.ds_icr_rec_num
, difs.data_element_prompt
, difv.orig_ibr_value
, difv.translated_value
, difv.modified_value
, difv.modified
, difs.data_element_num
, difs.nav_order
, COALESCE(difv.modified_value,difv.translated_value,difv.orig_ibr_value)
, COALESCE(dih.incidentno_converted,dih.incidentno)
, dih.posted
, ac.agency_code
, ac.agency_desc
FROM ds_ibr_field_systems difs
JOIN ds_ibr_field_values difv ON difv.ibr_field_system_id = difs.ibr_field_system_id
JOIN ds_icr_headers dih ON dih.headerid = difv.ds_icr_headerid
LEFT JOIN incidents inc ON inc.incident_id = dih.repnum
LEFT JOIN agency_codes ac ON inc.agncy_cd_agency_code = ac.agency_code
ORDER BY
difs.extsys_code
, difv.ds_icr_headerid
, difs.nav_order
, difv.ds_icr_rec_num
Possibly Referenced Tables/Views:
