Parcel Data Descriptions

Parcel Data Descriptions

#

NAME

ALIAS

TYPE

WIDTH

DEC

DEFINITION

1

FIPS CODE

FIPS_CODE

A

5

Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.

2

UNFORMATTED APN

UNFRM_APN

A

45

Assessor’s Parcel Number in an unformatted form. This is most often used by the county and others as a unique key (e.g.,10132021A)

3

APN SEQUENCE NBR

APN_SEQ_NO

999

3

This internal sequence number is used to ensure “unique-ness” of the Assessor’s Parcel Number (e.g., 10132021A seq 001)

4

FORMATTED APN

FRM_APN

A

60

Assessor’s Parcel Number in a formatted form. Dashes and decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A).

5

ORIGINAL APN

ORIG_APN

A

45

Assessor’s Parcel Number exactly as received by source (e.g., 10132-021A00000).

6

ACCOUNT NUMBER

ACCT_NO

A

15

The county or source number used primary for billing. Note: this number is typically not unique to a parcel, but rather to a tax bill (multiple parcels can be combined on 1 bill).

7

THOMAS BROS (new/old) MAP NUMB

TH_BRO_MAP

A

11

The current map page and grid number used by Thomas Bros. Maps company.

8

MAP REFERENCE 1

MAP_REF1

A

60

A CoreLogic unique key to link record to the CoreLogic CD Map product. This is typically built from components of the APN that are relevant to the Assessor Maps (e.g., 101-32, represent Map Book and Map Page numbers).

9

MAP REFERENCE 2

MAP_REF2

A

60

A secondary CoreLogic unique key to link property records to the CoreLogic CD Map product. See MAP REFERENCE 1 above.

10

CENSUS TRACT

CENSUS_TR

A

10

Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census).

11

BLOCK NUMBER

BLOCK_NBR

A

5

Subdivision or County Map Block Number

12

LOT NUMBER

LOT_NBR

A

5

Subdivision or County Map Lot Number

13

RANGE

RANGE

A

3

The “range” portion of geographical coordinates based on local surveys. Ranges typically run east or west of pre-determined “meridian” in six mile intervals.

14

TOWNSHIP

TOWNSHIP

A

3

The “township” portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined “meridian” in six mile intervals.

15

SECTION

SECTION

A

3

The “section” portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township.

16

QUARTER SECTION

QRT_SECT

A

3

A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).

17

LAND USE

LAND_USE

A

10

A CoreLogic established Land Use code converted from various county Land Use codes to aid in search and extract functions. See “LUSE” Table for descriptions

18

MOBILE HOME INDICATOR

M_HOME_IND

A

1

This field is populated with a “Y” if a Mobile Home is present on the parcel.

19

ZONING

ZONING

A

15

The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by CoreLogic

20

PROPERTY INDICATOR

PROP_IND

A

3

A CoreLogic general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial). See “PROPIND” Table for descriptions

21

SUBDIVISION TRACT NUMBER

SUB_TR_NUM

A

10

The unique number assigned to a specific subdivision by the county. Often this is used in lieu of an actual subdivision name.

22

SUBDIVISION PLAT BOOK

SUB_PLT_BK

A

10

The first component of a recording system used by some counties to catalog subdivision / condo plans (e.g., Book 123 Page 55A).

23

SUBDIVISION PLAT PAGE

SUB_PLT_PG

A

10

The second component of a recording system used by some counties to catalog subdivision / condo plans (e.g., Book 123 Page 55A).

24

SUBDIVISION NAME

SUB_NAME

A

60

The name of the Subdivision or Condominium where the parcel is located (e.g., Highland Mills Estates, Crystal Towers Condo).

25

OWNER CORPORATE INDICATOR

OWN_CP_IND

A

1

The Name of the property owner has been recognized as a corporation or business. See “CORPIND” Table for descriptions

26

OWNER 1 LAST NAME

OWN1_LAST

A

60

The name of the property owner.

27

OWNER 1 FIRST NAME & M I

OWN1_FIRST

A

45

Additional owner names if more than one person owns the property.

28

OWNER 2 LAST NAME

OWN2_LAST

A

60

