Table PHYSICAL_OBJECT

DescriptionREPLACED Physical Object with Road vehicle

A conveyance for transporting people, goods and so on, by road.

Columns
PHYSICAL_OBJECT_IDPHYSICAL_OBJECT_ID
ACQUISITION_COSTACQUISITION_COST
ACQUISITION_DATEACQUISITION_DATE
ANCHOR_IDANCHOR_ID
ANNUAL_MILEAGEANNUAL_MILEAGE
CYLINDERSCYLINDERS
DESCRIPTIONDESCRIPTION
DISPLACEMENT_SIZEDISPLACEMENT_SIZE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
ENGINE_CAPACITYENGINE_CAPACITY
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
HORSEPOWERHORSEPOWER
MAKEMAKE
MANUFACTURED_DATEMANUFACTURED_DATE
MODELMODEL
MODEL_IDENTIFICATION_NUMBERMODEL_IDENTIFICATION_NUMBER
MODEL_YEARMODEL_YEAR
NAMENAME
PASSENGER_CAPACITYPASSENGER_CAPACITY
REGISTRATION_NUMBERREGISTRATION_NUMBER
ROAD_VEHICLE_MINI_DIMENSION_IDROAD_VEHICLE_MINI_DIMENSION_ID
SERIAL_NUMBERSERIAL_NUMBER
SIZESIZE
SOUND_EQUIPMENT_MAKESOUND_EQUIPMENT_MAKE
SOUND_EQUIPMENT_VALUESOUND_EQUIPMENT_VALUE
START_DATESTART_DATE
STATED_VALUESTATED_VALUE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
VALUEVALUE
VALUE_NEWVALUE_NEW
BASEMENT_AREABASEMENT_AREA
CONSTRUCTION_DATECONSTRUCTION_DATE
GRADE_FLOOR_AREAGRADE_FLOOR_AREA
HYDRANT_DISTANCEHYDRANT_DISTANCE
NUMBER_OF_BATHROOMSNUMBER_OF_BATHROOMS
NUMBER_OF_BEDROOMSNUMBER_OF_BEDROOMS
NUMBER_OF_ELEVATORSNUMBER_OF_ELEVATORS
NUMBER_OF_FLOORSNUMBER_OF_FLOORS
NUMBER_OF_HABITABLE_UNITSNUMBER_OF_HABITABLE_UNITS
NUMBER_OF_ROOMSNUMBER_OF_ROOMS
OCCUPIED_AREAOCCUPIED_AREA
PARKING_LOT_AREAPARKING_LOT_AREA
PERCENTAGE_OF_BUILDING_SPRINKLEREDPERCENTAGE_OF_BUILDING_SPRINKLERED
PERSON_CAPACITYPERSON_CAPACITY
VEHICLE_CAPACITYVEHICLE_CAPACITY
YEAR_AIR_CONDITIONING_UPGRADEDYEAR_AIR_CONDITIONING_UPGRADED
YEAR_ELECTRIC_UPGRADEDYEAR_ELECTRIC_UPGRADED
YEAR_HEATING_UPGRADEDYEAR_HEATING_UPGRADED
YEAR_PLUMBING_UPGRADEDYEAR_PLUMBING_UPGRADED
YEAR_ROOF_UPGRADEDYEAR_ROOF_UPGRADED

Primary Key
PHYSICAL_OBJECT_PKPHYSICAL_OBJECT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 PHYSICAL_OBJECT_ID
DescriptionThe unique identifier of the Road vehicle
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACQUISITION_COST
DescriptionThe financial value for which this road vehicle was obtained by the current owner(s).
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACQUISITION_DATE
DescriptionThe date on which this road vehicle was obtained.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANNUAL_MILEAGE
DescriptionThe estimated usual distance travelled by a vehicle in one year. The unit of measure, in which the mileage is expressed, may vary depending on the type of vehicle.

e.g. 25000 miles
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CYLINDERS
DescriptionThe number of cylinders of this road vehicle.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to describe the road vehicle.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISPLACEMENT_SIZE
DescriptionIndication of the displacement provoked by a vehicle when in motion. For road vehicles, it is expressed as the measurement of the surface of the frontal view of the road vehicle. For ships, it is expressed as the weight of the ship's hull, machinery, equipment and spares, or the volume of water displaced.

e.g. 400 tons light displacement tonnage for the barque 'James Craig'
e.g. 5.389 square meter
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe date at which this road vehicle ceases to exist or is no longer considered as a specific road vehicle.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ENGINE_CAPACITY
DescriptionThe engine capacity of this road vehicle.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HORSEPOWER
DescriptionThe horsepower of this road vehicle.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MAKE
DescriptionThe make of this road vehicle.

e.g. Bayer Aspirin
e.g. Ford Mondeo
e.g. Ford Taurus
e.g. Ford, Opel, Peugeot, IBM.
e.g. Opel Vectra
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MANUFACTURED_DATE
DescriptionThe date at which this road vehicle was built.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MODEL
DescriptionThe model of this road vehicle.

e.g. 333
e.g. 66DX2
e.g. EcoWash 1100 (for a Zanussi washing-machine)
e.g. GLS
e.g. GLS, GTI, 333, 66DX2.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MODEL_IDENTIFICATION_NUMBER
DescriptionThe number that a manufacturer uses to uniquely identify a particular model specification that they build.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MODEL_YEAR
DescriptionThe model year of this road vehicle.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionThe word or phrase used to identify (but not uniquely) this road vehicle.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PASSENGER_CAPACITY
DescriptionThe maximum number of passengers that this vehicle model is allowed to convey.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REGISTRATION_NUMBER
DescriptionThe officially registered plate number of this road vehicle.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ROAD_VEHICLE_MINI_DIMENSION_ID
DescriptionSoft link to Road vehicle mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SERIAL_NUMBER
DescriptionThe text string that uniquely identifies this road vehicle for a given manufacturer makes and models of a product.

e.g. CD345-OEM-3457-ABC uniquely identifies a Canon EOS 50E camera.
e.g. The VIN (Vehicle Identification Number> of a .
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SIZE
DescriptionThe magnitude of this road vehicle.

e.g. 200 carat
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOUND_EQUIPMENT_MAKE
DescriptionThe manufacturer (brand) of the sound equipment of this road vehicle.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOUND_EQUIPMENT_VALUE
DescriptionThe financial value of the sound equipment installed in this road vehicle.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe date at which this road vehicle is created or recognised as being a specific road vehicle.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATED_VALUE
DescriptionThe monetary worth of this road vehicle as declared by the owner.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Road vehicle.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALUE
DescriptionThe value of this road vehicle.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALUE_NEW
DescriptionThe original price of this road vehicle. In most cases it refers to the value of the road vehicle mentioned on an invoice or bill.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BASEMENT_AREA
DescriptionThe surface area of the structure basement floor.

e.g. 100,000
e.g. 50,000
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONSTRUCTION_DATE
DescriptionThe date at which this structure was built or erected. Note: This is a specialisation of the generic attribute start date defined on physical object.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GRADE_FLOOR_AREA
DescriptionThe surface area of the structure first floor.

e.g. 10000
e.g. 5000
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HYDRANT_DISTANCE
DescriptionThe linear measurement from the structure to the nearest fire hydrant.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_BATHROOMS
DescriptionThe number of bathrooms in this dwelling.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_BEDROOMS
DescriptionThe number of bedrooms in this dwelling. This number is often used as a means of rating the property.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_ELEVATORS
DescriptionThe count of elevators in the structure.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_FLOORS
DescriptionThe number of floors in a construction.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_HABITABLE_UNITS
DescriptionThe count of the habitable components within the same structure.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_ROOMS
DescriptionThe count of rooms in the structure.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OCCUPIED_AREA
DescriptionThe surface area used by the insured in the structure.

e.g. 0
e.g. 100000
e.g. 40000
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARKING_LOT_AREA
DescriptionThe surface area of the structure parking lot.

e.g. 10000
e.g. 200000
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERCENTAGE_OF_BUILDING_SPRINKLERED
DescriptionThe ratio of the structure that is covered by a sprinkler system.

e.g. .75
e.g. 1
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_CAPACITY
DescriptionThe maximum number of people that this building can safely accommodate.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VEHICLE_CAPACITY
DescriptionThe number of vehicles that this garage can accommodate.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEAR_AIR_CONDITIONING_UPGRADED
DescriptionThe year when the air-conditioning system was improved or modernized.

e.g. 1998
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEAR_ELECTRIC_UPGRADED
DescriptionThe year when the electrical system was rewired, improved, or modernised.
Derived from the end date of the modification activity of type 'electricity upgrade' that is linked to this structure by the physical object subject of activity association.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEAR_HEATING_UPGRADED
DescriptionThe year when the heating system was improved or modernised.
Derived from the end date of the modification activity of type 'heating upgrade' that is linked to this structure by the physical object subject of activity association.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEAR_PLUMBING_UPGRADED
DescriptionThe year when the plumbing was improved or modernised.
Derived from the end date of the modification activity of type 'plumbing upgrade' that is linked to this structure by the physical object subject of activity association.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEAR_ROOF_UPGRADED
DescriptionThe year when the roof was improved or modernised.
Derived from the end date of the modification activity of type 'roof upgrade' that is linked to this structure by the physical object subject of activity association.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PHYSICAL_OBJECT_PK
DescriptionThe unique identifier of the Road vehicle
MemberPHYSICAL_OBJECT_ID [BIGINT]

Dependency Details

 AWM - Transformation