| Name | R_Tank_Strapping_Table |
|---|---|
| Entity Type | Table |
| Description | A strapping table is a chart that can be used to calculate fluid volume in a tank given the height of the fluid in a tank. It shows, for each increment of height in the tank, the associated volume of fluid the tank contains when the fluid height is at that level. |
| Submodel | Facility |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | 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) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | No |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| End_Date | DATE | NA |
The date and time from which this strapping table should no longer be used to calculate tank volumes. | No |
DATE |
| 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) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| 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) |
| Start_Date | DATE | NA |
The first date and time after which this strapping table can be used to calculate tank volumes. | No |
DATE |
| 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) |
| 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 |
|---|---|---|---|---|
| R_Strapping_Table_Entry | Tank_Strapping_Table | The identifier of the strapping table that contains this strapping table entry. | Cascade | Yes |
| R_Tank_Cat | Tank_Strapping_Table | The identifier of the strapping table that is, by default, used for this tank model. | Restrict | No |
| Tank_Oper_Pty_Set | Tank_Strapping_Table | The identifier of the tank strapping table that is used to calculate fluid volumes for this tank. When the shape of the tank changes, a new strapping table will be selected. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |