MORTGAGE COMPANY FILE LAYOUT and LOCK BOX IMPORT

This is the standard Mortgage Integration Layout with GovCollect’s Property Tax Software.  Each step (numbered 1-4) is a different file and layout.  The file, layout, and position numbers are defined below.

 

4 STEPS

 

1.      REQUEST (APPLY) – Company sends the city a text file with PIDN and their Mortgage Code.  The file being imported should be one file name with no spaces such as mortgage.txt.  The System imports and applies the Mortgage Code to matching PIDN.  Remember the 4 digit mortgage code should exist in the mortgage table prior to import.  After import, the user can run the mortgage import posting report from the reports menu to display which accounts were and were not updated.

 

 

Field

Length

Position

FILE

PIDN

20

1 - 20

 

Mortgage Code

4

21 - 24 (END)

 


2.      EXPORT BILLING FILE  - This should have an option to extract ALL Accounts or Enter a specific Mortgage Code.  (You could do the whole PROPERTY.DBF if you want)

Field

Length

Position

PIDN

20

1 - 20

ACCOUNT

7

21 - 27

PROPCODE

1

28 - 28

STATUS

10

29 - 38

LOCNUMB

15

39 - 53

LOCSTREET

20

54 - 73

LOCSUFFIX

5

74 - 78

L_CITY

25

79 - 103

L_STATE

2

104 - 105

L_ZIP

10

106 - 115

OWNER_NAME

30

116 - 145

CARE OF NAME

30

146 - 175

M_ADD

30

176 - 205

M_CITY

20

206 - 225

M_STATE

2

226 - 227

M_ZIP

10

228 - 237

LEGAL 1

40

238 - 277

LEGAL 2

40

278 - 317

LEGAL 3

40

318 - 357

LEGAL4

40

358 - 397

TAX_YEAR

4

398 - 401

LAND_VALUE

12

402 - 413

IMPROVE

12

414 - 425

GROSS AMT

12

426 - 437

EXEMPT CD

4

438 - 441

EXEMPT AMT

12

442 - 453

NET AMT

12

454 - 465

FAIRCASH

12

466 - 477

AVIS CODE

4

478 - 481

MORTGAGE CD

4

482 - 485

DEEDBOOK 1

4

486 - 489

DEEDPAGE 1

4

490 - 493

SALE_DATE

8

494 - 501

SUBDIV

35

502 - 536

SUBDIV 1

15

537 - 551

SUBDIV 2

15

552 - 566

BLOCK

20

567 - 586

PLOT

20

587 - 606

DISCOUNT

10.2 (12)

607 - 618

NORMAL

10.2 (12)

619 - 630

PENALTY

10.2 (12)

631 - 642

INTEREST

10.2 (12)

643 - 654

TOTAL

10.2 (12)

655 - 666

PAYMENT

10.2 (12)

667 - 678

PHONE

15

679 - 693

TANGIBLE

10.2 (12)

694 - 705

BILL_MTG

1

706 - 706

UNITS

6

707 -712

MAP

30

713 - 742

PROPERTY_NM

6

743 - 748 (END)

 


3.      IMPORT PAYMENT Same for Lock Box
This layout can be used by any 3rd party to import a payment into a GovCollect Batch that can be posted as a payment in the system. 

Field

Length

Position

PIDN

20

1 - 20

DATE

10

21 - 30

AMOUNT

10.2 (12)

31 - 42

CHECK_NUMB

10

43 - 52 (END)

 

·         PIDN should be left justified to not drop any leading zeros.

·         Amount is a total of 12 digits including the decimal and 2 places right of the decimal.  Should contain NO COMMAS.

 


4.      DELINQUENT LIST Export ALL accounts with a PAY_STATUS=Past Due

 

GROSS>0 AND PAY_STATUS=Past Due

 

Field

Length

Position

PIDN

20

1 - 20

TRAN_CODE

10

21 - 30

DATE_DUE

10

31 - 40

OWNER_NAME

30

41 - 70

NORMAL

12.2 (14)

71 - 84

PENALTY

12.2 (14)

85 - 98

INTEREST

12.2 (14)

99 - 112

GROSS

12.2 (14)

113 - 126

PAYMENT

12.2 (14)

127 - 140

MAP

30

141 - 170 (END)

 

Please contact support at 888-553-9991x1 with any questions.