- Contents
AIM Help
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. |