STPVREHAB

Street Curb Inspection

Field Name

Caption

Mask

Description

Field Type

RB_BY

Maint By

30x

Maintenance By

Text

RB_BY_CD

Maint By Type

nnn

Maintenance By Type

Integer

RB_BY_TY

Maint By Type Text

25x

Maintenance By Type Text

Text

RB_COST

Cost

nnnnnnnn.nn

Cost

Double

RB_CRT_BY

Created By

25x

Created By

Text

RB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RB_DESC

Short Description

200x

Short Description

Text

RB_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

RB_ID

Rec #

nnnnnnnn

AutoID

Long Integer

RB_MAT_CD

Material

nnn

Material

Integer

RB_MAT_TY

Material Text

50x

Material Text

Text

RB_MOD_BY

Last Modified By

25x

Last Modified By

Text

RB_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

RB_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RB_OPCI

Override PCI

nnn.

Override PCI Value

Double

RB_PAVE_CD

Pavement Type

nnn

Pavement Type

Integer

RB_PAVE_TY

Pavement Type Text

25x

Pavement Type Text

Text

RB_PROG

Program

30x

Program

Text

RB_REHB_CD

Rehab Technique

nnn

Maintenance

Integer

RB_REHB_DT

Maint Date

mm/dd/yyyy

Maintenance Date

Date/Time

RB_REHB_TY

Rehab Technique Text

30x

Maintenance Description

Text

RB_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RB_RS_ID

Road Segment Rec #

nnnnnnnn

Link to STRDSEG.RS_ID

Long Integer

RB_SB_ID

Subsegment Rec #

nnnnnnnn

Link to STSUBSEG.SB_ID

Long Integer

RB_SETFLD

Reset Field Insp PCI

 

Flag for Overriding Linked Field Inspection Record's PCI and Date

Boolean

RB_SETSPR

Reset Superseg PCI

 

Flag for Overriding Linked Supersegment's Overriding PCI and Date

Boolean

RB_SP_ID

Superseg Rec #

nnnnnnnn

Link to STSUPER.SP_ID

Long Integer

RB_STRE_CD

Pavement Strength

nnn

Pavement Strength

Integer

RB_STRE_TY

Pavement Strength Text

25x

Pavement Strength Type

Text

RB_SURF_CD

Surface Type

nnn

Surface Type

Integer

RB_SURF_TY

Surface Type Text

50x

Surface Type Text

Text

RB_THICK

Thickness

nnnnnnnn.nn

Thickness

Double

RB_USER1CD

User 1

nnn

User 1

Integer

RB_USER1TY

User 1 Text

25x

User 1 Text

Text

RB_USER2CD

User 2

nnn

User 2

Integer

RB_USER2TY

User 2 Text

25x

User 2 Text

Text

RB_USER3CD

User 3

nnn

User 3

Integer

RB_USER3TY

User 3 Text

25x

User 3 Text

Text

RB_USER4

User 4

30x

User 4

Text

RB_USER5

User 5

30x

User 5

Text

RB_USER6

User 6

30x

User 6

Text

RB_USER7

User 7

nnnnnnnn.nn

User 7

Double

RB_USER8

User 8

nnnnnnnn.nn

User 8

Double

RB_USER9

User 9

nnnnnnnn.nn

User 9

Double

RB_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

RB_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

RB_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

RB_USER13

User 13

 

User 13

Boolean

RB_USER14

User 14

 

User 14

Boolean

RB_USER15

User 15

 

User 15

Boolean

RB_USER16CD

User 16

nnn

User 16

Integer

RB_USER16TY

User 16 Text

50x

User 16 Text

String

RB_USER17CD

User 17

nnn

User 17

Integer

RB_USER17TY

User 17 Text

50x

User 17 Text

String

RB_USER18CD

User 18

nnn

User 18

Integer

RB_USER18TY

User 18 Text

50x

User 18 Text

String

RB_USER19CD

User 19

nnn

User 19

Integer

RB_USER19TY

User 19 Text

50x

User 19 Text

String

RB_USER20CD

User 20

nnn

User 20

Integer

RB_USER20TY

User 20 Text

50x

User 20 Text

String

RB_USER21

User 21

50x

User 21

String

RB_USER22

User 22

50x

User 22

String

RB_USER23

User 23

50x

User 23

String

RB_USER24

User 24

50x

User 24

String

RB_USER25

User 25

50x

User 25

String

RB_USER26

User 26

nnnnnnnn.nn

User 26

Double

RB_USER27

User 27

nnnnnnnn.nn

User 27

Double

RB_USER28

User 28

nnnnnnnn.nn

User 28

Double

RB_USER29

User 29

nnnnnnnn.nn

User 29

Double

RB_USER30

User 30

nnnnnnnn.nn

User 30

Double

RB_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

RB_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

RB_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

RB_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

RB_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

RB_USER36

User 36

 

User 36

Boolean

RB_USER37

User 37

 

User 37

Boolean

RB_USER38

User 38

 

User 38

Boolean

RB_USER39

User 39

 

User 39

Boolean

RB_USER40

User 40

 

User 40

Boolean

RB_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer