| 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 / Measurement | 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 |
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) |
| Impedance | double Percent |
Transformer impedance, usually expressed as a percentage ( 3.7%) | No |
NUMBER |
| 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 | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| Primary_Voltage_Range | CODE NA |
Primary Voltage Range of Transformer | No |
VARCHAR2(64) |
| Rated_Frequency | double Frequency |
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 |