MSSQL → Constellation API Normalization Audit

{
  "AccessibilityFeatures": {
    "arm": "accessibilityfeatures",
    "bar": "accessibilityfeatures",
    "brt": "accessibilityfeatures",
    "fml": "accessibilityfeatures",
    "glv": "accessibilityfeatures",
    "har": "accessibilityfeatures",
    "trd": "accessibilityfeatures"
  },
  "Appliances": {
    "arm": "appliances",
    "bar": "appliances",
    "brt": "appliances",
    "har": "appliances",
    "smt": "appliancesincluded"
  },
  "AssociationAmenities": {
    "bar": "associationamenities",
    "smt": "associationamenities"
  },
  "AssociationFee": {
    "bar": "hoafee",
    "brt": "assofee"
  },
  "AssociationFee2Frequency": {
    "brt": "assofee2frequency"
  },
  "AssociationFeeFrequency": {
    "brt": "assofeefrequency"
  },
  "AssociationFeeIncludes": {
    "arm": "associationfeeincludes",
    "mco": "associationfeeincludes",
    "mfr": "associationfeeincludes",
    "smt": "associationfeeincludes"
  },
  "AssociationName": {
    "brt": "assoname"
  },
  "AssociationName2": {
    "brt": "assoname2"
  },
  "AssociationYN": {
    "bar": "hoayn"
  },
  "AttachedGarageYN": {
    "arm": "attachedgarageyn",
    "brt": "attachedgarageyn"
  },
  "AvailabilityDate": {
    "brt": "availabilitydate"
  },
  "Basement": {
    "brt": "basement",
    "fml": "basement",
    "nnr": "basement",
    "smt": "basementdescription"
  },
  "BathroomsHalf": {
    "arm": "bathshalf",
    "bar": "bathshalf",
    "fml": "bathshalf",
    "glv": "bathshalf",
    "har": "bathshalf",
    "mco": "bathshalf",
    "mfr": "bathshalf",
    "nnr": "bathshalf",
    "smt": "bathshalf",
    "trd": "bathshalf"
  },
  "BathroomsTotalInteger": {
    "arm": "baths"
  },
  "BelowGradeFinishedArea": {
    "mco": "belowgradefinishedarea"
  },
  "BuilderModel": {
    "brt": "buildermodel"
  },
  "BuilderName": {
    "brt": "buildername"
  },
  "BuildingAreaSource": {
    "brt": "buildingareasrc"
  },
  "CarportSpaces": {
    "arm": "carportspaces",
    "bar": "carportspaces",
    "glv": "carportspaces",
    "mfr": "carportspaces"
  },
  "CoListAgentFirstName": {
    "har": "colistagentfirstname",
    "mfr": "colistagentfirstname"
  },
  "CoListAgentLastName": {
    "har": "colistagentlastname",
    "mfr": "colistagentlastname"
  },
  "CoListAgentOfficePhone": {
    "brt": "colistagentofficephone"
  },
  "CoListAgentPreferredPhone": {
    "brt": "colistagentpreferredph"
  },
  "CoListAgentURL": {
    "arm": "colistagenturl"
  },
  "CommonWalls": {
    "arm": "commonwalls"
  },
  "CommunityFeatures": {
    "arm": "communityfeatures",
    "bar": "communityfeatures",
    "fml": "communityfeatures",
    "glv": "communityfeatures",
    "har": "communityfeatures",
    "mfr": "communityfeatures"
  },
  "ConstructionMaterials": {
    "arm": "construction",
    "bar": "construction",
    "brt": "construction",
    "fml": "construction",
    "glv": "constructionmaterials",
    "nnr": "construction",
    "smt": "constructiondesc"
  },
  "Cooling": {
    "arm": "coolingdesc",
    "bar": "coolingdesc",
    "brt": "coolingdesc",
    "glv": "coolingdesc",
    "mco": "coolingdesc",
    "smt": "coolingdesc",
    "trd": "coolingdesc"
  },
  "CoolingYN": {
    "brt": "coolingyn",
    "mfr": "coolingyn"
  },
  "Country": {
    "arm": "country",
    "glv": "country"
  },
  "CountyOrParish": {
    "brt": "county",
    "fml": "county"
  },
  "CrossStreet": {
    "brt": "crossstreet"
  },
  "CumulativeDaysOnMarket": {
    "mfr": "cdom"
  },
  "CurrentFinancing": {
    "arm": "currentfinancing"
  },
  "CurrentUse": {
    "mco": "currentuse"
  },
  "DaysOnMarket": {
    "fml": "mlsdom",
    "mfr": "mlsdom"
  },
  "DevelopmentStatus": {
    "arm": "developmentstatus",
    "mfr": "developmentstatus"
  },
  "Directions": {
    "brt": "directions"
  },
  "Disclosures": {
    "glv": "disclosures"
  },
  "DocumentsCount": {
    "glv": "documentscount"
  },
  "DoorFeatures": {
    "brt": "doorfeatures"
  },
  "Electric": {
    "arm": "electric",
    "fml": "electric",
    "glv": "electric",
    "mco": "electric"
  },
  "EntryLevel": {
    "brt": "entrylevel"
  },
  "Exclusions": {
    "brt": "exclusions"
  },
  "ExteriorFeatures": {
    "arm": "exteriorfeatures",
    "bar": "exteriorfeatures",
    "brt": "exteriorfeatures",
    "glv": "exteriorfeatures",
    "har": "exteriorfeatures",
    "mfr": "exteriorfeatures",
    "nnr": "exteriorfeatures",
    "smt": "exteriorfeatures"
  },
  "Fencing": {
    "brt": "fencing",
    "mco": "fencing"
  },
  "FireplaceFeatures": {
    "arm": "fireplacedesc",
    "bar": "fireplacedesc",
    "brt": "fireplacedesc",
    "nnr": "fireplacedesc"
  },
  "FireplacesTotal": {
    "bar": "fireplaces",
    "brt": "fireplaces",
    "glv": "fireplacestotal",
    "smt": "fireplacestotal",
    "trd": "fireplacestotal"
  },
  "Flooring": {
    "brt": "floordesc",
    "glv": "flooring",
    "nnr": "floordesc"
  },
  "FoundationDetails": {
    "bar": "foundation",
    "brt": "foundationdetails",
    "nnr": "foundationdetails"
  },
  "Furnished": {
    "brt": "furnished"
  },
  "GarageSpaces": {
    "brt": "garagespace"
  },
  "GarageYN": {
    "arm": "garageyn",
    "brt": "garageyn"
  },
  "GreenEnergyEfficient": {
    "har": "greenenergyefficient"
  },
  "GreenEnergyGeneration": {
    "glv": "greenenergygeneration"
  },
  "Heating": {
    "bar": "heatingdesc",
    "brt": "heatingdesc",
    "glv": "heatingdesc",
    "smt": "heatingdesc"
  },
  "HeatingYN": {
    "mfr": "heatingyn"
  },
  "HorseAmenities": {
    "glv": "horseamenities"
  },
  "HorseYN": {
    "brt": "horseyn"
  },
  "Inclusions": {
    "brt": "inclusions"
  },
  "InteriorFeatures": {
    "arm": "interiorfeatures",
    "bar": "interiorfeatures",
    "brt": "interiorfeatures",
    "fml": "interiorfeatures",
    "glv": "interiorfeatures",
    "har": "interiorfeatures",
    "mco": "interiorfeatures",
    "mfr": "interiorfeatures",
    "nnr": "interiorfeatures",
    "smt": "interiorfeatures",
    "trd": "interiorfeatures"
  },
  "InternetAutomatedValuationDisplayYN": {
    "brt": "internetautovaldisplayyn"
  },
  "InternetConsumerCommentYN": {
    "brt": "internetconscommtyn"
  },
  "LaundryFeatures": {
    "arm": "laundryfeatures",
    "nnr": "laundryfeatures",
    "trd": "laundryfeatures"
  },
  "LeaseConsideredYN": {
    "brt": "leaseconsideredyn"
  },
  "LeaseTerm": {
    "har": "leaseterm"
  },
  "Levels": {
    "brt": "levels"
  },
  "ListAgentFirstName": {
    "har": "listagentfirstname",
    "mfr": "listagentfirstname"
  },
  "ListAgentFullName": {
    "bar": "dftlistagentname"
  },
  "ListAgentLastName": {
    "har": "listagentlastname",
    "mfr": "listagentlastname"
  },
  "ListAgentMiddleName": {
    "mfr": "listagentmiddlename"
  },
  "ListAgentPreferredPhone": {
    "brt": "listagentpreferredph",
    "mfr": "listagentpreferredphone"
  },
  "ListOfficeURL": {
    "arm": "listofficeurl",
    "fml": "listofficeurl"
  },
  "ListingAgreement": {
    "brt": "listingagreement"
  },
  "ListingService": {
    "brt": "listingservice"
  },
  "LivingArea": {
    "fml": "sqft",
    "mco": "sqft",
    "smt": "sqft"
  },
  "LivingAreaSource": {
    "brt": "livingareasource"
  },
  "LotFeatures": {
    "arm": "lotdesc",
    "bar": "lotdesc",
    "brt": "lotdesc",
    "glv": "lotfeatures",
    "har": "lotdesc",
    "mco": "lotdesc",
    "mfr": "lotfeatures",
    "smt": "lotdesc"
  },
  "LotSizeArea": {
    "arm": "lotsize",
    "mco": "lotsize"
  },
  "LotSizeSource": {
    "brt": "lotsizesource"
  },
  "LotSizeUnits": {
    "brt": "lotsizeunits"
  },
  "MainLevelBathrooms": {
    "fml": "mainlevelbaths"
  },
  "MainLevelBedrooms": {
    "brt": "mainlevelbeds",
    "fml": "mainlevelbeds",
    "mco": "mainlevelbeds"
  },
  "MajorChangeType": {
    "nnr": "majorchangetype",
    "smt": "lastchangetype"
  },
  "MlsStatus": {
    "brt": "dftstatus"
  },
  "NewConstructionYN": {
    "bar": "newconstructionyn"
  },
  "NumberOfUnitsTotal": {
    "bar": "noofunits"
  },
  "OnMarketDate": {
    "glv": "onmarketdate"
  },
  "OnMarketTimestamp": {
    "arm": "onmarkettimestamp",
    "glv": "onmarkettimestamp",
    "mfr": "onmarkettimestamp",
    "nnr": "onmarkettimestamp"
  },
  "OriginatingSystemName": {
    "arm": "originatingsystemname",
    "bar": "originatingsystemname",
    "brt": "originatingsystemname",
    "glv": "originatingsystemname",
    "har": "originatingsystemname",
    "mfr": "originatingsystemname",
    "nnr": "originatingsystemname"
  },
  "OtherEquipment": {
    "brt": "otherequipment"
  },
  "OtherStructures": {
    "arm": "otherstructures",
    "bar": "otherstructures",
    "brt": "otherstructures"
  },
  "OwnerName": {
    "smt": "ownername"
  },
  "OwnerPays": {
    "mfr": "ownerpays"
  },
  "ParcelNumber": {
    "brt": "parcelnumber"
  },
  "ParkingFeatures": {
    "arm": "parkingdesc",
    "bar": "parkingdesc",
    "brt": "parkingdesc",
    "glv": "parkingdesc",
    "mco": "parkingdesc",
    "mfr": "parkingdesc"
  },
  "ParkingTotal": {
    "arm": "noofparking",
    "brt": "noofparking"
  },
  "PatioAndPorchFeatures": {
    "arm": "patioandporchfeatures",
    "brt": "patioandporchfeatures",
    "har": "patioandporchfeatures"
  },
  "PetsAllowed": {
    "brt": "petsallowed",
    "glv": "petsallowed"
  },
  "PoolFeatures": {
    "arm": "pooldesc",
    "bar": "pooldesc",
    "brt": "pooldesc",
    "har": "pooldesc",
    "mfr": "pooldesc",
    "smt": "pooldesc"
  },
  "PoolPrivateYN": {
    "bar": "poolyn"
  },
  "Possession": {
    "brt": "possession",
    "mco": "possession"
  },
  "PropertyCondition": {
    "arm": "propertycondition",
    "bar": "propertycondition",
    "fml": "propertycondition",
    "glv": "propertycondition",
    "mfr": "propertycondition"
  },
  "PropertySubType": {
    "brt": "propertytype",
    "har": "propertytype",
    "smt": "propertytype",
    "trd": "propertytype"
  },
  "PropertyType": {
    "smt": "dftpropertytype"
  },
  "RentIncludes": {
    "arm": "rentincludes"
  },
  "RoadFrontageType": {
    "mco": "roadfrontagetype",
    "nnr": "roadfrontagetype"
  },
  "RoadResponsibility": {
    "arm": "roadresponsibility"
  },
  "RoadSurfaceType": {
    "har": "roadsurfacetype"
  },
  "Roof": {
    "brt": "roofdesc",
    "nnr": "roofdesc"
  },
  "RoomsTotal": {
    "bar": "noofrooms",
    "har": "noofrooms",
    "smt": "roomcount"
  },
  "SecurityFeatures": {
    "fml": "securityfeatures",
    "mco": "securityfeatures",
    "nnr": "securityfeatures"
  },
  "SeniorCommunityYN": {
    "arm": "seniorcommunityyn",
    "bar": "seniorcommunityyn",
    "brt": "seniorcommunityyn",
    "har": "seniorcommunityyn"
  },
  "Sewer": {
    "brt": "sewerdesc",
    "smt": "sewerdesc"
  },
  "SpaFeatures": {
    "glv": "spafeatures",
    "nnr": "spafeatures"
  },
  "SpecialListingConditions": {
    "brt": "speciallistingconditions",
    "nnr": "speciallistingconditions"
  },
  "Stories": {
    "brt": "noofstories"
  },
  "StoriesTotal": {
    "arm": "stories",
    "glv": "storiestotal",
    "mfr": "stories"
  },
  "StreetDirPrefix": {
    "smt": "streetdirectionprefix"
  },
  "StructureType": {
    "brt": "structuredesigntype"
  },
  "SubdivisionName": {
    "bar": "subdivision"
  },
  "TaxAnnualAmount": {
    "smt": "propertytax"
  },
  "Utilities": {
    "arm": "utilities",
    "bar": "utilities",
    "brt": "utilities",
    "har": "utilities",
    "mco": "utilities",
    "mfr": "utilities",
    "nnr": "utilities"
  },
  "Vegetation": {
    "mco": "vegetation"
  },
  "VideosCount": {
    "arm": "videoscount",
    "nnr": "videoscount"
  },
  "View": {
    "bar": "viewdesc",
    "brt": "viewdesc",
    "har": "viewdesc",
    "mfr": "views"
  },
  "ViewYN": {
    "brt": "viewyn"
  },
  "VirtualTourURLUnbranded": {
    "arm": "virtualtoururl",
    "brt": "virtualtourunbranded"
  },
  "WaterSource": {
    "arm": "waterdesc",
    "brt": "waterdesc",
    "har": "waterdesc",
    "smt": "waterdesc"
  },
  "WaterfrontFeatures": {
    "brt": "waterfrontfeatures",
    "har": "waterfrontfeatures",
    "mfr": "waterfrontfeatures"
  },
  "WindowFeatures": {
    "arm": "windowfeatures",
    "brt": "windowfeatures",
    "glv": "windowfeatures",
    "har": "windowfeatures",
    "mfr": "windowfeatures",
    "nnr": "windowfeatures"
  },
  "YearBuiltEffective": {
    "brt": "yearbuilteffective"
  },
  "YearBuiltSource": {
    "brt": "yearbuiltsource",
    "har": "yearbuiltsource"
  },
  "Zoning": {
    "brt": "zoning"
  }
}