Pre-Foreclosure Filing System

Vacant and Abandoned Property Reporting Bulk Filing Instructions – File Specifications

Effective July 8, 2020

Vacant and abandoned properties must be reported to the Department within 21 days of the date the mortgagee or mortgage loan servicer learns, or should have learned through the exercise of due diligence, that a property is vacant and abandoned. To report vacant and abandoned properties to the Department in bulk, use the specifications below.

Data File Requirements:

  • Data format: ASCII delimited text file
  • Field Separator: Tilde (~)
  • Record Separator: LF (Line Feed)

If you would like to update any previously submitted information, including filer’s contact email address, please include the Tracking Number issued for the previous submission on Column 2, along with all other current information. Please note that the unique ID on Column 1 and the property zip code on Column 8 must match the previous submission.

File Layout (Required fields must be filled if applicable):

Column Number Column Name Data Type Length Required Instructions

1

Unique_number

Alphanumeric

20

Y

A number (assigned by you) that uniquely identifies the filing for a property. Loan Number of the property may be used.

2

Tracking _number

Alphanumeric

10

*

Pre‐foreclosure (PFF) or Vacant Property (VA) Tracking Number provided by DFS.

*Required only if PFF or VA was previously filed with DFS.

3

Filer_email

Alphanumeric

100

Y

Filer’s email address for notification purpose

4

Addr_line1_property

Alphanumeric

100

Y

Property address – Line 1

5

Addr_line2_property

Alphanumeric

100

N

Property address – Line 2

6

Addr_city_property

Alphanumeric

100

Y

Property address – City

7

Add_cde_state_property

Alphanumeric

2

Y

Property – State code ‐ must be NY

8

Addr_zip5_property

Numeric

5

Y

Property address – Zip 5

9

Addr_zip4_property

Numeric

4

N

Property address – Zip 4

10

Addr_cde_county_property

Numeric

5

Y

Property address – County Code use table below

11

Last_name_borrower

Alphanumeric

100

Y

Primary Borrower’s Last Name

12

First_name_borrower

Alphanumeric

100

Y

Primary Borrower‘s First Name

13

Addr_line1_borrower

Alphanumeric

100

Y

Borrower’s Last Known Address Line 1

14

Addr_line2_borrower

Alphanumeric

100

N

Borrower‘s Last Known Address Line 2

15

Addr_city_borrower

Alphanumeric

100

Y

Borrower’s Last Known City

16

Addr_cde_state_borrower

Alphanumeric

2

Y

Borrower’s Address State code

17

Addr_zip5_borrower

Numeric

5

Y

Borrower’s Address Zip 5

18

Addr_zip4_borrower

Numeric

4

N

Borrower’s Address Zip 4

19

Code_loan_status

Numeric

2

Y

Loan Status code (select one):

01 - Pre‐foreclosure

02 - Active foreclosure

03 - Expedited foreclosure

20

Dte_foreclosure_status

Date

8

*

Date of foreclosure status format: MMDDYYYY

* Required if Row 19 is 02 or 03

21

New_Servicer

Alphanumeric

1

*

* Required only if acquiring a loan from another servicer

Y ‐ If acquiring

N ‐ Otherwise

22

Flag_Inactive

Alphanumeric

1

*

* Required only if filing to be discontinued

Y ‐ If discontinuing

N ‐ Otherwise

23

Code_Inactive

Alphanumeric

2

*

Reason for discontinuation:

01 - Loan Reinstated

02 - Property Occupied

04 - Loan/Servicing Rights Sold to Another Mortgagee/Servicer

05 - Property Demolished

06 - Mortgage Discharged (Lien Release)

07 - Other

08 - Mortgage Discharged (Foreclosure)

09 - Mortgage Discharged (Paid Off)

24

Buyers_Contact_Info

Alphanumeric

200

*

Required if the loan is sold. Provide buyers contact info

25

Property_email

Alphanumeric

200

Y

Provide an email address other than the filer’s email, to be contacted in connection with complaints about the property.

* Conditionally Required


New York State County Code Table

Code County Name

36001

Albany

36003

Allegany

36005

Bronx

36007

Broome

36009

Cattaraugus

36011

Cayuga

36013

Chautauqua

36015

Chemung

36017

Chenango

36019

Clinton

36021

Columbia

36023

Cortland

36025

Delaware

36027

Dutchess

36029

Erie

36031

Essex

36033

Franklin

36035

Fulton

36037

Genesee

36039

Greene

36041

Hamilton

36043

Herkimer

36045

Jefferson

36047

Kings

36049

Lewis

36051

Livingston

36053

Madison

36055

Monroe

36057

Montgomery

36059

Nassau

36061

New York

36063

Niagara

36065

Oneida

36067

Onondaga

36069

Ontario

36071

Orange

36073

Orleans

36075

Oswego

36077

Otsego

36079

Putnam

36081

Queens

36083

Rensselaer

36085

Richmond

36087

Rockland

36089

St. Lawrence

36091

Saratoga

36093

Schenectady

36095

Schoharie

36097

Schuyler

36099

Seneca

36101

Steuben

36103

Suffolk

36105

Sullivan

36107

Tioga

36109

Tompkins

36111

Ulster

36113

Warren

36115

Washington

36117

Wayne

36119

Westchester

36121

Wyoming

36123

Yates