ELREGC

Electric Regulator Control Inventory

Field Name

Caption

Mask

Description

Field Type

RG_ACT_CD

Action

nnnn

Last Action

Integer

RG_ACT_TY

Action Text

25x

Last Action Text

Text

RG_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

RG_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

RG_BR_CD

Default WO Cat

10x

Default WO Category Code

Text

RG_BR_TY

Default WO Cat Text

60x

Default WO Category Type

Text

RG_COND_CD

Overall Cond

nnnn

Last Condition

Integer

RG_COND_TY

Overall Cond Text

25x

Last Condition Text

Text

RG_CRT_BY

Created By

25x

Created By

Text

RG_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RG_CTPRIM

CT Primary

nnnnnnnn

CT Primary - Current Transformer (CT) rating of primary side of Regulator

Long Integer

RG_DOC_FLG

Doc Available

 

Doc Available: Doc Flag

Boolean

RG_FTPA_CD

Fuse Primary A

nnnn

Fuse Primary A - 1st House High Protection Phase A - Fuse Type on Primary Side

Integer

RG_FTPA_TY

Fuse Primary A Text

25x

Fuse Primary A Text

Text

RG_FTPB_CD

Fuse Primary B

nnnn

Fuse Primary B - 1st House High Protection Phase B - Fuse Type on Primary Side

Integer

RG_FTPB_TY

Fuse Primary B Text

25x

Fuse Primary B Text

Text

RG_FTPC_CD

Fuse Primary C

nnnn

Fuse Primary C - 1st House High Protection Phase C - Fuse Type on Primary Side

Integer

RG_FTPC_TY

Fuse Primary C Text

25x

Fuse Primary C Text

Text

RG_FTSA_CD

Fuse Second A

nnnn

Fuse Secondary A - 1st House Low Protection Phase A - Fuse Type on Secondary Side

Integer

RG_FTSA_TY

Fuse Second A Text

25x

Fuse Secondary A Text

Text

RG_FTSB_CD

Fuse Second B

nnnn

Fuse Secondary B - 1st House Low Protection Phase B - Fuse Type on Secondary Side

Integer

RG_FTSB_TY

Fuse Second B Text

25x

Fuse Secondary B Text

Text

RG_FTSC_CD

Fuse Second C

nnnn

Fuse Secondary C - 1st House Low Protection Phase C - Fuse Type on Secondary Side

Integer

RG_FTSC_TY

Fuse Second C Text

25x

Fuse Secondary C Text

Text

RG_ID

Regulator Control Rec #

nnnnnnnn

Regulator Control Rec ID

Long Integer

RG_IFREQ

Inspection Frequency

nnn

Inspection Frequency

Small Integer

RG_IFRQ_CD

Inspection Frequency Units

nnn

Inspection Frequency Units

Small Integer

RG_IFRQ_TY

Inspection Frequency Units Text

10x

Inspection Frequency Units Text

String

RG_INMAP

In Map Flag

 

In Map Flag

Boolean

RG_INSP_DT

Last Inspection

mm/dd/yyyy

Last Inspection Date

Date/Time

RG_INSP_TM

Inspection Time

hh:mm am

Last Inspection Time

Date/Time

RG_INST_DT

Installation Date

mm/dd/yyyy

Installation Date

Date/Time

RG_MANU_CD

Manufacturer

10x

Manufacturer

Text

RG_MANU_TY

Manufacturer Text

60x

Manufacturer Text

Text

RG_MOD_BY

Last Modified By

25x

Last Modified By

Text

RG_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

RG_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RG_MODEL

Model

30x

Model

Text

RG_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

RG_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

RG_NMNT_DT

Next Insp Date

mm/dd/yyyy

Next Inspection Date

Date/Time

RG_NOWORK

No WO/PM/Req

 

Not to be used in Work Orders PMs or Requests

Boolean

RG_NUMBER

Regulator Control Number

30x

Regulator Control Number

Text

RG_PTRATIO

PT Ratio

nnnnnnnn

PT Ratio - Potential transformer (PT) ratio used to sense source voltage

Long Integer

RG_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

RG_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

RG_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

RG_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RG_RSA_CD

R Setting A

nnnn

R Setting A - Setting of resistive component of line-drop compensation system - Phase A

Integer

RG_RSA_TY

R Setting A Text

25x

R Setting A Text

Text

RG_RSB_CD

R Setting B

nnnn

R Setting B - Setting of resistive component of line-drop compensation system - Phase B

Integer

RG_RSB_TY

R Setting B Text

25x

R Setting B Text

Text

RG_RSC_CD

R Setting C

nnnn

R Setting C - Setting of resistive component of line-drop compensation system - Phase C

Integer

RG_RSC_TY

R Setting C Text

25x

R Setting C Text

Text

RG_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

RG_SERIAL

Serial Number

30x

Serial Number

Text

RG_STAT_CD

Status

nnnn

Status

Integer

RG_STAT_TY

Status Text

25x

Status Text

Text

RG_STEP

Step Size

nnnnnnnn

Step Size - Size of Steps that voltage regulator has available at full regulation

Long Integer

RG_STYPE_CD

GIS SubType

nnnn

Sub-Type

Integer

RG_STYPE_TY

GIS SubType Text

40x

Sub-Type Text

Text

RG_TSA

Tap Setting A

nnnnnnnn

Tap Setting A - Current tap setting Phase A

Long Integer

RG_TSB

Tap Setting B

nnnnnnnn

Tap Setting B - Current tap setting Phase B

Long Integer

RG_TSC

Tap Setting C

nnnnnnnn

Tap Setting C - Current tap setting Phase C

Long Integer

RG_TYPE_CD

Type

nnnn

Type

Integer

RG_TYPE_TY

Type Text

40x

Type Text

Text

RG_USER10CD

User 10

10x

User 10

Text

RG_USER10TY

User 10 Text

60x

User 10 Text

Text

RG_USER11

User 11

30x

User 11

Text

RG_USER12

User 12

30x

User 12

Text

RG_USER13

User 13

30x

User 13

Text

RG_USER14

User 14

30x

User 14

Text

RG_USER15

User 15

30x

User 15

Text

RG_USER16

User 16

nnnnnnnnn.nn

User 16

Double

RG_USER17

User 17

nnnnnnnnn.nn

User 17

Double

RG_USER18

User 18

nnnnnnnnn.nn

User 18

Double

RG_USER19

User 19

nnnnnnnnn.nn

User 19

Double

RG_USER1CD

User 1

nnnn

User 1

Integer

RG_USER1TY

User 1 Text

25x

User 1 Text

Text

RG_USER20

User 20

nnnnnnnnn.nn

User 20

Double

RG_USER21

User 21

mm/dd/yyyy

User 21

Date/Time

RG_USER22

User 22

mm/dd/yyyy

User 22

Date/Time

RG_USER23

User 23

mm/dd/yyyy

User 23

Date/Time

RG_USER24

User 24

mm/dd/yyyy

User 24

Date/Time

RG_USER25

User 25

mm/dd/yyyy

User 25

Date/Time

RG_USER26

User 26

 

User 26

Boolean

RG_USER27

User 27

 

User 27

Boolean

RG_USER28

User 28

 

User 28

Boolean

RG_USER29

User 29

 

User 29

Boolean

RG_USER2CD

User 2

nnnn

User 2

Integer

RG_USER2TY

User 2 Text

25x

User 2 Text

Text

RG_USER30

User 30

 

User 30

Boolean

RG_USER31CD

User 31

nnn

User 31

Small Integer

RG_USER31TY

User 31 Text

25x

User 31 Text

String

RG_USER32CD

User 32

nnn

User 32

Small Integer

RG_USER32TY

User 32 Text

25x

User 32 Text

String

RG_USER33CD

User 33

nnn

User 33

Small Integer

RG_USER33TY

User 33 Text

25x

User 33 Text

String

RG_USER34CD

User 34

nnn

User 34

Small Integer

RG_USER34TY

User 34 Text

25x

User 34 Text

String

RG_USER35CD

User 35

nnn

User 35

Small Integer

RG_USER35TY

User 35 Text

25x

User 35 Text

String

RG_USER36CD

User 36

10x

User 36

String

RG_USER36TY

User 36 Text

60x

User 36 Text

String

RG_USER37CD

User 37

10x

User 37

String

RG_USER37TY

User 37 Text

60x

User 37 Text

String

RG_USER38CD

User 38

10x

User 38

String

RG_USER38TY

User 38 Text

60x

User 38 Text

String

RG_USER39CD

User 39

10x

User 39

String

RG_USER39TY

User 39 Text

60x

User 39 Text

String

RG_USER3CD

User 3

nnnn

User 3

Integer

RG_USER3TY

User 3 Text

25x

User 3 Text

Text

RG_USER40CD

User 40

10x

User 40

String

RG_USER40TY

User 40 Text

60x

User 40 Text

String

RG_USER41

User 41

30x

User 41

String

RG_USER42

User 42

30x

User 42

String

RG_USER43

User 43

30x

User 43

String

RG_USER44

User 44

30x

User 44

String

RG_USER45

User 45

30x

User 45

String

RG_USER46

User 46

-nnnnnnnn.nn

User 46

Double

RG_USER47

User 47

-nnnnnnnn.nn

User 47

Double

RG_USER48

User 48

-nnnnnnnn.nn

User 48

Double

RG_USER49

User 49

-nnnnnnnn.nn

User 49

Double

RG_USER4CD

User 4

nnnn

User 4

Integer

RG_USER4TY

User 4 Text

25x

User 4 Text

Text

RG_USER50

User 50

-nnnnnnnn.nn

User 50

Double

RG_USER51

User 51

mm/dd/yyyy

User 51

DateTime

RG_USER52

User 52

mm/dd/yyyy

User 52

DateTime

RG_USER53

User 53

mm/dd/yyyy

User 53

DateTime

RG_USER54

User 54

mm/dd/yyyy

User 54

DateTime

RG_USER55

User 55

mm/dd/yyyy

User 55

DateTime

RG_USER56

User 56

 

User 56

Boolean

RG_USER57

User 57

 

User 57

Boolean

RG_USER58

User 58

 

User 58

Boolean

RG_USER59

User 59

 

User 59

Boolean

RG_USER5CD

User 5

nnnn

User 5

Integer

RG_USER5TY

User 5 Text

25x

User 5 Text

Text

RG_USER60

User 60

 

User 60

Boolean

RG_USER6CD

User 6

10x

User 6

Text

RG_USER6TY

User 6 Text

60x

User 6 Text

Text

RG_USER7CD

User 7

10x

User 7

Text

RG_USER7TY

User 7 Text

60x

User 7 Text

Text

RG_USER8CD

User 8

10x

User 8

Text

RG_USER8TY

User 8 Text

60x

User 8 Text

Text

RG_USER9CD

User 9

10x

User 9

Text

RG_USER9TY

User 9 Text

60x

User 9 Text

Text

RG_VSA

Voltage Setting A

nnnnnnnn

Voltage Setting A - Voltage setting Phase A

Long Integer

RG_VSB

Voltage Setting B

nnnnnnnn

Voltage Setting B - Voltage setting Phase B

Long Integer

RG_VSC

Voltage Setting C

nnnnnnnn

Voltage Setting C - Voltage setting Phase C

Long Integer

RG_WO_COMM

WO Comment

250x

WO Comment

Text

RG_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

RG_XSA

X Setting A

nnnnnnnn

X Setting A - Setting of resistaive component of line-drop compensation system Phase A

Long Integer

RG_XSB

X Setting B

nnnnnnnn

X Setting B - Setting of resistaive component of line-drop compensation system Phase B

Long Integer

RG_XSC

X Setting C

nnnnnnnn

X Setting C - Setting of resistaive component of line-drop compensation system Phase C

Long Integer

RG_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

RG_YEAR

Year Manufactured

30x

Year Manufactured

Text

RG_Z

Z Elevation

nnnnnnnnn.nn

Z Elevation

Double