Table slot9.WORLD.TSTA.MASTER_INDEX_SECURITY_CODES
This table defines the different security levels used for each of the master indexes

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
INDX_SEC_LEVEL_CODE number 0
ADDRESS_COLLAPSE_LOG.INDX_SEC_LEVEL_CODE Implied Constraint R
ADDRESSES.INDX_SEC_LEVEL_CODE ADDRESSES_MIS_CD_CD_FK R
BUSINESS_RMS_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
BUSINESSES.INDX_SEC_LEVEL_CODE BUSINESSES_MIS_CD_CD_FK R
BUSINESSES_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
COURT_APPEARANCE_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
COURT_CASE_APP_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
COURT_CASE_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
CRIMINAL_COMPLAINT_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
GANG_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
GANG_SOLR_SEARCH_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
GANGS.INDX_SEC_LEVEL_CODE GANGS_MIS_CD_CD_FK R
IJIS_USER_PROFILES.INDX_SEC_LEVEL_CODE IUP_MIS_CD_FK R
INCIDENT_PROPERTY_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
JS_INCIDENT_PROPERTY_VW.INDX_SEC_LEVEL_CODE Implied Constraint R
MASTER_PEOPLE.INDX_SEC_LEVEL_CODE MPER_MIS_CD_CD_FK R
PROPERTIES.INDX_SEC_LEVEL_CODE PROPERTIES_MIS_CD_CD_FK R
PROPERTIES_AUDIT.INDX_SEC_LEVEL_CODE Implied Constraint R
VEHICLES.INDX_SEC_LEVEL_CODE VEHICLES_MIS_CD_CD_FK R
DESCRIPTION varchar2 4000  √  null
NOTES varchar2 4000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INDX_SEC_LEVEL_CODE" IS NOT NULL MIS_CD_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
INDX_SEC_LEVEL_CODE Primary key Asc MIS_CD_PK

Close relationships  within of separation: