Case data fields

An entity is an object in eProsecutor Online that reflects a distinct state of a Case or Person. Listed are all the entities and their fields that you can upload using the self-service data conversion tool.

Case

Field

Data Type

Required

Status

String

Yes

Status Date

DateTime

Yes

Received Date

DateTime

Yes

Case Type

String

Yes

Case Number

String

No

Reference Number

String

No

CaseSeal

In the Excel sheet you want to import, the Case data must be in columns that precede the CaseSeal columns.

Field

Data Type

Required

Case Seal Type

String

Yes

Case Seal Effective From

DateTime

No

Case Seal Effective To

DateTime

No

CaseSpecialStatus

In the Excel sheet you want to import, the Case data must be in columns that precede the CaseSpecialStatus columns.

Field

Data Type

Required

Case Special Status Type

String

Yes

Case Special Status Category

String

No

Case Special Status Value

String

No

Case Special Status Start Date

DateTime

No

Case Special Status End Date

DateTime

No

Case Special Status Memo

String

No

Person

Field

Data Type

Required

Name Prefix

String

No

First Name

String

Yes

Middle Name

String

No

Last Name

String

Yes

Name Suffix

String

No

Organization

String

No

Person Status

String

No

Person Type

String

No

Party

In the Excel sheet you want to import, the Case and Person data must be in columns that precede the Party columns.

Field

Data Type

Required

Party Type

String

Yes

Party Status

String

No

Party Start Date

DateTime

No

Party Number

String

No

Party Note

String

No

Address

In the Excel sheet you want to import, the Person data must be in columns that precede the Address columns.

Field

Data Type

Required

Address Type

String

No

Address Line 1

String

Yes

Address Line 2

String

No

Zip

String

No

City

String

No

State

String

No

Effective From

DateTime

No

Effective To

DateTime

No

Address Notes

String

No

Charge

In the Excel sheet you want to import, the Case and Party data must be in columns that precede the Charge columns.

Field

Data Type

Required

Charge Statute Section Number

ForeignKey

Yes

Charge Disposition Type

String

No

Charge Disposition Date

DateTime

No

Charge Declination Memo

String

No

Charge Disposition Reason

String

No

Charge Count

Integer

No

Charge Date

DateTime

No

Charge End Date

DateTime

No

Charge Stage Added

String

No

Charge Status

String

No

SubCharge

In the Excel sheet you want to import, the Charge data must be in columns that precede the SubCharge columns.

Field

Data Type

Required

Enhancement Statute Section Number

ForeignKey

Yes

Enhancement Notes

String

No

Ce_ChargeIntoxicant

In the Excel sheet you want to import, the Charge data must be in columns that precede the Ce_ChargeIntoxicant columns.

Field

Data Type

Required

Charge Intoxicant Type

String

Yes

Charge Intoxicant Level

String

No

Charge Intoxicant Notes

String

No

ChargeCharacteristic

In the Excel sheet you want to import, the Charge data must be in columns that precede the ChargeCharacteristic columns.

Field

Data Type

Required

Charge Characteristic

String

Yes

Charge Characteristic Type

String

No

Charge Characteristic Value

String

No

Sentence

In the Excel sheet you want to import, the Charge data must be in columns that precede the Sentence columns.

Field

Data Type

Required

Sentence Type

String

Yes

Sentence Min Length

Double

No

Sentence Max length

Double

No

Sentence Unit

String

No

Sentence Amount $

Double

No

Sentence Reduced To $

Double

No

Sentence Notes

String

No

Sentence Credit Length

Double

No

Sentence Credit Unit

String

No

Sentence Credit Notes

String

No

Sentence Amount Suspended

Double

No

Sentence Suspend Length

Double

No

Sentence Suspend Unit

String

No

Sentence Suspend Notes

String

No

SentenceCondition

In the Excel sheet you want to import, the Sentence data must be in columns that precede the SentenceCondition columns.

Field

Data Type

Required

Sentence Condition Type

String

Yes

Sentence Condition Length

Double

No

Sentence Condition Length Unit

String

No

Sentence Condition Begin Date

DateTime

No

Sentence Condition Location

String

No

Sentence Condition Amount $

Double

No

Sentence Condition Status

String

No

Sentence Condition Status Date

DateTime

No

Sentence Condition Notes

String

No

Telephone

In the Excel sheet you want to import, the Person data must be in columns that precede the Telephone columns.

Field

Data Type

Required

Telephone Number

String

Yes

Telephone Type

String

No

Telephone Effective From

DateTime

No

Telephone Effective To

DateTime

No

Telephone Notes

String

No

PersonProfile

In the Excel sheet you want to import, the Person data must be in columns that precede the PersonProfile columns.

Field

Data Type

Required

Date of Birth

DateTime

No

Gender

String

No

Hair Color

String

No

Eye Color

String

No

Height

String

No

Weight

Int

No

Ethnicity

String

No

Primary Language

String

No

CaseContact

In the Excel sheet you want to import, the Person data must be in columns that precede the CaseContact columns.

Field

Data Type

Required

Email Type

String

No

Email

String

No

Email Effective From

DateTime

No

Email Effective To

DateTime

No

Email Notes

String

No

OtherCaseNumber

In the Excel sheet you want to import, the Case data must be in columns that precede the OtherCaseNumber columns.

Field

Data Type

Required

Other Case Number

String

Yes

Other Number Type

String

No

Other Number Lead

Boolean

No

Other Number Active

Boolean

No

Identification

In the Excel sheet you want to import, the Person data must be in columns that precede the Identification columns.

Field

Data Type

Required

Identification Number

String

Yes

Identification Type

String

Yes

Identification Issuer State

String

No

Identification Status

String

No

Identification Class

String

No

Identification Issuer Notes

String

No

DocDef

Field

Data Type

Required

Case Document Docdef Description

String

No

Case Document DocDefName

String

Yes

Case Document DocDefNumber

String

Yes

Case Document ShortName

String

Yes

Document

In the Excel sheet you want to import, the Case and DocDef data must be in columns that precede the Document columns.

Field

Data Type

Required

Case Document File Path

String

Yes

Case Document Name Exact

String

No

Case Document Original File Name

String

No

Case Document Review Status

String

No

Case Document Review Status Date

DateTime

No

CaseNote

In the Excel sheet you want to import, the Case data must be in columns that precede the CaseNote columns.

Field

Data Type

Required

Case Note Title

String

No

Case Note

String

No

ChargeNote

In the Excel sheet you want to import, the Case and Charge data must be in columns that precede the ChargeNote columns.

Field

Data Type

Required

Charge Note Title

String

No

Charge Note

String

No

PleaOffer

In the Excel sheet you want to import, the Party data must be in columns that precede the PleaOffer columns.

Field

Data Type

Required

Plea Offer Type

String

Yes

Plea Offer Expiration Date

DateTime

No

Plea Offer Status

String

No

Plea Offer

String

Yes

ScheduledEvent

In the Excel sheet you want to import, the Case data must be in columns that precede the ScheduledEvent columns.

Field

Data Type

Required

Event Type

String

Yes

Event Start

DateTime

Yes

Event End

DateTime

No

Event Result Type

String

No

Event Category

String

No

EventNote

In the Excel sheet you want to import, the Case and ScheduledEvent data must be in columns that precede the CaseNote columns.

Field

Data Type

Required

Event Note Title

String

No

Event Note

String

No

PersonNote

In the Excel sheet you want to import, the Person data must be in columns that precede the PersonNote columns.

Field

Data Type

Required

Person Note Type

String

No

Person Note

String

No

Person Note Date

DateTime

No

DirOrgUnit

Field

Data Type

Required

Directory Organization Type

String

Yes

Directory Organization Name

String

Yes

DirPerson

In the Excel sheet you want to import, the DirOrgUnit data must be in columns that precede the DirPerson columns.

Field

Data Type

Required

Directory Person Role

String

Yes

Directory Person First Name

String

Yes

Directory Person Middle Name

String

No

Directory Person Last Name

String

Yes

Directory Person Email

String

No

CaseAssignment

In the Excel sheet you want to import, the Case and DirPerson data must be in columns that precede the CaseAssignment columns.

Field

Data Type

Required

Case Assignment Role

String

Yes

Case Assignment Date Assigned

DateTime

Yes

Case Assignment Status

String

Yes

Case Assignment Notes

String

No

DirIdentification

In the Excel sheet you want to import, the DirPerson data must be in columns that precede the DirIdentification columns.

Field

Data Type

Required

Directory Identification Number

String

Yes

Directory Identification Type

String

Yes

Directory Identification Active

Boolean

No

Directory Identification Note

String

No

ChecklistItem

In the Excel sheet you want to import, the Case and DirPerson data must be in columns that precede the ChecklistItem columns.

Field

Data Type

Required

Task Type

String

No

Task Instructions

String

Yes

Task Due Date

DateTime

No

Task Suspended

Boolean

No

Task Completed

Boolean

No

Task Status

String

No