STBSINV

Bus Stop Inventory

Field Name

Caption

Mask

Description

Field Type

BS_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

BS_ADR_B22

Street Post Bldg No 2

8x

Street Post Building No 2

Text

BS_ADR_BDG

Address

nnnnnn

Address

Long Integer

BS_ADR_DIR

Street Direction

2x

Street Direction

Text

BS_ADR_PT

Street Prefix Type

5x

Street Prefix

Text

BS_ADR_SFX

Street Suffix

5x

Street Suffix

Text

BS_ADR_STR

Street Name

50x

Street Name

Text

BS_ADR_TY

Street Type

5x

Street Type

Text

BS_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix

Text

BS_ADRBDG2

Address

nnnnnn

Address

Long Integer

BS_ADRDIR2

Address2 Direction

2x

Address2 Direction

Text

BS_ADRSFX2

Address2 Suffix

5x

Address2 Suffix

Text

BS_ADRSTR2

Address2 Name

50x

Address2 Name

Text

BS_ADRTY2

Address2 Type

5x

Address2 Type

Text

BS_ATTR1

Attribute 1

30x

Attribute 1

Text

BS_ATTR10

Attribute 10

30x

Attribute 10

Text

BS_ATTR11

Attribute 11

30x

Attribute 11

Text

BS_ATTR12

Attribute 12

30x

Attribute 12

Text

BS_ATTR13

Attribute 13

30x

Attribute 13

Text

BS_ATTR14

Attribute 14

30x

Attribute 14

Text

BS_ATTR15

Attribute 15

30x

Attribute 15

Text

BS_ATTR16

Attribute 16

30x

Attribute 16

Text

BS_ATTR17

Attribute 17

30x

Attribute 17

Text

BS_ATTR18

Attribute 18

30x

Attribute 18

Text

BS_ATTR19

Attribute 19

30x

Attribute 19

Text

BS_ATTR2

Attribute 2

30x

Attribute 2

Text

BS_ATTR20

Attribute 20

30x

Attribute 20

Text

BS_ATTR3

Attribute 3

30x

Attribute 3

Text

BS_ATTR4

Attribute 4

30x

Attribute 4

Text

BS_ATTR5

Attribute 5

30x

Attribute 5

Text

BS_ATTR6

Attribute 6

30x

Attribute 6

Text

BS_ATTR7

Attribute 7

30x

Attribute 7

Text

BS_ATTR8

Attribute 8

30x

Attribute 8

Text

BS_ATTR9

Attribute 9

30x

Attribute 9

Text

BS_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

BS_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

BS_BR_CD

Default WO Cat

10x

Default Category Code

Text

BS_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

BS_CITY_CD

Facility

nnn

Facility

Integer

BS_CITY_TY

Facility Text

50x

Facility Text

Text

BS_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

BS_COND_CD

Overall Cond

nnn

Condition

Integer

BS_COND_TY

Overall Cond Text

25x

Condition Text

Text

BS_CRT_BY

Created By

25x

Created By

Text

BS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BS_CS

Curr Station

nnnnnnnn.nnn

Current Stationing

Double

BS_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

BS_DRAWNO

Drawing #

30x

Drawing #

Text

BS_ENCL_CD

Enclosure

nnn

Enclosure

Integer

BS_ENCL_TY

Enclosure Text

25x

Enclosure Text

Text

BS_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

BS_FLAG

Flag

 

Flag

Boolean

BS_FURN_CD

Furniture

nnn

Furniture

Integer

BS_FURN_TY

Furniture Text

25x

Furniture Text

Text

BS_GPS

GPS Flag

 

GPS Flag

Boolean

BS_GPS_TM

GPS Time

hh:mm am

GPS Time

Date/Time

BS_GPSDATE

GPS Date

mm/dd/yyyy

GPS Date

Date/Time

BS_ID

Bus Stop Rec #

nnnnnnnn

Record Number

Long Integer

BS_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

BS_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

BS_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

BS_IMG_FLG

 

 

Image Available

Boolean

BS_INMAP

In Map

 

 

Boolean

BS_INST_DT

Date Installed

mm/dd/yyyy

Date Installed

Date/Time

BS_INSTBY

Installed By

30x

Installed By

Text

BS_INT_ID

Intersection Rec #

nnnnnnnn

Link to INTNET.IN_ID

Long Integer

BS_LINSPDT

Last Inspection

mm/dd/yyyy

Last Inspection

Date/Time

BS_LOC

Location

100x

Location

Text

BS_MAIN_CD

Maintained By

nnn

Maintained By

Integer

BS_MAIN_TY

Maintained By Text

25x

Maintained By Text

Text

BS_MAPNO

Map Number

30x

Map Number

Text

BS_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

BS_MOD_BY

Last Modified By

25x

Last Modified By

Text

BS_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

BS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BS_MOV_FLG

 

 

Movie Available

Boolean

BS_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

BS_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

BS_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

BS_NUM

Alt Bus Stop ID

20x

Alt ID

Text

BS_NXTINSP

Next Inspection

mm/dd/yyyy

Next Inspection

Date/Time

BS_OS

Org. Station

nnnnnnnn.nnn

Original Stationing

Double

BS_OWN_CD

Owner

nnn

Owner

Integer

BS_OWN_TY

Owner Text

25x

Owner Text

Text

BS_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

BS_PROJNO

Project Number

30x

Project Number

Text

BS_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

BS_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

BS_REPL_DT

Replacement

mm/dd/yyyy

Replacement

Date/Time

BS_REPLEST

Replace Est

nnnnn.n

Replace Est

Double

BS_RH_ID

Road Rec #

nnnnnnnn

Link to STRDROAD.RH_ID

Long Integer

BS_RISK

Risk

nnnn.

Risk - COF * POF

Double

BS_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

BS_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BS_RP

Ref Post

nnnnnnnn.nnn

Reference Post

Double

BS_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

BS_SB_ID

Subsegment Rec #

nnnnnnnn

Link to STSUBSEG.SB_ID

Long Integer

BS_SIGN_CD

Sign

nnn

Sign

Integer

BS_SIGN_TY

Sign Text

25x

Sign Text

Text

BS_SLOC_CD

Street Location

nnn

Street Location

Integer

BS_SLOC_TY

Street Location Text

25x

Street Location Text

Text

BS_SN_ID

Segment Rec #

nnnnnnnn

Link to STNET.SN_ID

Long Integer

BS_SORCECD

Info Source

nnn

Info Source

Integer

BS_SORCETY

Info Source Text

25x

Info Source Text

Text

BS_SP_ID

Superseg Rec #

nnnnnnnn

Link to STSUPER.SP_ID

Long Integer

BS_STAT_CD

Status

nnn

Status

Integer

BS_STAT_TY

Status Text

25x

Status Text

Text

BS_STYPE_CD

Sub-Type

nnn

Sub-Type

Integer

BS_STYPE_TY

Sub-Type Text

25x

Sub-Type Text

Text

BS_TYPE_CD

Type

nnn

Type

Integer

BS_TYPE_TY

Type Text

25x

Type Text

Text

BS_USER1CD

User 1

nnn

User 1

Integer

BS_USER1TY

User 1 Text

25x

User 1 Text

Text

BS_USER2CD

User 2

nnn

User 2

Integer

BS_USER2TY

User 2 Text

25x

User 2 Text

Text

BS_USER3CD

User 3

nnn

User 3

Integer

BS_USER3TY

User 3 Text

25x

User 3 Text

Text

BS_USER4

User 4

30x

User 4

Text

BS_USER5

User 5

30x

User 5

Text

BS_USER6

User 6

30x

User 6

Text

BS_USER7

User 7

nnnnnnnn.nn

User 7

Double

BS_USER8

User 8

nnnnnnnn.nn

User 8

Double

BS_USER9

User 9

nnnnnnnn.nn

User 9

Double

BS_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

BS_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

BS_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

BS_USER13

User 13

 

User 13

Boolean

BS_USER14

User 14

 

User 14

Boolean

BS_USER15

User 15

 

User 15

Boolean

BS_USER16CD

User 16

nnn

User 16

Integer

BS_USER16TY

User 16 Text

50x

User 16 Text

String

BS_USER17CD

User 17

nnn

User 17

Integer

BS_USER17TY

User 17 Text

50x

User 17 Text

String

BS_USER18CD

User 18

nnn

User 18

Integer

BS_USER18TY

User 18 Text

50x

User 18 Text

String

BS_USER19CD

User 19

nnn

User 19

Integer

BS_USER19TY

User 19 Text

50x

User 19 Text

String

BS_USER20CD

User 20

nnn

User 20

Integer

BS_USER20TY

User 20 Text

50x

User 20 Text

String

BS_USER21

User 21

50x

User 21

String

BS_USER22

User 22

50x

User 22

String

BS_USER23

User 23

50x

User 23

String

BS_USER24

User 24

50x

User 24

String

BS_USER25

User 25

50x

User 25

String

BS_USER26

User 26

nnnnnnnn.nn

User 26

Double

BS_USER27

User 27

nnnnnnnn.nn

User 27

Double

BS_USER28

User 28

nnnnnnnn.nn

User 28

Double

BS_USER29

User 29

nnnnnnnn.nn

User 29

Double

BS_USER30

User 30

nnnnnnnn.nn

User 30

Double

BS_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

BS_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

BS_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

BS_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

BS_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

BS_USER36

User 36

 

User 36

Boolean

BS_USER37

User 37

 

User 37

Boolean

BS_USER38

User 38

 

User 38

Boolean

BS_USER39

User 39

 

User 39

Boolean

BS_USER40

User 40

 

User 40

Boolean

BS_WO_COMM

WO Comment

255x

WO Comment

Text

BS_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

BS_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

BS_Z

Elevation

nnnnn.nn

Elevation

Double