PWS Attachment 5 - Data Mapping.pdf

PDF 94 KB Posted

Attached to
REO Case Management Support Services - Solicitation Amendment 00002 Federal contract opportunity
Solicitation number
86615622R00009
Issued by
Department of Housing and Urban Development

About this file

Written by GovTribe AI ·

This solicitation requests proposals for Real Estate Owned (REO) case management support services. The Department of Housing and Urban Development seeks a contractor to provide a FedRAMP compliant commercial web-based Software as a Service subscription platform to support REO case management and workflow tracking processes. The base period of performance is one year with four one-year options. Offerors must have an operational SaaS application available by the June 20th deadline. The contract will have both firm fixed price and indefinite delivery indefinite quantity elements, with only fixed price task orders issued against the IDIQ. Proposals are due no later than 2:00 PM Eastern on June 20th, 2022 and should be submitted to the contracting officer. Only one award is anticipated with an estimated period of September 2022 through August 2027.

View the file

Other files for this federal contract opportunity

Other files attached to REO Case Management Support Services - Solicitation Amendment 00002, newest first.
File Type Posted
Solicitation Amendment 00002 86615622R00009 (Conformed Copy 07192022).pdf PDF
SF 30 - Solicitation Amendment 00002 07192022.pdf PDF
Solicitation Amendment 00002 86615622R00009 (Conformed Copy 07192022).pdf PDF
SF 30 - Solicitation Amendment 00002 07192022.pdf PDF
Attachment 0003 - Price Schedule (Revised 07192022).xls XLS spreadsheet
Attachment 0004 - Sample Price Breakdown with Rates (Revised 07192022).xls XLS spreadsheet
PWS Attachment 18 - Standard Report Listing (Revised 06152022).pdf PDF
Attachment 0004 - Sample Price Breakdown with Rates (Revised 06152022).xlsx XLSX spreadsheet
Attachment 0005 - Labor Category and Hours Breakdown Worksheet without Rates (Revised 06152022).xlsx XLSX spreadsheet
Solicitation Amendment 86615622R00009 (Conformed Copy).pdf PDF
Attachment 0003 - Price Schedule (Revised 06152022).docx DOCX document
SF 30 Solicitation Amendment 00001.pdf PDF
Attachment 0001 - Performance Work Statement (Revised 06152022).docx DOCX document
Solicitation 86615622R00009.pdf PDF
PWS Attachment 17 - SFHEDW Flow Chart.pdf PDF
PWS Attachment 7 - Accounting Post Codes.pdf PDF
PWS Attachment 12 - Payee Types and NAID Status.pdf PDF
PWS Attachment 6 - WON Categories.pdf PDF
PWS Attachment 14 - Sales Cancellation Reason Codes.pdf PDF
PWS Attachment 15 - Contract Extension Reasons.pdf PDF
PWS Attachment 9 - Reconveyance Status.pdf PDF
Attachment 0006 - Past Performance Information.docx DOCX document
Attachment 0010 - FSM Tasks (Informational Purposes Only).pdf PDF
Attachment 0005 - Labor Category and Hours Breakdown Worksheet without Rates.xlsx XLSX spreadsheet
PWS Attachment 10 - Claim Form 27011.pdf PDF
PWS Attachment 4 - Listing Period Progression.pdf PDF
PWS Attachment 19 - Vendor Performance Reports.pdf PDF
PWS Attachment 16 - Automatic Email Types.pdf PDF
Attachment 0009 - A and M Tasks (Informational Purposes Only).pdf PDF
Attachment 0011 - MCM Tasks (Informational Purposes Only).pdf PDF
Attachment 0002 - Quality Assurance Surveillance Plan.doc DOC document
Attachment 0004 - Sample Price Breakdown with Rates.xlsx XLSX spreadsheet
PWS Attachment 18 - Standard Report Listing.pdf PDF
PWS Attachment 13 - Contract Data Elements.pdf PDF
PWS Attachment 11 - Note Categories.pdf PDF
PWS Attachment 3 - Sample Appraisal Review Form.pdf PDF
PWS Attachment 20 - Work Assignment Template.pdf PDF
Attachment 0007 - Past Performance Survey.docx DOCX document
Attachment 0008 - Subcontracting Plan Template.docx DOCX document
Attachment 0003 - Price Schedule.docx DOCX document
PWS Attachment 2 - User Groups.pdf PDF
PWS Attachment 1 - Geographical Locations.pdf PDF
PWS Attachment 8 - Sample Inspection Forms.pdf PDF
Attachment 0001 - Performance Work Statement.docx DOCX document
Show all 44

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Attachment 5 - DATA MAPPING

Field # Column Datatype

1 Primary Key NUMBER

2 POINTER TO PROPERTY NUMBER (18)

3 CASE PREFIX VARCHAR2 (3)

4 CASE NUMBER VARCHAR2 (6)

5 SFINANCETYPE VARCHAR2 (2 Byte)

6 FHA NUMBER

7 FMHA NUMBER

8 CONV UNITS NUMBER

9 VA NUMBER

10 CONV INS NUMBER

11 FILE NUMBER VARCHAR2 (60 Byte)

12 LOAN NUMBER VARCHAR2 (60 Byte)

13 CASE NUMBER VARCHAR2 (60 Byte)

14 Not Used 15 Not Used 16 Not Used 17 Not Used

18 401. CONTRACT SALES PRICE NUMBER (12,2)

19 406. CITY/TOWN TAXES FROM DATE DATE

20 406. CITY/TOWN TAXES TO DATE DATE

21 406. CITY/TOWN TAXES NUMBER (12,2)

22 407. COUNTY TAXES FROM DATE DATE

23 407. COUNTY TAXES TO DATE DATE

24 407. COUNTY TAXES NUMBER (12,2)

25 408. ASSESSMENTS FROM DATE DATE

26 408. ASSESSMENTS TO DATE DATE

27 408. ASSESSMENTS NUMBER (12,2)

28 510. CITY/TOWN TAXES FROM DATE DATE

29 510. CITY/TOWN TAXES TO DATE DATE

30 510. CITY/TOWN TAXES NUMBER (12,2)

31 511. COUNTY TAXES FROM DATE DATE

32 511. COUNTY TAXES TO DATE DATE

33 511. COUNTY TAXES NUMBER (12,2)

34 512. ASSESSMENTS FROM DATE DATE

35 512. ASSESSMENTS TO DATE DATE

36 512. ASSESSMENTS NUMBER (12,2)

37 101. PERSONAL PROPERTY NUMBER (12,2)

38 104. (FIELD CAPTION) VARCHAR2 (100 Byte)

39 104. (AMOUNT) NUMBER (12,2)

40 105. (FIELD CAPTION) VARCHAR2 (100 Byte)

41 105 (AMOUNT) NUMBER (12,2)

42 109. (FIELD CAPTION) VARCHAR2 (100 Byte)

43 109. (AMOUNT) NUMBER (12,2)

44 110. (FIELD CAPTION) VARCHAR2 (100 Byte)

45 110. (AMOUNT) NUMBER (12,2)

46 111. (FIELD CAPTION) VARCHAR2 (100 Byte)

47 111. (AMOUNT) NUMBER (12,2)

48 112. (FIELD CAPTION) VARCHAR2 (100 Byte)

49 112. (AMOUNT) NUMBER (12,2)

50 201. DEPOSIT OR EARNEST MONEY NUMBER (12,2)

202. PRINCIPAL AMOUNT OF NEW

LOAN(S)

NUMBER (12,2)

203. EXISTING LOAN(S) TAKEN

SUBJECT TO

NUMBER (12,2)

53 204. (FIELD CAPTION) VARCHAR2 (100 Byte)

54 204. (AMOUNT) NUMBER (12,2)

55 205. (FIELD CAPTION) VARCHAR2 (100 Byte)

56 205. (AMOUNT) NUMBER (12,2)

57 206. (FIELD CAPTION) VARCHAR2 (100 Byte)

58 206. (AMOUNT) NUMBER (12,2)

59 207. (FIELD CAPTION) VARCHAR2 (100 Byte)

60 207. (AMOUNT) NUMBER (12,2)

61 208. (FIELD CAPTION) VARCHAR2 (100 Byte)

62 208. (AMOUNT) NUMBER (12,2)

63 209. (FIELD CAPTION) VARCHAR2 (100 Byte)

64 209. (AMOUNT) NUMBER (12,2)

65 213. (FIELD CAPTION) VARCHAR2 (100 Byte)

66 213. (AMOUNT) NUMBER (12,2)

67 214. (FIELD CAPTION) VARCHAR2 (100 Byte)

68 214. (AMOUNT) NUMBER (12,2)

69 215. (FIELD CAPTION) VARCHAR2 (100 Byte)

70 215. (AMOUNT) NUMBER (12,2)

71 216. (FIELD CAPTION) VARCHAR2 (100 Byte)

72 216. (AMOUNT) NUMBER (12,2)

73 217. (FIELD CAPTION) VARCHAR2 (100 Byte)

74 217. (AMOUNT) NUMBER (12,2)

75 218. (FIELD CAPTION) VARCHAR2 (100 Byte)

76 218. (AMOUNT) NUMBER (12,2)

77 219. (FIELD CAPTION) VARCHAR2 (100 Byte)

78 219. (AMOUNT) NUMBER (12,2)

GROSS AMOUNT DUE FROM

BORROWER

NUMBER (12,2)

80 220. TOTAL PAID BY/FOR BORROWER NUMBER (12,2)

81 CASH FROM BORROWER B NUMBER

82 CASH TO BORROWER B NUMBER

83 303. CASH [ FROM/TO] BORROWER NUMBER (12,2)

84 402. PERSONAL PROPERTY NUMBER (12,2)

85 403. (FIELD CAPTION) VARCHAR2 (100 Byte)

86 403. (AMOUNT) NUMBER (12,2)

87 404. (FIELD CAPTION) VARCHAR2 (100 Byte)

88 404. (AMOUNT) NUMBER (12,2)

89 405. (FIELD CAPTION) VARCHAR2 (100 Byte)

90 405. (AMOUNT) NUMBER (12,2)

91 409. (FIELD CAPTION) VARCHAR2 (100 Byte)

92 409. (AMOUNT) NUMBER (12,2)

93 410. (FIELD CAPTION) VARCHAR2 (100 Byte)

94 410. (AMOUNT) NUMBER (12,2)

95 411. (FIELD CAPTION) VARCHAR2 (100 Byte)

96 411. (AMOUNT) NUMBER (12,2)

97 412. (FIELD CAPTION) VARCHAR2 (100 Byte)

98 412. (AMOUNT) NUMBER (12,2)

501. EXCESS DEPOSIT (SEE

INSTRUCTIONS)

NUMBER (12,2)

503. EXISTING LOAN(S) TAKEN

SUBJECT TO

NUMBER (12,2)

504. PAYOFF OF FIRST MORTGAGE

LOAN

NUMBER (12,2)

505. PAYOFF OF SECOND

MORTGAGE LOAN

NUMBER (12,2)

103 506. EXTEN FEE REFUND VARCHAR2 (100 Byte)

104 506. (AMOUNT) NUMBER (12,2)

105 507. SALES DISCOUNT VARCHAR2 (100 Byte)

106 507. (AMOUNT) NUMBER (12,2)

107 508. UTILITY ESCROW VARCHAR2 (100 Byte)

108 508. (AMOUNT) NUMBER (12,2)

109 509. REPAIR ESCROW VARCHAR2 (100 Byte)

110 509. (AMOUNT) NUMBER (12,2)

111 513. (FIELD CAPTION) VARCHAR2 (100 Byte)

112 513. (AMOUNT) NUMBER (12,2)

113 514. ALL OTHER UNPAID TAX VARCHAR2 (100 Byte)

114 514. (AMOUNT) NUMBER (12,2)

115 514. PENALTY/INT - HUD VARCHAR2 (100 Byte)

116 514. (AMOUNT) NUMBER (12,2)

117 515. OTHER UNPAID ITEM VARCHAR2 (100 Byte)

118 515. (AMOUNT) NUMBER (12,2)

119 516. OTHER UNPAID ITEM VARCHAR2 (100 Byte)

120 516. (AMOUNT) NUMBER (12,2)

121 517. OTHER UNPAID ITEM VARCHAR2 (100 Byte)

122 517. (AMOUNT) NUMBER (12,2)

123 518. OTHER UNPAID ITEM VARCHAR2 (100 Byte)

124 518. (AMOUNT) NUMBER (12,2)

125 519. CONDO/HOA FEE VARCHAR2 (100 Byte)

126 519. (AMOUNT) NUMBER (12,2)

420. GROSS AMOUNT DUE

TO SELLER

NUMBER (12,2)

520. TOTAL REDUCTION

AMOUNT DUE SELLER

NUMBER (12,2)

129 CASH FROM SELLERS NUMBER

130 CASH TO SELLERS NUMBER

131 603. CASH DUE TO SELLER NUMBER (12,2)

103. SETTLEMENT CHARGES TO

BORROWER (LINE 1400)

NUMBER (12,2)

502. SETTLEMENT CHARGES TO

SELLER (LINE 1400)

NUMBER (12,2)

134 SETTLEMENT DATE DATE

135 DATE RECEIVED DATE

136 DATE RECONCILED DATE

137 DATE RECORDED DATE

138 603A. SYSTEM TOTAL NUMBER (10,2)

139 603B. FEDWIRE AMOUNT NUMBER (10,2)

140 106. CITY/TOWN TAXES FROM DATE DATE

141 106. CITY/TOWN TAXES TO DATE DATE

142 106. CITY/TOWN TAXES NUMBER (12,2)

143 107. COUNTY TAXES FROM DATE DATE

144 107. COUNTY TAXES TO DATE DATE

145 107. COUNTY TAXES NUMBER (12,2)

146 108. ASSESSMENTS FROM DATE DATE

147 108. ASSESSMENTS TO DATE DATE

148 108. ASSESSMENTS NUMBER (12,2)

149 210. CITY/TOWN TAXES FROM DATE DATE

150 210. CITY/TOWN TAXES TO DATE DATE

151 210. CITY/TOWN TAXES NUMBER (12,2)

152 211. COUNTY TAXES FROM DATE DATE

153 211. COUNTY TAXES TO DATE DATE

154 211. COUNTY TAXES NUMBER (12,2)

155 212. ASSESSMENTS FROM DATE DATE

156 212. ASSESSMENTS TO DATE DATE

157 212. ASSESSMENTS NUMBER (12,2)

120. GROSS AMOUNT DUE FROM

BORROWER

NUMBER (12,2)

159 STATUS VARCHAR2 (50 Byte)

160 SETTLEMENT ACTIVE VARCHAR2 (10 Byte)

161 STATUS DATE DATE

162 MODIFIED BORROWER VARCHAR2 (250)

163 F. LENDER VARCHAR2 (100)

164 H. AGENT VARCHAR2 (100)

165 PLACING AGENT VARCHAR2 (100)

166 Not Used 167 Not Used 168 Not Used 169 Not Used 170 Not Used 171 Not Used

172 DATE CREATED DATE

173 TIME CREATED VARCHAR2 (6)

174 CREATE USER VARCHAR2 (8)

175 DATE UPDATED DATE

176 UPDATE USER NUMBER

177 Not Used 178 Primary Key NUMBER (18)

179 Pointer to Settlement NUMBER (18)

180 Pointer to Property NUMBER (18)

700. TOTAL SALES BROKER

COMMISSION BASED ON PRICE $

NUMBER (12,2)

700. TOTAL SALES BROKER

COMMISSION BASED ON PRICE @

NUMBER (10,6)

700. TOTAL SALES BROKER

COMMISSION PRICE $ * @

NUMBER (12,2)

184 701. SALES BROKER AMOUNT NUMBER (12,2)

185 701. SALES BROKER NAME VARCHAR2 (100 Byte)

186 702. (AMOUNT) NUMBER (12,2)

187 702. (FIELD CAPTION) VARCHAR2 (100 Byte)

703. COMMISSION PAID AT

SETTLEMENT FROM BORROWER’S

FUNDS

NUMBER (12,2)

703. COMMISSION PAID AT

SETTLEMENT FROM SELLER’S

FUNDS

NUMBER (12,2)

190 704. (FIELD CAPTION) VARCHAR2 (100 Byte)

704. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

704. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

193 801. LOAN ORIGINATION FEE % NUMBER (10,6)

194 801. LOAN ORIGINATION FEE TO VARCHAR2 (100 Byte)

801. LOAN ORIGINATION AMOUNT

PAID FROM BORROWER’S FUNDS

NUMBER (12,2)

801. LOAN ORIGINATION AMOUNT

PAID FROM SELLER’S FUNDS

NUMBER (12,2)

197 802. LOAN DISCOUNT % NUMBER (10,6)

198 802. LOAN DISCOUNT TO VARCHAR2 (100 Byte)

802. LOAN DISCOUNT PAID FROM

BORROWER’S FUNDS

NUMBER (12,2)

802. LOAN DISCOUNT PAID FROM

SELLER’S FUNDS

NUMBER (12,2)

201 803. (FIELD CAPTION) VARCHAR2 (100 Byte)

803. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

803. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

204 804. (FIELD CAPTION) VARCHAR2 (100 Byte)

804. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

804. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

207 805. (FIELD CAPTION) VARCHAR2 (100 Byte)

805. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

805. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

210 806. (FIELD CAPTION) VARCHAR2 (100 Byte)

806. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

806. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

213 807. (FIELD CAPTION) VARCHAR2 (100 Byte)

807. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

807. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

216 808. (FIELD CAPTION) VARCHAR2 (100 Byte)

808. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

808. (PAID FROM SELLER’S FUNDS

AMOUNT)

219 809. (FIELD CAPTION) VARCHAR2 (100 Byte)

809. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

809. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

222 810. (FIELD CAPTION) VARCHAR2 (100 Byte)

810. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

810. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

225 811. (FIELD CAPTION) VARCHAR2 (100 Byte)

811. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

811. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

228 901. INTEREST FROM DATE DATE

229 901. INTEREST TO DATE DATE

230 901. INTEREST PER DAY NUMBER (10,4)

901. INTEREST PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

901. INTEREST PAID FROM SELLER’S

FUNDS AMOUNT

NUMBER (12,2)

902. MORTGAGE INSURANCE

PREMIUM # OF MONTHS

NUMBER

902. MORTGAGE

INSURANCE PREMIUM TO

VARCHAR2 (100 Byte)

902. MORTGAGE INSURANCE

PREMIUM FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

902. MORTGAGE INSURANCE

PREMIUM FROM SELLER’S FUNDS

AMOUNT

NUMBER (12,2)

903. HAZARD INSURANCE PREMIUM

YEARS

NUMBER

903. HAZARD INSURANCE

PREMIUM TO

VARCHAR2 (100 Byte)

903. HAZARD INSURANCE

PREMIUM FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

903. HAZARD INSURANCE PREMIUM

FROM SELLER’S FUNDS AMOUNT

NUMBER (12,2)

241 904. (FIELD CAPTION) VARCHAR2 (100 Byte)

904. (PAID FROM BORROWER’S

FUNDS AMOUNT)

904. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

244 905. (FIELD CAPTION) VARCHAR2 (100 Byte)

905. (PAID FROM BORROWER’S

FUNDS AMOUNT)

NUMBER (12,2)

905. (PAID FROM SELLER’S FUNDS

AMOUNT)

NUMBER (12,2)

247 1001. HAZARD INSURANCE MONTHS NUMBER

1001. HAZARD INSURANCE

PER MONTH

NUMBER (12,2)

1001. HAZARD INSURANCE

PAID FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

1001. HAZARD INSURANCE PAID

FROM SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1002. MORTGAGE

INSURANCE MONTHS

NUMBER

1002. MORTGAGE INSURANCE PER

MONTH

NUMBER (12,2)

1002. MORTGAGE INSURANCE

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1002. MORTGAGE INSURANCE PAID

FROM SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1003. CITY PROPERTY TAXES

MONTHS

NUMBER

1003. CITY PROPERTY TAXES PER

MONTH

NUMBER (12,2)

1003. CITY PROPERTY TAXES

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1003. CITY PROPERTY TAXES PAID

FROM SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1004. COUNTY PROPERTY TAXES

MONTHS

NUMBER

1004. COUNTY PROPERTY

TAXES PER MONTH

NUMBER (12,2)

1004. COUNTY PROPERTY TAXES

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1004. COUNTY PROPERTY

TAXES PAID FROM SELLER’S

FUNDS AMOUNT

NUMBER (12,2)

1005. ANNUAL ASSESSMENTS

MONTHS

NUMBER

1005. ANNUAL ASSESSMENTS PER

MONTH

NUMBER (12,2)

1005. ANNUAL ASSESSMENTS

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1005. ANNUAL ASSESSMENTS PAID

FROM SELLER’S FUNDS AMOUNT

NUMBER (12,2)

267 1006. (FIELD CAPTION) VARCHAR2 (100 Byte)

268 1006. MONTHS NUMBER

269 1006. PER MONTH NUMBER (12,2)

1006. PAID FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

1006. PAID FROM SELLER’S FUNDS

AMOUNT

NUMBER (12,2)

272 1007. (FIELD CAPTION) VARCHAR2 (100 Byte)

273 1007. MONTHS NUMBER

274 1007. PER MONTH NUMBER (12,2)

1007. PAID FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

1007. PAID FROM SELLER’S FUNDS

AMOUNT

NUMBER (12,2)

1008. AGGREGATE ADJUSTMENT

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1008. AGGREGATE

ADJUSTMENT PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1101. SETTLEMENT OR CLOSING

FEES TO

VARCHAR2 (100 Byte)

1101. SETTLEMENT OR CLOSING

FEES PAID FROM BORROWER’S

FUNDS AMOUNT

NUMBER (12,2)

1101. SETTLEMENT OR CLOSING

FEES PAID FROM SELLER’S

FUNDS AMOUNT

NUMBER (12,2)

1102. ABSTRACT OR TITLE SEARCH

TO

VARCHAR2 (100 Byte)

1102. ABSTRACT OR TITLE SEARCH

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1102. ABSTRACT OR TITLE SEARCH

PAID FROM SELLER’S FUNDS

AMOUNT

285 1103. TITLE EXAM TO VARCHAR2 (100 Byte)

1103. TITLE EXAM PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

1103. TITLE EXAM PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

288 1104. TITLE INSURANCE BINDER TO VARCHAR2 (100 Byte)

1104. TITLE INSURANCE PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

1104. TITLE INSURANCE PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

291 1105. DOCUMENT PREPARATION TO VARCHAR2 (100 Byte)

1105. DOCUMENT PREPARATION

PAID FROM BORROWER’S FUNDS

AMOUNT

NUMBER (12,2)

1105. DOCUMENT PREPARATION

PAID FROM SELLER’S FUNDS

AMOUNT

NUMBER (12,2)

294 1106. NOTARY FEES TO VARCHAR2 (100 Byte)

1106. NOTARY FEES PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

1106. NOTARY FEES PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

297 1107. ATTORNEY FEES TO VARCHAR2 (100 Byte)

1107. ATTORNEY FEES PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

1107. ATTORNEY FEES PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1107. ATTORNEY FEES INCLUDE

ABOVE NUMBERS

VARCHAR2 (100 Byte)

301 1108. TITLE INSURANCE TO VARCHAR2 (100 Byte)

1108. TITLE INSURANCE PAID FROM

BORROWER’S FUNDS AMOUNT

NUMBER (12,2)

1108. TITLE INSURANCE PAID FROM

SELLER’S FUNDS AMOUNT

NUMBER (12,2)

1108. TITLE INSURANCE INCLUDES

ABOVE NUMBERS

VARCHAR2 (100 Byte)

305 1109. LENDER’S COVERAGE AMOUNT NUMBER (12,2)

306 1109. LENDER’S PREMIUM AMOUNT NUMBER (12,2)

307 1110. OWNER’S COVERAGE AMOUNT NUMBER (12,2)

308 1110. OWNER’S PREMIUM AMOUNT NUMBER (12,2)

309 1111. (FIELD CAPTION) VARCHAR2 (100 Byte)

1111. PAID FROM BORROWER’S

AMOUNT

311 1111. PAID FROM SELLER’S AMOUNT NUMBER (12,2)

312 1112. (FIELD CAPTION) VARCHAR2 (100 Byte)

1112. PAID FROM BORROWER’S

AMOUNT

NUMBER (12,2)

314 1112. PAID FROM SELLER’S AMOUNT NUMBER (12,2)

315 1113. (FIELD CAPTION) VARCHAR2 (100 Byte)

1113. PAID FROM BORROWER’S

AMOUNT

NUMBER (12,2)

317 1113. PAID FROM SELLER’S AMOUNT NUMBER (12,2)

318 1201. RECORDING FEES DEED NUMBER (12,2)

319 1201. RECORDING FEES MORTGAGE NUMBER (12,2)

320 1201. RECORDING FEES RELEASE NUMBER (12,2)

1201. RECORDING FEES PAID FROM

BORROWER’S AMOUNT

NUMBER (12,2)

1201. RECORDING FEES PAID FROM

SELLER’S AMOUNT

NUMBER (12,2)

1202. CITY/COUNTY TAX/ STAMPS

DEED

NUMBER (12,2)

1202. CITY/COUNTY TAX/ STAMPS

MORTGAGE

NUMBER (12,2)

1202. CITY/COUNTY TAX/ STAMPS

PAID FROM BORROWER’S AMOUNT

NUMBER (12,2)

1202. CITY/COUNTY TAX/ STAMPS

PAID FROM SELLER’S AMOUNT

NUMBER (12,2)

327 1203. STATE TAX/STAMPS DEED NUMBER (12,2)

1203. STATE TAX/STAMPS

MORTGAGE

NUMBER (12,2)

1203. STATE TAX/STAMPS PAID

FROM BORROWER’S AMOUNT

NUMBER (12,2)

1203. STATE TAX/STAMPS

PAID FROM

NUMBER (12,2)

331 1204. (FIELD CAPTION) VARCHAR2 (100 Byte)

1204. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1204. (PAID FROM SELLER’S

AMOUNT)

NUMBER (12,2)

334 1205. (FIELD CAPTION) VARCHAR2 (100 Byte)

1205. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1205. (PAID FROM SELLER’S

AMOUNT)

337 1301. (FIELD CAPTION) VARCHAR2 (100 Byte)

1301. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1301. (PAID FROM SELLER’S

AMOUNT)

NUMBER (12,2)

340 1302. (FIELD CAPTION) VARCHAR2 (100 Byte)

1302. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1302. (PAID FROM SELLER’S

AMOUNT)

NUMBER (12,2)

343 1303. (FIELD CAPTION) VARCHAR2 (100 Byte)

1303. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1303. (PAID FROM SELLER’S

AMOUNT)

NUMBER (12,2)

346 1304. PURCHASER ALLOWANCE VARCHAR2 (100 Byte)

1304. PURCHASER ALLOWANCE PAID

FROM BORROWER’S AMOUNT

NUMBER (12,2)

1304. PURCHASER ALLOWANCE PAID

FROM SELLER’S AMOUNT

NUMBER (12,2)

349 1305. (FIELD CAPTION) VARCHAR2 (100 Byte)

1305. (PAID FROM BORROWER’S

AMOUNT)

NUMBER (12,2)

1305. (PAID FROM SELLER’S

AMOUNT)

NUMBER (12,2)

1400. TOTAL SETTLEMENT CHARGES

PAID FROM BORROWER’S AMOUNT

NUMBER (12,2)

1400. TOTAL SETTLEMENT CHARGES

PAID FROM SELLER’S AMOUNT

NUMBER (12,2)

354 RECONCILE WITH TOLERANCE NUMBER (2)

355 THIRD PARTY CLOSING FEE NUMBER (2)

356 DATE CREATED DATE

357 CREATE USER NUMBER

358 DATE UPDATED DATE

359 UPDATE USER NUMBER

File details come from the government source that posted it. Updated .