Court Cases Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

CourtCaseID

Code that Latitude assigned to identify the court case record. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct court case record.

4

Integer

None

NB, M

AccountID

Code that Latitude assigned to identify the account. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, M

CourtID

Code that identifies the court assigned to the case. You must have already created this code in Latitude.

4

Integer

Courts/CourtID

NB, M

Judge

Name of the judge assigned to the case.

100

VarChar

None

NB, M

CaseNumber

Court case number.

50

VarChar

None

NB, M

DateFiled

Date the Plaintiff filed the complaint with the court.

8

DateTime

None

NB, M

Judgment

Flag that indicates whether a judgment exists on the account.

1 = Yes

0 = No

1

Bit

None

NB, M

JudgmentAmount

Amount of the judgment awarded toward principal.

8

Money

None

NB, M

JudgmentIntRate

Interest rate calculated from the specified interest date and applied toward the awarded principal amount.

4

Real

None

NB, M

JudgmentDate

Date the court awarded judgment.

8

DateTime

None

NB, M

Status

Status of the legal case.

50

VarChar

None

NB, M

MiscInfo1

Use for whatever information you choose.

500

VarChar

None

NB, M

MiscInfo2

Use for whatever information you choose.

500

VarChar

None

NB, M

Remarks

Comments regarding the case.

1000

VarChar

None

NB, M

Plaintiff

Person who filed the complaint.

200

VarChar

None

NB, M

Defendant

Person defending the case.

100

VarChar

None

NB, M

DateAnswered

Date the Defendant filed the response to the complaint with the court.

4

SmallDate

None

NB, M

StatusDeadline

Statutory deadline for trying the case.

4

SmallDate

None

NB, M

CourtDate

Date and time of the trial.

8

DateTime

None

NB, M

DiscoveryCutoff

Deadline for discovery requests.

4

SmallDate

None

NB, M

MotionCutOff

Deadline for filing a motion to reopen discovery.

4

SmallDate

None

NB, M

ArbitrationDate

Date and time of arbitration.

8

DateTime

None

NB, M

LastSummaryJudgmentDate

Deadline for filing summary judgment motions.

4

SmallDate

None

NB, M

JudgmentIntAward

Interest amount awarded in the judgment.

8

Money

None

NB, M

JudgmentCostAward

Court costs awarded in the judgment.

8

Money

None

NB, M

JudgmentAttorneyCostAward

Attorney fees awarded in the judgment.

8

Money

None

NB, M

JudgmentOtherAward

Miscellaneous fees awarded in the judgment.

8

Money

None

NB, M

IntFromDate

Date to use to apply interest at the specified interest rate.

4

SmallDate

None

NB, M

AccruedInt

Amount of accrued interest.

8

Money

None

NB, M

DateCreated

Date the court awarded judgment.

8

DateTime

None

NB, M

DateUpdated

Date the court clerk recorded the judgment.

8

DateTime

None

NB, M

UpdatedBy

Code that identifies the user who updated the court case in Latitude.

4

Integer

None

NB, M

UpdatedCheckSum

Internally calculated.

50

VarChar

None

NB, M

CourtName

Name of the court.

50

VarChar

None

NB, M

CourtCounty

Court's county.

50

VarChar

None

NB, M

CourtNotes

Comments regarding the court.

1000

VarChar

None

NB, M

ReverseJudgment

Flag that indicates whether the court reversed the judgment.

1 = Yes

0 = No

1

Bit

None

NB, M

IsCorrection

Flag that indicates whether the judgment reversal is to correct a judgment created in error.

1 = Yes

0 = No

1

Bit

None

NB, M