Att_E_HousingData.pdf

Attachment E - Data Elements to be Entered into iQMIS

# Field Description Type Size Comments

1 SurveyRegion Survey Region Text 2 Reqd Choice: AK, AN, AS, CB, CL, CU, GU, HI, IM, MS, NC, NE, NM, OW, PL, SE

2 SurveyYear Year Surveyed Number 4 Reqd YYYY 3 RecordNumber Record Number Reqd Sequential number, e.g., 1, 2, 3…

4 CompSequence Comparable Number; Survey I.D.

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

5 RentClass Rent Class Text 10 Reqd Choice: HOUSE, APT, MOBILE, PAD 6 Plex Duplex, Triplex, Four-Plex Text 1 Not Reqd for PAD Choice: Y, N

7 RealtyTrailerPark Realty Company or Trailer Park Name Text 100 Reqd for PAD 8 AgentName Owner/Agent Name Text 100 Reqd 9 AgentPhone Agent Phone Text 20 Optional 10 AgentAddress Agent Address Text 150 Optional 11 AgentCity Agent City Text 50 Optional 12 AgentState Agent State Text 2 Optional 13 AgentZip Agent Zip Code Text 10 Optional 14 AgentType Agent Type Text 10 Optional Choice: OWNER, AGENT, TENANT

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

23 Latitude Latitude in decimal degrees (e.g.

39.7434) Number Optional Default=0; Decimal Degrees

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

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

26 Interior Interior Condition Text 10 Not Reqd for PAD Choice: EXCEL, GOOD, FAIR, POOR 27 Exterior Exterior Condition Text 10 Not Reqd for PAD Choice: EXCEL, GOOD, FAIR, POOR 28 FinishedBsmtSF Finished Basement Sq Ft Number Not Reqd for PAD Default=0

29 FirstSF Finished First Floor Sq Ft or PAD Site Sq Ft Number Reqd Default=0

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

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

35 GarageCarport Type of Garage or Carport Text 15 Not Reqd for PAD Choice: TWO_CAR_GARAGE, ONE_CAR_GARAGE, CARPORT, NONE

36 Electric Electricity provided by Landlord;

included in Rent Text 1 Choice: Y, N

37 Sewer Sewer provided by Landlord; included in Rent Text 1 Choice: Y, N

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

Attachment E - Data Elements to be Entered into iQMIS

# Field Description Type Size Comments

39 Trash Trash Removal provided by Landlord;

included in Rent Text 1 Choice: Y, N

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

41 HeatFuel Primary Fuel type used by Heating system Text 15 Not Reqd for PAD

Choice: NATURAL_GAS, PROPANE, FUEL_OIL, ELEC_RESIST, ELEC_HEAT_PUMP, COAL, WOOD, SOLAR, NONE

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

43 CentralCool Central Cooling system type Text 10 Not Reqd for PAD Choice: EVAP, REFRIG, BOTH, NONE 44 Fireplace Working Fireplace available? Text 1 Not Reqd for PAD Choice: Y, N 45 Stove Free-Standing Stove available? Text 1 Not Reqd for PAD Choice: Y, N

46 Firewood Firewood provided by Landlord;

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

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

48 LawnCare Lawn Care provided by Landlord;

included in Rent Text 1 Choice: Y, N

49 SnowRemoval Snow Removal provided by Landlord;

included in Rent Text 1 Choice: Y, N

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

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

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

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

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

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

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

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

58 WindowEvap

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

59 WindowRefrig

Number of Window-mounted Air Conditioners provided by Landlord;

included in Rent Number Not Reqd for PAD Default=0

HouseAptMobile