A property characteristic of equipment item, general facility, catalog equipment, typical facility, material, equipment class and facility class. The characteristic is defined by a property kind, a value representation, and a time defining when the property is associated with the equipment or facility. Four types of value representations are defined as subtypes allowing use of quantity, string, point and line data types.

p_equipment_fcl_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


r_property_kind_s (FSK, M: CHAR VARYING(19))

pty_equipment_facility.ref_property_kind
Specifies the type of property. This is the role the data value with respect to the object which has this property.
Defines a foreign key to table r_property_kind.


entity_type_nm (M: CHAR VARYING(40))

Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: pty_line, pty_point, pty_quantity, pty_string.


description (O: CHAR VARYING(2000))

pty_equipment_facility.description
A description of the general property.


end_time (O: TIMESTAMP)

pty_transient_property.end_time
The date and time of day designated as the end of the valid or effective time interval over which the property applies.


line_value (O: CHAR VARYING(16))

pty_line.line_value
A line representation of a general property.


point_value (O: CHAR VARYING(16))

pty_point.point_value
A point representation of a general property.


preferred_flag (O: CHAR(1))

property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.


quantity_value (O: FLOAT)
quantity_value_u (FNK, O: CHAR VARYING(15))

pty_quantity.quantity_value
The value of a quantity representation of a general property.
quantity_value_u: Defines the unit of measure. Defines a foreign key to table r_uom.


start_time (O: TIMESTAMP)

pty_transient_property.start_time
The date and time of day that designated the start of the valid or effective time interval over which the property applies.


string_value (O: CHAR VARYING(40))

pty_string.string_value
A character representation of a property value.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


catalog_eqp_s (FSK, O: CHAR VARYING(19))

pty_equipment_facility.catalog_equipment

Defines a foreign key to table catalog_eqp.


clsn_cls_s (FSK, O: CHAR VARYING(19))
clsn_cls_t (O: CHAR VARYING(16))

pty_equipment_facility.classification_class

clsn_cls_s: Implements a foreign key to a row in one of the tables projected from entity classification_class depending on the value of the next column (See below).
clsn_cls_t: Defines the name of the referenced table. Possible values are defined in @classification_class.


equipment_item_s (FSK, O: CHAR VARYING(19))

pty_equipment_facility.equipment_item

Defines a foreign key to table equipment_item.


general_fcl_s (FSK, O: CHAR VARYING(19))
general_fcl_t (O: CHAR VARYING(16))

pty_equipment_facility.general_facility

general_fcl_s: Implements a foreign key to a row in one of the tables projected from entity general_facility depending on the value of the next column (See below).
general_fcl_t: Defines the name of the referenced table. Possible values are defined in @general_facility.


other_material_s (FSK, O: CHAR VARYING(19))

pty_equipment_facility.other_material

Defines a foreign key to table other_material.


other_sptl_obj_s (FSK, O: CHAR VARYING(19))
other_sptl_obj_t (O: CHAR VARYING(16))

property.other_spatial_object

other_sptl_obj_s: Implements a foreign key to a row in one of the tables projected from entity other_spatial_object depending on the value of the next column (See below).
other_sptl_obj_t: Defines the name of the referenced table. Possible values are defined in @other_spatial_object.


r_transient_pd_nm (FNK, O: CHAR VARYING(40))

pty_transient_property.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_pd.


represent_s (FSK, O: CHAR VARYING(19))
represent_t (O: CHAR VARYING(16))

grid_geometry_behavior.represent
This is the geometry description that is the original for which this representation is an equivalent representation.
represent_s: Implements a foreign key to a row in one of the tables projected from entity grid_geometry_behavior depending on the value of the next column (See below).
represent_t: Defines the name of the referenced table. Possible values are defined in @grid_geometry_behavior.


typical_fcl_name (FNK, O: CHAR VARYING(40))

pty_equipment_facility.typical_facility

Defines a foreign key to table typical_fcl.