STCURBINV

Street Curb Inventory

Field Name

Caption

Mask

Description

Field Type

CU_ABOVLIP

Above Lip

nnn.n

Above Lip

Double

CU_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

CU_ADR_B22

Street Post Bldg No 2

8x

Street Post Building No 2

Text

CU_ADR_BDG

Address

nnnnnn

Address

Long Integer

CU_ADR_DIR

Street Direction

2x

Street Direction

Text

CU_ADR_PT

Street Prefix Type

5x

Street Prefix

Text

CU_ADR_PT

Street Prefix Type

5x

Street Prefix

Text

CU_ADR_SFX

Street Suffix

5x

Street Suffix

Text

CU_ADR_STR

Street Name

50x

Street Name

Text

CU_ADR_TY

Street Type

5x

Street Type

Text

CU_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix

Text

CU_ADRBDG2

Address

nnnnnn

Address

Long Integer

CU_ADRDIR2

Address2 Direction

2x

Address2 Direction

Text

CU_ADRSFX2

Address2 Suffix

5x

Address2 Suffix

Text

CU_ADRSTR2

Address2 Name

50x

Address2 Name

Text

CU_ADRTY2

Address2 Type

5x

Address2 Type

Text

CU_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

CU_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

CU_BR_CD

Default WO Cat

10x

Default Category Code

Text

CU_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

CU_BRP

Beg Ref Post

nnnnnnnn.nnn

Beginning Reference Post

Double

CU_CBS

Curr Beg Station

nnnnnnnn.nnn

Current Beginning Stationing

Double

CU_CES

Curr End Station

nnnnnnnn.nnn

Current Ending Stationing

Double

CU_CITY_CD

Facility

nnn

Facility

Integer

CU_CITY_TY

Facility Text

50x

Facility Text

Text

CU_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

CU_COND_CD

Overall Cond

nnn

Condition

Integer

CU_COND_TY

Overall Cond Text

25x

Condition Text

Text

CU_CRT_BY

Created By

25x

Created By

Text

CU_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CU_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

CU_DRAWNO

Drawing #

30x

Drawing #

Text

CU_DWUNITS

DW Units

nnn.n

DW Units

Double

CU_ENDPT1

End Point 1

100x

End Point 1

Text

CU_ENDPT2

End Point 2

100x

End Point 2

Text

CU_ERP

End Ref Post

nnnnnnnn.nnn

Ending Reference Post

Double

CU_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

CU_FLAG

Flag

 

Flag

Boolean

CU_GPS

GPS Flag

 

GPS Flag

Boolean

CU_GPS_TM

GPS Time

hh:mm am

GPS Time

Date/Time

CU_GPSDATE

GPS Date

mm/dd/yyyy

GPS Date

Date/Time

CU_HEIGHT

Height

nnn.n

Height

Double

CU_ID

Curb Rec #

nnnnnnnn

AutoID

Long Integer

CU_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

CU_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

CU_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

CU_IMG_FLG

 

 

Image Available

Boolean

CU_INMAP

In Map

 

 

Boolean

CU_INST_DT

Date Installed

mm/dd/yyyy

Date Installed

Date/Time

CU_INSTBY

Installed By

30x

Installed By

Text

CU_INT_ID

Intersection Rec #

nnnnnnnn

Link to INTNET.IN_ID

Long Integer

CU_LENGTH

Length

nnnnn.n

Length

Double

CU_LINSPDT

Last Inspection

mm/dd/yyyy

Last Inspection

Date/Time

CU_MAIN_CD

Maintained By

nnn

Maintained By

Integer

CU_MAIN_TY

Maintained By Text

25x

Maintained By Text

Text

CU_MAPNO

Map Number

30x

Map Number

Text

CU_MAT_CD

Material

nnn

Material

Integer

CU_MAT_TY

Material Text

25x

Material Text

Text

CU_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

CU_MOD_BY

Last Modified By

25x

Last Modified By

Text

CU_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

CU_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CU_MOV_FLG

 

 

Movie Available

Boolean

CU_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

CU_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

CU_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

CU_NUM

Curb ID

20x

Curb ID

Text

CU_NXTINSP

Next Inspection

mm/dd/yyyy

Next Inspection

Date/Time

CU_OBS

Org. Beg Station

nnnnnnnn.nnn

Original Beginning Stationing

Double

CU_OES

Org. End Station

nnnnnnnn.nnn

Original Ending Stationing

Double

CU_OLAY_CD

Overlaid

nnn

Overlaid

Integer

CU_OLAY_TY

Overlaid Text

25x

Overlaid Text

Text

CU_OWN_CD

Owner

nnn

Owner

Integer

CU_OWN_TY

Owner Text

25x

Owner Text

Text

CU_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

CU_PROJNO

Project Number

30x

Project Number

Text

CU_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

CU_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

CU_REPL_DT

Replacement

mm/dd/yyyy

Replacement

Date/Time

