STMUTCD

Street Sign Descriptions

Field Name

Caption

Mask

Description

Field Type

MU_BKCL_CD

Backgrd Color

nnn

Back Color;

Integer

MU_BKCL_TY

Backgrd Color Text

25x

Back Color Text;

Text

MU_BOLD

Bold

 

Bold Symbol

Boolean

MU_CLAS_CD

Class

nnn

Class;

Integer

MU_CLAS_TY

Class Text

25x

Class Text;

Text

MU_COLR_CD

Legend Color

nnn

Color;

Integer

MU_COLR_TY

Legend Color Text

25x

Color Text;

Text

MU_COMM

Comments

 

Comments

Long Integer

MU_CRT_BY

Created By

25x

Created By

Text

MU_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

MU_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

MU_IMG_FLG

 

 

Image Available

Boolean

MU_LEGEND

Sign Desc.

75x

Sign Legend;

Text

MU_MID

MUTCD Rec #

nnnnnnnn

AutoNumber

Long Integer

MU_MOD_BY

Last Modified By

25x

Last Modified By

Text

MU_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

MU_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

MU_MOV_FLG

 

 

Movie Available

Boolean

MU_MUTCD

MUTCD Code

35x

MUTCD Number

Text

MU_PICT

Picture File

20x

Picture File;

Text

MU_PICT

Picture File

20x

Picture File;

Text

MU_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

MU_SHAP_CD

Shape

nnn

Shape;

Integer

MU_SHAP_TY

Shape Text

25x

Shape Text;

Text

MU_SIZE_H

Height

nnnnn.n

Sign Height;

Double

MU_SIZE_L

Length

nnnnn.n

Sign Length;

Double

MU_SIZE_W

Width

nnnnn.n

Sign Width;

Double

MU_SUBC_CD

Sub Class

nnn

Sub Class

Integer

MU_SUBC_TY

Sub Class Text

25x

Sub Class Text

Text

MU_USER1CD

User 1

nnn

User 1

Integer

MU_USER1TY

User 1 Text

25x

User 1 Text

Text

MU_USER2CD

User 2

nnn

User 2

Integer

MU_USER2TY

User 2 Text

25x

User 2 Text

Text

MU_USER3CD

User 3

nnn

User 3

Integer

MU_USER3TY

User 3 Text

25x

User 3 Text

Text

MU_USER4

User 4

30x

User 4

Text

MU_USER5

User 5

30x

User 5

Text

MU_USER6

User 6

30x

User 6

Text

MU_USER7

User 7

nnnnnnnnn.nn

User 7

Double

MU_USER8

User 8

nnnnnnnnn.nn

User 8

Double

MU_USER9

User 9

nnnnnnnnn.nn

User 9

Double

MU_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

MU_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

MU_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

MU_USER13

User 13

 

User 13

Boolean

MU_USER14

User 14

 

User 14

Boolean

MU_USER15

User 15

 

User 15

Boolean

MU_USER16CD

User 16

nnn

User 16

Integer

MU_USER16TY

User 16 Text

50x

User 16 Text

String

MU_USER17CD

User 17

nnn

User 17

Integer

MU_USER17TY

User 17 Text

50x

User 17 Text

String

MU_USER18CD

User 18

nnn

User 18

Integer

MU_USER18TY

User 18 Text

50x

User 18 Text

String

MU_USER19CD

User 19

nnn

User 19

Integer

MU_USER19TY

User 19 Text

50x

User 19 Text

String

MU_USER20CD

User 20

nnn

User 20

Integer

MU_USER20TY

User 20 Text

50x

User 20 Text

String

MU_USER21

User 21

50x

User 21

String

MU_USER22

User 22

50x

User 22

String

MU_USER23

User 23

50x

User 23

String

MU_USER24

User 24

50x

User 24

String

MU_USER25

User 25

50x

User 25

String

MU_USER26

User 26

nnnnnnnn.nn

User 26

Double

MU_USER27

User 27

nnnnnnnn.nn

User 27

Double

MU_USER28

User 28

nnnnnnnn.nn

User 28

Double

MU_USER29

User 29

nnnnnnnn.nn

User 29

Double

MU_USER30

User 30

nnnnnnnn.nn

User 30

Double

MU_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

MU_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

MU_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

MU_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

MU_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

MU_USER36

User 36

 

User 36

Boolean

MU_USER37

User 37

 

User 37

Boolean

MU_USER38

User 38

 

User 38

Boolean

MU_USER39

User 39

 

User 39

Boolean

MU_USER40

User 40

 

User 40

Boolean