View slot9.WORLD.TSTA.LSI_ADDRESSES_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
LEGAL_SEARCH_ID number 0
LEGAL_SEARCH_INDEX.LEGAL_SEARCH_ID Implied Constraint R
LS_STATUS_CODE varchar2 30
LS_TYPE_CODE varchar2 30
ISSUE_DATE date 7
RETURN_DATE date 7  √  null
CASE_ID number 12  √  null
JUDGE_NUMBER number 38
OFFICER_ID number 0
OFFICERS.OFFICER_ID Implied Constraint R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
VEH_LIC_NUMBER varchar2 12  √  null
VEH_STATE_CODE varchar2 30  √  null
LS_COMMENT varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
JUDGE_LAST_NAME varchar2 30
JUDGE_FIRST_NAME varchar2 20
JUDGE_ACTIVE varchar2 1
OFFICER_AGENCY varchar2 30
OFFICER_LNAME varchar2 20
OFFICER_FNAME varchar2 20  √  null
OFFICER_INTERNAL_ID varchar2 100
OFFICER_TITLE varchar2 20  √  null
OFFICER_ACTIVE varchar2 1  √  null
STREET_NUMBER varchar2 10  √  null
DIRCT_CD_DIRECTION_CODE varchar2 30  √  null
STREET_NAME varchar2 40  √  null
STREET_CD_STREET_TYPE_CODE varchar2 30  √  null
DIRECT_SUFFIX varchar2 30  √  null
ADDR_SC_ADDRESS_SUBTYPE_CODE varchar2 30  √  null
SUB_NUMBER varchar2 50  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INTRSECT1_DIR varchar2 30  √  null
INTRSECT1_NAME varchar2 40  √  null
INTRSECT1_STREET_TYPE_CODE varchar2 30  √  null
INTRSECT1_DIR_SUFFIX varchar2 30  √  null
CITY varchar2 40  √  null
CITY_CD_CITY_CODE varchar2 30  √  null
STATE_CD_STATE_CODE varchar2 30  √  null
ZIP5 varchar2 30  √  null
ZIP4 number 0  √  null
GEO_CITY varchar2 40  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
CASE_NUMBER varchar2 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT LSI.LEGAL_SEARCH_ID ,LSI.LS_STATUS_CODE ,LSI.LS_TYPE_CODE ,LSI.ISSUE_DATE ,LSI.RETURN_DATE ,LSI.CASE_ID ,LSI.JUDGE_NUMBER ,LSI.OFFICER_ID ,LSI.AGENCY_CODE ,LSI.VEH_LIC_NUMBER ,LSI.VEH_STATE_CODE ,LSI.LS_COMMENT ,LSI.CREATOR_ID ,LSI.CREATOR_DATE ,LSI.UPDATOR_ID ,LSI.UPDATOR_DATE ,JUD.LAST_NAME ,JUD.FIRST_NAME ,JUD.ACTIVE ,OFF.AGNCY_CD_AGENCY_CODE ,OFF.LNAME ,OFF.FNAME ,OFF.INTERNAL_ID ,OFF.TITLE ,OFF.ACTIVE ,ADDR.STREET_NUMBER ,ADDR.DIRCT_CD_DIRECTION_CODE ,ADDR.STREET_NAME ,ADDR.STREET_CD_STREET_TYPE_CODE ,ADDR.DIRECT_SUFFIX ,ADDR.ADDR_SC_ADDRESS_SUBTYPE_CODE ,ADDR.SUB_NUMBER ,ADDR.INTRSECT1_STREET_NUMBER ,ADDR.INTRSECT1_DIR ,ADDR.INTRSECT1_NAME ,ADDR.INTRSECT1_STREET_TYPE_CODE ,ADDR.INTRSECT1_DIR_SUFFIX ,ADDR.CITY ,ADDR.CITY_CD_CITY_CODE ,ADDR.STATE_CD_STATE_CODE ,ADDR.ZIP5 ,ADDR.ZIP4 ,ADDR.GEO_CITY ,ADDR.BEAT ,ADDR.SUB_BEAT ,NULL FROM LEGAL_SEARCH_INDEX LSI ,LEGAL_SEARCH_ADDRESSES LSA ,JUDGES JUD ,OFFICERS OFF ,ADDRESSES ADDR WHERE LSA.LEGAL_SEARCH_ID = LSI.LEGAL_SEARCH_ID AND JUD.JUDGE_NUMBER = LSI.JUDGE_NUMBER AND OFF.OFFICER_ID = LSI.OFFICER_ID AND LSA.ADDRESS_ID = ADDR.ADDRESS_ID
 
Possibly Referenced Tables/Views:
ADDRESSES JUDGES LEGAL_SEARCH_ADDRESSES LEGAL_SEARCH_INDEX OFFICERS 


Close relationships: