ELVREGL

Electric Voltage Regulator Location Inventory

Field Name

Caption

Mask

Description

Field Type

VL_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

VL_ADR_BDG

Address

nnnnnn

Address

Long Integer

VL_ADR_DIR

Street Direction

2x

Street Direction

Text

VL_ADR_PT

Street Prefix Type

5x

Street Prefix

Text

VL_ADR_SFX

Street Suffix

5x

Street Suffix

Text

VL_ADR_STR

Street Name

50x

Street Name

Text

VL_ADR_TY

Street Type

5x

Street Type

Text

VL_ADR2_PT

Cross Street Prefix Type

5x

Street 2 Prefix

Text

VL_ADRDIR2

Cross Street

2x

Address2 Direction

Text

VL_ADRSFX2

Cross Street Suffix

5x

Address2 Suffix

Text

VL_ADRSTR2

Cross Street Name

50x

Address2 Name

Text

VL_ADRTY2

Cross Street Type

5x

Address2 Type

Text

VL_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

VL_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

VL_BOOS_CD

Boost Percent

nnnn

Boost Percent - tap setting for increase in capacity acheived by raising the maximum voltage level

Integer

VL_BOOS_TY

Boost Percent Text

25x

Boost Percent Text

Text

VL_BR_CD

Default WO Cat

10x

Default WO Category Code

Text

VL_BR_TY

Default WO Cat Text

60x

Default WO Category Type

Text

VL_BUCK_CD

Buck Percent

nnnn

Buck Percent - tap setting for increase in capacity acheived by lowering the minimum voltage level

Integer

VL_BUCK_TY

Buck Percent Text

25x

Buck Percent Text

Text

VL_BYPA_CD

Bypass Switch

nnnn

Bypass Switch

Integer

VL_BYPA_TY

Bypass Switch Text

25x

Bypass Switch Text

Text

VL_CITY_CD

City

nnnn

Facility

Integer

VL_CITY_TY

City Text

50x

Facility Text

Text

VL_CRT_BY

Created By

25x

Created By

Text

VL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

VL_DOC_FLG

Doc Available

 

Doc Available: Doc Flag

Boolean

VL_DRAWNO

Drawing #

30x

Drawing #

Text

VL_ES_ID

Electric Station Rec #

nnnnnnnn

Link to ELSTAT.ES_ID

Long Integer

VL_FACI_ID

Facility ID

30x

Facility ID

Text

VL_FEED

Feeder ID

30x

Feeder ID - Feeder manager identifier assigned to feeders and devices that participate in a specific distribution circuit

Text

VL_FEED2

Feeder 2 ID

30x

Feeder 2 ID - Feeder Manager identifier assigned if device is supplied by second feeder

Text

VL_FI_CD

Feeder Info

nnnn

Feeder Info - Feeder Manager-assigned phase information describing the phase of the circuit

Integer

VL_FI_TY

Feeder Info Text

25x

Feeder Info Text

Text

VL_GRNDREA

Ground Reactance

nnnnnnnnn

Ground Reactance, in ohms

Long Integer

VL_GRNDRES

Ground Resistance

nnnnnnnnn

Ground Resistance, in ohms

Long Integer

VL_HSC_CD

H Side Config

nnnn

High Side Configuration - configuration of primary side of transformer

Integer

VL_HSC_TY

H Side Config Text

25x

High Side Configuration Text

Text

VL_HSGREA

HS Ground React

nnnnnnnnn

High Side Ground Reactance, in ohms

Long Integer

VL_HSGRES

HS Ground Resist

nnnnnnnnn

High Side Ground Resistance, in ohms

Long Integer

VL_HSP_CD

H Side Protect

nnnn

High Side Protection - Type of Overcurrent protection used at the primary side of Transformer

Integer

VL_HSP_TY

H Side Protect Text

25x

High Side Protection Text

Text

VL_ID

Volt Reg Loc Rec #

nnnnnnnn

Voltage Regulator Location Rec ID

Long Integer

VL_INMAP

In Map Flag

 

In Map Flag

Boolean

VL_INST_DT

Installation Date

mm/dd/yyyy

Installation Date

Date/Time

VL_LOC_CD

Location Type

nnnn

Location Type

Integer

VL_LOC_TY

Location Type Text

25x

Location Type Text

Text

VL_LOCATION

Location

75x

General Location

Text

VL_LTEXT

Label Text

30x

Label Text - provides text for line annotation

Text

VL_MAPNO

Map Number

30x

Map Number

Text

VL_MOD_BY

Last Modified By

25x

Last Modified By

Text

VL_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

VL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

VL_MREA

Magnetic Reactance

nnnnnnnnn.nn

Magnetic Reactance, in ohms

Double

VL_MRES

Magnetic Resistance

nnnnnnnnn.nn

Magnetic Resistance, in ohms

Double

VL_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

VL_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

VL_NOTE

Note

254x

Note - User or designer comments

Text

VL_NOWORK

No WO/PM/Req

 

Not to be used in Work Orders PMs or Requests

Boolean

VL_NUMBER

Volt Reg Loc Number

30x

Voltage Regulator Location Number

Text

VL_NVLT_CD

Nominal Voltage

nnnn

Nominal Voltage

Integer

VL_NVLT_TY

Nominal Voltage Text

25x

Nominal Voltage Text

Text

VL_OP_ID

Open Point Rec #

nnnnnnnn

Link to ELOPNT.OP_ID

Long Integer

VL_OVLT_CD

Operating Voltage

nnnn

Operating Voltage

Integer

VL_OVLT_TY

Operating Voltage Text

25x

Operating Voltage Text

Text

VL_PHAS_CD

Phase Designation

nnnn

Phase Designation

Integer

VL_PHAS_TY

Phase Designation Text

25x

Phase Designation Text

Text

VL_POSTAL

Zip Code

30x

Zip Code

Text

VL_RKVA_CD

Rated kVA A

nnnn

Rated kVA-A - Sum of Rated kVA-A of related transformer units per phase

Integer

VL_RKVA_TY

Rated kVA A Text

25x

Rated kVA-A Text

Text

VL_RKVB_CD

Rated kVA B

nnnn

Rated kVA-B - Sum of Rated kVA-B of related transformer units per phase

Integer

VL_RKVB_TY

Rated kVA B Text

25x

Rated kVA-B Text

Text

VL_RKVC_CD

Rated kVA C

nnnn

Rated kVA-C - Sum of Rated kVA-C of related transformer units per phase

Integer

VL_RKVC_TY

Rated kVA C Text

25x

Rated kVA-C Text

Text

VL_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

VL_SF_ID

Switching Station Rec #

nnnnnnnn

Link to ELSSWT.SF_ID

Long Integer

VL_SP_ID

Support Struct Rec #

nnnnnnnn

Link to ELSSTR.SP_ID

Long Integer

VL_SR_ID

Surface Struct Rec #

nnnnnnnn

Link to ELSSRF.SR_ID

Long Integer

VL_ST_LOC

Street Location

20x

Street Location

Text

VL_STAT_CD

Status

nnnn

Status

Integer

VL_STAT_TY

Status Text

25x

Status Text

Text

VL_STYPE_CD

GIS SubType

nnnn

Sub-Type

Integer

VL_STYPE_TY

GIS SubType Text

40x

Sub-Type Text

Text

VL_SYMBR

Symbol Rotation

nnnnnnnnn.nn

Symbol Rotation

Double

VL_TW_CD

Trace Weight

nnnn

Trace Weight - Used by Feeder Manager to determine device status and other information that affects circuit connectivity

Integer

VL_TW_TY

Trace Weight Text

25x

Trace Weight Text

Text

VL_TYPE_CD

Type

nnnn

Type

Integer

VL_TYPE_TY

Type Text

40x

Type Text

Text

VL_UN_ID

Underground Struct Rec #

nnnnnnnn

Link to ELUNDG.UN_ID

Long Integer

VL_USER10CD

User 10

10x

User 10

Text

VL_USER10TY

User 10 Text

60x

User 10 Text

Text

VL_USER11

User 11

30x

User 11

Text

VL_USER12

User 12

30x

User 12

Text

VL_USER13

User 13

30x

User 13

Text

VL_USER14

User 14

30x

User 14

Text

VL_USER15

User 15

30x

User 15

Text

VL_USER16

User 16

nnnnnnnnn.nn

User 16

Double

VL_USER17

User 17

nnnnnnnnn.nn

User 17

Double

VL_USER18

User 18

nnnnnnnnn.nn

User 18

Double

VL_USER19

User 19

nnnnnnnnn.nn

User 19

Double

VL_USER1CD

User 1

nnnn

User 1

Integer

VL_USER1TY

User 1 Text

25x

User 1 Text

Text

VL_USER20

User 20

nnnnnnnnn.nn

User 20

Double

VL_USER21

User 21

mm/dd/yyyy

User 21

Date/Time

VL_USER22

User 22

mm/dd/yyyy

User 22

Date/Time

VL_USER23

User 23

mm/dd/yyyy

User 23

Date/Time

VL_USER24

User 24

mm/dd/yyyy

User 24

Date/Time

VL_USER25

User 25

mm/dd/yyyy

User 25

Date/Time

VL_USER26

User 26

 

User 26

Boolean

VL_USER27

User 27

 

User 27

Boolean

VL_USER28

User 28

 

User 28

Boolean

VL_USER29

User 29

 

User 29

Boolean

VL_USER2CD

User 2

nnnn

User 2

Integer

VL_USER2TY

User 2 Text

25x

User 2 Text

Text

VL_USER30

User 30

 

User 30

Boolean

VL_USER31CD

User 31

nnn

User 31

Small Integer

VL_USER31TY

User 31 Text

25x

User 31 Text

String

VL_USER32CD

User 32

nnn

User 32

Small Integer

VL_USER32TY

User 32 Text

25x

User 32 Text

String

VL_USER33CD

User 33

nnn

User 33

Small Integer

VL_USER33TY

User 33 Text

25x

User 33 Text

String

VL_USER34CD

User 34

nnn

User 34

Small Integer

VL_USER34TY

User 34 Text

25x

User 34 Text

String

VL_USER35CD

User 35

nnn

User 35

Small Integer

VL_USER35TY

User 35 Text

25x

User 35 Text

String

VL_USER36CD

User 36

10x

User 36

String

VL_USER36TY

User 36 Text

60x

User 36 Text

String

VL_USER37CD

User 37

10x

User 37

String

VL_USER37TY

User 37 Text

60x

User 37 Text

String

VL_USER38CD

User 38

10x

User 38

String

VL_USER38TY

User 38 Text

60x

User 38 Text

String

VL_USER39CD

User 39

10x

User 39

String

VL_USER39TY

User 39 Text

60x

User 39 Text

String

VL_USER3CD

User 3

nnnn

User 3

Integer

VL_USER3TY

User 3 Text

25x

User 3 Text

Text

VL_USER40CD

User 40

10x

User 40

String

VL_USER40TY

User 40 Text

60x

User 40 Text

String

VL_USER41

User 41

30x

User 41

String

VL_USER42

User 42

30x

User 42

String

VL_USER43

User 43

30x

User 43

String

VL_USER44

User 44

30x

User 44

String

VL_USER45

User 45

30x

User 45

String

VL_USER46

User 46

-nnnnnnnn.nn

User 46

Double

VL_USER47

User 47

-nnnnnnnn.nn

User 47

Double

VL_USER48

User 48

-nnnnnnnn.nn

User 48

Double

VL_USER49

User 49

-nnnnnnnn.nn

User 49

Double

VL_USER4CD

User 4

nnnn

User 4

Integer

VL_USER4TY

User 4 Text

25x

User 4 Text

Text

VL_USER50

User 50

-nnnnnnnn.nn

User 50

Double

VL_USER51

User 51

mm/dd/yyyy

User 51

DateTime

VL_USER52

User 52

mm/dd/yyyy

User 52

DateTime

VL_USER53

User 53

mm/dd/yyyy

User 53

DateTime

VL_USER54

User 54

mm/dd/yyyy

User 54

DateTime

VL_USER55

User 55

mm/dd/yyyy

User 55

DateTime

VL_USER56

User 56

 

User 56

Boolean

VL_USER57

User 57

 

User 57

Boolean

VL_USER58

User 58

 

User 58

Boolean

VL_USER59

User 59

 

User 59

Boolean

VL_USER5CD

User 5

nnnn

User 5

Integer

VL_USER5TY

User 5 Text

25x

User 5 Text

Text

VL_USER60

User 60

 

User 60

Boolean

VL_USER6CD

User 6

10x

User 6

Text

VL_USER6TY

User 6 Text

60x

User 6 Text

Text

VL_USER7CD

User 7

10x

User 7

Text

VL_USER7TY

User 7 Text

60x

User 7 Text

Text

VL_USER8CD

User 8

10x

User 8

Text

VL_USER8TY

User 8 Text

60x

User 8 Text

Text

VL_USER9CD

User 9

10x

User 9

Text

VL_USER9TY

User 9 Text

60x

User 9 Text

Text

VL_VR_ID

Voltage Reg Rec #

nnnnnnnn

Link to ELVREG.VR_ID

Long Integer

VL_WO_COMM

WO Comment

250x

WO Comment

Text

VL_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

VL_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

VL_Z

Z Elevation

nnnnnnnnn.nn

Z Elevation

Double