CU_REPLEST

Replace Est

nnnnn.n

Replace Est

Double

CU_RH_ID

Road Rec #

nnnnnnnn

Link to STRDROAD.RH_ID

Long Integer

CU_RISK

Risk

nnnn.

Risk - COF * POF

Double

CU_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

CU_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

CU_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

CU_SB_ID

Subsegment Rec #

nnnnnnnn

Link to STSUBSEG.SB_ID

Long Integer

CU_SBSEGCD

Subsegment #

nnn

Subsegment Number(Null if no Subsegments)

Integer

CU_SLOC_CD

Street Location

nnn

Street Location

Integer

CU_SLOC_TY

Street Location Text

25x

Street Location Text

Text

CU_SN_ID

Segment Rec #

nnnnnnnn

Link to STNET.SN_ID

Long Integer

CU_SNCOMID

Segment ID

20x

Segment ID

Text

CU_SORCECD

Info Source

nnn

Info Source

Integer

CU_SORCETY

Info Source Text

25x

Info Source Text

Text

CU_SP_ID

SuperSeg Rec #

nnnnnnnn

Link to STSUPER.SP_ID

Long Integer

CU_STAT_CD

Status

nnn

Status

Integer

CU_STAT_TY

Status Text

25x

Status Text

Text

CU_STYPE_CD

Sub-Type

nnn

Sub-Type

Integer

CU_STYPE_TY

Sub-Type Text

25x

Sub-Type Text

Text

CU_TYPE_CD

Type

nnn

Type

Integer

CU_TYPE_TY

Type Text

25x

Type Text

Text

CU_USER1CD

User 1

nnn

User 1

Integer

CU_USER1TY

User 1 Text

25x

User 1 Text

Text

CU_USER2CD

User 2

nnn

User 2

Integer

CU_USER2TY

User 2 Text

25x

User 2 Text

Text

CU_USER3CD

User 3

nnn

User 3

Integer

CU_USER3TY

User 3 Text

25x

User 3 Text

Text

CU_USER4

User 4

30x

User 4

Text

CU_USER5

User 5

30x

User 5

Text

CU_USER6

User 6

30x

User 6

Text

CU_USER7

User 7

nnnnnnnn.nn

User 7

Double

CU_USER8

User 8

nnnnnnnn.nn

User 8

Double

CU_USER9

User 9

nnnnnnnn.nn

User 9

Double

CU_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

CU_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

CU_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

CU_USER13

User 13

 

User 13

Boolean

CU_USER14

User 14

 

User 14

Boolean

CU_USER15

User 15

 

User 15

Boolean

CU_USER16CD

User 16

nnn

User 16

Integer

CU_USER16TY

User 16 Text

50x

User 16 Text

String

CU_USER17CD

User 17

nnn

User 17

Integer

CU_USER17TY

User 17 Text

50x

User 17 Text

String

CU_USER18CD

User 18

nnn

User 18

Integer

CU_USER18TY

User 18 Text

50x

User 18 Text

String

CU_USER19CD

User 19

nnn

User 19

Integer

CU_USER19TY

User 19 Text

50x

User 19 Text

String

CU_USER20CD

User 20

nnn

User 20

Integer

CU_USER20TY

User 20 Text

50x

User 20 Text

String

CU_USER21

User 21

50x

User 21

String

CU_USER22

User 22

50x

User 22

String

CU_USER23

User 23

50x

User 23

String

CU_USER24

User 24

50x

User 24

String

CU_USER25

User 25

50x

User 25

String

CU_USER26

User 26

nnnnnnnn.nn

User 26

Double

CU_USER27

User 27

nnnnnnnn.nn

User 27

Double

CU_USER28

User 28

nnnnnnnn.nn

User 28

Double

CU_USER29

User 29

nnnnnnnn.nn

User 29

Double

CU_USER30

User 30

nnnnnnnn.nn

User 30

Double

CU_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

CU_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

CU_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

CU_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

CU_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

CU_USER36

User 36

 

User 36

Boolean

CU_USER37

User 37

 

User 37

Boolean

CU_USER38

User 38

 

User 38

Boolean

CU_USER39

User 39

 

User 39

Boolean

CU_USER40

User 40

 

User 40

Boolean

CU_WIDTH

Width

nnn.nn

Width

Double

CU_WO_COMM

WO Comment

255x

WO Comment

Text

CU_X1

Beg X Coordinate

-nnnnnnnn.nn

Beg X Coordinate

Double

CU_X2

End X Coordinate

-nnnnnnnn.nn

End X Coordinate

Double

CU_Y1

Beg Y Coordinate

-nnnnnnnn.nn

Beg Y Coordinate

Double

CU_Y2

End Y Coordinate

-nnnnnnnn.nn

End Y Coordinate

Double

CU_Z1

Beg Elevation

nnnnn.nn

Beg Elevation

Double

CU_Z2

End Elevation

nnnnn.nn

End Elevation

Double