Difference between revisions of "SSIS:Property:Output"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
 
Line 48: Line 48:
[[File:SSIS_PY_Output.png|link=]]
[[File:SSIS_PY_Output.png|link=]]


Check the box next to the groups or columns you want to output. The following are definitions of the available groups and columns:
Check the box next to the groups or columns you want to output. The following are definitions of the available groups and columns. For a list of codes returned by these columns, refer to [[Property Codes]].


==Parcel==
==Parcel==
Line 513: Line 513:
;FoundationCode
;FoundationCode
:The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).
:The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).
;FlooringCode
:The type of floor construction (e.g., Concrete, Plywood). Please see the “FLTYP” table on page 86 for code descriptions.
;RoofFramingCode
:The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore). Please see the “RFFRM” table on page 88 for code descriptions.
;GarageCode
:Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Please see the “GRGCD” table on page 90 for code descriptions.
;HeatingCode
:Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant). Please see the “HEAT” table on page 95 for code descriptions.
;MobileHome
:This element is populated with a “Y” if a Mobile Home is present on the parcel.
;ParkingSpaces
:This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.
;ParkingCode
:Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. Please see the “PARKG” table on page 115 for code descriptions.
;Pool
:This element is populated with a “Y” if a Pool is present on the parcel.
;PoolCode
:Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated). Please see the “POOL” table on page 122 for code descriptions.
;QualityCode
:Type of construction quality of building (e.g., excellent, economical). Please see the “QUAL” table on page 126 for code descriptions.
;RoofCoverCode
:Type of roof covering (e.g., Clay Tile, Aluminum, Shake). Please see the “RFCOV” table on page 126 for code descriptions.
;RoofTypeCode
:Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). Please see “RFSHP” table on page 129 for code descriptions.
;StoriesCode
:Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story). Please see the “STORY” table on page 132 for code descriptions.
;Stories
:Number of stories associated with the building (e.g., 2, 1.5).
;BuildingStyleCode
:Type of building style (e.g., Colonial, Cape Code, Bungalow). Please see the “STYLE” table on page 137 for code descriptions.
;Units
:Number of Residential, Apartment or Business Units.
;ElectricityCode
:Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source). Please see the “ELEC” table on page 74 for code descriptions.
;FuelCode
:Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil). Please see the “FUEL” table on page 89 for code descriptions.
;SewerCode
:Type of sewer system on the parcel (e.g., Public, Septic, Commercial). Please see the “SEWER” table on page 131 for code descriptions.
;WaterCode
:Type of water service on the parcel (e.g., Public, Well, Cistern). Please see the “WATER” table on page 141 for code descriptions.




[[Category:SSIS]]
[[Category:SSIS]]
[[Category:SSIS Property]]
[[Category:SSIS Property]]

Revision as of 21:57, 27 October 2014

← SSIS Reference

Property Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
Property Tabs
Input
Pass-Through Columns
Output
Output Filter
Result Codes
Returned Result Codes
Result Codes



SSIS PY Output.png

Check the box next to the groups or columns you want to output. The following are definitions of the available groups and columns. For a list of codes returned by these columns, refer to Property Codes.

Parcel

These fields return information used to uniquely identify the parcel of land which the property occupies

FIPSCode
Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.
FIPSSubCode
A secondary classification of a jurisdiction within a FIPS.
UnformattedAPN
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).
APNSequenceNo
This internal sequence number is used to ensure "uniqueness" of the Assessor's Parcel Number (e.g., 10132021A seq 001).
FormattedAPN
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).
OriginalAPN
Assessor's Parcel Number exactly as received by source (e.g., 10132-021A00000).
CensusTract
Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census).
Zoning
The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by FARES.
Range
The “range” portion of geographical coordinates based on local surveys. Ranges typically run east or west of predetermined “meridian” in sixmile intervals.
Township
The “township” portion of geographical coordinates based on local surveys. Townships typically run north or south of predetermined “meridian” in six-mile intervals.
Section
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.
QuarterSection
A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).
HomesteadExempt
This field will be set with a “Y” if the owner has qualified for a Homeowner/Homestead exemption.
AbsenteeOwnerCode
This field will be set with an "A" if the owner is an absentee.
LandUseCode
A FARES established Land Use code converted from various county Land Use codes to aid in search and extract functions.
CountyLandUse1
Primary (i.e., highest) Land Use as established by the county or local taxing administration.
CountyLandUse2
Secondary Land Use as established by the county or local taxing administration.
PropertyIndicatorCode
A FARES general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial).
MunicipalityName
Name of the Municipality where parcel is located.
ViewCode
View from building (e.g., Gulf, Mountains, Pool).
LocationInfluenceCode
Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport).
NumberOfBuildings
Total number of buildings on the parcel.


PropertyAddress

These fields contain the physical address of the property.

Address
The first line of the street address.e.g. 22382 Avenida Empresa
City
The city associated with the property address (CHICAGO, ATLANTA, DENVER).
State
The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (CA, VI, PR).
Zip
The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (95463-0042).
AddressKey
A unique 11-digit address key for the submitted address (92688211282).
Latitude
Geographic coordinate that specifies the northsouth position of a point on the Earth's surface (33.637550).
Longitude
Geographic coordinate that specifies the eastwest position of a point on the Earth's surface (117.606840).


ParsedPropertyAddress

These fields contain the parsed address of the physical property.

Range
The delivery number of a parsed address.
PreDirectional
The geographic directional that precedes the street name(NW, E, etc).
StreetName

The name of the street from a parsed address (Empresa, etc).

Suffix
Suffix portion of a parsed address(Avenida).
PostDirectional
Geographic directional that follows the street name.
SuiteName
The name of the secondary unit of a parsed address (Apt, Suite, etc.).
SuiteRange
Range of any secondary unit of a parsed address.


Owner

These fields contain information on the current owner of the property.

CorporateOwner
The Name of the property owner has been recognized as a corporation or business.
Name
The name of the property owner.
Name2
Additional owner names if more than one person owns the property.
UnparsedName1
Non-parsed owner name.
UnparsedName2
Additional owner names if more than one person owns the property - non-parsed.
Phone
Phone number of property owner (e.g., 9095551212).
PhoneOptOut
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 phone for solicitation.


OwnerAddress

These fields contain the ownder's mailing address.

Address
The first line of the street address.
Suite
The unit or suite number of the property address (e.g., 649 LAKE SHORE DR #1400).
City
The city associated with the property address (e.g., CHICAGO, ATLANTA, DENVER).
State
The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (e.g., CA, VI, PR).
Zip
The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (e.g., 954630042).
CarrierRoute
This is the four-digit code used by the local mail carrier to identify the delivery path.
Matchcode
Indicates the level of matching for an owner's mailing address (no matching streets, ranges, etc.)
MailOptOut
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.


Values

These fields contain data on the current value of the property.

CalculatedTotalValue
The “TOTAL” (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities.
CalculatedLandValue
The “LAND” Value closest to current market value used for assessment by county or local taxing authorities.
CalculatedImprovementValue
The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities.
CalculatedTotalValueCode
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field.
CalculatedLandValueCode
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field.
CalculatedImprovementValue
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the IMPROVEMENT VALUE CALCULATED field.
AssessedTotalValue
The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
AssessedLandValue
The Assessed Land Values as provided by the county or local taxing/assessment authority.
AssessedImprovementValue
The Assessed Improvement Values as provided by the county or local taxing/assessment authority.
MarketTotalValue
The Total Market Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
MarketLandValue
The Market Land Values as provided by the county or local taxing/assessment authority.
MarketImprovementValue
The Market Improvement Values as provided by the county or local taxing/assessment authority.
AppraisedTotalValue
The Total Appraised Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.
AppraisedLandValue
The Appraised Land Values as provided by the county or local taxing/assessment authority.
AppraisedImprovementValue
The Appraised Improvement Values as provided by the county or local taxing/assessment authority.
TaxAmount
The Total Tax amount provided by the county or local taxing/assessment authority.
TaxYear
The tax or assessment year for which the taxes were billed.


CurrentSale

These fields contain information from the most recent sale of the property.

TransactionId
This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.
DocumentYear
The year a sales transaction document was recorded (e.g., 1984).
DeedCategoryCode
The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure).
RecordingDate
The date the sales transaction was recorded at the county (e.g., 19621028).
SaleDate
The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).
SalePrice
Price of the sale as depicted on the recorded sales transaction.
SaleCode
This field indicates whether the financial consideration is F = Full or P = Partial.
SellerName
The seller's name as it appears on the recorded sales transaction.
MultiAPNCode
The data contained in this field depicts multiple or split parcel sales.
MultiAPNCount
This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).
ResidentalModel
A code to indicate whether the property is residential based on individual ZIP codes and values. “Y” = yes, “N” or blank = no.


CurrentDeed

These fields contain information about the current mortgage holder on the property.

MortgageAmount
The amount of the first mortgage as depicted on the recorded document.
MortgageDate
The date the Mortgage was initiated.
MortgageLoanTypeCode
Type of loan secured (e.g., Conventional, FHA, VA).
MortgageDeedTypeCode
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).
MortgageTermCode
This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years.
MortgageTerm
The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys).
MortgageDueDate
The date the mortgage amount becomes due.
MortgageAssumptionAmount
The assumption amount related to an existing mortgage.
LenderCode
This is a FARES internal code used to identify the Lending Company that was associated with the sales transaction.
LenderName
This is the name of the lender on the original recorded document.
SecondMortgageAmount
This is the amount associated with the 2nd mortgage.
SecondMortgageLoanTypeCode
Type of loan secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA).
SecondMortgageDeedTypeCode
Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed).


PriorSale

These fields contain information about a sale of the property prior to the most recent one.

TransactionId
This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.
DocumentYear
The year a sales transaction document was recorded (e.g., 1984).
DeedCategoryCode
The type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure).
RecordingDate
The date the sales transaction was recorded at the county (e.g., 19621028).
SaleDate
The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).
SalePrice
Price of the sale as depicted on the recorded sales transaction.
SaleCode
This field indicates whether the financial consideration is F = Full or P = Partial.
TransactionCode
This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback).
MultiAPNCode
The data contained in this field depicts multiple or split parcel sales.
MultiAPNCount
This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).
MortgageAmount
This is the amount associated with the mortgage of the prior sale.
DeedTypeCode
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).


Lot

These fields contain data on the physical dimensions of the entire property.

FrontFootage
The linear feet across the front of the lot - facing the street.
DepthFootage
The linear feet between the front and back of the lot.
Acreage
Total land mass in Acres.
SquareFootage
Total land mass in Square Feet.


SquareFootage

These fields contain physical information about the building or buildings on the property.

UniversalBuilding
The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross).
BuildingAreaCode
The codes appearing in this field indicate the source used to populate the UNIVERSAL BUILDING SQUARE FEET field (e.g., Living, Adjusted, Gross).
BuildingArea
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.
LivingSpace
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 does not include Garage, Porch or Basement square footage.
GroundFloor
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.
Gross
This is the square footage for the entire building. Typically this represents all square feet under the roof.
AdjustedGross
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.
Basement
This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas.
GarageOrParking
This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas.


Building

These fields contain information about the features of the building or buildings on the property.

YearBuilt
This is the construction year of the original building.
EffectiveYearBuilt
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.
BedRooms
Total number of Bedrooms contained in the primary building.
TotalRooms
Total number of rooms contained in the primary building.
TotalBathsCalculated
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).
TotalBaths
Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75).
FullBaths
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.
HalfBaths
Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field.
OneQuarterBaths
Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms).
ThreeQuarterBaths
Total number of Three-Quarter Baths (typically comprised of a sink, toilet & shower stall).
BathFixtures
The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures - 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head).
AirConditioningCode
The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative).
BasementCode
The type of basement found in the building (e.g., Finished, Half, Crawl).
BuildingCode
The primary building type (e.g., Bowling Alley, Supermarket).
ImprovementCode
The primary improvement type (e.g., Grain Silo, Hanger, Marina).
ConditionCode
This represents the physical condition of the main improvement (e.g., Good, Fair, Under Construction).
ConstructionCode
The primary method of construction (e.g., Steel/Glass, Concrete Block, Log).
ExteriorWallCode
The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone).
Fireplace
This field is populated with a “Y” if a fireplace is located within the building.
Fireplaces
This represents the number of fireplace openings located within the building
FireplaceCode
The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick).
FoundationCode
The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).
FlooringCode
The type of floor construction (e.g., Concrete, Plywood). Please see the “FLTYP” table on page 86 for code descriptions.
RoofFramingCode
The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore). Please see the “RFFRM” table on page 88 for code descriptions.
GarageCode
Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Please see the “GRGCD” table on page 90 for code descriptions.
HeatingCode
Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant). Please see the “HEAT” table on page 95 for code descriptions.
MobileHome
This element is populated with a “Y” if a Mobile Home is present on the parcel.
ParkingSpaces
This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.
ParkingCode
Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. Please see the “PARKG” table on page 115 for code descriptions.
Pool
This element is populated with a “Y” if a Pool is present on the parcel.
PoolCode
Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated). Please see the “POOL” table on page 122 for code descriptions.
QualityCode
Type of construction quality of building (e.g., excellent, economical). Please see the “QUAL” table on page 126 for code descriptions.
RoofCoverCode
Type of roof covering (e.g., Clay Tile, Aluminum, Shake). Please see the “RFCOV” table on page 126 for code descriptions.
RoofTypeCode
Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). Please see “RFSHP” table on page 129 for code descriptions.
StoriesCode
Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story). Please see the “STORY” table on page 132 for code descriptions.
Stories
Number of stories associated with the building (e.g., 2, 1.5).
BuildingStyleCode
Type of building style (e.g., Colonial, Cape Code, Bungalow). Please see the “STYLE” table on page 137 for code descriptions.
Units
Number of Residential, Apartment or Business Units.
ElectricityCode
Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source). Please see the “ELEC” table on page 74 for code descriptions.
FuelCode
Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil). Please see the “FUEL” table on page 89 for code descriptions.
SewerCode
Type of sewer system on the parcel (e.g., Public, Septic, Commercial). Please see the “SEWER” table on page 131 for code descriptions.
WaterCode
Type of water service on the parcel (e.g., Public, Well, Cistern). Please see the “WATER” table on page 141 for code descriptions.