|
|
| 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 |
|
|
|
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| ACTION |
varchar2 |
255 |
√ |
|
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,
dih.action
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
JOIN incidents inc ON inc.incident_id = dih.repnum
JOIN agency_codes ac ON inc.agncy_cd_agency_code = ac.agency_code
Possibly Referenced Tables/Views:
