| Name | Material_Composition |
|---|---|
| Entity Type | Extension of Fluid_Sample |
| Description | Records the relative concentrations of the components of a material. |
| Submodel | Fluid_Analysis |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Fluid_Sample_Id , Component_Material_Type , Material_Type , Fluid_Analysis_Id , Fluid_Analysis_Stage_Id , Existence_Kind , Version |
| Generalizations | IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Component_Material_Type | R_Production_Material |
The component material that is described as being a part of the whole material (represented by Material_Type or Fluid_Sample_Id). | Yes |
VARCHAR2(64) |
| Concentration | double Mass_Per_Volume |
The concentration of the material in the sample | No |
NUMBER |
| Equilibrium_Ratio | double Gas_To_Liquid_Ratio |
The equilibrium vaporization ratio: ratio of the mole fraction of a fluid system component in the vapor phase divided by the mole fraction of the same component in the liquid phase. The temperature and pressure at which this ratio is valid are populated in the Fluid_Analysis class. | No |
NUMBER |
| Existence_Kind | REF_EXISTENCE_KIND NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| Fluid_Analysis_Id | Fluid_Analysis |
The fluid analysis that determined the composition of the sample. | No |
NUMBER(38) |
| Fluid_Analysis_Stage_Id | Fluid_Analysis_Stage |
The identifier of the fluid analysis stage that determined the composition of the sample. | No |
NUMBER(38) |
| Fluid_Sample_Id | Fluid_Sample |
The identifier of the fluid sample described by this material composition. | Yes |
NUMBER(38) |
| GUID | STRING128 NA |
Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. | No |
VARCHAR2(128) |
| Id | ID No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| Insert_Date | DATE NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Mass_Fraction | double Dimensionless |
The fraction of the sample that this material represents calculated on a mass basis | No |
NUMBER |
| Material_Phase_Code | R_Material_Phase |
The phase of the material whose composition is being described. Example values are: Solid, Liquid, or Gas. | No |
VARCHAR2(64) |
| Material_Type | R_Production_Material |
The type of material on which the compositional analysis is performed | No |
VARCHAR2(64) |
| Mole_Fraction | double Dimensionless |
The fraction of the sample that this material represents calculated on a mole basis | No |
NUMBER |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | REMARKS_STR NA |
Any type of remarks added to a material composition. | No |
VARCHAR2(999) |
| Result_Operator | STRING1 NA |
An operator to describe whether the actual result was less than or greater than the value in the respective column. This is required when the actual value is less than the detect value for the test or greater than the limit that the measurement device can read. | No |
VARCHAR2(1) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Update_Date | DATE NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Version | STRING255 NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Volume_Fraction | double Dimensionless |
The fraction of the sample that this material represents calculated on a volumetric basis | No |
NUMBER |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Gas_Fluid_Analysis_DOV | C1 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | C2 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | C6plus | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | H2S | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | C3 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | iC4 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | nC4 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | iC5 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | nC5 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | CO2 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | O2 | READ ONLY: Material composition identifier. | Cascade | No |
| Gas_Fluid_Analysis_DOV | N2 | READ ONLY: Material composition identifier. | Cascade | No |
| Oil_Fluid_Analysis_DOV | Salt_Content | READ ONLY: Material composition identifier. | Cascade | No |
| Oil_Fluid_Analysis_DOV | Sulfur_Content | READ ONLY: Material composition identifier. | Cascade | No |
| Oil_Fluid_Analysis_DOV | BSW | READ ONLY: Material composition identifier. | Cascade | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Material_Phase_Code | R_Material_Phase | The phase of the material whose composition is being described. Example values are: Solid, Liquid, or Gas. | Restrict | No |
| Material_Type | R_Production_Material | The type of material on which the compositional analysis is performed | Restrict | No |
| Fluid_Sample | Fluid_Sample | The identifier of the fluid sample described by this material composition. | Cascade | Yes |
| Fluid_Analysis | Fluid_Analysis | The fluid analysis that determined the composition of the sample. | Nullify | No |
| Fluid_Analysis_Stage | Fluid_Analysis_Stage | The identifier of the fluid analysis stage that determined the composition of the sample. | Nullify | No |
| Component_Material_Type | R_Production_Material | The component material that is described as being a part of the whole material (represented by Material_Type or Fluid_Sample_Id). | Restrict | Yes |