The activity of developing an estimate of reserves.

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

Surrogate key of the table.


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

activity.ref_existence_kind
The lifecycle kind of the activity e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kd.


cost (O: FLOAT)
cost_u (FNK, O: CHAR VARYING(15))

activity.cost
The cost of the activity.
cost_u: Defines the currency unit. Defines a foreign key to table r_currency_unit.


description (O: CHAR VARYING(2000))

activity.description
A description of the activity.


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

activity.duration
The duration of the activity.
duration_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

activity.end_time
The end time of the activity.


activity_name (O: CHAR VARYING(40))

activity.name
The name or label given to the activity.


start_time (O: TIMESTAMP)

activity.start_time
The start time of the activity.


containing_act_s (FSK, O: CHAR VARYING(19))
containing_act_t (O: CHAR VARYING(16))

activity.containing_activity
Specifies the containing activity. The containing activity indicates the activity for which this activity is a component sub-activity. Constrains the time of the contained activity to be during the containing activity.
containing_act_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).
containing_act_t: Defines the name of the referenced table. Possible values are defined in @activity.


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

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


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

activity.typical_activity
Gives the typical activity which acts as the template or design for this activity.
Defines a foreign key to table typical_act.


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

activity.utilize_equipment
Defines a piece of equipment used by the activity without stating the functional usage of the equipment. This is useful for legacy data where there is knowledge about a piece of equipment but there is not enough knowledge to define a facility.
Defines a foreign key to table equipment_item.