Non parsed owner name.

29

OWNER 2 FIRST NAME & M I

OWN2_FIRST

A

45

Additional owner names if more than one person owns the property – non parsed.

30

MAIL HOUSE NUMBER PREFIX

MAIL_NBRPX

A

5

The digits found to the left of a traditional house number (e.g., A123 MAIN ST) portion of a mailing address.

31

MAIL HOUSE NUMBER

MAIL_NBR

A

10

The digits found to the immediate right of the Mail House Number Prefix and to the left of a traditional street name (e.g., A123 MAIN ST).

32

MAIL HOUSE NUMBER #2

MAIL_NBR2

A

10

The digits found to the immediate right of the Mail House Number in rare circumstances such as 123-125 MAIN ST

33

MAIL HOUSE NUMBER SUFFIX

MAIL_NBRSX

A

10

The digits found to the right of a traditional house number often representing a multiple or range of entries to a building (e.g., 202B JONES RD, 202-220 JONES RD).

34

MAIL DIRECTION

MAIL_DIR

A

2

This field represents the direction found to the left of the street name (e.g., 9340 N DUNHILL DR / 340 NW 70TH AVE). AKA Directional Abbreviations, Pre-Directional.

35

MAIL STREET NAME

MAIL_STR

A

30

The name or number of the street where a parcel is located (e.g., 9340 N DUNHILL DR / 340 NW 70TH AVE / RR BOX 202, 12 BOX CREEK RD).

36

MAIL MODE

MAIL_MODE

A

5

The Mode or Type of street found to the right of the street name (e.g.., 9340 N DUNHILL DR). AKA Street Designators / Street Suffixes.

37

MAIL QUADRANT

MAIL_QDRT

A

2

The quadrant field is found to the right of Mail Mode (e.g., 100 TEMPLE ST NW, 2040 NW 100 ST SW). AKA Post-Directional.

38

MAIL UNIT NUMBER

MAIL_UNIT

A

10

The unit or suite number of the mailing address (e.g., 649 LAKE SHORE DR #1400).

39

MAIL CITY

MAIL_CITY

A

40

The city associated with the mailing address (e.g., CHICAGO, ATLANTA, DENVER).

40

MAIL STATE

MAIL_STATE

A

2

The two-letter USPS postal abbreviation associated with the state / protectorants / commonwealth (e.g., CA, VI, PR).

41

MAIL ZIP CODE

MAIL_ZIP

A

9

The nine digit (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and non-proprietary processes (e.g., 954630042).

42

MAIL CARRIER CODE

MAIL_CC

A

4

This is the four digit code used by the local mail carrier to identify the delivery path.

43

MAILING OPT-OUT CODE

MAIL_OPT

A

1

A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by mail for solicitation. Please see “MAILOPTIND” table for code descriptions.

44

TOTAL VALUE CALCULATED

TOT_VAL

99999999999

11

The “TOTAL” (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities.

45

LAND VALUE CALCULATED

LAN_VAL

99999999999

11

The “LAND” Value closest to current market value used for assessment by county or local taxing authorities.

46

IMPROVEMENT VALUE CALCULATED

IMP_VAL

99999999999

11

The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities.

47

TOTAL VALUE CALCULATED IND

TOT_VAL_CD

A

1

The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field. Please see “VALTY” table for code descriptions.

48

LAND VALUE CALCULATED IND

LAN_VAL_CD

A

1

The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field. Please see “VALTY” table for code descriptions.

49

ASSD TOTAL VALUE

ASSD_VAL

99999999999

11

The Total Assessed Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

50

ASSD LAND VALUE

ASSD_LAN

99999999999

11

The Assessed Land Values as provided by the county or local taxing/assessment authority.

51

ASSD IMPROVEMENT VALUE

ASSD_IMP

99999999999

11

The Assessed Improvement Values as provided by the county or local taxing/assessment authority.

52

MKT TOTAL VALUE

MKT_VAL

99999999999

11

The Total Market Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

53

MKT LAND VALUE

MKT_LAN

99999999999

11

The Market Land Values as provided by the county or local taxing/assessment authority.

54

MKT IMPROVEMENT VALUE

MKT_IMP

99999999999

11

The Market Improvement Values as provided by the county or local taxing/assessment authority.

55

APPR TOTAL VALUE

APPR_VAL

99999999999

11

The Total Appraised Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

56

APPR LAND VALUE

APPR_LAN

99999999999

11

The Appraised Land Values as provided by the county or local taxing/assessment authority.

57

APPR IMPROVEMENT VALUE

APPR_IMP

99999999999

11

The Appraised Improvement Values as provided by the county or local taxing/assessment authority.

58

TAX AMOUNT

TAX_AMT

99999999999.99

13

2

The Total Tax amount provided by the county or local taxing/assessment authority.

59

TAX YEAR

TAX_YR

YYYY

4

The tax year for which the taxes were billed.

60

ASSESSED YEAR

ASSD_YR

YYYY

4

The assessment year for which the taxes were billed.

61

TAX CODE AREA

TAX_AREA

A

10

This is a county specific code that represent the tax entity(s) for which a parcel is taxed (e.g., Park Hosp Dist, Hall Sch Dist,).

62

DOCUMENT NO

DOC_NBR

A

12

The document number used by some counties to record sales transactions (e.g., 000012345678).

63

BOOK & PAGE

SALE_BK_PG

A

12

The Book and Page number used by some counties to catalog their sales recordings (e.g., 001234005678).

64

DOCUMENT TYPE

DOC_TYP

A

6

The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure). Please see “DEEDC” table for code descriptions.

65

RECORDING DATE

REC_DT

YYYYMMDD

8

The date the sales transaction was recorded at the county (e.g., 19621028)

66

SALE DATE

SALE_DT

YYYYMMDD

8

The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).

67

SALE PRICE

SALE_PRICE

99999999999.99

13

2

Price of the sale as depicted on the recorded sales transaction.

68

SALE CODE

SALE_TYP

A

4

This field indicates what the financial consideration is.
Please see “SALECD” table for code descriptions

69

SELLER NAME

SELL_NAME

A

60

The seller’s name as it appears on the recorded sales transaction.

70

TRANSACTION TYPE

TRAN_TYPE

A

3

This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback). Please see “TRNTP” table for code descriptions.

71

TITLE COMPANY CODE

TITL_CO_CD

A

5

This is a CoreLogic internal code used to identify the Title Company that was associated with the sales transaction.

72

TITLE COMPANY NAME

TITL_CO_NM

A

60

This is the Title Company associated with the sales transaction

73

RESIDENTIAL MODEL INDICATOR

RES_MOD_CD

A

1

A code to indicate whether the property is residential based on individual zipcodes and values. “Y” = yes, “N” or blank = no

74

1st MORTAGE AMOUNT

MTG_AMT

99999999999.99

13

2

The amount of the first mortgage as depicted on the recorded document.

75

MORTGAGE DATE

MTG_DT

YYYYMMDD

8

The date the mortgage was initiated.

76

MORTGAGE LOAN TYPE CODE

MTG_LOAN

A

5

Type of loan secured (e.g., Conventional, FHA, VA). Please see “MTGTP” table for code descriptions.

77

MORTGAGE DEED TYPE

MTG_DEED

A

6

Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed). Please see “DETDOCTYP” descriptions.

78

MORTGAGE TERM CODE

MTG_TRM_CD

A

4

This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years. Please see “MTGTC” table for code descriptions.

79

MORTGAGE TERM

MTG_TRM

99999

5

The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys).

80

MORTGAGE DUE DATE

MTG_DUE_DT

YYYYMMDD

8

The date the mortgage amount becomes due.

81

MORTGAGE ASSUMPTION AMOUNT

MTG_ASSUM

99999999999

11

The assumption amount related to an existing mortgage.

82

LENDER CODE

MTG_LEN_CD

A

10

This is a CoreLogic internal code used to identify the Lending Company that was associated with the sales transaction.

83

LENDER NAME

MTG_LEN_NM

A

60

This is the name of the lender on the original recorded document.

84

2nd MORGAGE AMOUNT

MTG2_AMT

99999999999.99

13

2

This is the amount associated with the 2nd mortgage.

