Feedback

  • Contents
 

Judgments Import File Record

Delimited/fixed record type = AJDG

Excel worksheet name = JudgmentRecord

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = AJDG

File Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed. Use this value for all data sent to AIM.

Judgment Flag

14

3

JudgmentFlag

String (1)

Contains the value "U" for update.

Case Number

15-64

4

CaseNumber

String (50)

Court case number.

Judgment Amt

65-76

5

JudgmentAmt

Decimal (12)

Principal amount awarded in the judgment.

Judgment Int Award

77-88

6

JudgmentIntAward

Decimal (12)

Interest amount awarded in the judgment.

Judgment Cost Award

89-100

7

JudgmentCostAward

Decimal (12)

Costs and fees awarded in the judgment.

Judgment Attorney Cost Award

101-112

8

JudgmentAttorneyCostAward

Decimal (12)

Attorney costs awarded in the judgment.

Judgment Other Award

113-124

9

JudgmentOtherAward

Decimal (12)

Other dollar amount  awarded in the judgment.

Judgment Int Rate

125-129

10

JudgmentIntRate

Decimal (5)

New interest rate awarded in the judgment.

Int From Date

130-137

11

IntFromDate

Date (CCYYMMDD)

Date the new interest rate takes effect.

Attorney Ack Date

138-145

12

AttorneyAckDate

Date (CCYYMMDD)

Date the attorney acknowledged placement of the account.

Date Filed

146-153

13

DateFiled

Date (CCYYMMDD)

Date the creditor filed the suit against the debtor.

Service Date

154-161

14

ServiceDate

Date (CCYYMMDD)

Date the court served the debtor.

Judgment Date

162-169

15

JudgmentDate

Date (CCYYMMDD)

Date the court awarded judgment.

Judgment Recorded Date

170-177

16

JudgmentRecordedDate

Date (CCYYMMDD)

Date the clerk recorded the judgment.

Date Answered

178-185

17

DateAnswered

Date (CCYYMMDD)

Date the debtor answered the judgment.

Statute Deadline

186-193

18

StatuteDeadline

Date (CCYYMMDD)

Statute of limitations deadline.

Court Date

194-201

19

CourtDate

Date (CCYYMMDD)

Court date.

Discovery Cutoff

202-209

20

DiscoveryCutoff

Date (CCYYMMDD)

Cutoff date for discovery.

Discovery Reply Date

210-217

21

DiscoveryReplyDate

Date (CCYYMMDD)

Discovery reply date.

Motion Cutoff

218-225

22

MotionCutoff

Date (CCYYMMDD)

Cutoff date for filing motions.

Arbitration Date

226-233

23

ArbitrationDate

Date (CCYYMMDD)

Arbitration date.

Last Summary Judgment Date

234-241

24

LastSummaryJudgmentDate

Date (CCYYMMDD)

Last summary judgment date.

Status

242-291

25

Status

String (50)

Status of the court case.

Service Type

292-311

26

ServiceType

String (20)

Type of service performed.

Misc Info 1

312-411

27

MiscInfo1

String (100)

Miscellaneous information.

Misc Info 2

412-511

28

MiscInfo2

String (100)

Miscellaneous information.

Remarks

512-611

29

Remarks

String (100)

Comments regarding the judgment.

Plaintiff

612-711

30

Plaintiff

String (100)

Plaintiff in the case.

Defendant

712-811

31

Defendant

String (100)

Defendant in the case.

Judgment Book

812-831

32

JudgmentBook

String (20)

Number of the local records book where the clerk recorded the judgment.

Judgment Page

832-851

33

JudgmentPage

String (20)

Page in the local records book where the clerk recorded the judgment.

Judge

852-951

34

Judge

String (100)

Judge who is presiding over the case.

Court Room

952-966

35

CourtRoom

String (15)

Court room for hearing the case.

Court Name

967-1016

36

CourtName

String (50)

Name of the court.

Court County

1017-1066

37

CourtCounty

String (50)

Court's county.

Court Street 1

1067-1116

38

CourtStreet1

String (50)

Court's street address line 1.

Court Street 2

1117-1166

39

CourtStreet2

String (50)

Court's street address line 2.

Court City

1167-1216

40

CourtCity

String (50)

Court's city.

Court State

1217-1221

41

CourtState

String (5)

Court's state.

Court Zipcode

1222-1231

42

CourtZipcode

String (10)

Court's postal code.

Court Phone

1232-1281

43

CourtPhone

String (50)

Court's phone number.

Court Fax

1282-1331

44

CourtFax

String (50)

Court's fax number.

Court Salutation

1332-1381

45

CourtSalutation

String (50)

Court's salutation.

Court Clerk First Name

1382-1431

46

CourtClerkFirstName

String (50)

Court clerk's first name.

Court Clerk Middle Name

1432-1481

47

CourtClerkMiddleName

String (50)

Court clerk's middle name.

Court Clerk Last Name

1482-1531

48

CourtClerkLastName

String (50)

Court clerk's last name.

Court Notes

1532-1781

49

CourtNotes

String (250)

Court notes.

Related Topics

Judgments Import File Layout

Import File Layouts