| Name | R_Transformer_Cat |
|---|---|
| Entity Type | Table |
| Description | Catalog data for transformers |
| Submodel | Artificial_Lift |
| 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) |
| Capacity_Voltage | double | Electric_Potential V |
Transformer capacity | No |
NUMBER |
| 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) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Equipment_Symbol | R_Equipment_Symbol |
|
The display symbol associated with the equipment catalog entry. | No |
NUMBER(38) |
| Impedance | double | Percent % |
Transformer impedance, usually expressed as a percentage ( 3.7%) | 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) |
| Primary_Voltage_Range | CODE | NA |
Primary Voltage Range of Transformer | No |
VARCHAR2(64) |
| Rated_Frequency | double | Frequency Hz |
Rated Operating Frequency | No |
NUMBER |
| Rated_KVA | double | No_Unit |
The Kilo Volt Amp Rating of the Transformer | No |
NUMBER |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Secondary_Voltage_Range | CODE | NA |
Secondary Voltage Range of Transformer | 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_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) |
| Tap_Count | int | No_Unit |
The number of taps available | No |
NUMBER(10) |
| Tap_Voltage_Change | double | Percent % |
The percentage difference in voltage between 2 adjacent taps | No |
NUMBER |
| Transformer_Type | CODE | NA |
The type of transformer, for example "Potential Transformer". | 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 |
|---|---|---|---|---|
| Transformer | Transformer_Cat | Reference to the catalog entry for this device | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Equipment_Symbol | R_Equipment_Symbol | _ | Restrict | No |