Att_E_-_HousingData.pdf

ATTACHMENT E SURVEY DATA ELEMENTS

ATTACHMENT E

HOUSING DATA ELEMENTS TO BE ENTERED INTO IQMIS

HOUSES / APARTMENTS / MOBILE HOMES / PADS

Column Field Description Type Size Comments

1 SurveyRegion Survey Region Text 2

Choice: AK, AN, AS, CB, CL, CU, GU, HI, IM, MS, NC, NE, NM, OW, PL, SE;

Reqd

2 SurveyYear Year Surveyed Number 4 YYYY; Reqd

3 CompSequence Comparable Number; Survey I.D.

Number, as specified in Contract Text 4 e.g. DEAA, DEAB, DEAC. This is not unique among all comparables; it is unique only to the survey region and survey year; Reqd

4 RentClass Rent Class Text 10 Choice: HOUSE, APT, MOBILE, PAD;

Reqd

5 Plex Duplex, Triplex, Four-Plex Text 1 Choice: Y, N; Not reqd for PAD

6 RealtyTrailerPark Realty Company or Trailer Park Name Text 100 Reqd for PAD

7 AgentName Owner/Agent Name Text 100 Reqd 8 AgentPhone Agent Phone Text 20 9 AgentAddress Agent Address Text 150 10 AgentCity Agent City Text 50 11 AgentState Agent State Text 2 12 AgentZip Agent Zip Code Text 10 13 AgentType Agent Type Text 10 Choice: OWNER, AGENT, TENANT

14 Contractor Contractor's Representative in the Field Text 100

15 DateCollected Date Comparable Collected Date MM/DD/YYYY 16 ContractRent Monthly Contract Rent, Rounded Number Reqd 17 CommCode Community Code Text 6 Reqd 18 CompAddress Comparable Address Text 150 Reqd 19 CompCity Comparable City Text 50 Reqd 20 CompState Comparable State Text 2 Reqd 21 CompZip Comparable Zip Code Text 10 Reqd

22 Latitude Latitude in decimal degrees (e.g.

39.7434) Number Default=0; Decimal Degrees

23 Longitude Longitude in decimal degrees (e.g. - 104.9110) Number Default=0; Decimal Degrees

24 YearBuilt Year Comparable Constructed OR Year PAD Trailer Park constructed Number 4 YYYY; Reqd

25 Interior Interior Condition Text 10 Choice: EXCEL, GOOD, FAIR, POOR;

Not reqd for PAD

26 Exterior Exterior Condition Text 10 Choice: EXCEL, GOOD, FAIR, POOR;

Not reqd for PAD

27 FinishedBsmtSF Finished Basement Sq Ft Number Default=0; Not Reqd for PAD

28 FirstSF Finished First Floor Sq Ft or PAD Site Sq Ft Number Default=0;

29 OtherSF Finished Other Floors Sq Ft Number Default=0; Not Reqd for PAD 30 UnfinishedBsmtSF Unfinished Basement Sq Ft Number Default=0; Not Reqd for PAD 31 Rooms Number of Rooms Number Default=0; Not Reqd for PAD 32 Bedrooms Number of Bedrooms Number Default=0; Not Reqd for PAD

33 Bathrooms Number of Bathrooms (e.g. 1.5 or 1.75) Number Default=0; Not Reqd for PAD

34 GarageCarport Type of Garage or Carport Text 15

Choice: TWO_CAR_GARAGE, ONE_CAR_GARAGE, CARPORT, NONE; Not reqd for PAD

35 Electric Electricity provided by Landlord;

included in Rent Text 1 Choice: Y, N

36 Sewer Sewer provided by Landlord;

included in Rent Text 1 Choice: Y,N

37 Water Water provided by Landlord;

included in Rent Text 1 Choice: Y,N

38 Trash Trash Removal provided by Landlord; included in Rent Text 1 Choice: Y,N

39 Heat Heat provided by Landlord; included in Rent Text 1 Choice: Y,N

40 HeatFuel Primary Fuel type used by Heating system Text 15

Choice: NATURAL_GAS, PROPANE, FUEL_OIL, ELEC_RESIST, ELEC_HEAT_PUMP, COAL, WOOD, SOLAR, NONE; Not Reqd for PAD

41 Cable Television service provided by Landlord; included in Rent Text 10 Choice: CABLE, SATELLITE, NONE

42 CentralCool Central Cooling system type Text 10 Choice: EVAP, REFRIG, BOTH, NONE; Not reqd for PAD

43 Fireplace Working Fireplace available? Text 1 Choice: Y,N; Not reqd for PAD 44 Stove Free-Standing Stove available? Text 1 Choice: Y,N; Not reqd for PAD

45 Firewood Firewood provided by Landlord;

included in Rent Text 1 Choice: Y,N; Not reqd for PAD

46 FurnishRooms Furnished Rooms provided by Landlord; included in Rent Text 1 Choice: Y,N; Not reqd for PAD

47 LawnCare Lawn Care provided by Landlord;

included in Rent Text 1 Choice: Y,N

48 SnowRemoval Snow Removal provided by Landlord; included in Rent Text 1 Choice: Y,N

49 Dishwasher Number of Dishwashers provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

50 Dryer Number of Clothes Dryers provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

51 Freezer Number of Freezers provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

52 Microwave Number of Microwaves provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

53 Range

Number of Ranges/Cooktops provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

54 Refrigerator Number of Refrigerators provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

55 TrashCompactor

Number of Trash Compactors provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

56 Washer

Number of Clothes Washers provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

57 WindowEvap

Number of Window-mounted Evaporative Coolers provided by Landlord; included in Rent Number Default=0; Not Reqd for PAD

58 WindowRefrig

Number of Window-mounted Air Conditioners provided by Landlord;

included in Rent Number Default=0; Not Reqd for PAD l f h f l l