The offset between two vertical datums in the direction normal to the initial vertical datum. These offsets provide a vertical link to the Earth when at least one related offset is based upon a vertical datum tied to the Earth. The offset may be defined through a selected point, when appropriate.

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

Surrogate key of the table.


initial_datum_s (FSK, M: CHAR VARYING(19))
initial_datum_t (M: CHAR VARYING(16))

vertical_datum_offset.initial_datum
The vertical datum which is the initiation of an offset between two vertical datums. The offset is described normal to this datum. For an offset from A to B, this points to A.
initial_datum_s: Implements a foreign key to a row in one of the tables projected from entity vertical_datum depending on the value of the next column (See below).
initial_datum_t: Defines the name of the referenced table. Possible values are: geodetic_datum, geoid, local_vert_dtm, vert_ref_dtm (@vertical_datum).


source (FNK, M: CHAR VARYING(40))

reference_behavior.source
The provider of this instance of reference information. If this instance is provided by POSC, then this attribute must be "POSC".
Defines a foreign key to table r_source.


terminal_datum_s (FSK, M: CHAR VARYING(19))
terminal_datum_t (M: CHAR VARYING(16))

vertical_datum_offset.terminal_datum
The vertical datum which is the termination of the offset between two vertical datums. When the offset is expressed from A to B, this defines B.
terminal_datum_s: Implements a foreign key to a row in one of the tables projected from entity vertical_datum depending on the value of the next column (See below).
terminal_datum_t: Defines the name of the referenced table. Possible values are: geodetic_datum, geoid, local_vert_dtm, vert_ref_dtm (@vertical_datum).


description (O: CHAR VARYING(2000))

transient_association.description
A description of the transient association.


duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))

transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

transient_association.end_time
End time of the association.


length_offset (O: FLOAT)
length_offset_u (FNK, O: CHAR VARYING(15))

vertical_datum_offset.length_offset
Length of the offset from the initial vertical datum to the terminal vertical datum. This length is measured in the vertical direction, positive upwards.
length_offset_u: Defines the unit of measure. Defines a foreign key to table r_uom.


start_time (O: TIMESTAMP)

transient_association.start_time
Start time of the association.


status (O: CHAR VARYING(11))

reference_behavior.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.


time_offset (O: FLOAT)
time_offset_u (FNK, O: CHAR VARYING(15))

vertical_datum_offset.time_offset
One way travel time of the offset from the initial vertical datum to the terminal vertical datum. This travel time is measured in the vertical direction, positive upwards.
time_offset_u: Defines the unit of measure. Defines a foreign key to table r_uom.


caused_by_s (FSK, O: CHAR VARYING(19))
caused_by_t (O: CHAR VARYING(16))

transient_association.caused_by
Specifies the activity which establishes this association.
caused_by_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).
caused_by_t: Defines the name of the referenced table. Possible values are defined in @activity.


earth_point_s (FSK, O: CHAR VARYING(19))
earth_point_t (O: CHAR VARYING(16))

vertical_datum_offset.earth_point
This is an earth point that is defined as being on the line normal to the initiating datum in which the offset is described. This allows non-parallel datums to be described with offsets at various points.
earth_point_s: Implements a foreign key to a row in one of the tables projected from entity earth_point depending on the value of the next column (See below).
earth_point_t: Defines the name of the referenced table. Possible values are defined in @earth_point.


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

transient_association.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.


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

reference_behavior.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
Defines a foreign key to table r_source_ref.


terminated_by_s (FSK, O: CHAR VARYING(19))
terminated_by_t (O: CHAR VARYING(16))

transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
terminated_by_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).
terminated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.


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

reference_behavior.version
Describes the version of Epicentre when this status was assigned to this instance of reference behavior
Defines a foreign key to table r_epcnt_version.