Version - Draft State of California DOJ 12/1/2011
IEPD Data Element Mapping
Row Form ID Data Element Desciption UML Class UML Attribute / Association UML Class Inherits/Instatiates Cardinality
766 PC1381 49 Also known as a Booking Number; this is the unique Booking BookingNumber string 1
identifier for the event.
776 PC1381 N-462 The name of the court and location where charges Court CourtName string
are currently pending against the defendant/inmate.
1
783 PC1381 N-481 The projected date of an inmate's release from jail Detention ProjectedReleaseDate DetentionAugmentation 1
794 PC1381 N-890 Date of the inmate's scheduled release from jail. Detention ScheduledReleaseDate date 1
781 PC1381 N-478 The full name of the person incarcerated in a jail. Inmate PersonName Person 1
782 PC1381 N-479 The date of birth of the person incarcerated in a jail. Inmate dateOfBirth Person 1
785 PC1381 N-483 The digital signature of the person incarcerated. Inmate SignatureImage Signature 1
787 PC1381 N-814 The gender of the inmate. Inmate Gender Person 1
788 PC1381 N-815 Other names used by the inmate. Inmate AlternateName PersonName *.1
777 PC1381 N-474 The date a demand for trial notice is prepared by the PC1381 NoticeCompletionDate Date
inmate. 1
780 PC1381 N-477 Description of the demand for trial PC1381 RequestDescription string 1
786 PC1381 N-813 The unique identification number assigned by CA PersonIdentification PersonDOJIdentification string 1
DOJ to the inmate.
791 PC1381 N-887 The identification number assigned to a sheriff's PersonIdentification EmployeeIdentification string 1
office employee.
784 PC1381 N-482 The defendant's plea to a charge (guilty, not guilty, Plea DefenendentsPlea string 1
nolo, etc.)
767 PC1381 389 Complex element containing all of the components of PriorConviction ConvictionCharge string 1
a charge associated with a prior conviction.
768 PC1381 390 The case number associated with the prior PriorConviction CaseNumber string 1..*
conviction.
775 PC1381 N-461 The county name for which the district attorney has Prosecutor CountyJurisdiction string 1
jurisdiction.
789 PC1381 N-885 The work title of a sheriff's office employee. Sheriff JobTitle string *.1
790 PC1381 N-886 Complex element composed of all the required Sheriff Name PersonName 1
components of a name.
793 PC1381 N-889 The digital signature of a sheriff's deputy. Sheriff SignatureImage Signature 1
778 PC1381 N-475 The name of the Sheriff's Department. SheriffDept OrganizationName string 1
779 PC1381 N-476 The address of the Sheriff's Department. SheriffDept StructuredAddress Address 1
769 PC1381 539 The total amount of bail required on the warrant Warrant BailAmount string 1
770 PC1381 541 Complex element containing all of the components of Warrant WarrantCharges string 1
a warrant charge.
771 PC1381 544 The warrant identification number assigned by the Warrant WarrantFileNumber string 1
warrant repository when it was originally processed.
772 PC1381 549 The level of severity of the warrant (e.g. felony, Warrant WarranLevel string 1
misdemeanor).
773 PC1381 552 Unique identification number assigned to a warrant. Warrant WarrantNumber string 1
774 PC1381 553 Describes the agency (e.g., law enforcement, DA) WarrantAgency OrganiztaionName string 1
originating the warrant request.
792 PC1381 N-888 The county in which a warrant was issued. WarrantAgency CountyJurisdiction string 1
C:\Docstoc\Working\pdf\35762d01-d0a2-4c9e-b757-3687b4447eb5.xls 1
Version - Draft State of California DOJ 12/1/2011
IEPD Data Element Mapping
NIEM Style Schema Mapping Inherits / Instatiates XSD Type
j:Booking/j:BookingFileIdentification nc:IdentificationType
cadoj:CourtType/j:CourtName nc:TextType
cadoj:DetentionType/scr:DetentionAugmentation/scr:ProjectedReleaseDate nc:DateType
cadoj:DetentionType/cadoj:ScheduledReleaseDate nc:DateType
cadoj:InmateType/nc:Person/nc:PersonName nc:PersonNameType
caldoj:InmateType/nc:Person/nc:PersonBirthDate nc:DateType
cadoj:InmateType/cadoj:Signature/nc:PersonDigitizedSignatureImage nc:ImageType
cadoj:Inmate/nc:PersonSexCode fbi:SEXCodeType
cadoj:Inmate/nc:PersonName/nc:PersonAlternateName nc:IdentificationType
cadoj:PC1381Type/cadoj:NoticeCompletionDate nc:DateType
cadoj:RequestForTrial/cadoj:RequestDescription nc:TextType
cadoj:PersonIdentificationType/cadoj:PersonDOJIdentification nc:IdentificationType
cadoj:PersonIdentificationType/j:EmployeeIdentificaton nc:IdentificationType
j:PleaType/j:PleaCatagoryCode ut_offender:PleaCategoryCodeType
cadoj:PriorConvicationType/jChargeEnhancingPriorConviction/j:ConvictionCharge/ nc:TextType
j:chargeText
cadoj:PriorConvicationType/jChargeEnhancingPriorConviction/j:ConvictionCharge/ nc:IdentificationType
j:chargeIdentification
cadoj:ProsecutorType/nc:LocationCountyCode fips_6-4:USCountyCodeSimpleType
cadoj:SheriffType/cadoj:JobTitle nc:TextType
cadoj:SheriffType/nc:Person/nc:PersonName nc:EntityType
cadoj:SheriffType/cadoj:Signature/nc:PersonDigitizedSignatureImage nc:ImageType
cadoj:SheriffDeptType/nc:Organization/nc:OrganizationName nc:TextType
nc:AddressType/nc:StructuredAddress abstract
j:WarrantType/j:WarrantAppearanceBail/j:BailSetAmount xsd:string
j:WarrantType/j:ChargeText nc:TextType
j:WarrantType/cadoj:WarrantFileNumber nc:TextType
j:WarrantType/j:WarrentLevelText nc:TextType
j:WarrantType/cadoj:WarrantNumber nc:IdentificationType
cadoj:WarrantAgencyType/nc:Organization/nc:OrganizationUnitName nc:TextType
cadoj:WarrantAgencyType/nc:LocationCountyCode fips_6-4:USCountyCodeSimpleType
C:\Docstoc\Working\pdf\35762d01-d0a2-4c9e-b757-3687b4447eb5.xls 2
Row UML Class UML Attribute / Association UML Class Inherits/Instatiates
1 Address
2 city string
3 county string
4 state string
5 zipCode string
6 countryCode string
7 Street Street
8
9 AffSearchWrnt
10 AffidavitRequestDate date
11 AffidavitSwornTime date
12 Attachment Attachment
13 Charge Charge
14 Court Court
15 Judge Judge
16 Officer Officer
17 Location Location
18 ProbableCause ProbableCause
19
20 Attachment
21 Documents abstract
19
20 ArrestDocument
21 FileNumber string
19
20 Case
21 CaseTrackingID string
22
23 Charge
24 LegalCodeSectionNumber integer
25 ChargeDescription string
26 ChargeStatuteCode string
27 SpecialAllegations string
28 ChargeQualifier string
22
23 ChargeDisposition
24 ChargeDispositionDate date
19
20 Citation
21 CitationDate date
21 CitationNumber string
22
30 ContactInformation
32 ContactInformationDescriptionText string
31 SourceContactPerson string
32 ContactTelephoneNumber string
32 ContactFaxNumber string
32 ContactEmailID string
32 ContactMailingAddress string
36
37 ContactPerson
Role Of Person
22
30 CourtClerk
Role Of Person
22
30 Court
32 CourtName string
31 CourtBranchName string
32 CourtIdentificaitonNumber string
32 CourtJurisdiction string
32 Address Address
32 ContactInformation ContactInformation
32 CourtDMVFTACode string
22
34 CourtAppearance
35 AppearanceDate date
35 AppearanceTime string
35 AppearanceCategory time
22
34 CourtOrder
35 CaseDescription string
SpecialInstructions string
DepartmentName string
IssueDate string
35 HearingLocation string
36
37 DAInvestigator
Role Of Person
TelephoneNumber ContactInformation
36
37 Defendant
Role Of Person
22
20 DL157
22
30 DriverRecordToAdjust
Role Of Person
22
30 DriverLicenseIdentification
IdentifcationID string
IdentificaitonExpirationDate date
IdentificationCategoryDescriptionText string
IdentificaitonEffectiveDate date
IdentificationsStatus string
IdentificationJurisdiction string
22
30 EnforcementAgency
Name string
Address Address
36
37 Investigation
38 Name string
36
37 Judge
Role Of Person
38 Signature Signature
39
40 Location
41 SearchPlaceDescription string
42 SearchPropertyDescription string
43
44 Officer
Role Of Person
45 Name PersonName
46 OfficerIdentification string
47 OfficerEducation string
48 Signature Signature
49 OfficerRank string
30 OrganizationName
OrganizationName string
30 OriginalCitationIssuedTo
Role Of Person
Person
PrimaryName PersonName
AdditionalName PersonName
ScarMarkTattoo ScarMarkTattoo
IdentifyingNumber IdentifyingNumber
birthPlace Address
dateOfBirth date
modusOperandi string
socialSecurityNumber string
FBIIDNumber string
cadojID string
crimeAge string
citizen boolean
ethnicity string
eyeColor string
hairColor string
height string
race string
skinTone string
weight string
fingerPrintClassification string
localPersonIDNumber string
50
51 PersonName
52 giventName string
53 middleName string
54 lastName string
55 suffixName string
56 prefixName string
57 maindenName string
58 fullName string
59
60 ProbableCause
61 ReasonCode string
62 ReasonNumber string
36
37 Prosecutor
Role Of Person
TelephoneNumber ContactInformation
ProsecutorTitle string
38 Signature Signature
69
70 ReturnServSubp
Address Address
63
64 Signature
65 SignatureImage binary
66 SignatureDate date
67 PersonName string
68 SignatureMethod string
69
70 Street
71 streetName string
72 streetNumber string
73 streetFullText string
69
70 Subpoena
69
70 SubpoenaPreMeeting
71 Date date
72 Time time
69
70 SubpoenaReturned
72 ReturnDate date
71 ReturnCity string
69
70 SubpoenaServed
72 ServiceDate date
71 ServiceCity string
69
70 SubpoenaServer
Role Of Person
71 SubpoenaServerIdentification string
69
70 Subject
Role Of Person
63
64 Vehicle
65 LicenseNumber string
66 LicenseCatagory string
67 IssuingCounty string
68 IssuingState string
Cardinality NIEM Style Schema Mapping
nc:AddressType
1 nc:AddressType/nc:LocationCityName
1 nc:AddressType/nc:LocationCountyName
1 nc:AddressType/nc:LocationStateName
1 nc:AddressType/nc:LocationPostalCode
1 nc:AddressType/nc:LocationCountryName
1 nc:AddressType/nc:LocationStreet
cadoj:AffSearchWrntType
1 cadoj:AffSearchWrntType/nc:DateTime
1 cadoj:AffSearchWrntType/cadoj:Judge/cadoj:Signature/cadoj:SignatureDate
0..* cadoj:AffSearchWrntType/nc:Attachment
1..* cadoj:AffSearchWrntType/j:Charge
1 cadoj:AffSearchWrntType/cadoj:Court
1 cadoj:AffSearchWrntType/cadoj:Judge
1 cadoj:AffSearchWrntType/cadoj:Officer
1..* cadoj:AffSearchWrntType/cadoj:Location
1..* cadoj:AffSearchWrntType/cadoj:ProbableCause
nc:attachment
0..* nc:attachmenttype/nc:BinaryObject
nc:attachment
1 nc:DocumentType/nc:DocumentFileControlID
nc:CaseType
0..* nc:CaseType/nc:CaseTrackingID
j:ChargeType
1..* j:ChargeType/j:StatuteCodeSectionIdentification/nc:IdentificationID
1..* j:ChargeType/j:ChargeDescriptionText
1..* j:ChargeType/j:StatuteCodeIdentification/nc:IdentificationID
1..* j:ChargeType/j:ChargeSpecialAlligationText
1..* j:ChargeType/j:ChargeQualifierText
cadoj:ChargeDispositionType
1 cadoj:ChargeDispositionType/nc:ActivityDate
j:CitationType
1 j:CaseType/cadoj:CitationDate
1 j:CaseType/cadoj:CitationNumber
nc:ContactInformationType
1 nc:ContactInformationType/nc:ContactInformationDescriptionText
1 nc:ContactInformationType/nc:SourceContactPerson
1 nc:ContactInformationType/nc:ContactTelephoneNumber
1 nc:ContactInformationType/nc:ContactFaxNumber
1 nc:ContactInformationType/nc:ContactEmailID
1 nc:ContactInformationType/nc:ContactMailingAddress
cadoj:ContactPersonType
1 cadoj:ContactPersonType/nc:RoleOfPersonReference
cadoj:CourtClerkType
1 cadoj:InmateType/nc:RoleOfPersonReference
cadoj:CourtType
1 cadoj:CourtType/j:CourtName
1 cadoj:CourtType/nc:Organization/OrganizationBranchName
1 cadoj:CourtType/cadoj:CourtIdentificationNumber
1 cadoj:CourtType/cadoj:CourtJurisdiction
1 cadoj:CourtType/nc:Address
1 cadoj:CourtType/nc:ContactInformation
1 cadoj:CourtType/cadoj:CourtDMVFTACode
cadoj:CourtAppearanceType
1 cadoj:CourtAppearanceType/j:CourtAppearnce/j:CourtAppearanceDate
1 cadoj:CourtAppearanceType/cadoj:AppearanceTime
1 cadoj:CourtAppearanceType/j:casecourtevent/j:CourtEventAppearence/j:CourtAppearanceCategoryText
j:CourtOrderType
*.1 j:CourtOrderType/j:Warrant/j:WarrantProbableCauseText
*.1 j:CourtOrderType
1 j:CourtOrderType/j:CourtOrderDesignatedLocation/nc:LocationName
1 j:CourtOrderType/j:CourtOrderIssuingDate
1 j:CourtOrder/cadoj:HearingLocation
cadoj:DAInvestigatorType
1 cadoj:DAInvestigatorType/nc:RoleOfPersonReference
1 cadoj:DAInvestigatorType/nc:ContactInformatoin/nc:ContactTelephoneNumber
cadoj:DefendentType
1 cadoj:DefendentType/nc:RoleOfPersonReference
cadoj:DL157Type
cadoj:DriverRecordToAdjustType
1 cadoj:DriverRecordToAdjustType/nc:RoleOfPersonReference
nc:DriverLicenseType
1 nc:DriverLicenseType/nc:IdentifcationID
1 nc:DriverLicenseType/nc:IdentificaitonExpirationDate
1 nc:DriverLicenseType/nc:IdentificationCategoryDescriptionText
1 nc:DriverLicenseType/nc:IdentificaitonEffectiveDate
1 nc:DriverLicenseType/nc:IdentificationsStatus
*.1 nc:DriverLicenseType/nc:IdentificationJurisdiction
cadoj:EnforcementAgencyType
1 cadoj:EnforcementAgencyType/j:CourtOrder/j:CourtOrderEnforcementAgency
1 cadoj:EnforcementAgencyType/nc:Address
cadoj:InvestigtaionType
1 cadoj:InvestigtaionType\nc:ActivityReasonText
cadoj:JudgeType
1 cadoj:JudgeType/nc:RoleOfPersonReference
1 cadoj:JudgeType/cadoj:signature
cadoj:LocationType
1..* cadoj:LocationType/j:CourtOrderDisignatedLocation
1..* cadoj:LocationType/j:CourtOrderDesignatedProperty
cadoj:OfficerType
1 cadoj:OfficerType/nc:RoleOfPersonReference
1 cadoj:OfficerType/cadoj:PersonName
1 cadoj:OfficerType/j:EnforcementOfficialBadgeIdentification
1 cadoj:OfficerType/j:EnforcementOfficialPOSTLicenseIdentification
1 cadoj:OfficerType/cadoj:Signature
1 cadoj:OfficerIdentificationType/j:EnforcementOfficialCategoryText
nc:OrganizationType
nc:OrganizationType/nc:OrganizationName
cadoj:OriginalCitationIssuedToType
1 cadoj:OfficerType/nc:RoleOfPersonReference
cadoj:PersonType
1 cadoj:PersonType/nc:PersonName
1 cadoj:PersonType/nc:PersonAlternateName
0..1 cadoj:PersonType/cadoj:PersonPhysicalFeature
1 cadoj:PersonType/cadoj:PersonIdentifyingNumberIdentification
1 cadoj:PersonType/nc:PersonBirthLocation/LocationAddress
1 cadoj:PersonType/nc:PersonBirthDate/nc:Date
0..* cadoj:PersonType/j:CriminalTraitModusOperandiText
1 cadoj:PersonType/nc:PersonSSNIdentification/nc:IdentificationID
1 cadoj:PersonType/j:PersonFBIIdentification/nc:IdentificationID
1 cadoj:PersonType/j:PersonStateIdentification/nc:IdentificationID
1 cadoj:PersonType/nc:PersonAgeMeasure/nc:MeasureText
1 cadoj:PersonType/cadoj:PersonUnitedStatesCitizenIndicator
1 cadoj:PersonType/nc:PersonEthnicityText
1 cadoj:PersonType/nc:PersonEyeColorText
1 cadoj:PersonType/nc:PersonHairColorText
1 cadoj:PersonType/nc:PersonHeightMeasure/nc:MeasureText
1 cadoj:PersonType/nc:PersonRaceText
1 cadoj:PersonType/nc:PersonSkinToneText
1 cadoj:PersonType/nc:PersonWeightMeasure/nc:MeasureText
1 cadoj:PersonType/cadoj:PersonFingerprintClassificationText
0..* cadoj:PersonType/cadoj:PersonLocalIdentification/nc:IdentificationID
nc:PersonNameType
1 nc:PersonNameType/nc:PersonGivenName
1 nc:PersonNameType/nc:PersonMiddleName
1 nc:PersonNameType/nc:PersonSurName
0..1 nc:PersonNameType/nc:PersonNameSuffixText
0..1 nc:PersonNameType/nc:PersonNamePrefixText
0..1 nc:PersonNameType/nc:PersonMaidenName
1 nc:PersonNameType/nc:PersonFullName
cadoj:ProbableCauseType
1 cadoj:ProbableCauseType/cadoj:ReasonCode
1 cadoj:ProbableCauseType/cadoj:ReasonNumber
cadoj:DAInvestigatorType
1 cadoj:DAInvestigatorType/nc:RoleOfPersonReference
1 cadoj:DAInvestigatorType/nc:ContactInformatoin/nc:ContactTelephoneNumber
1 cadoj:ProsecutorType/j:JudicialOfficial/j:JudicialOfficialCategoryText
1 cadoj:JudgeType/cadoj:signature
cadoj:ReturnServSubpType
1 cadoj:ReturnServSubpType/nc:Address
cadoj:SignatureType
1 cadoj:SignatureType/nc:PersonDigitizedSignatureImage
1 cadoj:SignatureType/nc:DateTime
1 cadoj:SignatureType/nc:PersonFullName
1 cadoj:SignatureType/j:CourtOrderSignatureMethodText
nc:StreetType
1 nc:StreetType/nc:StreetName
1 nc:StreetType/nc:StreetNumberText
1 nc:StreetType/nc:StreetFullText
cadoj:SubpoenaType
cadoj:SubpoenaPreMeetingType
1 cadoj:SubpoenaPreMeetingType/cadoj:PreMeetingDate
1 cadoj:SubpoenaPreMeetingType/cadoj:PreMeetingTime
cadoj:SubpoenaReturnType
1 cadoj:SubpoenaReturnType/nc:ActivityDate
1 cadoj:SubpoenaReturnType:/nc:Address/nc:LocationCityName
cadoj:SubpoenaServedType
1 cadoj:SubpoenaServedType/nc:ActivityDate
1 cadoj:SubpoenaServedType:/nc:Address/nc:LocationCityName
cadoj:SubpoenaServerType
1 cadoj:SubpoenaServerType/nc:RoleOfPersonReference
1 cadoj:SubpoenaServerType/cadoj:SubpoenaServerIdentification
cadoj:Subject
1 cadoj:SubjectType/nc:RoleOfPersonReference
cadoj:VehicleType
1 cadoj:VehicleType/cadoj:LicenseNumber
1 cadoj:VehicleType/cadoj:LicenseCatagory
1 cadoj:VehicleType/cadoj:IssuingCounty
1 cadoj:VehicleType/cadoj:IssuingState
CDCAbstJudgem
BloodAlcoholRpt
CntrlSubLabRpt
AffSearchWrnt
CDCAddCom
CDCDetainer
BCII8420
CDC863
DL157
Inherits / Instatiates XSD Type Comments
s:ComplexObjectType x
nc:ProperNameTextType
nc:ProperNameTextType
nc:ProperNameTextType
niem-xsd:string
nc:ProperNameTextType
nc:StreetType
x
niem-xsd:dateTime x
niem-xsd:dateTime x
cadoj:AttachedDocumentsType x
cadoj:ChargeType
cadoj:CourtType
cadoj:JudgeType
cadoj:OfficerType
cadoj:LocationType
cadoj:ProbableCauseType
x
abstract
x
niem-xsd:string
x
niem-xsd:string
x
niem-xsd:string x
nc:TextType x
nc:IdentificationType x
nc:TextType x
nc:TextType x
x
nc:DateType x
x
nc:DateType
nc:TextType
x
nc:ContactInformationType x
nc:TextType x
nc:TelephoneNumberType x
nc:TelephoneNumberType x
niem-xsd:string x
niem-xsd:string x
x
x
x
nc:TextType x
nc:TextType x
nc:IdentificationType x
nc:JurisdictionType x
x
x
nc:IdentificationType x
x
nc:DateType x
ncTImeType x
nc:TextType x
x
nc:TextType x
nc:TextType
nc:ProperNameTextType
nc:DateType
nc:TextType x
x
nc:TelephoneNumberType
x
x
x
x
niem-xsd:string
nc:DateType
nc:TextType
nc:DateType
nc:StatusType
abstract
x
nc:OrganizationType
x
nc:TextType x
x
cadoj:SignatureType x
x
nc:LocationType x
nc:PropertyType x
x
cadoj:PersonName x
nc:IdentificationType
nc:IdentificationType x
cadoj:SignatureType x
nc:TextType x
x
nc:TextType
x
nc:PersonType
cadoj:PersonNameType
cadoj:PersonNameType
cadoj:PersonIdentifyingNumberIdentificationType
nc:AddressType
niem-xsd:date
nc:TextType
niem-xsd:string
niem-xsd:string
nc:TextType indicates
niem-xsd:boolean whether or not
nc:TextType
nc:TextType
nc:TextType
nc:TextType
nc:TextType
nc:TextType
nc:TextType
nc:TextType
niem-xsd:string
nc:PersonNameType x
nc:PersonNameTextType
nc:PersonNameTextType
nc:PersonNameTextType
nc:TextType
nc:TextType
nc:PersonNameTextType
nc:PersonNameType
x
nc:TextType x
nc:TextType x
x
nc:TelephoneNumberType
nc:TextType
cadoj:SignatureType x
s:ComplexObjectType x
s:ComplexObjectType x
nc:ImageType
niem-xsd:dateTime
nc:TextType
nc:DateType
s:ComplexObjectType x
nc:TextType
nc:TextType
nc:TextType
s:ComplexObjectType x
s:ComplexObjectType x
nc:DateType
nc:TimeType
s:ComplexObjectType x
nc:DateType
nc:ProperNameTextType
s:ComplexObjectType x
nc:DateType
nc:ProperNameTextType
s:ComplexObjectType x
nc:TextType
s:ComplexObjectType x
x
niem-xsd:string
niem-xsd:string
niem-xsd:string
niem-xsd:string
DL310
DNAOrderComp
DS145
DS367E
DS427
EscapeNotice
HealthAssmt
IndvEduProg
JV732
MMHTransSum
NoticeDemandTrialPC1
NoticeParoleHrg
OrdTransPC12039
PoliceRpt
PreBooking
PreSentlnvRpt
ProbCauseDect
PsychAssmt
ReqComlinCust
ReqCourtesySuperv
ReqProsDV
ReqProsFelony
ReqProsMisd
ReturnServSubp
SearchWrnt
SexOffReltst
SS8047
SS8047
SS8049
SS8102
Subpoena
UrineLabRpt
YA1411