STCULINS

Street Culvert Inspection (linked to Structures)

Field Name

Caption

Mask

Description

Field Type

UL_AGR_CD

Approach Guardrail

1x

Approach Guardrail

Text

UL_AGR_TY

Approach Guardrail Text

30x

Approach Guardrail Text

Text

UL_AGRT_CD

Approach GR Terminal

1x

Approach Guardrail Terminal

Text

UL_AGRT_TY

Approach GR Terminal Text

30x

Approach Guardrail Terminal Text

Text

UL_BAR_CM

Barrel Comm

250x

Barrel Comment

Text

UL_BC_CD

Barrel Concrete

1x

Barrel Concrete

Text

UL_BC_TY

Barrel Concrete Text

30x

Barrel Concrete Text

Text

UL_BRAIL_CD

Bridge Railing

1x

Bridge Railing

Text

UL_BRAIL_TY

Bridge Railing Text

30x

Bridge Railing Text

Text

UL_BS_CD

Barrel Steel

1x

Barrel Steel

Text

UL_BS_TY

Barrel Steel Text

30x

Barrel Steel Text

Text

UL_CGC_CD

Channel General Cond

1x

Channel & Channel Protection General Condition

Text

UL_CGC_TY

Channel General Cond Text

30x

Channel & Channel Protection General Condition Text

Text

UL_COVER_CD

Adequacy of Cover

1x

Adequacy of Cover

Text

UL_COVER_CM

Adequacy of Cover Comm

250x

Adequacy of Cover Comment

Text

UL_COVER_TY

Adequacy of Cover Text

30x

Adequacy of Cover Text

Text

UL_CREW

Inspected by

30x

Inspected by

Text

UL_CRT_BY

Created By

25x

Created By

Text

UL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

UL_CSCOUR_CD

Channel Scour

1x

Channel Scour

Text

UL_CSCOUR_CM

Channel Scour Comm

250x

Channel Scour Comment

Text

UL_CSCOUR_TY

Channel Scour Text

30x

Channel Scour Text

Text

UL_CULGC_CD

Culvert General Cond

1x

Culvert & Retaining Walls General Condition

Text

UL_CULGC_TY

Culvert General Cond Text

30x

Culvert & Retaining Walls General Condition Text

Text

UL_DEBRIS_CD

Debris

1x

Debris

Text

UL_DEBRIS_CM

Debris Comm

250x

Debris Comment

Text

UL_DEBRIS_TY

Debris Text

30x

Debris Text

Text

UL_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

UL_DRIFT_CD

Drift

1x

Drift

Text

UL_DRIFT_CM

Drift Comm

250x

Drift Comment

Text

UL_DRIFT_TY

Drift Text

30x

Drift Text

Text

UL_EEROS_CD

Embankment Erosion

1x

Embankment Erosion

Text

UL_EEROS_CM

Embankment Erosion Comm

250x

Embankment Erosion Comment

Text

UL_EEROS_TY

Embankment Erosion Text

30x

Embankment Erosion Text

Text

UL_EMBANK_CD

Embankment

1x

Embankment

Text

UL_EMBANK_CM

Embankment Comm

250x

Embankment Comment

Text

UL_EMBANK_TY

Embankment Text

30x

Embankment Text

Text

UL_EOPEN_CD

Existing Open

1x

Existing Open

Text

UL_EOPEN_CM

Existing Open Comm

250x

Existing Open Comment

Text

UL_EOPEN_TY

Existing Open Text

30x

Existing Open Text

Text

UL_HWALL_CD

Headwall

1x

Headwall

Text

UL_HWALL_CM

Headwall Comm

250x

Headwall Comment

Text

UL_HWALL_TY

Headwall Text

30x

Headwall Text

Text

UL_ID

Culvert Ins Rec #

nnnnnnnn

Culvert Ins Rec #

Long Integer

UL_INSP_DT

Date Inspected

mm/dd/yyyy

Date Inspected

Date/Time

UL_INSP_TM

Time Inspected

hh:mm am

Time Inspected

Date/Time

UL_LATEST

Most Recent Inspect

 

Most Recent Inspection

Boolean

UL_MOD_BY

Last Modified By

25x

Last Modified By

Text

UL_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

UL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

UL_NEEDREP

Needs Repair

 

Needs Repair

Boolean

UL_NXT_DT

Next Inspection

mm/dd/yyyy

Next Inspection

Date/Time

UL_PAVE_CD

Pavement

1x

Pavement

Text

UL_PAVE_CM

Pavement Comm

250x

Pavement Comment

Text

UL_PAVE_TY

Pavement Text

30x

Pavement Text

Text

UL_RGC_CD

Roadway General Cond

1x

Roadway General Condition

Text

UL_RGC_TY

Roadway General Cond Text

30x

Roadway General Condition Text

Text

UL_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

UL_SC_ID

Structure Rec #

nnnnnnnn

Link to STSTRUCT.SC_ID

Long Integer

UL_SCOUR_CD

Scour

1x

Scour

Text

UL_SCOUR_CM

Scour Comm

250x

Scour Comment

Text

UL_SCOUR_TY

Scour Text

30x

Scour Text

Text

UL_SETTLE_CD

Settlement

1x

Settlement

Text

UL_SETTLE_CM

Settlement Comm

250x

Settlement Comment

Text

UL_SETTLE_TY

Settlement Text

30x

Settlement Text

Text

UL_SHOLDER_CD

Shoulders

1x

Shoulders

Text

UL_SHOLDER_CM

Shoulders Comm

250x

Shoulders Comment

Text

UL_SHOLDER_TY

Shoulders Text

30x

Shoulders Text

Text

UL_SILTPERC

Silt Percent

nnn

Silt Percent

Integer

UL_TRAN_CD

Transitions

1x

Transitions

Text

UL_TRAN_TY

Transitions Text

30x

Transitions Text

Text

UL_USER1CD

User 1

nnn

User 1

Integer

UL_USER1TY

User 1 Text

25x

User 1 Text

Text

UL_USER2CD

User 2

nnn

User 2

Integer

UL_USER2TY

User 2 Text

25x

User 2 Text

Text

UL_USER3CD

User 3

nnn

User 3

Integer

UL_USER3TY

User 3 Text

25x

User 3 Text

Text

UL_USER4

User 4

30x

User 4

Text

UL_USER5

User 5

30x

User 5

Text

UL_USER6

User 6

30x

User 6

Text

UL_USER7

User 7

nnnnnnnnn.nn

User 7

Double

UL_USER8

User 8

nnnnnnnnn.nn

User 8

Double

UL_USER9

User 9

nnnnnnnnn.nn

User 9

Double

UL_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

UL_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

UL_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

UL_USER13

User 13

 

User 13

Boolean

UL_USER14

User 14

 

User 14

Boolean

UL_USER15

User 15

 

User 15

Boolean

UL_USER16CD

User 16

nnn

User 16

Integer

UL_USER16TY

User 16 Text

50x

User 16 Text

String

UL_USER17CD

User 17

nnn

User 17

Integer

UL_USER17TY

User 17 Text

50x

User 17 Text

String

UL_USER18CD

User 18

nnn

User 18

Integer

UL_USER18TY

User 18 Text

50x

User 18 Text

String

UL_USER19CD

User 19

nnn

User 19

Integer

UL_USER19TY

User 19 Text

50x

User 19 Text

String

UL_USER20CD

User 20

nnn

User 20

Integer

UL_USER20TY

User 20 Text

50x

User 20 Text

String

UL_USER21

User 21

50x

User 21

String

UL_USER22

User 22

50x

User 22

String

UL_USER23

User 23

50x

User 23

String

UL_USER24

User 24

50x

User 24

String

UL_USER25

User 25

50x

User 25

String

UL_USER26

User 26

nnnnnnnn.nn

User 26

Double

UL_USER27

User 27

nnnnnnnn.nn

User 27

Double

UL_USER28

User 28

nnnnnnnn.nn

User 28

Double

UL_USER29

User 29

nnnnnnnn.nn

User 29

Double

UL_USER30

User 30

nnnnnnnn.nn

User 30

Double

UL_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

UL_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

UL_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

UL_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

UL_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

UL_USER36

User 36

 

User 36

Boolean

UL_USER37

User 37

 

User 37

Boolean

UL_USER38

User 38

 

User 38

Boolean

UL_USER39

User 39

 

User 39

Boolean

UL_USER40

User 40

 

User 40

Boolean

UL_VEG_CD

Vegetation

1x

Vegetation

Text

UL_VEG_CM

Vegetation Comm

250x

Vegetation Comment

Text

UL_VEG_TY

Vegetation Text

30x

Vegetation Text

Text

UL_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer

UL_WWALL_CD

Wing Wall

1x

Wing Wall

Text

UL_WWALL_CM

Wing Wall Comm

250x

Wing Wall Comment

Text

UL_WWALL_TY

Wing Wall Text

30x

Wing Wall Text

Text