Table slot9.WORLD.TSTA.MASTER_PEOPLE
This table stores the MASTER PERSON information added in the application
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
MASTER_PERSON_ID number 0
ARREST_ADDRESS_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_CFS_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_DISPOSITION_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_JAIL_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_LIVESCAN_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_NARRATIVE_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_ORG_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_PERSON_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_PROPERTY_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
ARREST_VEHICLE_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
CITATION_PERSON_VW.MASTER_PERSON_ID Implied Constraint R
DISPATCH_EVENT_PEOPLE_VW.MASTER_PERSON_ID Implied Constraint R
FIELD_INT_SEARCH_PERSON_VW.MASTER_PERSON_ID Implied Constraint R
JS_CITATION_VW.MASTER_PERSON_ID Implied Constraint R
JS_WARRANT_OFFENSE_CHARGE_VW.MASTER_PERSON_ID Implied Constraint R
MASTER_PEOPLE_NOT_DUPLICATES.MASTER_PERSON_ID MPEOPNODUP_MPER_FK R
MASTER_PEOPLE_NOT_DUPLICATES.NOT_DUP_MASTER_PERSON_ID MPEOPNODUP_MPERNO_FK R
MASTER_PERSON_TEMP.MASTER_PERSON_ID Implied Constraint R
PEOPLE.MASTER_PERSON_ID PER_MPER_FK R
PEOPLE_MASTER_NAME_VW.MASTER_PERSON_ID Implied Constraint R
PERMIT_PEOPLE_VW.MASTER_PERSON_ID Implied Constraint R
PERSON_DUP_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
PERSON_GEO_VW.MASTER_PERSON_ID Implied Constraint R
PERSON_INDICATOR_VW.MASTER_PERSON_ID Implied Constraint R
WARRANT_ADDR_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
WARRANT_OFFICER_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
WARRANT_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
WARRANT_SRVOFF_SEARCH_VW.MASTER_PERSON_ID Implied Constraint R
Master Person ID number
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
CREATOR_ID varchar2 100  √  null Person creating the record
ETHNICITY_CODE varchar2 30  √  null
EJS_CODES.CODE MPER_ETHNICITY_CD_EJS_CD_FK R
PERSON_VERIFIED varchar2 1 'Y'
INDX_SEC_LEVEL_CODE number 0  √  1
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE MPER_MIS_CD_CD_FK R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
ETHNICITY_CODE_TYPE varchar2 30  √  'ETHNICITY_CODES'
EJS_CODES.CODE_TYPE MPER_ETHNICITY_CD_EJS_CD_FK R
INDX_TYPE_CODE varchar2 30  √  'KNOWN'
RACE_CODE varchar2 30
EJS_CODES.CODE MPER_RACE_CODE_EJS_CODE_FK R
code identifies the persons race
RACE_CODE_TYPE varchar2 30  √  'RACE_CODES'
EJS_CODES.CODE_TYPE MPER_RACE_CODE_EJS_CODE_FK R
SEX_CODE varchar2 30
EJS_CODES.CODE MPER_SEX_CODE_EJS_CODE_FK R
code identifies the persons sex - (m)ale, (f)emale, or (u)nknown
SEX_CODE_TYPE varchar2 30  √  'SEX_CODES'
EJS_CODES.CODE_TYPE MPER_SEX_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
DUP_COMMENT_ID number 0  √  null
EJS_COMMENTS.EJS_COMMENT_ID MPER_E_CMNT_FK R
EXPUNGE varchar2 1  √  'N' Y/N flag to mark a person as expunged.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"MASTER_PERSON_ID" IS NOT NULL MPER_MASTER_PERSON_ID_NN
"PERSON_VERIFIED" IS NOT NULL MPER_PERSON_VERIFIED_NN
"RACE_CODE" IS NOT NULL MPER_RACE_CODE_NN
"SEX_CODE" IS NOT NULL MPER_SEX_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
MASTER_PERSON_ID Primary key Asc MPER_PK
DUP_COMMENT_ID Performance Asc MPER_E_CMNT_FK_I
ETHNICITY_CODE_TYPE + ETHNICITY_CODE Performance Asc/Asc MPER_ETHNICITY_CD_EJS_CD_FK_I
INDX_SEC_LEVEL_CODE Performance Asc MPER_MIS_CD_CD_FK_I
RACE_CODE_TYPE + RACE_CODE Performance Asc/Asc MPER_RACE_CODE_EJS_CODE_FK_I
SEX_CODE_TYPE + SEX_CODE Performance Asc/Asc MPER_SEX_CODE_EJS_CODE_FK_I

Close relationships  within of separation: