View slot9.WORLD.TSTA.INCIDENT_CASE_OFFICERS_VW
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 Comments
INC_CASE_ID number 0
INCIDENT_CASES.INC_CASE_ID Implied Constraint R
INC_CASE_NUMBER varchar2 20
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
UNIT_CODE varchar2 5  √  null
CASE_SECURITY_LEVEL number 38  √  null
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
REVIEW_STATUS_CODE varchar2 30
REVIEW_STATUS_DESC varchar2 4000  √  null
CASE_STATUS_CODE varchar2 30  √  null
CASE_STATUS_DESC varchar2 4000  √  null
CASE_SOLVABILITY_CODE varchar2 30  √  null
CASE_SOLVABILITY_DESC varchar2 4000  √  null
DATE_CLEARED date 7  √  null
DATE_EXPIRED date 7  √  null
REVIEW_UPDATE varchar2 1  √  null
INC_REPORT_NUMBER varchar2 20  √  null
INC_AGENCY_CODE varchar2 30  √  null
INC_AGENCY_DESC varchar2 40  √  null
REPORT_DATE date 7  √  null
START_DATE date 7  √  null
END_DATE date 7  √  null
REPORT_SUMMARY varchar2 1000  √  null
ADDRESS_ID number 0  √  null
ADDRESSES.ADDRESS_ID Implied Constraint R
ADDRESS_SUMMARY varchar2 4000  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
SUPP_SEQ number 0
SUPP_AGENCY_CODE varchar2 30  √  null
ISC_STATUS_CODE varchar2 30
SUPP_REPORT_DATE date 7
SUPP_REPORT_TIME date 7
SUPP_REPORT_OWNER varchar2 100  √  null
SUPP_APPROVAL_DATE date 7  √  null
SUPP_APPROVER varchar2 100  √  null
SUPP_CID varchar2 1  √  null
SUPP_SECURITY_LEVEL number 38  √  null
SUPP_AGENCY_ONLY varchar2 1  √  null
OFFICER_END_DATE date 7  √  null
OFFICER_ASSIGN_DATE date 7  √  null
OFFICER_ID number 0
OFFICERS.OFFICER_ID Implied Constraint R
OFFICER_LNAME varchar2 20
OFFICER_FNAME varchar2 20  √  null
OFFICER_NAME varchar2 42  √  null
OFFICER_NAME_BADGE varchar2 145  √  null
OFFICER_TITLE varchar2 20  √  null
SUPERVISOR varchar2 1  √  null
OFFICER_LOGIN varchar2 100  √  null
OFFICER_BADGE_NO varchar2 100
DETECTIVE varchar2 1  √  null
ACTIVE_OFFICER varchar2 1  √  null
TODAYS_DATE date 8  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ic.inc_case_id, ic.inc_case_number, ic.agency_code, ic.unit_code, ic.security_level "CASE_SECURITY_LEVEL", ici.incident_id, ic.rsc_status_code "REVIEW_STATUS_CODE", ec_rev.description "REVIEW_STATUS_DESC", ic.case_status_code, ec_cs.description "CASE_STATUS_DESC", ic.sc1_solvability_code "CASE_SOLVABILITY_CODE", ec_slv.description "CASE_SOLVABILITY_DESC", ic.date_cleared, ic.date_expired, ic.review_update, i.inc_report_number, i.agncy_cd_agency_code "INC_AGENCY_CODE", ac.agency_desc "INC_AGENCY_DESC", i.report_date, i.start_date, i.end_date, i.summary "REPORT_SUMMARY", ia.address_id, ejs_addresses.address_summary (ia.address_id) "ADDRESS_SUMMARY", ia.beat, ia.sub_beat, supp.supp_seq, supp.supp_agency_code, supp.isc_status_code, supp.supp_report_date "SUPP_REPORT_DATE", supp.supp_report_time "SUPP_REPORT_TIME", supp.responsible_user_id "SUPP_REPORT_OWNER", supp.approval_date "SUPP_APPROVAL_DATE", supp.approval_user_id "SUPP_APPROVER", supp.cid "SUPP_CID", supp.security_level "SUPP_SECURITY_LEVEL", supp.agency_only "SUPP_AGENCY_ONLY", ico.end_date "OFFICER_END_DATE", ico.assign_date "OFFICER_ASSIGN_DATE", o.officer_id, o.lname "OFFICER_LNAME", o.fname "OFFICER_FNAME", o.lname || ', ' || fname "OFFICER_NAME", o.lname || ', ' || fname || DECODE (internal_id, NULL, NULL, ' - ' || internal_id) "OFFICER_NAME_BADGE", o.title "OFFICER_TITLE", o.supervisor, o.user_id "OFFICER_LOGIN", o.internal_id "OFFICER_BADGE_NO", o.detective, o.active "ACTIVE_OFFICER", SYSDATE "TODAYS_DATE" FROM officers o, incident_cases ic, incident_case_officers ico, incidents i, incident_supplements supp, incident_addresses ia, inc_case_incidents ici, ejs_codes ec_rev, ejs_codes ec_cs, ejs_codes ec_slv, ejs_codes ec_stat, agency_codes ac WHERE o.officer_id = ico.officer_id AND i.incident_id = supp.inc_incident_id AND i.incident_id = ia.incident_id(+) AND ic.inc_case_id = ici.inc_case_id(+) AND ic.inc_case_id = ico.inc_case_id AND ici.incident_id = i.incident_id(+) AND ic.rsc_status_code = ec_rev.code(+) AND ic.rsc_status_code_type = ec_rev.code_type(+) AND ac.agency_code = i.agncy_cd_agency_code AND ic.case_status_code = ec_cs.code(+) AND ic.case_status_code_type = ec_cs.code_type(+) AND ic.sc1_solvability_code = ec_slv.code(+) AND ic.sc1_solvability_code_type = ec_slv.code_type(+) AND supp.isc_status_code = ec_stat.code AND supp.isc_status_code_type = ec_stat.code_type
 
Possibly Referenced Tables/Views:
AGENCY_CODES EJS_CODES INC_CASE_INCIDENTS INCIDENT_ADDRESSES INCIDENT_CASE_OFFICERS INCIDENT_CASES INCIDENT_SUPPLEMENTS INCIDENTS OFFICERS 


Close relationships: