People Level
ApproximateAge
|
integer
|
Approximate age of the individual
|
Incident/People/Person/ApproximateAge
|
|
AptNumber
|
string (6)
|
Individual’s apartment number
|
Incident/People/Person/AptNumber
|
|
BirthDateUnknown
|
boolean
|
Indicates if the individual’s birthdate is unknown
|
Incident/People/Person/BirthDateUnknown
|
|
BirthDte
|
date
|
Date of birth for the individual
|
Incident/People/Person/BirthDte
|
|
CitationNumberText
|
string (10)
|
The citation number assigned to the individual
|
Incident/People/Person/CitationNumbers/CitationNumber/CitationNumberText
|
|
CityCde
|
string (5)
|
City address for the individual
|
Incident/People/Person/CityCde
|
See Appendix C
|
CityName
|
string (25)
|
City’s name for the address of the individual
|
Incident/People/Person/CityName
|
|
EthnicCde
|
string (2)
|
Ethnicity of the individual
|
Incident/People/Person/EthnicCde
|
H - HISPANIC
|
N - NOT HISPANIC
|
U - UNKNOWN
|
|
EyeColorCde
|
string (3)
|
Eye color of the individual
|
Incident/People/Person/EyeColorCde
|
BLK - BLACK
|
BLU - BLUE
|
BRO - BROWN
|
GRN - GREEN
|
GRY - GRAY
|
HAZ - HAZEL
|
MAR - MAROON
|
MUL - MULTICOLORED
|
PNK - PINK
|
XXX - UNKNOWN
|
|
GenderCde
|
string (1)
|
Gender of the individual
|
Incident/People/Person/GenderCde
|
F - FEMALE
|
M - MALE
|
U - UNKNOWN
|
|
HairColorCde
|
string (3)
|
Hair color of the individual
|
Incident/People/Person/HairColorCde
|
BLD - BALD (III RECORDS ONLY)
|
BLK - BLACK
|
BLN – BLOND OR STRAWBERRY
|
BLU - BLUE
|
BRO - BROWN
|
GRN - GREEN
|
GRY - GRAY OR PARTIALLY GRAY
|
ONG - ORANGE
|
PLE - PURPLE
|
PNK - PINK
|
RED - RED OR AUBURN
|
SDY - SANDY
|
WHI - WHITE
|
XXX - UNKNOWN OR COMPLETELY BALD
|
|
Height
|
number (16,2)
|
Height of individual
|
Incident/People/Person/Height
|
|
IDNumber
|
string (50)
|
Number on the individuals form of ID
|
Incident/People/Person/IDNumber
|
|
IDStateCde
|
string (2)
|
State where ID was created
|
Incident/People/Person/IDStateCde
|
See Appendix A
|
IDTypeCde
|
string (2)
|
Type of ID
|
Incident/People/Person/IDTypeCde
|
CL - COMMERCIAL DRIVER'S LICENSE
|
ID - STATE ISSUED ID CARD
|
IO - ID CARD OTHER
|
MI - MILITARY ID
|
OL - OPERATOR'S LICENSE
|
PL - OPERATOR PERMIT LICENSE
|
PP - PASSPORT
|
XX - NONE
|
|
IsNameUnknown
|
boolean
|
Indicates if the name is unknown
|
Incident/People/Person/IsNameUnknown
|
|
NameFilial
|
string (3)
|
Filial name of the individual
|
Incident/People/Person/NameFilial
|
|
NameFirst
|
string (25)
|
First name of the individual
|
Incident/People/Person/NameFirst
|
|
NameLast
|
string (30)
|
Last name of the individual
|
Incident/People/Person/NameLast
|
|
NameMiddle
|
string (25)
|
Middle name of the individual
|
Incident/People/Person/NameMiddle
|
|
NameFilial
|
string (3)
|
Alias filial name of the individual
|
Incident/People/Person/Person_Alias/Person_Alias/NameFilial
|
|
NameFirst
|
string (25)
|
Alias first name of the individual
|
Incident/People/Person/Person_Alias/Person_Alias/NameFirst
|
|
NameLast
|
string (30)
|
Alias last name of the individual
|
Incident/People/Person/Person_Alias/Person_Alias/NameLast
|
|
NameMiddle
|
string (25)
|
Alias middle name of the individual
|
Incident/People/Person/Person_Alias/Person_Alias/NameMiddle
|
|
WeaponCde
|
string (3)
|
Indicates the type of weapon
|
Incident/People/Person/Person_ArmedWith/Person_ArmedWith/WeaponCde
|
01 - UNARMED
|
11 - FIREARM (type not stated)
|
11A - FIREARM (TYPE NOT STATED) - FULLY AUTO
|
12 - HANDGUN
|
12A - HANDGUN - FULLY AUTOMATIC
|
13 - RIFLE
|
13A - RIFLE - FULLY AUTOMATIC
|
14 - SHOTGUN
|
14A - SHOTGUN - FULLY AUTOMATIC
|
15 - OTHER FIREARM
|
15A - OTHER FIREARM - FULLY AUTOMATIC
|
16 - LETHAL CUTTING INSTRUMENT
|
17 - CLUB, BLACKJACK, BRASS KNUCKLES
|
20 - KNIFE, CUTTING INSTRUMENT
|
30 - BLUNT OBJECT (e.g. club, hammer)
|
35 - MOTOR VEHICLE (when used as a weapon)
|
40 - PERSONAL WEAPONS (hands,feet,teeth,etc.)
|
45 - PRYING TOOL
|
50 - POISON
|
60 - EXPLOSIVES
|
65 - FIRE, INCENDIARY DEVICE
|
70 - DRUGS, NARCOTICS, SLEEPING PILLS
|
85 - ASPHYXIATION
|
90 - OTHER (Any Other Weapon or Force)
|
95 - UNKNOWN
|
99 - NONE
|
|
WeaponDesc
|
string (50)
|
Describes the weapon
|
Incident/People/Person/Person_ArmedWith/Person_ArmedWith/WeaponDesc
|
|
Arrestee
|
boolean
|
Indicates if the individual is an arrestee
|
Incident/People/Person/Person_Crime/Person_Offender/Arrestee
|
|
ArrestDte
|
date
|
Indicates the date of the arrest
|
Incident/People/Person/Person_Crime/Person_Offender/Person_Arrestee/ArrestDte
|
|
ArrestTypeCde
|
string (1)
|
Indicates the type of arrest
|
Incident/People/Person/Person_Crime/Person_Offender/Person_Arrestee/ArrestTypeCde
|
O - WARRANTLESS ARREST
|
S - SUMMONED/CITED
|
T - WARRANT ARREST
|
|
JustifiableHomicideCde
|
string (2)
|
Indicates the circumstances for justifiable homicide
|
Incident/People/Person/Person_Crime/Person_Victim/JustifiableHomicideCde
|
A - ATTACKED POLICE OFFICER
|
B - ATTACKED FELLOW POLICE OFFICER
|
C - ATTACKED CIVILIAN
|
D - FLIGHT FROM CRIME
|
E - COMMISION OF CRIME
|
F - RESISTING ARREST
|
G - UNABLE TO DETERMINE
|
|
OffenderAlso
|
boolean
|
Indicates that the victim is also an offender
|
Incident/People/Person/Person_Crime/Person_Victim/OffenderAlso
|
|
AssaultHomicideCde
|
string (2)
|
Indicates the circumstances for the assault or homicide
|
Incident/People/Person/Person_Crime/Person_Victim/Person_VictimAssaultHomicideCir/Person_VictimAssaultHomicideCir/AssaultHomicideCde
|
01 - ARGUMENT
|
02 - ASSAULT ON LAW ENFORCEMENT OFFICER
|
03 - DRUG DEALING
|
04 - GANGLAND (ORGANIZED CRIME INVOLVED)
|
05 - JUVENILE GANG
|
06 - LOVERS’ QUARREL
|
07 - MERCY KILLING
|
08 - OTHER FELONY INVOLVED
|
09 - OTHER CIRCUMSTANCES
|
10 - UNKNOWN CIRCUMSTANCES
|
|
InjuryTypeCde
|
string (1)
|
Indicates the type of injury of the victim
|
Incident/People/Person/Person_Crime/Person_Victim/Person_VictimInjury/Person_VictimInjury/InjuryTypeCde
|
B - APPARENT BROKEN BONES
|
D - DEATH
|
I - POSSIBLE INTERNAL INJURY
|
L - SEVERE LACERATION
|
M - APPARENT MINOR INJURY
|
N - NONE
|
O - OTHER MAJOR INJURY
|
T - LOSS OF TEETH
|
U - UNCONSCIOUS
|
|
OffenderID
|
integer
|
Identifies the offender record for the person
|
Incident/People/Person/Person_Crime/Person_Victim/Person_VictimOffenderPair/Person_VictimOffenderPair/OffenderID
|
|
RelationshipCde
|
string (2)
|
Indicates the relationship to the victim
|
Incident/People/Person/Person_Crime/Person_Victim/Person_VictimOffenderPair/Person_VictimOffenderPair/RelationshipCde
|
AQ - ACQUAINTANCE
|
BE - BABYSITTEE (THE BABY)
|
BG - BOYFRIEND/GIRLFRIEND
|
CF - CHILD OF BOYFRIEND OR GIRLFRIEND
|
CH - CHILD
|
CS - COMMON-LAW SPOUSE
|
EE - EMPLOYEE
|
ER - EMPLOYER
|
FR - FRIEND
|
GC - GRANDCHILD
|
GP - GRANDPARENT
|
HR - HOMOSEXUAL RELATIONSHIP
|
IL - IN-LAW
|
NE - NEIGHBOR
|
OF - OTHER FAMILY MEMBER
|
OK - OTHERWISE KNOWN
|
PA - PARENT
|
RU - RELATIONSHIP UNKNOWN
|
SB - SIBLING (BROTHER OR SISTER)
|
SC - STEPCHILD
|
SE - SPOUSE
|
SP - STEPPARENT
|
SS - STEPSIBLING (STEPBROTHER OR STEPSISTER)
|
ST - STRANGER
|
VO - OFFENDER
|
XS - EX-SPOUSE
|
|
OffenseID
|
integer
|
Identifies the offense record
|
Incident/People/Person/Person_Crime/Person_Victim/Person_VictimOffensePair/Person_VictimOffensePair/OffenseID
|
|
PoliceActivityTypeCde
|
string (2)
|
Indicates the type of police activity
|
Incident/People/Person/Person_Crime/Person_Victim/PoliceActivityTypeCde
|
00 - Not Applicable
|
01 - RESPONDING TO DISTURBANCE CALL
|
02 - BURGLARIES IN PROGRESS PURSING
BURLARY
|
03 - ROBBERIES IN PROGRESS, PURSING
ROBBERY
|
04 - ATTEMPTING OTHER ARREST
|
05 - CIVIL DISORDER(RIOT)
|
06 - HANDLE, TRANSPORT, CUSTODY OF
PRISONER
|
07 - INVESTIGATE SUSPICIOUS PERSONS
|
08 - AMBUSH - NO WARNING
|
09 - MENTALLY DERANGED
|
10 - TRAFFIC PURSUITS AND STOPS
|
11 - ALL OTHERS
|
|
PoliceAssignmentCde
|
string (2)
|
Indicates the police assignment
|
Incident/People/Person/Person_Crime/Person_Victim/PoliceAssignmentCde
|
00 - Not Applicable
|
01 - TWO-MAN VEHICLE (UNIFORMED OFFICER)
|
02 - ONE-MAN VEHICLE ALONE
|
03 - ONE-MAN VEHICLE ASSIST
|
04 - DETECTIVE OR SPCL ASSIGNMENT A
|
05 - DETECTIVE OR SPCL ASSIGNMENT A
|
06 - OTHER ALONE
|
07 - OTHER ASSISTED
|
|
PoliceOfficer
|
boolean
|
Indicates if the person is a police officer
|
Incident/People/Person/Person_Crime/Person_Victim/PoliceOfficer
|
|
PoliceOfficerOtherAgency
|
boolean
|
Indicates if the officer works for a different agency
|
Incident/People/Person/Person_Crime/Person_Victim/PoliceOfficerOtherAgency
|
|
PoliceOtherORI
|
string (9)
|
Indicates the ORI of the officer if the officer is from another agency
|
Incident/People/Person/Person_Crime/Person_Victim/PoliceOtherORI
|
7 digit ORI value excluding the prefix of IN
|
VictimTypeCde
|
string (2)
|
Indicates the type of victim
|
Incident/People/Person/Person_Crime/Person_Victim/VictimTypeCde
|
B - BUSINESS
|
C - FINANCIAL/INSTITUTION
|
G - GOVERNMENT
|
I - INDIVIDUAL
|
O - OTHER
|
R - RELIGOUS ORGANIZATION
|
S - SOCIETY
|
U - UNKNOWN
|
|
RelationshipCde
|
string (2)
|
Indicates the relationship of the victim to the offender
|
Incident/People/Person/Person_Crime/Person_VictimOffenderPair/Person_VictimOffenderPair/RelationshipCde
|
99 - MISSING RELATIONSHIP
|
AQ - ACQUAINTANCE
|
BE - BABYSITTEE
|
BF - BOYFRIEND
|
BR - BROTHER
|
CF - CHILD OF BF/GF
|
CH - COMMON-LAW HUSBAND
|
CW - COMMON-LAW WIFE
|
DA - DAUGHTER
|
EE - EMPLOYEE
|
ER - EMPLOYER
|
FA - FATHER
|
FR - FRIEND
|
GF - GIRLFRIEND
|
HR - HOMOSEXUAL RELATIONSHIP
|
HU - HUSBAND
|
IL - INLAW
|
MO - MOTHER
|
NE - NEIGHBOR
|
OF - OTHER FAMILY
|
OK - OTHERWISE KNOWN
|
RU - RELATIONSHIP UNKNOWN
|
SD - STEPDAUGHTER
|
SF - STEPFATHER
|
SI - SISTER
|
SM - STEPMOTHER
|
SO - SON
|
SS - STEPSON
|
ST - STRANGER
|
WI - WIFE
|
XH - EX-HUSBAND
|
XW - EX-WIFE
|
|
VictimID
|
integer
|
Identifies the victim record
|
Incident/People/Person/Person_Crime/Person_VictimOffenderPair/Person_VictimOffenderPair/VictimID
|
|
RptBySameAsVictim
|
boolean
|
Indicates if the person reporting the crime is the same as the victim
|
Incident/People/Person/Person_Crime/RptBySameAsVictim
|
|
EmailAddress
|
string (250)
|
Individuals email address
|
Incident/People/Person/Person_Email/Person_Email/EmailAddress
|
|
PersonTypeCde
|
string (2)
|
Indicates the type of person
|
Incident/People/Person/PersonTypeCde
|
R – Reported By
|
O - Offender
|
V - Victim
|
W - Witness
|
T - Other
|
|
PhoneCell
|
string (10)
|
Individuals cell phone number
|
Incident/People/Person/PhoneCell
|
Phone number without dashes
|
PhoneHome
|
string (10)
|
Individuals home phone number
|
Incident/People/Person/PhoneHome
|
Phone number without dashes
|
PhoneWork
|
string (10)
|
Individuals work phone number
|
Incident/People/Person/PhoneWork
|
Phone number without dashes
|
RaceCde
|
string (2)
|
Individuals race
|
Incident/People/Person/RaceCde
|
01 - WHITE
|
02 - BLACK
|
03 - AMERICAN INDIANA OR ALASKAN NATIVE
|
04 - ASIAN OR PACIFIC ISLANDER
|
|
SSN
|
string (9)
|
Indicates individual’s SSN
|
Incident/People/Person/SSN
|
SSN without dashes
|
StateCde
|
string (2)
|
Individuals state of residence
|
Incident/People/Person/StateCde
|
See Appendix A
|
StreetDir
|
string (2)
|
Individuals street direction
|
Incident/People/Person/StreetDir
|
E - E
|
N - N
|
NE - NE
|
NW - NW
|
S - S
|
SE - SE
|
SW - SW
|
W - W
|
|
StreetName
|
string (55)
|
Individuals street name
|
Incident/People/Person/StreetName
|
|
StreetNumber
|
string (10)
|
Individuals street number
|
Incident/People/Person/StreetNumber
|
|
StreetSfx
|
string (5)
|
Individuals street suffix
|
Incident/People/Person/StreetSfx
|
See Appendix E
|
Weight
|
integer
|
Individuals weight
|
Incident/People/Person/Weight
|
|
Zip
|
string (5)
|
Individuals zipcode
|
Incident/People/Person/Zip
|
|
ZipExtension
|
string (4)
|
Individuals zipcode extension
|
Incident/People/Person/ZipExtension
|
|
