STBRINS

Bridge Inspections

Field Name

Caption

Mask

Description

Field Type

BI_113_CD

Scour Critical

1x

Scour Critical Bridges

Text

BI_113_TY

Scour Critical Text

60x

Scour Critical Bridges Text

Text

BI_36A_CD

Bridge Railings

1x

Bridge Railings

Text

BI_36A_TY

Bridge Railings Text

60x

Bridge Railings Text

Text

BI_36B_CD

Transitions

1x

Transitions

Text

BI_36B_TY

Transitions Text

60x

Transitions Text

Text

BI_36C_CD

Approach Guardrail

1x

Approach Guardrail

Text

BI_36C_TY

Approach Guardrail Text

60x

Approach Guardrail Text

Text

BI_36D_CD

Approach GR Ends

1x

Approach Guardrail Ends

Text

BI_36D_TY

Approach GR Ends Text

60x

Approach Guardrail Ends Text

Text

BI_58_1

1.Wearing Surface

1x

58.1 - Deck - Wearing Surface Condition

Text

BI_58_10

10.Utilities

1x

58.10 - Deck - Utilities Condition

Text

BI_58_11

11.Expansion Joints

1x

58.11 - Deck - Expansion Joints or Devices Condition

Text

BI_58_2

2.Deck Struct Cond

1x

58.2 - Deck - Structural Condition

Text

BI_58_3

3.Curbs

1x

58.3 - Deck - Curbs Condition

Text

BI_58_4

4.Median

1x

58.4 - Deck - Median Condition

Text

BI_58_5

5.Sidewalks

1x

58.5 - Deck - Sidewalks Condition

Text

BI_58_6

6.Parapet

1x

58.6 - Deck - Parapet Condition

Text

BI_58_7

7.Railing

1x

58.7 - Deck - Railing Condition

Text

BI_58_8

8.Drains

1x

58.8 - Deck - Drains Condition

Text

BI_58_9

9.Lighting

1x

58.9 - Deck - Lighting Condition

Text

BI_58_CD

Deck Condition

1x

Deck Condition Code

Text

BI_58_TY

Deck Condition Text

60x

Deck Condition Text

Text

BI_59_1

1.Bearing Devices

1x

59.1 - Superstructure - Bearing Devices Condition

Text

BI_59_2

2.Stringers

1x

59.2 - Superstructure - Stringers Condition

Text

BI_59_3A

3a.Girders-General

1x

59.3a - Superstructure - Girder or Beams General Condition

Text

BI_59_3B

3b.Girders-Diaphrams

1x

59.3b - Superstructure - Girder or Beams Diaphragms or Cross Frames Condition

Text

BI_59_3C

3c.Girders-Bracing

1x

59.3c - Superstructure - Girder or Beams Bracing Condition

Text

BI_59_4

4.Floor Beams

1x

59.4 - Superstructure - Floor Beams Condition

Text

BI_59_5A

5a.Trusses-General

1x

59.5a - Superstructure - Trusses General Condition

Text

BI_59_5B

5b.Trusses-Portals

1x

59.5b - Superstructure - Trusses Portals Condition

Text

BI_59_5C

5c.Trusses-Bracing

1x

59.5c - Superstructure - Trusses Bracing Condition

Text

BI_59_6

6.Paint

1x

59.6 - Superstructure - Paint Condition

Text

BI_59_7

7.Machinery

1x

59.7 - Superstructure - Machinery Condition (movable span)

Text

BI_59_CD

Superstructure Cond

1x

Superstructure Condition Code

Text

BI_59_TY

Superstructure Cond Text

60x

Superstructure Condition Text

Text

BI_60_1A

1a.Abutment-Wings

1x

60.1a - Substructure - Abutments - Wings Condition

Text

BI_60_1B

1b.Abutment-Backwall

1x

60.1b - Substructure - Abutments - Backwall Condition

Text

BI_60_1C

1c.Abutment-BearingSeats

1x

60.1c - Substructure - Abutments - Bearing Seats Condition

Text

BI_60_1D

1d.Abutment-BreastWall

1x

60.1d - Substructure - Abutments - Breast Wall Condition

Text

BI_60_1E

1e.Abutment-WeepHoles

1x

60.1e - Substructure - Abutments - Weep Holes Condition

Text

BI_60_1F

1f.Abutment-Footing

1x

60.1f - Substructure - Abutments - Footing Condition

Text

BI_60_1G

1g.Abutment-Piles

1x

60.1g - Substructure - Abutments - Piles Condition

Text

BI_60_1H

1h.Abutment-Erosion

1x

60.1h - Substructure - Abutments - Erosion or Scour Condition

Text

BI_60_1I

1i.Abutment-Settlement

1x

60.1i - Substructure - Abutments - Settlement Condition

Text

BI_60_2A

2a.Pier-Caps

1x

60.2a - Substructure - Piers or Bents - Caps Condition

Text

BI_60_2B

2b.Pier-BearingSeats

1x

60.2b - Substructure - Piers or Bents - Bearing Seats Condition

Text

BI_60_2C

2c.Pier-ColumnStem

1x

60.2c - Substructure - Piers or Bents - Column Stem or Wall Condition

Text

BI_60_2D

2d.Pier-Footing

1x

60.2d - Substructure - Piers or Bents - Footing Condition

Text

BI_60_2E

2e.Pier-Piles

1x

60.2e - Substructure - Piers or Bents - Piles Condition

Text

BI_60_2F

2f.Pier-Bracing

1x

60.2f - Substructure - Piers or Bents - Bracing Condition

Text

BI_60_2G

2g.Pier-Erosion

1x

60.2g - Substructure - Piers or Bents - Erosion or Scour Condition

Text

BI_60_2H

2h.Pier-Settlement

1x

60.2h - Substructure - Piers or Bents - Settlement Condition

Text

BI_60_3A

3a.PileBents-Caps

1x

60.3a - Substructure - Pile Bents - Caps Condition

Text

BI_60_3B

3b.PileBents-BearingSeats

1x

60.3b - Substructure - Pile Bents - Bearing Seats Condition

Text

BI_60_3C

3c.PileBents-Piles

1x

60.3c - Substructure - Pile Bents - Piles Condition

Text

BI_60_3D

3d.PileBents-Bracing

1x

60.3d - Substructure - Pile Bents - Bracing Condition

Text

BI_60_CD

Substructure Cond

1x

Substructure Condition Code

Text

BI_60_TY

Substructure Cond Text

60x

Substructure Condition Text

Text

BI_61_1

1.Channel Scour

1x

61.1 - Channel & Channel Protection or Slope Protection - Channel Scour Condition

Text

BI_61_2

2.Embankment Erosion

1x

61.1 - Channel & Channel Protection or Slope Protection - Embankment Erosion Condition

Text

BI_61_3

3.Drift

1x

61.1 - Channel & Channel Protection or Slope Protection - Drift Condition

Text

BI_61_4

4.Vegetation

1x

61.1 - Channel & Channel Protection or Slope Protection - Vegetation Condition

Text

BI_61_5

5.Fender System

1x

61.1 - Channel & Channel Protection or Slope Protection - Fender System Condition

Text

BI_61_6

6.Spur Dikes/Jetties

1x

61.1 - Channel & Channel Protection or Slope Protection - Spur Dikes & Jetties Condition

Text

BI_61_7

7.Rip Rap/Slope Prot

1x

61.1 - Channel & Channel Protection or Slope Protection - Rip Rap or Slope Protection Condition

Text

BI_61_8

8.Adequacy of Opening

1x

61.1 - Channel & Channel Protection or Slope Protection - Adequacy of Opening Condition

Text

BI_61_CD

Channel Condition

1x

Channel and Channel Condition Code

Text

BI_61_TY

Channel Condition Text

60x

Channel and Channel Condition Text

Text

BI_62_CD

Culvert Condition

1x

Culvert Condition Code

Text

BI_62_TY

Culvert Condition Text

60x

Culvert Condition Text

Text

BI_65_1

1.Alignment

1x

65.1 - Approach Alignment - Alignment Condition

Text

BI_65_2

2.Approach Slab

1x

65.2 - Approach Alignment - Approach Slab Condition

Text

BI_65_3

3.Relief Joints

1x

65.3 - Approach Alignment - Relief Joints Condition

Text

BI_65_4A

4a.Approach-Guardrail

1x

65.4a - Approach Alignment - Approach - Guardrail Condition

Text

BI_65_4B

4b.Approach-Pavement

1x

65.4b - Approach Alignment - Approach - Pavement Condition

Text

BI_65_4C

4c.Approach-Embankment

1x

65.4c - Approach Alignment - Approach - Embankment Condition

Text

BI_66_1

1.Posted Loading

1x

66.1 - Rated Loading - Posted Loading Condition

Text

BI_66_2

2.Legibility

1x

66.1 - Rated Loading - Legibility Condition

Text

BI_66_3

3.Visibility

1x

66.1 - Rated Loading - Visibility Condition

Text

BI_67_CD

Structural Eval

1x

Structural Evaluation

Text

BI_67_TY

Structural Eval Text

60x

Structural Evaluation Text

Text

BI_68_CD

Deck Geometry

1x

Deck Geometry

Text

BI_68_TY

Deck Geometry Text

60x

Deck Geometry Text

Text

BI_69_CD

Underclearance V H

1x

Underclearances, Vertical and Horizontal

Text

BI_69_TY

Underclearance V H Text

60x

Underclearances, Vertical and Horizontal Text

Text

BI_71_CD

Waterway Adequacy

1x

Waterway Adequacy

Text

BI_71_TY

Waterway Adequacy Text

60x

Waterway Adequacy Text

Text

BI_72_CD

Approach Road Align

1x

Approach Roadway Alignment

Text

BI_72_TY

Approach Road Align Text

60x

Approach Roadway Alignment Text

Text

BI_91

Insp Frequency (m)

nn.

Designated Inspection Frequency

Double

BI_92A_CD

Fracture Critical

1x

Fracture Critical Details

Text

BI_92A_TY

Fracture Critical Text

60x

Fracture Critical Details Text

Text

BI_92B_CD

Underwater Insp

1x

Underwater Inspection

Text

BI_92B_TY

Underwater Insp Text

60x

Underwater Inspection Text

Text

BI_92C_CD

Other Special Insp

1x

Other Special Inspection

Text

BI_92C_TY

Other Special Insp Text

60x

Other Special Inspection Text

Text

BI_93A_DT

Next Fracture Critical

mm/dd/yyyy

Fracture Critical Details Date

Date/Time

BI_93B_DT

Next Underwater

mm/dd/yyyy

Underwater Inspection Date

Date/Time

BI_93C_DT

Next Other Insp

mm/dd/yyyy

Other Special Inspection Date

Date/Time

BI_ABUT_CD

Abutment

nnn

Abutment

Integer

BI_ABUT_PR

Abutment Priority

nnn

Abutment Priority

Integer

BI_ABUT_TY

Abutment Text

25x

Abutment Text

Text

BI_BDCK_CD

Below Deck

nnn

Below Deck

Integer

BI_BDCK_PR

Below Deck Priority

nnn

Below Deck Priority

Integer

BI_BDCK_TY

Below Deck Text

25x

Below Deck Text

Text

BI_BEAM_CD

Beams

nnn

Beams

Integer

BI_BEAM_PR

Beams Priority

nnn

Beams Priority

Integer

BI_BEAM_TY

Beams Text

25x

Beams Text

Text

BI_BSW_CD

Below Sidewalk

nnn

Below Sidewalk

Integer

BI_BSW_PR

Below Sidewalk Priority

nnn

Below Sidewalk Priority

Integer

BI_BSW_TY

Below Sidewalk Text

25x

Below Sidewalk Text

Text

BI_BV_ID

Bridge Record #

nnnnnnnn

Link to STBRINV.BV_ID

Long Integer

BI_COND_CD

Overall Condition

nnn

Overall Condition

Integer

BI_COND_PR

Overall Priority

nnn

Overall Priority

Integer

BI_COND_TY

Overall Condition Text

25x

Overall Condition Text

Text

BI_CREW

Inspection Crew

30x

Crew

Text

BI_CRT_BY

Created By

25x

Created By

Text

BI_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BI_CURB_CD

Curb

nnn

Curb

Integer

BI_CURB_PR

Curb Priority

nnn

Curb Priority

Integer

BI_CURB_TY

Curb Text

25x

Curb Text

Text

BI_DDRA_CD

Deck Drains

nnn

Deck Drains

Integer

BI_DDRA_PR

Deck Drains Priority

nnn

Deck Drains Priority

Integer

BI_DDRA_TY

Deck Drains Text

25x

Deck Drains Text

Text

BI_DEBR_CD

Debris

nnn

Debris

Integer

BI_DEBR_PR

Debris Priority

nnn

Debris Priority

Integer

BI_DEBR_TY

Debris Text

25x

Debris Text

Text

BI_DOC_FLG

Document Available

 

Doc Available

Boolean

BI_DSUR_CD

Deck Surface

nnn

Deck Surface

Integer

BI_DSUR_PR

Deck Surface Priority

nnn

Deck Surface Priority

Integer

BI_DSUR_TY

Deck Surface Text

25x

Deck Surface Text

Text

BI_EXPJ_CD

Expansion Joints

nnn

Expansion Joints

Integer

BI_EXPJ_PR

Expansion Joints Priority

nnn

Expansion Joints Priority

Integer

BI_EXPJ_TY

Expansion Joints Text

25x

Expansion Joints Text

Text

BI_GRAF_CD

Graffiti

nnn

Graffiti

Integer

BI_GRAF_PR

Graffiti Priority

nnn

Graffiti Priority

Integer

BI_GRAF_TY

Graffiti Text

25x

Graffiti Text

Text

BI_ID

Inspection Rec #

nnnnnnnn

AutoID

Long Integer

BI_INSN_DT

Next Inspection

mm/dd/yyyy

Next Inspection Date

Date/Time

BI_INSP_DT

Inspection Date

mm/dd/yyyy

Inspection Date

Date/Time

BI_INSP_TM

Inspection Time

mm/dd/yyyy hh:mm am

Inspection Time

DateTime

BI_LATEST

Most Recent Inspection

 

Most Recent Inspection

Boolean

BI_MOD_BY

Last Modified By

25x

Last Modified By

Text

BI_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

BI_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BI_NEEDREP

Needs Repair

 

Needs Repair

Boolean

BI_PAPP_CD

Pedestrian Appr

nnn

Pedestrian Approach

Integer

BI_PAPP_PR

Pedestrian Appr Priority

nnn

Pedestrian Approach Priority

Integer

BI_PAPP_TY

Pedestrian Appr Text

25x

Pedestrian Approach Text

Text

BI_PIER_CD

Piers

nnn

Piers

Integer

BI_PIER_PR

Piers Priority

nnn

Piers Priority

Integer

BI_PIER_TY

Piers Text

25x

Piers Text

Text

BI_PRAI_CD

Pedest Railing

nnn

Pedestrian Railing

Integer

BI_PRAI_PR

Pedest Railing Priority

nnn

Pedestrian Railing Priority

Integer

BI_PRAI_TY

Pedest Railing Text

25x

Pedestrian Railing Text

Text

BI_ROCK_CD

Rocker/Bearing

nnn

Rockers/Bearings

Integer

BI_ROCK_PR

Rocker/Bearing Priority

nnn

Rockers/Bearings Priority

Integer

BI_ROCK_TY

Rocker/Bearing Text

25x

Rockers/Bearings Text

Text

BI_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BI_RRAP_CD

Rip Rap

nnn

Rip Rap

Integer

BI_RRAP_PR

Rip Rap Priority

nnn

Rip Rap Priority

Integer

BI_RRAP_TY

Rip Rap Text

25x

Rip Rap Text

Text

BI_SPEC1

Spec 1

30x

Spec 1

Text

BI_SPEC2

Spec 2

30x

Spec 2

Text

BI_SPEC3

Spec 3

30x

Spec 3

Text

BI_SPEC4

Spec 4

30x

Spec 4

Text

BI_SPEC5

Spec 5

30x

Spec 5

Text

BI_SPEC6

Spec 6

30x

Spec 6

Text

BI_SPEC7

Spec 7

30x

Spec 7

Text

BI_SPEC8

Spec 8

30x

Spec 8

Text

BI_SPEC9

Spec 9

30x

Spec 9

Text

BI_SPEC10

Spec 10

30x

Spec 10

Text

BI_SPEC11

Spec 11

30x

Spec 11

Text

BI_SPEC12

Spec 12

30x

Spec 12

Text

BI_SPEC13

Spec 13

30x

Spec 13

Text

BI_SPEC14

Spec 14

30x

Spec 14

Text

BI_SPEC15

Spec 15

30x

Spec 15

Text

BI_SPEC16

Spec 16

30x

Spec 16

Text

BI_SPEC17

Spec 17

30x

Spec 17

Text

BI_SPEC18

Spec 18

30x

Spec 18

Text

BI_SPEC19

Spec 19

30x

Spec 19

Text

BI_SPEC20

Spec 20

30x

Spec 20

Text

BI_SWCD_CD

Sidewalk Cond

nnn

Sidewalk Condition

Integer

BI_SWCD_PR

Sidewalk Cond Priority

nnn

Sidewalk Condition Priority

Integer

BI_SWCD_TY

Sidewalk Cond Text

25x

Sidewalk Condition Text

Text

BI_TAPP_CD

Traffic Approach

nnn

Traffic Approach

Integer

BI_TAPP_PR

Traffic Approach Priority

nnn

Traffic Approach Priority

Integer

BI_TAPP_TY

Traffic Approach Text

25x

Traffic Approach Text

Text

BI_TRAI_CD

Traffic Railing

nnn

Traffic Railing

Integer

BI_TRAI_PR

Traffic Railing Priority

nnn

Traffic Railing Priority

Integer

BI_TRAI_TY

Traffic Railing Text

25x

Traffic Railing Text

Text

BI_TREE_CD

Trees

nnn

Trees

Integer

BI_TREE_PR

Trees Priority

nnn

Trees Priority

Integer

BI_TREE_TY

Trees Text

25x

Trees Text

Text

BI_USER_CD

User

nnn

User

Integer

BI_USER_PR

User Priority

nnn

User Priority

Integer

BI_USER_TY

User Text

25x

User Text

Text

BI_USER1CD

User 1

nnn

User 1

Integer

BI_USER1TY

User 1 Text

25x

User 1 Text

Text

BI_USER2CD

User 2

nnn

User 2

Integer

BI_USER2TY

User 2 Text

25x

User 2 Text

Text

BI_USER3CD

User 3

nnn

User 3

Integer

BI_USER3TY

User 3 Text

25x

User 3 Text

Text

BI_USER4

User 4

30x

User 4

Text

BI_USER5

User 5

30x

User 5

Text

BI_USER6

User 6

30x

User 6

Text

BI_USER7

User 7

nnnnnnnnn.nn

User 7

Double

BI_USER8

User 8

nnnnnnnnn.nn

User 8

Double

BI_USER9

User 9

nnnnnnnnn.nn

User 9

Double

BI_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

BI_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

BI_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

BI_USER13

User 13

 

User 13

Boolean

BI_USER14

User 14

 

User 14

Boolean

BI_USER15

User 15

 

User 15

Boolean

BI_USER16CD

User 16

nnn

User 16

Integer

BI_USER16TY

User 16 Text

50x

User 16 Text

String

BI_USER17CD

User 17

nnn

User 17

Integer

BI_USER17TY

User 17 Text

50x

User 17 Text

String

BI_USER18CD

User 18

nnn

User 18

Integer

BI_USER18TY

User 18 Text

50x

User 18 Text

String

BI_USER19CD

User 19

nnn

User 19

Integer

BI_USER19TY

User 19 Text

50x

User 19 Text

String

BI_USER20CD

User 20

nnn

User 20

Integer

BI_USER20TY

User 20 Text

50x

User 20 Text

String

BI_USER21

User 21

50x

User 21

String

BI_USER22

User 22

50x

User 22

String

BI_USER23

User 23

50x

User 23

String

BI_USER24

User 24

50x

User 24

String

BI_USER25

User 25

50x

User 25

String

BI_USER26

User 26

nnnnnnnn.nn

User 26

Double

BI_USER27

User 27

nnnnnnnn.nn

User 27

Double

BI_USER28

User 28

nnnnnnnn.nn

User 28

Double

BI_USER29

User 29

nnnnnnnn.nn

User 29

Double

BI_USER30

User 30

nnnnnnnn.nn

User 30

Double

BI_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

BI_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

BI_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

BI_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

BI_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

BI_USER36

User 36

 

User 36

Boolean

BI_USER37

User 37

 

User 37

Boolean

BI_USER38

User 38

 

User 38

Boolean

BI_USER39

User 39

 

User 39

Boolean

BI_USER40

User 40

 

User 40

Boolean

BI_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer

BI_WWAL_CD

Wing Walls

nnn

Wing Walls

Integer

BI_WWAL_PR

Wing Walls Priority

nnn

Wing Walls Priority

Integer

BI_WWAL_TY

Wing Walls Text

25x

Wing Walls Text

Text