Prop. Valuation (Shared Acc.)

    API Details

    Property Value
    Endpoint /tablesHousing/propValuationSharedAccs
    Table name Prop. Valuation (Shared Acc.)
    Table id 11024109
    Table caption Prop. Valuation (Shared Acc.)
    Data per company True
    Group Housing

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    eenheidnr Realty Object No. Code 20 * OGE
    volgnummer Entry No. Integer 4 *
    totaalPuntenAfgerond Total Points Rounded Integer 4
    eigenVerwarmdeVertrekken (Own) Heated Rooms Decimal 12
    eigenThermostregelknoppen (Own) Thermostat Control Buttons Boolean 4
    eigenGasaansluiting (Own) Gas Connection Boolean 4
    douchebad Shower/Bath Option 4 Geen, Eigen, Gemeensch
    wastafel Washbasin Option 4 Geen, Eigen, Gemeensch
    toilet Toilet Option 4 Geen, Eigen, Gemeensch
    keuken Kitchen Option 4 Geen, Apart, NietMinder25, Minder25, InGemVertrek, Gemeensch, GemeenschMeerDan5, KookgelegenheidGeenKeuken
    buitenruimte Outdoor Space Option 4 Geen, EigNietMeer10, EigMeer10, GemNietMeer10, GemMeer10
    fietsenberging Bicycle Storage Option 4 Geen, Eigen, Gemeensch, Gemeensch (< 2m2 per eenheid)
    gemVerblijfsruimtes (Shared) Occupied Space(s) Decimal 12
    gemPerkamers (Shared) Per ##rooms Integer 4
    aftrekVerdieping4 Floor +4 Without Elevator (factor -5) Boolean 4
    aftrekVloeropp10 Total Floor Surface of Living and Sleeping Room Less Than 10m2 (factor -10) Boolean 4
    aftrekIndirectBereikbaar Toilet Only Reachable Via Living/Sleeping Room of Other Occupant (factor -10) Boolean 4
    aftrekRamen075 Surface of Windows in Main Room Less Than 0,75m2 (factor -10) Boolean 4
    aftrekRaamHoger16 Lowest Window Frame in Main Room More Than 1,6m Above Floor (factor -10) Boolean 4
    aftrekGevel5 Wall at Less Than 5m From Biggest Window in Main Room (factor -10) Boolean 4
    aftrekOverlast Severe Nuisance from Housing Environment (factor -15) Boolean 4
    aftrekNietKoken Not Allowed to Prepare Warm Meals (factor -20) Boolean 4
    automatischBerekenenTotaal Automatically Calculate Total Boolean 4
    jaar Year Integer 4
    ingangsdatum Ingangsdatum Date 4 *
    einddatum Ending Date Date 4
    totaalPunten Total Points Decimal 12
    totaalVertrekken Total Chambers Decimal 12
    totaalPuntenZonderAftrek Total Points Without Deduction Decimal 12
    lastDateModified Last Date Modified Date 4
    changedBy Changed By Code 50
    totalSurface Total Surface Decimal 12
    nationalMonument National Monument Boolean 4
    open Open Boolean 4
    maximumRentPrice Maximum Rent Price Decimal 12
    protectedCityOrVillageView Protected City or Village View Boolean 4
    maximumRentPriceRaisePerc Maximum Rent Price Raise Percentage Decimal 12
    maximumRentPriceExclRaise Maximum Rent Price excl. Raise Decimal 12
    totalPointsProtectedMonument Total Points Protected Monument Decimal 12
    totalPointsSurfaceArea Total Points Surface Independent Living Space Decimal 12
    totalPointsHeatingFacilities Total Points Heating Facilities Decimal 12
    totalPointsCookingFacilities Total Points Cooking Facilities Decimal 12
    totalPointsToilet Total Points Toilet Decimal 12
    totalPointsWashingFacility Total Points Washing Facility Decimal 12
    totalPointsQualityFactors Total Points Quality Factors Decimal 12
    neededInvestmentMade Needed Investment Made Boolean 4
    constructionYear Construction Year Integer 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8