View slot9.WORLD.TSTA.TDEX_RMS_NARRATIVE_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
HEADER char 2  √  null
ACTION varchar2 0  √  null
LABEL varchar2 0  √  null
UPDATE_DATE date 7  √  null
UPDATE_TIME varchar2 4  √  null
AGENCY varchar2 9  √  null
INCIDENT_NUMBER varchar2 20
ACCIDENT_NUMBER varchar2 0  √  null
NARRATIVE_UNIQUE_ID number 0
CASE_NUMBER varchar2 0  √  null
SUPPLEMENT_FLAG varchar2 1  √  null
CREATED_DATETIME_STAMP varchar2 15  √  null
TITLE varchar2 0  √  null
FILE_NAME varchar2 44  √  null
ACCIDENT_SYSTEM_NUMBER varchar2 0  √  null
INCIDENT_SYSTEM_NUMBER number 0

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT 'NR' HEADER, NULL ACTION, NULL LABEL, ejsn.updator_date UPDATE_DATE, TO_CHAR (ejsn.updator_date, 'HH24MI') UPDATE_TIME, ac.ori_number AGENCY, inc.inc_report_number INCIDENT_NUMBER, NULL ACCIDENT_NUMBER, ejsn.note_id NARRATIVE_UNIQUE_ID, NULL CASE_NUMBER, --Not used in EJS RMS --NULL SUPPLEMENT_FLAG, --19389 DECODE (incsupp.supp_seq, 0, 'N', 'Y') SUPPLEMENT_FLAG, --19389 TO_CHAR (ejsn.creator_date, 'MM/DD/YYYY HH24MI') CREATED_DATETIME_STAMP, NULL TITLE, --NULL FILE_NAME, --19237 ejsn.note_id || '.txt' FILE_NAME, --19237 NULL ACCIDENT_SYSTEM_NUMBER, inc.incident_id INCIDENT_SYSTEM_NUMBER FROM ejs_notes ejsn, incident_supplements incsupp, inc_supp_narratives isn, --18230 incidents inc, agency_codes ac --where incsupp.note_id (+) = ejsn.note_id --18230 WHERE isn.note_id(+) = ejsn.note_id --18230 AND incsupp.inc_incident_id = isn.incident_id --18230 AND incsupp.supp_seq = isn.supp_seq --18230 AND inc.incident_id = incsupp.inc_incident_id AND ac.agency_code(+) = inc.agncy_cd_agency_code AND incsupp.isc_status_code = 'A'
 
Possibly Referenced Tables/Views:
AGENCY_CODES EJS_NOTES INC_SUPP_NARRATIVES INCIDENT_SUPPLEMENTS INCIDENTS