|
|
| 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 |
| CRIMINAL_COMPLAINT_ID |
number |
0 |
|
|
|
|
|
| CRIMINAL_COMPLAINT_NUM |
varchar2 |
100 |
√ |
|
null |
|
|
| COMPLAINT_DATETIME |
date |
7 |
√ |
|
null |
|
|
| STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATUS_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| STATUS_DATE |
date |
7 |
√ |
|
null |
|
|
| SUBMIT_STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUBMIT_STATUS_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUBMIT_STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| SUBMIT_STATUS_DATE |
date |
7 |
√ |
|
null |
|
|
| SUBMIT_STATUS_REASON |
varchar2 |
255 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| HEARING_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| HEARING_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| HEARING_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| COMPLAINT_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| COMPLAINT_TYPE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| COMPLAINT_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| THREAT_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| THREAT_TYPE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| THREAT_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| CHARGE_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| CHARGE_TYPE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| CHARGE_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| MNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| OBTN_NUMBER |
varchar2 |
100 |
√ |
|
null |
|
|
| COURT_DOCKET_NUMBER |
varchar2 |
100 |
√ |
|
null |
|
|
| OFFICER_ID |
number |
0 |
√ |
|
null |
|
| OFFICERS.OFFICER_ID
|
Implied Constraint R |
|
| OFFICER_FNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_MNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_LNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_INTERNAL_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| JUVENILE |
varchar2 |
1 |
|
|
|
|
|
| COMMENTS |
varchar2 |
255 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_CODE |
number |
0 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
CC.ID AS CRIMINAL_COMPLAINT_ID,
CC.CRIMINAL_COMPLAINT_NUM AS CRIMINAL_COMPLAINT_NUM,
CC.COMPLAINT_DATETIME AS COMPLAINT_DATETIME,
STATUS.CODE AS STATUS_CODE,
STATUS.CODE_TYPE AS STATUS_CODE_TYPE,
STATUS.DESCRIPTION AS STATUS_DESC,
CC.STATUS_DATE AS STATUS_DATE,
SUBMIT_STATUS.CODE AS SUBMIT_STATUS_CODE,
SUBMIT_STATUS.CODE_TYPE AS SUBMIT_STATUS_CODE_TYPE,
SUBMIT_STATUS.DESCRIPTION AS SUBMIT_STATUS_DESC,
CC.SUBMIT_STATUS_DATE AS SUBMIT_STATUS_DATE,
CC.SUBMIT_STATUS_REASON AS SUBMIT_STATUS_REASON,
AGENCY.AGENCY_CODE AS AGENCY_CODE,
AGENCY.AGENCY_DESC AS AGENCY_DESC,
HEARING.CODE AS HEARING_CODE,
HEARING.CODE_TYPE AS HEARING_CODE_TYPE,
HEARING.DESCRIPTION AS HEARING_DESC,
COMP_TYPE.CODE AS COMPLAINT_TYPE_CODE,
COMP_TYPE.CODE_TYPE AS COMPLAINT_TYPE_CODE_TYPE,
COMP_TYPE.DESCRIPTION AS COMPLAINT_TYPE_DESC,
THREAT.CODE AS THREAT_TYPE_CODE,
THREAT.CODE_TYPE AS THREAT_TYPE_CODE_TYPE,
THREAT.DESCRIPTION AS THREAT_TYPE_DESC,
CHARGE_TYPE.CODE AS CHARGE_TYPE_CODE,
CHARGE_TYPE.CODE_TYPE AS CHARGE_TYPE_CODE_TYPE,
CHARGE_TYPE.DESCRIPTION AS CHARGE_TYPE_DESC,
NAMES.FNAME AS FNAME,
NAMES.MNAME AS MNAME,
NAMES.LNAME AS LNAME,
CC.OBTN_NUMBER AS OBTN_NUMBER,
CC.COURT_DOCKET_NUMBER AS COURT_DOCKET_NUMBER,
OFFS.OFFICER_ID AS OFFICER_ID,
OFFS.FNAME AS OFFICER_FNAME,
OFFS.MNAME AS OFFICER_MNAME,
OFFS.LNAME AS OFFICER_LNAME,
OFFS.INTERNAL_ID AS OFFICER_INTERNAL_ID,
CC.JUVENILE AS JUVENILE,
CC.COMMENTS AS COMMENTS,
MP.INDX_SEC_LEVEL_CODE AS INDX_SEC_LEVEL_CODE,
CC.CREATOR_ID AS CREATOR_ID,
CC.CREATOR_DATE AS CREATOR_DATE,
CC.UPDATOR_ID AS UPDATOR_ID,
CC.UPDATOR_DATE AS UPDATOR_DATE
FROM CRIMINAL_COMPLAINTS CC
LEFT OUTER JOIN EJS_CODES STATUS ON STATUS.CODE_TYPE = CC.STATUS_CODE_TYPE AND STATUS.CODE = CC.STATUS_CODE
LEFT OUTER JOIN EJS_CODES SUBMIT_STATUS ON SUBMIT_STATUS.CODE_TYPE = CC.SUBMIT_STATUS_CODE_TYPE AND SUBMIT_STATUS.CODE = CC.SUBMIT_STATUS_CODE
LEFT OUTER JOIN AGENCY_CODES AGENCY ON AGENCY.AGENCY_CODE = CC.COMPLAINTANT_AGENCY_CODE
LEFT OUTER JOIN EJS_CODES HEARING ON HEARING.CODE_TYPE = CC.HEARING_CODE_TYPE AND HEARING.CODE = HEARING_CODE
LEFT OUTER JOIN EJS_CODES COMP_TYPE ON COMP_TYPE.CODE_TYPE = CC.COMPLAINT_TYPE_CODE_TYPE AND COMP_TYPE.CODE = CC.COMPLAINT_TYPE_CODE
LEFT OUTER JOIN EJS_CODES THREAT ON THREAT.CODE_TYPE = CC.THREAT_CODE_TYPE AND THREAT.CODE = CC.THREAT_CODE
LEFT OUTER JOIN EJS_CODES CHARGE_TYPE ON CHARGE_TYPE.CODE_TYPE = CC.CHARGE_TYPE_CODE_TYPE AND CHARGE_TYPE.CODE = CC.CHARGE_TYPE_CODE
LEFT OUTER JOIN MASTER_NAMES NAMES ON NAMES.MN_ID = CC.MN_MN_ID AND NAMES.PER_PERSON_ID = CC.PER_PERSON_ID
LEFT OUTER JOIN PEOPLE P ON NAMES.PER_PERSON_ID = P.PERSON_ID
LEFT OUTER JOIN MASTER_PEOPLE MP ON P.MASTER_PERSON_ID = MP.MASTER_PERSON_ID
LEFT OUTER JOIN OFFICERS OFFS ON OFFS.OFFICER_ID = CC.COMPLAINTANT_OFF_ID
Possibly Referenced Tables/Views:
