Appendix-I Database Field Description
The database fields that you can access in e-DPP are tabulated here with their field types and descriptions. You need to refer to the database fields for; Template Design Filter, Sort and Page Feed Condition in Edit Forms RevControl - Revision List for the following 10 tables;
1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
Project Record (DPPProjectRec) Electrical Load (DPPElecLoad) Cable (DPPCable) Switchgear/MCC (DPPSwgrMcc) Bus (DPPBus) Switchboard (DPPPanel) Local Control Station (DPPLCS) Revision Data (REVData) Lumped Load (DPPLump) Transformer (DPPXFMR)
ELTECHS Engineering & Consulting Co., Ltd

App - I - 1

e-DPP 3.0
Database Field Description
Project Record (DPPProjectRec)
1. Project Record (DPPProjectRec)

1. 2. 3. 4. 5. 6. 7.

Field Name
Altitude AverageTemp BTDCableEntryType CableStandard CableUnits CableUpdate CabVoltageDC

Data Type

Number Number Text Number Number Date/Time Text

Description

(Selection Values, Default Value with *)
Site altitude from sea level (m) 0, 1000 (*) Average ambient air temperature (deg. C) Type of cable entry for bearing temperature detector "M" (*), "NPT", "PG","PF", "ET", [blank] Applicable cable standard 0: IEC (*), 1: ANSI, 2 : JIS Units of length (ft, mile, m, km), weight (lbs, kg) and size (mm2, AWG) for cables 0: Metric (*), 1: English Data/Time of DPPCable updated lastly Cable rated low voltage-1phase <[CableStandard]="IEC"> Default="0.6/1KV" <[CableStandard]="ANSI" > Default="1KV" <[CableStandard]="JIS"> Default="600V" Cable rated high voltage no.1 <[CableStandard]="IEC"> Default=blank <[CableStandard]="ANSI" > Default=blank <[CableStandard]="JIS"> Default=blank Cable rated high voltage no.2 <[CableStandard]="IEC"> Default="8.7/15KV" <[CableStandard]="ANSI" > Default="15KV" <[CableStandard]="JIS"> Default="11KV" Cable rated low voltage-1phase <[CableStandard]="IEC"> Default="0.6/1KV" <[CableStandard]="ANSI" > Default="1KV" <[CableStandard]="JIS"> Default="600V" Cable rated low voltage-3phase <[CableStandard]="IEC"> Default="0.6/1KV" <[CableStandard]="ANSI" > Default="1KV" <[CableStandard]="JIS"> Default="600V" Cable rated low voltage-3phase <[CableStandard]="IEC"> Default="0.6/1KV" <[CableStandard]="ANSI" > Default="1KV" <[CableStandard]="JIS"> Default="600V"

Template

CabVoltageHV1

CabVoltageHV2

CabVoltageLV1Ph

CabVoltageLV3Ph1

CabVoltageLV3Ph2

App - I - 2

Cable rated medium voltage no.1 <[CableStandard]="IEC"> Default="6/10KV" <[CableStandard]="ANSI" > Default="10KV" <[CableStandard]="JIS"> Default="6.6KV" Cable rated medium voltage no.2 <[CableStandard]="IEC"> Default="3.6/6KV" <[CableStandard]="ANSI" > Default="5KV" <[CableStandard]="JIS"> Default="3.3KV" Type of CCR cable entry "M" (*), "NPT", "PG","PF", "ET", [blank] Name of consultant Official contract no. Name of contractor Cooling water temperature (deg. C) Corrosion protection Yes: Required (*), No: Not required Name of country of plant site Name of customer (For ETAP interface) Data/Time of DPPElecload updated lastly Name of engineer Power frequency (Hz) 50 (*), 60 Not used Frequency variation for HV-1 "+-0.5%", "+-1.0%", "+-1.5%", "+-2.0%", "+-2.5%", "+-3.0%", "+-4.0%", "+-5.0%" (*), <blank> Same for HV-2 Same for LV (1phase) Same for LV-1 (3phase) Same for LV-2 (3phase) Same for MV-1 Same for MV-2 Gas group (=Enclosure group) <Standard=IEC> II, IIA, IIB (*), IIC, [blank] <Standard=ANSI> A, B, C, D (*), [blank]

SysVoltageMV2 TempClass TropicalTreatment Units VoltVariationDC VoltVariationHV1 VoltVariationHV2 VoltVariationLV1Ph VoltVariationLV3Ph1 VoltVariationLV3Ph2 VoltVariationMV1
Number Text Yes/No Number Text Text Text Text Text Text Text

App - I - 8

150. 151. 152. 153. 154. 155. 156. 157. 158. 159.
Same for MV-2 Not used Number of wires for HV-1 circuit system 3 (*), 4 Same for HV-2 Number of wires for LV (1phase) circuit system 2 (*), 3 Same for LV-1 (3phase) Same for LV-2 (3phase) Same for MV-1 Same for MV-2 Type of cable entry for winding temperature detector "M" (*), "NPT", "PG","PF", "ET", [blank]
VoltVariationMV2 WireSystemDC WireSystemHV1 WireSystemHV2 WireSystemLV1Ph WireSystemLV3Ph1 WireSystemLV3Ph2 WireSystemMV1 WireSystemMV2 WTDCableEntryType
Text Number Number Number Number Number Number Number Number Text

App - I - 9

Electrical Load (DPPElecLoad)
2. Electrical Load (DPPElecLoad)

1. 2. 3. 4. 5.

BaseforMotor BearingInsulation BearingNoDE BearingNoNDE BearingRTD
Yes/No Yes/No Text Text Yes/No
Base for motor required or not Yes, No (*) Bearing insulation required or not Yes, No (*) Bearing no. for driving end Bearing no. for non driving end Bearing RTD required or not <[BearingRTDQty] = 0> No <[BearingRTDQty] <> 0> Yes Number of bearing temperature detectors <KV greater than 1.0> BearingRTDQty =DPPMotorDefault [BearingRTDQtyHV] <KV equal or less than 1.0> BearingRTDQty =DPPMotorDefault [BearingRTDQtyLV] <KV greater than 1.0> 2 (*) <KV equal or less than 1.0> 0 (*) Type of bearing temperature detectors "Pt100" (*), "Jpt100", "Ni100", "Ni120", [blank] Bearing type for driving end "B": Ball (*), "S": Sleeve, "R": Roller, [blank] Bearing type for non driving end "B": Ball (*), "S": Sleeve, "R": Roller, [blank] Load BHP (Breaking Horse Power) in kW for loading category No.1 When PercentLoad0 or KW is altered: <EquipType<>5 (Capacitor)> BHP=PercentLoad0*KW/100 Load BHP (Breaking Horse Power) in kW for loading category No.2 When PercentLoad1 or KW is altered: <EquipType<>5 (Capacitor)> BHP1=PercentLoad1*KW/100 Load BHP (Breaking Horse Power) in kW for loading category No.3 When PercentLoad2 or KW is altered: <EquipType<>5 (Capacitor)> BHP2=PercentLoad2*KW/100 Size of cable entry for bearing RTD Connected bus ID <[FromETAP]=Yes> Edit disabled <[FromETAP]=No> Edit enabled ID to accessed cable library table LIBCable Overall diameter of power cable in mm Power cable type in number from ETAP (Not used in DPP)

BearingRTDQty

7. 8. 9. 10.
BearingRTDType BearingTypeDE BearingTypeNDE BHP

Text Text Text Number

SiteArea SizedKeyFactor

SpaceHeater

Yes/No

180. 181.
SpaceHeaterPhase SpaceHeaterVolt

182. 183. 184.

SpaceHeaterW SpareDF SpareQty

185. 186.

SpeedControl StartType
187. 188. 189. 190. 191. 192. 193. 194. 195.
Substation SupplierName SurgeArrestors SurgeCapacitors TaCold TaHot TBPosition tE ThrustContraction
Text Text Yes/No Yes/No Number Number Text Number Number

App - I - 21

196. 197. 198. 199.
Thrust force in expansion direction in kg Starting time in sec on full load at rated voltage <TsFullLoad<>0> Ts100Un=TsFullLoad Starting time in sec on full load at 80% rated voltage Starting time on full load condition <Data Source Table=INTIndMotor> TsFullLoad=INTIndMotor [TsFullLoad] <Data Source Table=INTMOV> TsFullLoad=StartTime <Ts100Un<>0> TsFullLoad=Ts100Un Starting time on no load condition Type of motor <INTIndMotor [MotorType]=0> TypeMotor="IM" <INTIndMotor [MotorType]=1> TypeMotor="IG" "IM"(*), "SM", "MOV", "DCM", "Canned", "Geared", "IG", [blank] Unit of motor full load torque <DPPProjectRec [Units] = 0 (Metric)> 1: "N-m" (*), 2: "kg-m" <DPPProjectRec [Units] = 1 (English)> 1: "lb-ft" (*) Description of phase, grounding and/or neutral cores UnitsOfWires=DPPCable [UnitsOfWires] (For future, only after ConnectedCableIID becomes valid.) UnitsOfWires=LIBCableIDX [UnitsOfWires] "C" (*), "P", "T", "Q", "C+G", "C+E", "C+N", "C+1/2", "1/2C", "C+G+N", "C+E+N", [blank] Expression in the column "No. of Cores" is [NumberOfWire] + [UnitsOfWire] (e.g. "3C+E", "3C+1/2", "30P") User defined field No.0 in date format User defined field No.1 in date format User defined field No.2 in date format User defined field No.0 in numeric format User defined field No.1 in numeric format User defined field No.2 in numeric format User defined field No.3 in numeric format User defined field No.4 in numeric format User defined field No.0 in text format User defined field No.1 in text format User defined field No.2 in text format User defined field No.3 in text format
ThrustExpansion Ts100Un Ts80Un TsFullLoad

200. 201.

TsNoLoad TypeMotor

Number Text

UnitsOfTorque (Future use)

UnitsOfWire

204. 205. 206. 207. 208. 209. 210. 211. 212. 213. 214. 215.
UserDate_0 UserDate_1 UserDate_2 UserNum_0 UserNum_1 UserNum_2 UserNum_3 UserNum_4 UserText_0 UserText_1 UserText_2 UserText_3
Date/Time Date/Time Date/Time Number Number Number Number Number Text Text Text Text

App - I - 22

216. 217. 218.

FaultLampColor FaultStatus FinalData FromDPPElecLoad FuseBaseA
Text Text Yes/No Yes/No Number

FuseInterruptingKA

77. 78.

FuseLibID FuseRatedA

FuseRatedKV

80. 81. 82. 83.

FuseType GndWireSize GndWireType GPTClass

Text Text Text Text

App - I - 34
Rating of grounding potential transformer volt-ampere Ratio (V) of grounding potential transformer (e.g. "6600/240V", "480/110V", "No") Healthy condition indication lamp on MCC unit in
GPTRatedVA GPTRatioV HealthyLamp HealthyLampColor HP
Number Text Yes/No Text Number

90. 91.

HVCBLibID ID
Color of running indication lamp on MCC unit "G": Green, "R": Red, "A": Amber, "O": Orange, "W": White (*), "Bl": Blue, "Y": Yellow, <blank> Output power or capacity in the unit specified by HP_KW Same as DPPElecLoad [HP] Edit Disabled Unit of output power 0: HP, 1: kW (*), 2: kVA, 3: kvar, A(*) Same as DPPElecLoad [HP_KW] Edit Disabled ID to access to DPP HV CB library table LIBHVCB Equipment ID Main key to link to DPPElecLoad [ID] Edit disabled Service name of electrical cubicle (e.g. "INCOME-A", "FEEDER-1", "BUS-TIE", etc.) Full load current in A Same as DPPElecLoad [IFL] Edit Disabled ETAP internal key ID [IID] starts from 990001.for e-DPP original record Equipment rated voltage (kV) Same as DPPElecLoad [KV] Edit Disabled Unit label reading Alarm lamp on LCS Color of alarm indication lamp on LCS "G": Green, "R": Red (*), "A": Amber, "O": Orange, "W": White, "Bl": Blue, "y": Yellow Ammeter on LCS Scale of ammeter on LCS Auto / Manual change over switch on LCS Auto / Manual / Stop change over switch on LCS Circuit ID of LCS ID to access to LIBLCS Edit Disable Name of LCS circuit CT inside LCS Ratio of CT inside LCS Emergency stop button on LCS
92. 93. 94. 95. 96. 97. 98. 99. 100. 101. 102. 103. 104. 105. 106.
IFL IID KV LabelDescription LCSAlarmLamp LCSAlarmLampColor LCSAmmeter LCSAmmeterScale LCSAutoManual LCSAutoManualOff LCSCircuitID LCSCircuitName LCSCT LCSCTRatio LCSEmergStop
Number Number Number Text Yes/No Text Yes/No Text Yes/No Yes/No Text Text Yes/No Text Yes/No

App - I - 35

