|
|
| 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 |
|
|
|
|
|
| MAX_DATE |
date |
7 |
√ |
|
null |
|
|
| POSTED |
varchar2 |
1 |
|
|
|
|
|
| HEADERID |
number |
0 |
|
|
|
|
|
| STATE_STATUS |
varchar2 |
30 |
√ |
|
null |
|
|
| INCIDENT_ID |
number |
0 |
|
|
|
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| HEADER_INC_REPORT_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| REPORT_DATE |
date |
7 |
|
|
|
|
|
| OFFENSES |
varchar2 |
4000 |
√ |
|
null |
|
|
| STATUS |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
DSH.DATASETID,
DSI.MAX_DATE,
DSH.POSTED,
DSH.HEADERID,
DSH.STATE_STATUS,
I.INCIDENT_ID,
I.INC_REPORT_NUMBER,
DSH.INCIDENTNO AS HEADER_INC_REPORT_NUMBER,
I.AGNCY_CD_AGENCY_CODE AS AGENCY_CODE,
DSH.INCDATE AS START_DATE,
I.REPORT_DATE,
(SELECT stragg (OC.OFFENSE_DESC)
FROM OFFENSES O
INNER JOIN OFFENSE_CODES OC ON O.OFFNS_CD_OFFENSE_CODE = OC.OFFENSE_CODE
WHERE O.INC_INCIDENT_ID = I.INCIDENT_ID) OFFENSES,
(SELECT ISUP.DS_ICR_SUBMISSION_STATUS
FROM INCIDENT_SUPPLEMENTS ISUP
WHERE ISUP.INC_INCIDENT_ID = I.INCIDENT_ID
AND ISUP.SUPP_SEQ = (SELECT MAX(ISUP2.SUPP_SEQ) FROM INCIDENT_SUPPLEMENTS ISUP2
WHERE ISUP2.INC_INCIDENT_ID = ISUP.INC_INCIDENT_ID
AND ISUP2.ISC_STATUS_CODE_TYPE = 'INCIDENT_STATUS_CODES'
AND ISUP2.ISC_STATUS_CODE = 'A')) AS STATUS
FROM DS_ICR_HEADERS DSH
INNER JOIN DS_ICR_DATA_SETS DSI ON DSH.DATASETID = DSI.DATASETID
INNER JOIN INCIDENTS I ON DSH.REPNUM = I.INCIDENT_ID
INNER JOIN AGENCY_CODES AC ON I.AGNCY_CD_AGENCY_CODE = AC.AGENCY_CODE
Possibly Referenced Tables/Views:
