| Name | R_Pump_Curve_Cat |
|---|---|
| Entity Type | Table |
| Description | Details on the expected performance characteristics of a pump |
| 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) |
| BEP_Efficiency | double | Percent % |
The efficiency of the pump at the Best Efficiency Point | No |
NUMBER |
| BEP_Flowrate | double | Flowrate m3/h |
The pump flow rate at the Best Efficiency Point | No |
NUMBER |
| BEP_Head | double | Length m |
The pump head at the Best Efficiency Point | No |
NUMBER |
| BEP_Mechanical_Power | double | Power W |
The mechanical power of the pump at the Best Efficiency Point | No |
NUMBER |
| 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) |
| 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) |
| Max_Operating_Flow | double | Flowrate m3/h |
The maximum operating flow rate of the pump | No |
NUMBER |
| Min_Operating_Flow | double | Flowrate m3/h |
The minimum operating flow rate of the pump | No |
NUMBER |
| 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) |
| 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_Pump_Cat | Pump_Curve | The nominal pump performance curve associated with this type of pump. | Restrict | No |
| R_Pump_Curve_Coef | Pump_Curve | The catalog entry to which the polynomial coefficients belong | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |