View slot9.WORLD.TSTA.DISPATCH_EVENT_PEOPLE_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
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R
DISPATCH_ID number 38
DISPATCH_EVENTS.DISPATCH_ID Implied Constraint R
DISPATCH_NUMBER varchar2 30  √  null
CALL_DATE date 7  √  null
MASTER_PERSON_ID number 0  √  null
MASTER_PEOPLE.MASTER_PERSON_ID Implied Constraint R
PERSON_ID number 0  √  null
JAIL_PEOPLE.PERSON_ID Implied Constraint R
MN_ID varchar2 0  √  null
LAST_NAME varchar2 100  √  null
FIRST_NAME varchar2 80  √  null
MIDDLE_NAME varchar2 80  √  null
TITLE_CODE varchar2 30  √  null
TITLE_DESC varchar2 4000  √  null
PHONE varchar2 30  √  null
SSN varchar2 30  √  null
DOB date 7  √  null
RACE_CODE varchar2 30  √  null
RACE_DESC varchar2 4000  √  null
SEX_CODE varchar2 30  √  null
SEX_DESC varchar2 4000  √  null
HEIGHT varchar2 30  √  null
WEIGHT varchar2 30  √  null
ADDRESS varchar2 200  √  null
STREET_NUMBER varchar2 30  √  null
STREET_DIRECTION_CODE varchar2 30  √  null
STREET_DIRECTION_DESC varchar2 4000  √  null
STREET_NAME varchar2 40  √  null
STREET_TYPE_CODE varchar2 30  √  null
STREET_TYPE_DESC varchar2 4000  √  null
STREET_DIR_SUFFIX_CODE varchar2 30  √  null
STREET_DIR_SUFFIX_DESC varchar2 4000  √  null
SUB_TYPE_CODE varchar2 30  √  null
SUBSCRIPTION_TYPE_CODES.SUB_TYPE_CODE Implied Constraint R
SUB_TYPE_DESC varchar2 4000  √  null
SUB_NUMBER varchar2 30  √  null
CITY varchar2 40  √  null
STATE_CODE varchar2 30  √  null
STATE_DESC varchar2 4000  √  null
ZIP5 varchar2 30  √  null
ZIP4 varchar2 30  √  null
EYE_COLOR_CODE varchar2 30  √  null
EYE_COLOR_DESC varchar2 4000  √  null
HAIR_COLOR_CODE varchar2 30  √  null
HAIR_COLOR_DESC varchar2 4000  √  null
SKIN_COLOR_CODE varchar2 30  √  null
SKIN_COLOR_DESC varchar2 4000  √  null
SMT_DESCRIPTION varchar2 4000  √  null
COMMENTS varchar2 4000  √  null
AGE number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DEP.DISPATCH_PERSON_ID, DE.DISPATCH_ID, DE.DISPATCH_NUMBER, DE.CALL_DATE, (SELECT MASTER_PERSON_ID FROM PEOPLE P WHERE P.PERSON_ID = DEP.PER_PERSON_ID), DEP.PER_PERSON_ID, NULL, DEP.LNAME, DEP.FNAME, DEP.MNAME, DEP.TITLE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.TITLE_CODE_TYPE AND DEP.TITLE_CODE = EC.CODE) AS TITLE_DESC, DEP.PHONE, DEP.SSN, DEP.DOB, DEP.RACE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.RACE_CODE_TYPE AND DEP.RACE_CODE = EC.CODE) AS RACE_DESC, DEP.SEX_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.SEX_CODE_TYPE AND DEP.SEX_CODE = EC.CODE) AS SEX_DESC, DEP.HEIGHT, DEP.WEIGHT, DEP.ADDRESS, DEP.STREET_NUMBER, DEP.STREET_DIRECTION, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.STR_DIR_TYPE AND DEP.STREET_DIRECTION = EC.CODE) AS STREET_DIRECTION_DESC, DEP.STREET_NAME, DEP.STREET_TYPE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.STR_TYPE_CODE_TYPE AND DEP.STREET_TYPE_CODE = EC.CODE) AS STREET_TYPE_DESC, DEP.STREET_DIR_SUFFIX AS STREET_DIR_SUFFIX_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.STR_DIR_SUF_TYPE AND DEP.STREET_DIR_SUFFIX = EC.CODE) AS STREET_TYPE_DESC, DEP.SUB_TYPE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.SUB_TYPE_CODE_TYPE AND DEP.SUB_TYPE_CODE = EC.CODE) AS SUB_TYPE_DESC, DEP.SUB_NUMBER, DEP.CITY, DEP.STATE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.STATE_CODE_TYPE AND DEP.STATE_CODE = EC.CODE) AS STATE_CODE_DESC, DEP.ZIP5, DEP.ZIP4, DEP.EYE_COLOR_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.EYE_COLOR_CODE_TYPE AND DEP.EYE_COLOR_CODE = EC.CODE) AS EYE_COLOR_DESC, DEP.HAIR_COLOR_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.HAIR_COLOR_CODE_TYPE AND DEP.HAIR_COLOR_CODE = EC.CODE) AS HAIR_COLOR_DESC, DEP.SKIN_CODE AS SKIN_COLOR_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DEP.SKIN_CODE_TYPE AND DEP.SKIN_CODE = EC.CODE) AS SKIN_COLOR_DESC, DEP.SMT_DESCRIPTION, DEP.COMMENTS, DEP.AGE, DEP.DATE_OF_INFO FROM DISPATCH_EVENTS DE INNER JOIN DISPATCH_EVENT_PEOPLE DEP ON DE.DISPATCH_ID = DEP.DISPATCH_ID
 
Possibly Referenced Tables/Views:
DISPATCH_EVENT_PEOPLE DISPATCH_EVENTS EJS_CODES PEOPLE 


Close relationships: