- Contents
AIM Help
YGC Import Record Type 45 - Deceased
This record reports updates to deceased debtor information. AIM only supports the primary debtor and the first two co-debtors for this information.
Field Code |
Field Description |
Field Type |
Field Size |
Start |
End |
RECORD_CODE |
Value = 45. |
Char |
2 |
1 |
2 |
FILENO |
Latitude file number. |
Char |
10 |
3 |
12 |
FORW_FILE |
Customer account number in Latitude. |
Char |
20 |
13 |
32 |
MASCO_FILE |
Internal file number of the receiver (agency or law firm) working the account. |
Char |
15 |
33 |
47 |
FIRM_ID |
YGC ID for the attorney record in AIM. |
Char |
10 |
48 |
57 |
FORW_ID |
You've Got Claims ID. |
Char |
10 |
58 |
67 |
DEBTOR_NO |
Identifies which debtor on the account is filing for bankruptcy. Valid values are: 1 = Primary debtor 2 = Second debtor 3 = Third debtor The last record (02 or 31) determines the primary debtor. The last record (03 or 33) determines the second and third debtors. AIM requires this field. |
Numeric |
3 |
68 |
70 |
DOD |
Date the debtor died. |
Date |
8 |
71 |
78 |
PRB_CASE_NO |
Court-issued case number. |
Char |
15 |
79 |
93 |
PRB_ST |
State abbreviation of the debtor's residence. |
Char |
2 |
94 |
95 |
PRB_CTY |
County name of the debtor's residence. |
Char |
20 |
96 |
115 |
PRB_CRT |
Name of the court where the beneficiaries filed probate. There is no format restriction. |
Char |
30 |
116 |
145 |
PRB_DATE |
Date the beneficiaries filed probate. |
Date |
8 |
146 |
153 |
PRB_EXP |
Last date on which creditors can file claims against the estate. |
Date |
8 |
154 |
161 |
REP_NAME |
Cull name of the person handling the estate. |
Char |
40 |
162 |
201 |
REP_STRT1 |
Personal representative's street address line 1. |
Char |
40 |
202 |
241 |
REP_STRT2 |
Overflow field for REP_STRT1. |
Char |
40 |
242 |
281 |
REP_CITY |
Personal representative's city. |
Char |
30 |
282 |
311 |
REP_ST |
Personal representative's state. |
Char |
2 |
312 |
313 |
REP_ZIP |
Personal representative's postal code, which can include the four-digit extension. |
Char |
10 |
314 |
323 |
REP_PHONE |
Personal representative's phone number. |
Char |
20 |
324 |
343 |
ATTY_NAME |
Estate attorney's full name. |
Char |
40 |
344 |
383 |
ATTY_FIRM |
Estate attorney's law firm. |
Char |
40 |
384 |
423 |
ATTY_STRT1 |
Estate attorney's street address line 1. |
Char |
40 |
424 |
463 |
ATTY_STRT2 |
Overflow field for ATTY_STRT1. |
Char |
40 |
464 |
503 |
ATTY_CITY |
Estate attorney's city. |
Char |
30 |
504 |
533 |
ATTY_ST |
Estate attorney's state. |
Char |
2 |
534 |
535 |
ATTY_ZIP |
Estate attorney's postal code, which can include the four-digit extension. |
Char |
10 |
536 |
545 |
ATTY_PHONE |
Estate attorney's phone number. |
Char |
20 |
546 |
565 |
REP_CNTRY |
Personal representative's country. |
Char |
3 |
566 |
568 |
ATTY_CNTRY |
Estate attorney's country. |
Char |
3 |
569 |
571 |