| Name | R_Tank_Cat |
|---|---|
| Entity Type | Table |
| Description | A collection of tank standard catalog values. |
| Submodel | Facility |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | R_Facility_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Catalog_Number | STRING64 | NA |
A catalog or part number for a facility. | No |
VARCHAR2(64) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | No |
VARCHAR2(64) |
| Cone_Height | double | Length m |
The height of the cone (for tanks with conical ends only). | No |
NUMBER |
| Conversion_Factor | double | Volume_Per_Length m3/m |
A number that can be used instead of height and diameter values to determine tank volume for a vertical tank with flat ends. (Conversion Factor)*(Tank Level) = Volume | No |
NUMBER |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Diameter | double | Cylinder_Diameter mm |
The diameter of the tank. | No |
NUMBER |
| Equipment_Symbol | R_Equipment_Symbol |
|
The display symbol associated with the equipment catalog entry. | No |
NUMBER(38) |
| First_Tank_End_Shape_Code | R_Tank_End_Shape |
|
A reference value that describes the shape of the first end of the tank. (For example, round, flat, conical.) | No |
VARCHAR2(64) |
| Height | double | Length m |
The height or length of the tank, depending on the orientation of the tank. (I.e., for vertical tanks, this value represents the height of the tank. For horizontal tanks, it represents the length of the tank.) | No |
NUMBER |
| 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) |
| Manufacturer | STRING64 | NA |
Name of the business associate who manufactured the item. | No |
VARCHAR2(64) |
| Model_Name | STRING64 | NA |
Name of a model or version of some entity; for equipment, it may coincide with the trade name. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Orientation_Code | R_Orientation |
|
A value that describes the orientation of a tank. I.e., whether it is horizontal or vertical. | No |
VARCHAR2(64) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Second_Tank_End_Shape_Code | R_Tank_End_Shape |
|
A reference value that describes the shape of the second end of the tank. (For example, round, flat, conical.) | No |
VARCHAR2(64) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Storage_Capacity | double | Volume m3 |
The storage capacity of the tank. | No |
NUMBER |
| Storage_Unit_System | R_Unit_System |
|
The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g Metric, English etc | No |
VARCHAR2(64) |
| Tank_Strapping_Table | R_Tank_Strapping_Table |
|
The identifier of the strapping table that is, by default, used for this tank model. | No |
NUMBER(38) |
| Tank_Type | R_Tank |
|
The type of tank. | Yes |
VARCHAR2(64) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Tank | Tank_Cat | The identifier of the tank catalog that describes the nominal properties of the tank. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| First_Tank_End_Shape_Code | R_Tank_End_Shape | A reference value that describes the shape of the first end of the tank. (For example, round, flat, conical.) | Restrict | No |
| Orientation_Code | R_Orientation | A value that describes the orientation of a tank. I.e., whether it is horizontal or vertical. | Restrict | No |
| Tank_Type | R_Tank | The type of tank. | Restrict | Yes |
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Second_Tank_End_Shape_Code | R_Tank_End_Shape | A reference value that describes the shape of the second end of the tank. (For example, round, flat, conical.) | Restrict | No |
| Equipment_Symbol | R_Equipment_Symbol | _ | Restrict | No |
| Tank_Strapping_Table | R_Tank_Strapping_Table | The identifier of the strapping table that is, by default, used for this tank model. | Restrict | No |