YGC Import Record Type 46 - Physical Assets

Field Code

Field Description

Field Type

Field Size

Start

End

RECORD_CODE

Value = 46.

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 in Latitude.

Char

10

58

67

DBTR_NUM

Debtor on the account who owns the asset. Valid values are:

1 = Primary debtor

2 = Second debtor

3 = Third debtor

Numeric

3

68

70

ASSET_ID

Code that identifies the asset the debtor owns.

Char

3

71

73

ASSET_OWNER

Full name of the debtor who owns the asset.

Char

60

74

133

STREET

Asset's street address.

Char

40

134

173

STREET_2

Overflow field for STREET.

Char

40

174

213

STREET_3

Overflow field for STREET_2.

Char

40

214

253

CITY

Asset's city.

Char

30

254

283

TOWN

Asset's town or borough. Use this field as an alternative or supplement to CITY.

Char

30

284

313

CNTY

Asset's county.

Char

30

314

343

STATE

Asset's state abbreviation.

Char

2

344

345

ZIP

Asset's postal code.

Char

20

346

365

CNTRY

Asset's country abbreviation.

Char

3

366

368

PHONE

Asset's phone number. This field can accommodate separators for the area code and exchange.

Char

20

369

388

BLOCK

For a land asset, the block number.

Char

10

389

398

LOT

For a land asset, the lot number.

Char

10

399

408

ASSET_VALUE

Dollar value of the asset.

Numeric

9.2

409

417

ASSET_DESC

Description of the asset.

Char

40

418

457

ASSET_VIN

For an automobile asset, the vehicle ID number.

Char

20

458

477

ASSET_LIC_PLATE

For an automobile asset, the license plate number.

Char

10

478

487

ASSET_COLOR

For an automobile asset, the color of the vehicle.

Char

15

488

502

ASSET_YEAR

For an automobile asset, the manufacture year.

Char

4

503

506

ASSET_MAKE

For an automobile asset, the maker of the vehicle.

Char

20

507

526

ASSET_MODEL

For an automobile asset, the vehicle model.

Char

20

527

546

REPO_FILE_NUM

For an automobile asset, the repossession file number that the creditor assigned.

Char

15

547

561

REPO_D

For an automobile asset, the date the repossession occurred.

Date

8

562

569

REPO_AMT

For an automobile asset, the value of the vehicle. This value is the same as ASSET_VALUE.

Numeric

9.2

570

578

CERT_TITLE_NAME

For an automobile asset, the name of the new owner as stated on the title.

Char

40

579

618

CERT_TITLE_D

For an automobile asset, the certification title transfer date.

Date

8

619

626

MORT_FRCL_D

For a real estate asset, the foreclosure date.

Date

8

627

634

MORT_FRCL_FILENO

Court-issued case number for the foreclosure.

Char

15

635

649

MORT_FRCL_DISMIS_D

Date the court dismissed the foreclosure for whatever reason.

Date

8

650

657

MORT_PMT

Periodic or total payment on the mortgage.

Numeric

7.2

658

664

MORT_RATE

Mortgage interest rate in decimal form. For example, if the interest rate is 19.5 percent, the value is ".1950."

Numeric

4.3

665

668

MORT_BOOK_1

Number of the local records book where the clerk filed the property, or the liber number.

Char

5

669

673

MORT_PAGE_1

Page number in the local records book where the clerk filed the property.

Char

5

674

678

MORT_BOOK_2

If MORT_BOOK_1 is the liber number, this field contains the portfolio number of the property.

Char

5

679

683

MORT_PAGE_2

Page number corresponding to MORT_BOOK_2.

Char

5

684

688

MORT_RECRD_D

Date the clerk recorded the mortgage in the local record book.

Date

8

689

696

MORT_DUE_D

Mortgage due date.

Date

8

697

704

LIEN_FILE_NUM

Number the land records office provided in the property's county.

Char

15

705

719

LIEN_CASE_NUM

Case number that the bank holding the lien assigned.

Char

15

720

734

LIEN_D

Date the court established the lien.

Date

8

735

742

LIEN_BOOK

Number of the local records book where the clerk filed the lien.

Char

5

743

747

LIEN_PAGE

Page number in the local records book where the clerk filed the lien.

Char

5

748

752

LIEN_AOL

Indicates whether there was a response to the lien. Valid values are:

Y = Yes

N = No

Char

1

753

753

LIEN_RLSE_D

Date the clerk filed the lien release (the confirmation of the lien's payment).

Date

8

754

761

LIEN_RLSE_BOOK

Number of the local records book where the clerk filed the lien release.

Char

5

762

766

LIEN_RLSE_PAGE

Page number in the local records book where the clerk filed the lien release.

Char

5

767

771

LIEN_LITIG_D

Lien foreclosure date.

Date

8

772

779

LIEN_LITIG_BOOK

Number of the local records book where the clerk filed the foreclosed lien.

Char

5

780

784

LIEN_LITIG_PAGE

Page number in the local records book where the clerk filed the foreclosed lien.

Char

5

785

789