|
|
| 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 |
| ID |
varchar2 |
190 |
√ |
|
null |
|
|
| INCIDENT_ID |
number |
0 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| SUPP_SEQ |
number |
38 |
|
|
|
|
|
| FORWARD_TO_SA |
varchar2 |
1 |
√ |
|
null |
|
|
| ISC_STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| AGENCY |
varchar2 |
40 |
√ |
|
null |
|
|
| STATUS |
varchar2 |
4000 |
√ |
|
null |
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| REPORT_DATE |
varchar2 |
10 |
√ |
|
null |
|
|
| START_DATE |
varchar2 |
10 |
√ |
|
null |
|
|
| END_DATE |
varchar2 |
10 |
√ |
|
null |
|
|
| SUMMARY |
varchar2 |
1000 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| PER_PERSON_ID |
number |
0 |
|
|
|
|
|
| MN_ID |
number |
0 |
|
|
|
|
|
| SLNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| SFNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| SSN_NO |
number |
0 |
√ |
|
null |
|
|
| DOB |
date |
7 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
|
|
|
|
|
| RACE_CODE |
varchar2 |
30 |
|
|
|
|
|
| SSN |
varchar2 |
162 |
√ |
|
null |
|
|
| AGE |
number |
0 |
√ |
|
null |
|
|
| RACE |
varchar2 |
4000 |
√ |
|
null |
|
|
| SEX |
varchar2 |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT (USER || i.incident_id || ip.supp_seq || ip.per_person_id
|| ip.mn_mn_id
) AS ID,
i.incident_id, i.agncy_cd_agency_code, ip.supp_seq,
isp.forward_to_sa, isp.isc_status_code,
INITCAP ((SELECT ac.agency_desc
FROM agency_codes ac
WHERE ac.agency_code = i.agncy_cd_agency_code))
AS agency,
INITCAP ((SELECT ec.description
FROM ejs_codes ec
WHERE ec.code_type = isp.isc_status_code_type
AND ec.code = isp.isc_status_code)
) AS status,
i.inc_report_number,
TO_CHAR (i.report_date, 'MM/DD/YYYY') AS report_date,
TO_CHAR (i.start_date, 'MM/DD/YYYY') AS start_date,
TO_CHAR (i.end_date, 'MM/DD/YYYY') AS end_date, i.summary, mn.lname,
mn.fname, mn.per_person_id, mn.mn_id, mn.slname, mn.sfname,
mn.ssn AS ssn_no, mn.dob, mp.sex_code, mp.race_code,
( SUBSTR (TO_CHAR (mn.ssn), 1, 3)
|| '-'
|| SUBSTR (TO_CHAR (mn.ssn), 4, 2)
|| '-'
|| SUBSTR (TO_CHAR (mn.ssn), 6)
) AS ssn,
FLOOR (MONTHS_BETWEEN (SYSDATE, mn.dob) / 12) AS age,
INITCAP ((SELECT ec.description
FROM ejs_codes ec
WHERE ec.code_type = mp.race_code_type
AND ec.code = mp.race_code)
) AS race,
INITCAP ((SELECT ec.description
FROM ejs_codes ec
WHERE ec.code_type = mp.sex_code_type
AND ec.code = mp.sex_code)
) AS sex
FROM incidents i INNER JOIN incident_supplements isp
ON isp.inc_incident_id = i.incident_id
INNER JOIN incident_people ip ON i.incident_id = ip.inc_incident_id
INNER JOIN master_names mn ON mn.mn_id = ip.mn_mn_id
INNER JOIN people p ON mn.per_person_id = p.person_id
INNER JOIN master_people mp ON p.master_person_id =
mp.master_person_id
Possibly Referenced Tables/Views:
