STMODPAR

Model Parameters

Field Name

Caption

Mask

Description

Field Type

MP_AUTO

Model Rec ID

nnnnnnnn

 

Long Integer

MP_BD_DESC

Budget Description

30x

Budget Description

Text

MP_BD_NUM

Budget Table

nnn

Budget Table

Integer

MP_CO_ID

 

 

Comments

Long Integer

MP_CRT_BY

Created By

25x

Created By

Text

MP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

MP_DESC

Model Description

30x

Model Description

Text

MP_DOC_FLG

Document Available

 

Doc Available?

Boolean

MP_HAS_RUN

Model Been Run

 

Model Been Run

Boolean

MP_MOD_BY

Last Modified By

25x

Last Modified By

Text

MP_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

MP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

MP_MS_DESC

Misc. Cost Descrip

30x

Misc. Cost Descrip

Text

MP_MS_NUM

Misc. Cost Table

nnn

Misc. Cost Table

Integer

MP_NUMBER

Model Name

nnn

Model Name

Integer

MP_PT_DESC

Planning Description

30x

Planning Description

Text

MP_PT_NUM

Planning Table

nnn

Planning Table

Integer

MP_PV_DESC

Pave. Cost Descrip

30x

Pave. Cost Descrip

Text

MP_PV_NUM

Pave. Cost Table

nnn

Pave. Cost Table

Integer

MP_RH_DESC

Rehab B.P. Descrip

30x

Rehab B.P. Descrip

Text

MP_RH_NUM

Rehab Table

nnn

Rehab Table

Integer

MP_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

MP_RUN_BY

Model Run By

25x

Model Run By

Text

MP_RUN_DT

Model Run Date

mm/dd/yyyy

Model Run Date

Date/Time

MP_SQ_DESC

Sequence Description

30x

Sequence Description

Text

MP_SQ_NUM

Sequence Table

nnn

Sequence Table

Integer

MP_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

MP_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

MP_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

MP_USER13

User 13

 

User 13

Boolean

MP_USER14

User 14

 

User 14

Boolean

MP_USER15

User 15

 

User 15

Boolean

MP_USER1CD

User 1

nnn

User 1

Integer

MP_USER1TY

User 1 Text

25x

User 1 Text

Text

MP_USER2CD

User 2

nnn

User 2

Integer

MP_USER2TY

User 2 Text

25x

User 2 Text

Text

MP_USER3CD

User 3

nnn

User 3

Integer

MP_USER3TY

User 3 Text

25x

User 3 Text

Text

MP_USER4

User 4

30x

User 4

Text

MP_USER5

User 5

30x

User 5

Text

MP_USER6

User 6

30x

User 6

Text

MP_USER7

User 7

-nnnnnnnnn.nn

User 7

Double

MP_USER8

User 8

-nnnnnnnnn.nn

User 8

Double

MP_USER9

User 9

-nnnnnnnnn.nn

User 9

Double