STSNOWSHOE

Snow Shoes Inventory

Field Name

Caption

Mask

Description

Field Type

SS_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

SS_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

SS_BR_CD

Default WO Cat

10x

Default Category Code

Text

SS_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

SS_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

SS_CRT_BY

Created By

25x

Created By

Text

SS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

SS_DOC_FLG

Document Available

 

Document Available

Boolean

SS_EXCESS

Excess Cable

nnn.nn

Excess Cable

Double

SS_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

SS_GPS

 

 

GPS Flag

Boolean

SS_ID

Snow Shoe Rec #

nnnnnnnn

Snow Shoe No.

Long Integer

SS_IMG_FLG

 

 

Image Available

Boolean

SS_INMAP

In Map

 

In Map Flag

Boolean

SS_INST_DT

Installation Date

mm/dd/yyyy

Installation Date

Date/Time

SS_LOC_CD

Location

nnn

Location

Integer

SS_LOC_TY

Location Text

25x

Location Text

Text

SS_MANUF

Manufacturer

30x

Manufacturer

Text

SS_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

SS_MOD_BY

Last Modified By

25x

Last Modified By

Text

SS_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

SS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

SS_MODEL

Model No

30x

Model No

Text

SS_MOV_FLG

 

 

Movie Available

Boolean

SS_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

SS_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

SS_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

SS_NUMBER

Alt Snow Shoe ID

20x

Alt. Snow Shoe ID

Text

SS_OWN_CD

Owner

nnn

Owner

Integer

SS_OWN_TY

Owner Text

25x

Owner Text

Text

SS_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

SS_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

SS_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

SS_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

SS_RISK

Risk

nnnn.

Risk - COF * POF

Double

SS_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

SS_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

SS_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

SS_SIZE

Size

nnn.nn

Size

Double

SS_STAT_CD

Status

nnn

Status

Integer

SS_STAT_TY

Status Text

25x

Status Text

Text

SS_STYPE_CD

Sub Type

nnn

Sub Type

Integer

SS_STYPE_TY

Sub Type Text

25x

Sub Type Text

Text

SS_TRUNK

Trunk

30x

Trunk

Text

SS_TYPE_CD

Type

nnn

Type

Integer

SS_TYPE_TY

Type Text

25x

Type Text

Text

SS_USER1CD

User 1

nnn

User 1

Integer

SS_USER1TY

User 1 Text

50x

User 1 Text

String

SS_USER2CD

User 2

nnn

User 2

Integer

SS_USER2TY

User 2 Text

50x

User 2 Text

String

SS_USER3CD

User 3

nnn

User 3

Integer

SS_USER3TY

User 3 Text

50x

User 3 Text

String

SS_USER4CD

User 4

nnn

User 4

Integer

SS_USER4TY

User 4 Text

50x

User 4 Text

String

SS_USER5CD

User 5

nnn

User 5

Integer

SS_USER5TY

User 5 Text

50x

User 5 Text

String

SS_USER6

User 6

50x

User 6

String

SS_USER7

User 7

50x

User 7

String

SS_USER8

User 8

50x

User 8

String

SS_USER9

User 9

50x

User 9

String

SS_USER10

User 10

50x

User 10

String

SS_USER11

User 11

nnnnnnnn.nn

User 11

Double

SS_USER12

User 12

nnnnnnnn.nn

User 12

Double

SS_USER13

User 13

nnnnnnnn.nn

User 13

Double

SS_USER14

User 14

nnnnnnnn.nn

User 14

Double

SS_USER15

User 15

nnnnnnnn.nn

User 15

Double

SS_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

SS_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

SS_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

SS_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

SS_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

SS_USER21

User 21

 

User 21

Boolean

SS_USER22

User 22

 

User 22

Boolean

SS_USER23

User 23

 

User 23

Boolean

SS_USER24

User 24

 

User 24

Boolean

SS_USER25

User 25

 

User 25

Boolean

SS_WO_COMM

WO Comment

255x

WO Comment

Text

SS_X

X Coordinate

nnnnnnnn.nn

X Coordinate

Double

SS_Y

Y Coordinate

nnnnnnnn.nn

Y Coordinate

Double