LCS enclosure is explosion proof or not. <DPPElecLoad [ExpProtection] = " "> No <DPPElecLoad [ExpProtection] <> " "> Yes Stop lamp on LCS Color of stop indication lamp on LCS "G": Green, "R": Red (*), "A": Amber, "O": Orange, "W": White, "Bl": Blue, "y": Yellow Running lamp on LCS Color of running indication lamp on LCS "G": Green, "R": Red (*), "A": Amber, "O": Orange, "W": White, "Bl": Blue, "y": Yellow Start switch (button) on LCS Start / Stop switch on LCS Stop switch (button) on LCS Type of LCS <[LCSExpProof] = No> [LCSCircuitName] <[LCSExpProof] = Yes> [LCSCircuitName] + "-EX" (Spare field #1 for LCS user defined signal - Yes/No type) Yes: Common contact is used for Start & Stop commands of PLC or local panel No: Separate contacts are used for Start & Stop commands of PLC or local panel Current reading (A) to PLC or local panel by analogue signal Range of current reading (A) to PLC or local panel by analogue signal Fault signal to PLC or local panel by digital signal Permit to start signal from PLC or local panel by digital signal Electrical power reading (kW) to PLC or local panel by analogue signal Range of power reading (kW) to PLC or local panel by analogue signal Running status signal to PLC or local panel by digital signal Speed reading (rpm) to PLC or local panel by analogue signal Speed control signal from PLC or local panel by analogue signal Range of speed control from PLC or local panel by analogue signal Range of speed reading (rpm) to PLC or local panel by analogue signal Start command from PLC or local panel by digital signal Type of start contact from PLC or local panel 0: One-shot (Momentary), 1: Steady (Maintained) Stop command from PLC or local panel by digital signal

LPStopContact LPStopInterLock LPUserSignal1 LPUserSignal2 LRC LVCBLibID MagContactor MainPowerSize
Number Yes/No Yes/No Yes/No Number Text Yes/No Text

MainPowerType

141. 142. 143. 144.
MCCB MCCBFrameA MCCBLibID MCCBTripA
Yes/No Number Text Number

145. 146. 147. 148.

MeteringDevice MotorRestartSetting MotorSpaceHeater MultiFuncRelay

Text Text Yes/No Yes/No

App - I - 37

149. 150. 151. 152.

Number of MCCB poles "2", "3" (*), "4", "3+N", "2P", "3P", "4P", "3P+N", <blank> ID to access to DPP thermal over load relay library table LIBOLR Rating range of thermal over load relay in text format Switchboard no. from which motor/load is power supplied Sub-key to link to DPPElecLoad [Panel] and Access key to DPPPanel System voltage applied to this switchboard in kV. Same as DPPPanel [PanelKV] Type of switchboard Same as DPPPanel [PanelType] "SWGR" (*), "MCC", "DP" for future (unselectable) Number of poles Same as DPPElecLoad [KV] Edit Disabled Identification no. of power circuit diagram for motor starter or power feeder ID to access LIBPowerCircuit Edit Disable Name of motor starter or power feeder power circuit diagram Power fuse is used or not Pressure flap required or not Type, model or drawing no. of protection device Trip by protection device Number of AC ammeters Number of AC voltmeters Number of DC ammeters Number of differential relays Number of earth fault relays Number of frequency meters Number of negative phase-sequence relay Number of neutral overcurrent relays Number of overcurrent relays Number of overvoltage relays Number of power-factor meters Number of reverse power relays Number of undervoltage relays Number of reactive volt-ampere meters
NoOfMCCBPoles OLRLibID OLRRangeA PanelID

153. 154.

PanelKV PanelType

155. 156.

Poles PowerCircuitID
157. 158. 159. 160. 161. 162. 163. 164. 165. 166. 167. 168. 169. 170. 171. 172. 173. 174. 175.
PowerCircuitName PowerFuse PressureFlap ProtectionDevice ProtectionDeviceTrip QtyACAmmeter QtyACVoltMeter QtyDCAmmeter QtyDifferential QtyEarthFault QtyFreqMeter QtyNegativePhase QtyNeutralOCR QtyOCR QtyOverVoltage QtyPFMeter QtyReversePower QtyUnderVoltage QtyVARMeter
Text Yes/No Yes/No Text Yes/No Number Number Number Number Number Number Number Number Number Number Number Number Number Number

App - I - 38

176. 177. 178. 179. 180. 181. 182. 183. 184. 185. 186. 187. 188. 189.
Number of wattmeters Number of watt-hour meters Number of contacts required for remote control "1-NO", "1-NO/1-NC", "2-NO", "Yes", "No", "NA", "-" Reset button / switch on MCC unit required or not Color of reset button on MCC unit "G": Green, "R": Red, "O": Orange, "B": Black (*), <blank> Restart is required or not. Same as DPPElecLoad [RestartReq] Same as LIBSequence [RestartReq] by Quick Pick Running indication lamp on MCC unit Color of running indication lamp on MCC unit "G": Green (*), "R": Red, "A": Amber, "O": Orange, "W": White, "Bl": Blue, "Y": Yellow, <blank> Safety shutter required or not Drawing no. of motor starter or power feeder schematic diagram Default = DPPPanel [SchematicDWG] Seal-in (Self-holding) auxiliary relay (42X) Seal-in (Self-holding) relay (42) Switchboard section no. Identification no. of motor starter or power feeder sequence diagram ID to access LIBSequence Edit disable Name of motor starter or power feeder sequence diagram Shunt trip of switching device Speed control for motor "C": Constant (*), "R": Reversible, "V": Variable, "M": Multi-Speed, "P": Pole-Change, [blank] Same as DPPElecLoad [SpeedControl] Edit Disabled Start button / switch on MCC unit required or not Color of start button on MCC unit "G": Green (*), "R": Red, "B": Black, <blank> Unit no. of motor starter, power feeder, incomer, bus coupler, etc. To be unique within a switchboard Start/Stop switch on MCC unit Type of motor start Same as DPPElecLoad [StartType] Edit Disabled Stop button / switch on MCC unit required or not Color of start button on MCC unit "G": Green, "R": Red (*), "B": Black, <blank>

UnitType

230. 231. 232. 233. 234. 235. 236. 237. 238. 239. 240. 241. 242. 243.
UserDate_0 UserDate_1 UserDate_2 UserNum_0 UserNum_1 UserNum_2 UserNum_3 UserNum_4 UserText_0 UserText_1 UserText_2 UserText_3 UserText_4 VT1Class
Date/Time Date/Time Date/Time Number Number Number Number Number Text Text Text Text Text Text

244. 245. 246. 247. 248.

VT1PrimaryV VT1RatedVA VT1RatioV VT1SecondaryV VT2Class
Number Number Text Number Text

249. 250. 251. 252.

VT2PrimaryV VT2RatedVA VT2RatioV VT2SecondaryV
Number Number Text Number

App - I - 41

253. 254. 255.
Class of zero-phase current transformer "0.1", "0.2", "0.5", "1.0", "3.0", "5.0", "5P", "10P", "(*)", "(**)", "(*1)", "(*2)", "(*3)", <blank> Rating of zero-phase current transformer in volt-ampere Ratio (V) of zero-phase current transformer (e.g. "50/5A", "50/0.025A", "No")
ZCTClass ZCTRatedVA ZCTRatioA

Text Number Text

App - I - 42

Bus (DPPBus)

5. Bus (DPPBus)
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.
AlteredBy AlteredTime BusKV ContCF ContCFKVA Contingency1 Contingency2 DataRevs FinalData FromBusID FromBusID1 FromBusID2 FromBusID3 FromBusID4 FromBusID5 FromBusID6 FromBusID7 FromBusID8 FromBusID9 FromBusIID FromETAP ID
Text Number Number Number Number Number Number Number Yes/No Text Text Text Text Text Text Text Text Text Text Number Yes/No Text
(For ETAP Interface) (For ETAP Interface) Same as INTBus [NominalkV] Same as DPPBusSummary [BusKV] Coincidence factor for continuous load in % (0-100) 100(*) KVA for continuous load adjusted by C.F. ContCFKVA=ContCF * TotalContKVA / 100 Margin in % for calculated plant maximum demand Margin in % for calculated plant peak demand (For ETAP Interface) "Yes" - This record is fixed and not allowed to update any data except this field itself. [BusID] of an upstream bus supplying power to this bus for system configuration No.1 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.2 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.3 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.4 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.5 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.6 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.7 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.8 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.9 "<top>" for the top bus [BusID] of an upstream bus supplying power to this bus for system configuration No.10 "<top>" for the top bus [BusIID] of an upstream bus supplying power to this bus. "Yes" for a record come from ETAP "No" for a record originated in DPP Bus No. Same as INTBus [ID] Same as DPPBusSummary [BusID]

Number Text Text Text Number Number Number Number Text Text Number Yes/No Text Number
102. 103. 104. 105. 106. 107. 108. 109. 110.
Lifter LiftingEye Lighting Location MFRAssemblyDWG MFRDocumentList MFRLayoutDWG MFRLoadingData MFRName
Yes/No Yes/No Yes/No Text Yes/No Yes/No Yes/No Yes/No Text

111. 112.

MFROpManual MFROtherDocuments

App - I - 50

113. 114. 115. 116. 117. 118. 119. 120. 121. 122.
Manufacturers Relay Coordination and Setting schedule required or not Manufacturers Schematic diagram required or not Manufacturers Spare Parts List required or not Manufacturers Specification and Performance Data required or not Manufacturers Special Tool List required or not Manufacturers Test Procedure required or not Manufacturers Wiring diagram required or not Name of switchboard model Mounting type of whole switchboard "Vertical Free Standing" (*), "Rack Mounting", "Wall Mounting" Total apparent power of motor loads in kVA MTLoadKVA=MTLoadPercent * TotalKVA / 100 Motor loads are identified by XLoadSumPanel [EquipType] = 0, 1, 2 or 3. Same as DPPPanelSummary [MTLoadPercent] Percent of motor loads against all motor and static loads. When Load Summary calculation is performed, this field is updated. Motor loads are identified by XLoadSumPanel [EquipType] = 0, 1, 2 or 3. Short circuit capacity MVA class in MVA Neutral bus bar required or not Required number of bus riser units Required number of capacitor bank units Required number of bus coupler units Required number of earthing trucks Required number of distribution feeder units (without transformer) Required number of generator breaker units Required number of incomer units Required number of motor starter units Required number of transformer feeder units Material of nameplate "Stainless steel", "Plastic", "Vinyl"
MFRRelaySetData MFRSchematicDWG MFRSparePartsList MFRSpecData MFRSpecialToolList MFRTestProcedure MFRWiringDWG ModelName MountingType MTLoadKVA

23. 24. 25. 26. 27. 28. 29. 30. 31.
Auto / Manual / Off change over switch on LCS Circuit ID of LCS ID to access to LIBLCS Edit disabled Name of LCS circuit Edit disabled CT inside LCS Ratio of CT inside LCS Emergency stop button on LCS LCS enclosure is explosion proof or not. Off lamp on LCS Color of stop indication lamp on LCS "G": Green, "R": Red (*), "A": Amber, "O": Orange, "Y": Yellow, "W": White, <blank> On lamp on LCS Color of running indication lamp on LCS "G": Green, "R": Red (*), "A": Amber, "O": Orange, "Y": Yellow, "W": White, <blank> On switch (button) on LCS On / Off switch on LCS Off switch (button) on LCS Lock facility on auto/manual/(off) switch, e.g. pin lock, etc. Mounting method of LCS "Wall Mounting"(*), "Embedded", "Self-Standing", <blank> Mounting bolts Off-Lock facility on stop button, e.g. padlock, pin lock, etc. Rated operation voltage in text format "110VAC", "120VAC" (*), "230VAC", "240VAC", "48VDC", <blank> Method and/or color of painting Quantity of the same type [LCSTypeID] of LCS Total value of DPPSwgrMcc with the index key DPPSwgrMcc [LCSTypeID] Rated current in text format "3A", "5A", <blank> Description or material of tag plate Terminal block for external cables User defined field No.0 in date format User defined field No.1 in date format User defined field No.2 in date format
LCSAutoManualOff LCSCircuitID LCSCircuitName LCSCT LCSCTRatio LCSEmergStop LCSExpProof LCSOffLamp LCSOffLampColor
Yes/No Text Text Yes/No Text Yes/No Yes/No Yes/No Text

32. 33.

LCSOnLamp LCSOnLampColor
34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49.
LCSStart LCSStartStop LCSStop LockAutoManual Mounting MountingBolt OffLockStop OperationVoltage Painting Quantity RatedA TagPlate TerminalBlock UserDate_0 UserDate_1 UserDate_2
Yes/No Yes/No Yes/No Yes/No Text Yes/No Yes/No Text Text Number Text Text Yes/No Date/Time Date/Time Date/Time

App - I - 56

50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60.
User defined field No.0 in numeric format User defined field No.1 in numeric format User defined field No.2 in numeric format User defined field No.3 in numeric format User defined field No.4 in numeric format User defined field No.0 in text format User defined field No.1 in text format User defined field No.2 in text format User defined field No.3 in text format User defined field No.4 in text format "Yes"/"No" or description of warning plate

24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
(Selection Values, Default Value with *) Revision description indicated in the bottom line of data sheet Revision description indicated in the second line from bottom of data sheet Revision description indicated in the third line from bottom of data sheet Revision description indicated in the forth line from bottom of data sheet (Spare field) Revision no indicated in the bottom line of data sheet Always "0" or blank Revision no indicated in the second line from bottom of data sheet Revision no indicated in the third line from bottom of data sheet Revision no indicated in the forth line from bottom of data sheet (Spare field)
RevDescription1 RevDescription2 RevDescription3 RevDescription4 RevDescription5 RevNo1 RevNo2 RevNo3 RevNo4 RevNo5
Text Text Text Text Text Text Text Text Text Text

App - I - 59

Lumped Load (DPPLump)

9. Lumped Load (DPPLump)

AlteredBy AlteredTime Bus ContCF ContCFKVA ContDF DataRevs FinalData FromETAP ID IFL IID InService InterCF InterCFKVA InterDF Issue KV LoadPercent0 LoadPercent1 LoadPercent2 MTLoadKVA
Text Number Text Number Number Number Number Yes/No Yes/No Text Number Number Number Number Number Number Number Number Number Number Number Number
(For ETAP Interface) (For ETAP Interface) Same as INTLump [Bus] Coincidence factor for continuous load in % 100(*) KVA for continuous load adjusted by C.F. ContCFKVA=ContCF * TotalContKVA / 100 Same as INTLump [ContDF] (For ETAP Interface) "Yes" This record is fixed and not allowed to update any data except this field itself. "Yes" for a record come from ETAP "No" for a record originated in DPP ID of lumped load Same as INTLump [ID] Same as XLump [ID] Same as INTLump [IFL] IFL=TotalKVA/(sqrt(3) * KV) ETAP internal key to link to INTLump Same as INTLump [IID] Same as XLump [IID] Same as INTLump [InService] Coincidence factor for intermittent load in % 50(*) KVA for intermittent load adjusted by C.F. InterCFKVA=InterCF * TotalInterKVA / 100 Same as INTLump [InterDF] (For ETAP Interface) Same as INTLump [KV] for ETAP lumped load Same as XLump [KV] for DPP lumped load Same as INTLump [LoadPercent0] Same as INTLump [LoadPercent1] Same as INTLump [LoadPercent2] Total apparent power of motor loads in kVA MTLoadKVA=MTLoadPercent * TotalKVA / 100 Motor loads are identified by XLoadSum [EquipType]=0, 1, 2 or 3. Percent of motor loads against all motor and static loads. MTLoadPercent=100(%) - STLoadPercent Static loads are identified by XLoadSum [EquipType]<>0, 1, 2 and 3.

ClassNeutCT

ClassPrimCT

ClassSecCT

ClassTerCT

17. 18.

CodeStandard CoolFanCBDegProtection

19. 20.

CoolFanContBox CoolFanControl

App - I - 64

21. 22. 23. 24. 25. 26. 27. 28. 29. 30.
Number of phase of cooling fan power (e.g. "3-ph", "Single") Number of cooling fans Rated voltage of cooling fan power (e.g. "AC120V", "240Vac") Rated output of cooling fan in watt Cooling fan required or not Weight of core in kg, ton or lb Date of revision (Same as ETAP) Dimension in text "H2300xW3450xD2310") Document no. form (e.g.
CoolFanPhase CoolFanQty CoolFanVolt CoolFanWatt CoolingFan CoreWeight DateRevs DimensionText DocumentNo DutyRating
Text Number Text Number Yes/No Number Number Text Text Text
Duty rating of transformer operation (e.g. "Continuous", "Emergency", "Short time", "Periodic", etc.) Continuous, Intermittent, Periodic, Short-Time, Varying Efficiency at 50% load factor & 80% power factor in % Efficiency at 50% load factor & 100% power factor in % Efficiency at 75% load factor & 80% power factor in % Efficiency at 75% load factor & 100% power factor in % Efficiency at 100% load factor & 80% power factor in % Efficiency at 100% load factor & 100% power factor in % Service name of transformer (e.g. "Unit Distribution for #20 Process Area") "Yes" This record is fixed and not allowed to update any data except this field itself. Foundation bolts required or not "Yes" for a record come from ETAP Grounding terminals required or not Hazardous area classification code <Standard=IEC> Zone 0, Zone 1, Zone 2 (*) <Standard=ANSI> Class I Div 1, Class I Div 2 (*) Equipment ID (Equipment ID, e.g. "TX-20-101A") Second ID for plural number of transformers (e.g. ID="TX-001A", ID2="TX-001B") ETAP internal ID in XFMR2 or XFMR3 for link with XFMRDPP Impulse test required or not
31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42.
EFF050LF080PF EFF050LF100PF EFF075LF080PF EFF075LF100PF EFF100LF080PF EFF100LF100PF EquipmentName FinalData FoundationBolt FromETAP GroundTerminal HazardAreaClass
Number Number Number Number Number Number Text Yes/No Yes/No Yes/No Yes/No Text

43. 44. 45. 46.

ID (Unique) ID2 IID ImpulseTest

Text Text Number Yes/No

App - I - 65

47. 48.

0: In service, 1: Out of service Used for ETAP interface Insulation class (e.g. "F (65deg.C Rise)") IEC: A(60oC Rise), E (75oC Rise), B (80oC Rise), F (100oC Rise), H (125oC Rise), C(150 oC Rise) Related to item #15 ANSI : A(Class 105), B(Class 130), F (Class 155), H (Class 180), >H (Class 220) Issue no. (Same as ETAP) Dimensional length in mm or inch Lifting lug required or not Installation location (e.g. "Outdoor", "Tropical", etc.) Indoor, Outdoor, Marine Below Deck, Marine Above Deck, Control method of LTC (e.g. "AVR", "Local-Remote", "Auto-Manual", "Master-Follower", etc.) Master Follower, Circulating Current, Reverse Reactance, Power Factor, VAR, AVR, Manual LTC remote control panel required or not Maximum magnetizing current in kA Duration of maximum magnetizing current in sec. Name of manufacturer (ETAP Info page) Maximum tap position in % (e.g. 10, 5, etc.) +10, +7.5, +5, [Blank] Name of manufacturer (ETAP Remarks page) Minimum tap position in % (e.g. 10, -5, etc.) -10, -7.5, -5, [Blank], [kV button then specify value] Mounting type (e.g. "Skid", "Wheel", etc.) Pad Mount, Pole Mount, Platform Mount, Unit Substation, Skid Mount, [Blank] Unit of apparent power (MVA=0, kVA=1) Used for ETAP interface Transformer capacity in text form (e.g. "2000/2500kVA (OA/FA)") Nameplate required or not Maximum noise in dBA No load loss at 100% voltage in watt or % Number of neutral phase CT Number of taps ([MaxPercentTap][MinPercentTap])/[StepPercentTap]+1 Number of primary phase CT Number of secondary phase CT Number of tertiary phase CT

PrimConnectCond PrimConnectSize PrimConnectType

Text Text Text

97. 98. 99. 100. 101. 102. 103.
PrimIsolatingSW PrimkV PrimLFWithstandKV PrimMVA PrimMVA2 PrimMVA3 PrimNGAmp
Yes/No Number Number Number Number Number Number
104. 105. 106. 107. 108. 109.
PrimNGSec PrimNGType PrimNumberCond PrimNumberConnect PrimNumberCore PrimTypeCond
Number Text Number Number Number Text
110. 111. 112. 113. 114. 115. 116. 117. 118.
PrimWireSystem PSPosX PSPosXoverR PSPosZ PSPosZBase PSZeroX PSZeroXoverR PSZeroZ PTPosX
Text Number Number Number Text Number Number Number Number

App - I - 68

119. 120. 121. 122. 123. 124. 125. 126. 127. 128. 129. 130. 131. 132. 133. 134. 135. 136. 137. 138. 139. 140. 141. 142. 143. 144.
X/R ratio of positive sequence impedance between primary and tertiary windings Positive sequence impedance between primary and tertiary windings in % Zero sequence reactance between primary and tertiary windings in % X/R ratio of Zero sequence impedance between primary and tertiary windings Zero sequence impedance between primary and tertiary windings in % Purchase order (PO) no. Date of purchasing in text form Quantity of identical transformers to be indicated in a datasheet Rated frequency (Hz) 50 (*), 60 Rate load loss at 100% voltage in watt or % Rated burden of neutral phase CT in VA Rated burden of primary phase CT in VA Rated burden of secondary phase CT in VA Rated burden of tertiary phase CT in VA Ratio of neutral phase CT (e.g. "2000/5A", "300/1A") Ratio of primary phase CT (e.g. "2000/5A", "300/1A") Ratio of secondary phase CT (e.g. "2000/5A", "300/1A") Ratio of tertiary phase CT (e.g. "2000/5A", "300/1A") Drawing number of reference diagram Requisition no. Revision no. (Same as ETAP) Routine test required or not Short circuit current withstand level in kA Voltage for short circuit current withstand level in kV Short circuit current withstand level in MVA Short circuit current withstand duration in second
PTPosXoverR PTPosZ PTZeroX PTZeroXoverR PTZeroZ PurchaseOrderNo PurchasingDate Quantity RatedFrequency RatedLoadLoss RatedVANeutCT RatedVAPrimCT RatedVASecCT RatedVATerCT RatioNeutCT RatioPrimCT RatioSecCT RatioTerCT ReferenceDWG RequisitionNo Revision RoutineTest SCCkA SCCkV SCCMVA SCCSec
Number Number Number Number Number Text Text Number Number Number Number Number Number Number Text Text Text Text Text Text Number Yes/No Number Number Number Number

App - I - 69

BIL (Basic Lightning Impulse Insulation Level) of secondary connection in kV 10, 15, 19, 26, 34, 40, 50, 70, 95, 140, 185, 230, 275, 325, 360, 395, 460, 520, 575, 630, 690, 750, 800, 860, 920, 980, 1040, 1090 IEC : 20,40,60,75,95,125,145,150,170,200, 250,325,350,450, 550,650,750,825,850,900,950,1050,1175,1300,1425,1 550,1800,1950 ANSI: 30, 45, 60, 75, 95, 110, 125, 150, 200, 250, 350, 450, 550, 650, 750, 825, 900, 1050, 1175, 1300, 1425, 1550, 1675, 1800, 1925, 2050 Bus duct box for secondary connection required or not Secondary cable duct required or not Conductor type of secondary connection material (e.g. "PVC/SWA", "Thin Copper", "XLPE") Conductor size of secondary connection (e.g. "2000A", "35mm2", "250MCM") Type of secondary connection (e.g. "Exposed bushing ", "Cable Chamber", "Bus Duct") Air Terminal Chamber, Exposed Bushing, Bus Duct, Braided Flex , Flexible Bus Link, Rated kV of secondary winding Power frequency withstand voltage of secondary system in kV Capacity of secondary winding for 3-winding transformer in the unit [MVAbutton] Rated current of secondary neutral grounding facility in ampere 1, 5, 10, 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000, Blank Rated time duration of secondary neutral grounding facility in second 10, 30, 60, 600, Extended Type of neutral grounding of secondary power (e.g. "Resistor", "Solid", "Reactor", etc.) Open, Resistor, Reactor, Solid, Resonant Number of conductors of secondary connection material Number of secondary connections per phase Number of cores of secondary connection material Name (ID) of bus the secondary of transformer connects to. Conductor type of secondary connection (e.g. "Cu", "Al") Cu, Al Circuit wire system of secondary power (e.g. "3ph-3w") 1ph-2W, 1ph-3W, 3ph-3W, 3ph-4W Silica gel breather required or not

App - I - 71

Nominal primary system voltage (kV) 230, 220, 215, 176, 132, 115, 77, 69, 66, 34.5, 33, 30, 24.5, 24, 23, 22, 13.8, 13.2, 12, 11.5, 11, 6.9, 6.6, 6.3, 6, 4.16, 4.0, 3.8, 3.6, 3.45, 3.3, 3, 2.4, 1.0, 0.6, 0.48, 0.46, 0.44, 0.435, 0.415, 0.4, 0.38, 0.25, 0.24, 0.235, 0.23, 0.22 (*), 0.2, 0.12, 0.115, 0.11, 0.1 [blank] Primary system voltage variation "+/-1%", "+/-2%", "+/-3%", "+/-4%", "+/-5%", "+/-6%", "+/-7%", "+/-8%", "+/-10%" (*), <blank> Number of wires for primary circuit system 3 (*), 4 Weight of tank body in kg, ton or lb Type or treatment of tap neutral terminal Installed location of tap changer ("Primary", Secondary", "Tertiary", Primary & Secondary", etc.) Primary, Secondary, Tertiary Temperature rise of insulation oil in deg.C (e.g. 60, 65, etc) IEC : 55, 60, Blank

SysVoltage

186. 187. 188. 189. 190. 191.
SysVoltVariation SysWireSystem TankWeight TapNeutralTerminal TappingWinding TemperatureOil
Text Number Number Text Text Number

TemperatureWinding

ANSI: 55, Blank Temperature rise of winding in deg.C (e.g. 60, 65, etc) IEC (Oil): 65,70 (Dry): 60,75,80,100,125,150 ANSI (Oil): 65 (Dry) 55, 60, 80, 115, 130, 150 Temperature rise in text form for users discrete use BIL (Basic Lightning Impulse Insulation Level) of tertiary connection in kV 10, 15, 19, 26, 34, 40, 50, 70, 95, 140, 185, 230, 275, 325, 360, 395, 460, 520, 575, 630, 690, 750, 800, 860, 920, 980, 1040, 1090 IEC : 20,40,60,75,95,125,145,150,170,200, 250,325,350,450, 550,650,750,825,850,900,950,1050,1175,1300,1425,1 550,1800,1950 ANSI: 30, 45, 60, 75, 95, 110, 125, 150, 200, 250, 350, 450, 550, 650, 750, 825, 900, 1050, 1175, 1300, 1425, 1550, 1675, 1800, 1925, 2050 Bus duct box for tertiary connection required or not Tertiary cable duct required or not Conductor type of tertiary connection material (e.g. "PVC/SWA", "Thin Copper", "XLPE") Conductor size of tertiary connection (e.g. "2000A", "35mm2", "250MCM") Type of tertiary connection (e.g. "Exposed bushing ", "Cable Chamber", "Bus Duct") Rated kV of tertiary winding Power frequency withstand voltage of tertiary system in kV

193. 194.

TempRise TerBIL
195. 196. 197. 198. 199. 200. 201.