85

2nd MORTGAGE LOAN TYPE CODE

MTG2_LOAN

A

5

Type of loan secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA). Please see “MTGTP” table for code descriptions

86

2nd DEED TYPE

MTG2_DEED

A

6

Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed). Please see “DETDOCTYP” table for code descriptions

87

FRONT FOOTAGE

FRONT_FT

9999999.9999

11

4

The linear feet across the front of the lot – facing the street.

88

DEPTH FOOTAGE

DEPTH_FT

9999999.9999

11

4

The linear feet between the front and back of the lot.

89

ACRES

LAND_ACRES

999999999.9999

13

4

Total land mass in Acres.

90

LAND SQUARE FOOTAGE

LAND_SQ_FT

999999999

9

Total land mass is Square Feet.

91

LOT AREA (ALPHA)

LOT_AREA

A

20

A textual description of the lot area, which may include size and unique attributes of the lot (e.g., irregular lot size).

92

UNIVERSAL BUILDING SQUARE FEET

UBLD_SQ_FT

999999999

9

The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross).

93

BUILDING SQUARE FEET IND

BLD_SQ_IND

A

1

The codes appearing in this field indicates the source used to populate the UNIVERSAL BUILDING SQUARE FEET field (e.g., Living, Adjusted, Gross). Please see “BLDSF” table for code descriptions.

94

BUILDING SQUARE FEET

BLD_SQ_FT

999999999

9

The size of the building in Square Feet. This field is most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.

95

LIVING SQUARE FEET

LIV_SQ_FT

9999999.99

9

2

This is the area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and generally does not include Garage, Porch or Unfinished Basement Square Footage values.

96

GROUND FLOOR SQUARE FEET

GF_SQ_FT

9999999.99

9

2

Square footage of the part of the building which is level with the ground (typically the front of the building). This is generally above the basement(s) and below the second floor.

97

GROSS SQUARE FEET

GR_SQ_FT

9999999.99

9

2

This is the square footage for the entire building. Typically this represents all square feet under the roof.

98

ADJUSTED GROSS SQUARE FEET

ADJ_SQ_FT

9999999.99

9

2

This is the square footage used by the county or local taxing / assessment authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.

99

BASEMENT SQUARE FEET

BSMT_SQ_FT

9999999.99

9

2

This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas.

100

GARAGE/PARKING SQUARE FEET

PKG_SQ_FT

9999999.99

9

2

This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas.

101

YEAR BUILT

YR_BLT

YYYY

4

This is the construction year of the original building.

102

EFFECTIVE YEAR BUILT

EFF_YR_BLT

YYYY

4

This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974. The Year Built would be 1960 and the Effective Year Built would be 1974.

103

BEDROOMS

BEDROOMS

99999

5

Total number of bedroom contained in the primary building.

104

TOTAL ROOMS

ROOMS

99999

5

Total number of rooms contained in the primary building.

105

TOTAL BATHS CALCULATED

BATHS_CAL

99999.99

7

2

Total number of Bathrooms in whole numbers (e.g., a home containing 2 1/2 baths would have the number 3 stored in this field as, three actual rooms have been designated for this purpose).

106

TOTAL BATHS

BATHS

99999.99

7

2

Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75).

107

FULL BATHS

FULL_BATHS

99999

5

Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field.

108

HALF BATHS

HALF_BATHS

99999

5

Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 2 stored in this field.

109

1QTR BATHS

QTR1_BATHS

99999

5

Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms).

110

3QTR BATHS

QTR3_BATHS

99999

5

Total number of 3 Quarter Baths (typically comprised of a sink, toilet & shower stall).

111

BATH FIXTURES

BATH_FIX

99999

5

The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures – 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head).

112

AIR CONDITIONING

AIR_COND

A

3

The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative). Please see “ANCHO” table for code descriptions.

113

BASEMENT FINISH

BSMT_FNSH

A

3

The type of basement found in the building (e.g., Finished, Half, Crawl). Please see “BSMTF” table for code descriptions.

114

BLDG CODE

BLD_CODE

A

3

The primary building type (e.g., Bowling Alley, Supermarket). Please see “BISCO” table for code descriptions.

115

BLDG IMPV CODE

BLD_IMP_CD

A

3

The primary improvement type (e.g., Grain Silo, Hanger, Marina). Please see “BISCO” table for code descriptions.

116

CONDITION

CONDITION

A

3

This represent the physical condition of the mail improvement (e.g., Good, Fair, Under Construction). Please see “COND” table for code descriptions.

117

CONSTRUCTION TYPE

CONSTR_TYP

A

3

The primary method of construction (e.g., Steel / Glass, Concrete Block, Log). Please see “CNSTR” table for code descriptions.

118

EXTERIOR WALLS

EXT_WALLS

A

3

The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone). Please see “EXTNW” table for code descriptions.

119

FIREPLACE IND

FRPLCE_IND

A

1

This field is populated with a “Y” if a fireplace is located within the building.

120

FIREPLACE NUMBER

FRPLCE_NBR

999

3

This represent the number of fireplace openings located within the building

121

FIREPLACE TYPE

FRPLCE_TYP

A

3

The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick). Please see “FIREP” table for code descriptions.

122

FOUNDATION

FOUNDATION

A

3

The type of foundation (e.g., Continuous Footing, Pier, Mud Sill). Please see “FOUND” table for code descriptions.

123

FLOOR

FLOOR

A

3

The type of floor construction (e.g., Concrete, Plywood). Please see “FLRCO” table for code descriptions.

124

FRAME

FRAME

A

3

The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore). Please see “RFCO” table for code descriptions.

125

GARAGE

GARAGE

A

3

Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Please see “GNPCO” table for code descriptions.

126

HEATING

HEATING

A

3

Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant). Please see “ANHCO” table for code descriptions.

127

PARKING SPACES

PKG_SPACES

99999

5

This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.

128

PARKING TYPE

PKG_TYP

A

3

Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. Please see “GNPCO” table for code descriptions.

129

POOL

POOL

A

1

This field is populated with a “Y” if a Pool is present on the parcel

130

POOL CODE

POOL_CD

A

3

Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated). Please see “POOL” table for code descriptions.

131

QUALITY

QUALITY

A

3

Type of construction quality of building (e.g., excellent, economical). Please see “QUAL” table for code descriptions.

132

ROOF COVER

ROOF_COVER

A

3

Type of roof covering (e.g., Clay Tile, Aluminum, Shake). Please see “RFCO” table for code descriptions.

133

ROOF TYPE

ROOF_TYP

A

3

Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). Please see “RFCO” table for code descriptions.

134

STORIES CODE

STORY_CD

A

3

Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story). Please see “STORY” table for code descriptions.

135

STORIES NUMBER

STORY_NBR

999.99

5

2

Number of stories associated with the building (e.g., 2, 1.5).

136

VIEW

BLD_VIEW

A

3

View from building (e.g., Gulf, Mountains, Pool). Please see “LIVS” table for code descriptions.

137

LOCATION INFLUENCE

LOC_INF

A

3

Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport). Please see “LIVS” table for code descriptions.

138

NUMBER OF UNITS

BLD_UNITS

999

3

Total number of buildings on the parcel.

139

UNITS NUMBER

UNITS_NBR

99999

5

Number of Residential, Apartment or Business Units.

140

ELECTRIC/ENERGY

ENERGY_USE

A

3

Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source). Please see “ELEC” table for code descriptions. See also “UTIL” table

141

FUEL

FUEL

A

3

Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil). Please see “FUEL” table for code descriptions. See also “UTIL” table

142

SEWER

SEWER

A

3

Type of sewer system on the parcel (e.g., Public, Septic, Commercial). Please see “SEWER” table for code descriptions. See also “UTIL” table

143

WATER

WATER

A

3

Type of water service on the parcel (e.g., Public, Well, Cistern). Please see “WATER” table for code descriptions. See also “UTIL” table

144

LEGAL

LEGAL1

A

250

First 250 bytes of the total 750 byte legal description.

145

LEGAL

LEGAL2

A

250

Second 250 bytes of the total 750 byte legal description.

146

LEGAL

LEGAL3

A

250

Third 250 bytes of the total 750 byte legal description.