|
|
| 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 |
|
|
|
|
|
| INCIDENT_ID |
number |
0 |
|
|
|
|
|
| INC_REPORT_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
| ORIG_IBR_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| MODIFIED_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
| MODIFIED |
varchar2 |
1 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
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
, dih.repnum
, dih.incidentno
, difv.orig_ibr_value
, difv.modified_value
, difv.modified
, esa.agncy_cd_agency_code
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 external_system_agencies esa ON esa.exsys_code=difs.extsys_code
ORDER BY
difs.extsys_code
, difv.ds_icr_headerid
, difs.nav_order
, difv.ds_icr_rec_num
Possibly Referenced Tables/Views:
