STPREEMPT

Preempt Signal Inventory

Field Name

Caption

Mask

Description

Field Type

PR_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

PR_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

PR_BR_CD

Default WO Cat

10x

Default Category Code

Text

PR_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

PR_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

PR_CRT_BY

Created By

25x

Created By

Text

PR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PR_CT_ID

Conduit Rec #

nnnnnnnn

Link to STCONDUIT.CT_ID

Long Integer

PR_DIA

Diameter

nnn.nn

Diameter

Double

PR_DOC_FLG

Document Available

 

Document Available

Boolean

PR_ID

Preempt Rec #

nnnnnnnn

Preempt No.

Long Integer

PR_IMG_FLG

 

 

Image Available

Boolean

PR_INMAP

In Map

 

In Map Flag

Boolean

PR_INST_DT

Installation Date

mm/dd/yyyy

Installation Date

Date/Time

PR_LOC_CD

Location

nnn

Location

Integer

PR_LOC_TY

Location Text

25x

Location Text

Text

PR_MAT_CD

Material

nnn

Material

Integer

PR_MAT_TY

Material Text

25x

Material Text

Text

PR_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

PR_ML_ID

Main Line Rec #

nnnnnnnn

Link to STMAINLINE.ML_ID

Long Integer

PR_MOD_BY

Last Modified By

25x

Last Modified By

Text

PR_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

PR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PR_MOV_FLG

 

 

Movie Available

Boolean

PR_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

PR_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

PR_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

PR_NUMBER

Alt Preempt ID

20x

Alt. Preempt ID

Text

PR_OWN_CD

Owner

nnn

Owner

Integer

PR_OWN_TY

Owner Text

25x

Owner Text

Text

PR_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

PR_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

PR_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

PR_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

PR_RISK

Risk

nnnn.

Risk - COF * POF

Double

PR_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

PR_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

PR_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

PR_STAT_CD

Status

nnn

Status

Integer

PR_STAT_TY

Status Text

25x

Status Text

Text

PR_STYPE_CD

Sub Type

nnn

Sub Type

Integer

PR_STYPE_TY

Sub Type Text

25x

Sub Type Text

Text

PR_USER1_CD

User 1

nnn

User 1

Integer

PR_USER1_TY

User 1 Text

25x

User 1 Text

Text

PR_USER2

User 2

nnn

User 2

Integer

PR_USER3CD

User 3

nnn

User 3

Integer

PR_USER3TY

User 3 Text

50x

User 3 Text

String

PR_USER4CD

User 4

nnn

User 4

Integer

PR_USER4TY

User 4 Text

50x

User 4 Text

String

PR_USER5CD

User 5

nnn

User 5

Integer

PR_USER5TY

User 5 Text

50x

User 5 Text

String

PR_USER6CD

User 6

nnn

User 6

Integer

PR_USER6TY

User 6 Text

50x

User 6 Text

String

PR_USER7CD

User 7

nnn

User 7

Integer

PR_USER7TY

User 7 Text

50x

User 7 Text

String

PR_USER8

User 8

50x

User 8

String

PR_USER9

User 9

50x

User 9

String

PR_USER10

User 10

50x

User 10

String

PR_USER11

User 11

50x

User 11

String

PR_USER12

User 12

50x

User 12

String

PR_USER13

User 13

nnnnnnnn.nn

User 13

Double

PR_USER14

User 14

nnnnnnnn.nn

User 14

Double

PR_USER15

User 15

nnnnnnnn.nn

User 15

Double

PR_USER16

User 16

nnnnnnnn.nn

User 16

Double

PR_USER17

User 17

nnnnnnnn.nn

User 17

Double

PR_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

PR_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

PR_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

PR_USER21

User 21

mm/dd/yyyy hh:mm am

User 21

DateTime

PR_USER22

User 22

mm/dd/yyyy hh:mm am

User 22

DateTime

PR_USER23

User 23

 

User 23

Boolean

PR_USER24

User 24

 

User 24

Boolean

PR_USER25

User 25

 

User 25

Boolean

PR_USER26

User 26

 

User 26

Boolean

PR_USER27

User 27

 

User 27

Boolean

PR_WO_COMM

WO Comment

255x

WO Comment

Text

PR_X

X Coordinate

nnnnnnnn.nn

X Coordinate

Double

PR_Y

Y Coordinate

nnnnnnnn.nn

Y Coordinate

Double