A classification of material based on specification of a range of characteristics. For example, the classification of rocks into lithologic classes is based on ranges of mineral composition and grain size. Other examples of material class is to classify a fluid system as a crude oil, natural gas or formation water.

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

Surrogate key of the table.


clsn_cls_name (M: CHAR VARYING(80))

classification_class.name
The name given to the class.


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.


description (O: CHAR VARYING(2000))

classification_class.description
The description of this class, describing the criteria for exclusion and inclusion.


end_date (O: DATE)

classification_class.end_date
The expiration of the class, after which the class is invalid.


start_date (O: DATE)

classification_class.start_date
The date from which this class is valid.


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.


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

classification_class.classification_system
The classification system with which this class is identified.
Defines a foreign key to table clsn_sys.


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

material_class.rock_feature
This the rock_feature that provides definition for this material_class.
Defines a foreign key to table rock_feature.


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.


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.