SMQASR

Storm Water Quality Annual Municipal Maintenance Spill Review Summary

Field Name

Caption

Mask

Description

Field Type

AR_CHAG_DT

Sewage Spill Response Procedures - If changes or modifications were made, provide the date these changes were implemented.

mm/dd/yyyy hh:mm am

Sewage Spill Response Procedures - If changes or modifications were made, provide the date these changes were implemented.

DateTime

AR_CRT_BY

Created By

25x

Created By

String

AR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

AR_DOC_FLG

Document Flag

 

Document Flag

Boolean

AR_FCDM

Flood Control and Drainage - Have maintenance practices been Modified?

 

Flood Control and Drainage - Have maintenance practices been Modified?

Boolean

AR_FCDMOD

Flood Control and Drainage - If maintenance practices have been modified, describe the modifications here

250x

Flood Control and Drainage - If maintenance practices have been modified, describe the modifications here

String

AR_FCDR

Flood Control and Drainage - Have maintenance practices been Reviewed?

 

Flood Control and Drainage - Have maintenance practices been Reviewed?

Boolean

AR_ID

Water Quality Spill Review Record Number

nnnnnnnn

Water Quality Spill Review Record Number

Long Integer

AR_MOD_BY

Last Modified By

25x

Last Modified By

String

AR_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

AR_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

AR_OPFM

Other Public Facilities - Have maintenance practices been Modified?

 

Other Public Facilities - Have maintenance practices been Modified?

Boolean

AR_OPFMOD

Other Public Facilities - If maintenance practices have been modified, describe the modifications here

250x

Other Public Facilities - If maintenance practices have been modified, describe the modifications here

String

AR_OPFR

Other Public Facilities - Have maintenance practices been Reviewed?

 

Other Public Facilities - Have maintenance practices been Reviewed?

Boolean

AR_PRM

Parks and Recreation - Have maintenance practices been Modified?

 

Parks and Recreation - Have maintenance practices been Modified?

Boolean

AR_PRMOD

Parks and Recreation - If maintenance practices have been modified, describe the modifications here

250x

Parks and Recreation - If maintenance practices have been modified, describe the modifications here

String

AR_PRR

Parks and Recreation - Have maintenance practices been Reviewed?

 

Parks and Recreation - Have maintenance practices been Reviewed?

Boolean

AR_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

AR_SCOMMENT

Short Comment

250x

Short Comment

String

AR_SOPMOD

Sewage Spill Response Procedures - If maintenance practices have been modified, describe the modifications here

250x

Sewage Spill Response Procedures - If maintenance practices have been modified, describe the modifications here

String

AR_SOPR

Sewage Spill Response Procedures - Have standard operating procedures and spill response plans regarding protecting storm drains in case of a sewage spill been Reviewed?

 

Sewage Spill Response Procedures - Have standard operating procedures and spill response plans regarding protecting storm drains in case of a sewage spill been Reviewed?

Boolean

AR_USER1CD

User 1

nnn

User 1

Integer

AR_USER1TY

User 1 Text

50x

User 1 Text

String

AR_USER2CD

User 2

nnn

User 2

Integer

AR_USER2TY

User 2 Text

50x

User 2 Text

String

AR_USER3CD

User 3

nnn

User 3

Integer

AR_USER3TY

User 3 Text

50x

User 3 Text

String

AR_USER4CD

User 4

nnn

User 4

Integer

AR_USER4TY

User 4 Text

50x

User 4 Text

String

AR_USER5CD

User 5

nnn

User 5

Integer

AR_USER5TY

User 5 Text

50x

User 5 Text

String

AR_USER6

User 6

50x

User 6

String

AR_USER7

User 7

50x

User 7

String

AR_USER8

User 8

50x

User 8

String

AR_USER9

User 9

50x

User 9

String

AR_USER10

User 10

50x

User 10

String

AR_USER11

User 11

nnnnnnnn.nn

User 11

Double

AR_USER12

User 12

nnnnnnnn.nn

User 12

Double

AR_USER13

User 13

nnnnnnnn.nn

User 13

Double

AR_USER14

User 14

nnnnnnnn.nn

User 14

Double

AR_USER15

User 15

nnnnnnnn.nn

User 15

Double

AR_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

AR_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

AR_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

AR_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

AR_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

AR_USER21

User 21

 

User 21

Boolean

AR_USER22

User 22

 

User 22

Boolean

AR_USER23

User 23

 

User 23

Boolean

AR_USER24

User 24

 

User 24

Boolean

AR_USER25

User 25

 

User 25

Boolean

AR_YEAR

Year

nnn

Year

Integer