SMQICR

Storm Water Quality Industrial Contacts

Field Name

Caption

Mask

Description

Field Type

UR_CRT_BY

Created By

25x

Created By

String

UR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

UR_EMAIL

Email

150x

Email

String

UR_FAX

Fax

25x

Fax

String

UR_ID

Industrial Contact Rec #

nnnnnnnn

Unique ID

Long Integer

UR_MOBILE

Mobile Phone

25x

Mobile Phone

String

UR_MOD_BY

Modified By

25x

Modified By

String

UR_MOD_DT

Modified Date

mm/dd/yyyy hh:mm am

Modified Date

DateTime

UR_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

UR_NAME

Name

50x

Name

String

UR_PHONE

Phone

25x

Phone

String

UR_QI_ID

Industrial Record No

nnnnnnnn

Link to SMQI.QI_ID

Long Integer

UR_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

UR_TITL_CD

Title

nnn

Title

Integer

UR_TITL_TY

Title Text

50x

Title Text

String