YGC Export Record Type 15 - Deceased

Field Code

Field Description

Field Type

Field Size

Start

End

RECORD_CODE

Value = 15.

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

Blank.

Char

15

33

47

FORW_ID

You've Got Claims ID.

Char

10

48

57

FIRM_ID

YGC ID for the attorney record in AIM.

Char

10

58

67

DBTR_NUM

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.

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 person handling the estate filed the probate. There is no format restriction.

Char

30

116

145

PRB_DATE

Date the person handling the estate filed the probate.

Date

8

146

153

PRB_EXP

Last date on which the client 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