SMQAPE

Storm Water Quality Public Education Information

Field Name

Caption

Mask

Description

Field Type

AP_CRT_BY

Created By

25x

Created By

String

AP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

AP_DOC_FLG

Document Flag

 

Document Flag

Boolean

AP_END_DT

End Date

mm/dd/yyyy hh:mm am

End Date

DateTime

AP_EPOSTAL

Event Zip Code

15x

Event Zip Code

String

AP_ETOPIC

Event Topic

150x

Event Topic

String

AP_EVENT

Event Description

250x

Event Description

String

AP_EVENTLOC

Event Location

200x

Event Location

String

AP_ID

Public Education Record Number

nnnnnnnn

Public Education Record Number

Long Integer

AP_IMPRESS

Number of Impressions

nnnnnnnn

Number of Impressions

Long Integer

AP_MATERIALS

Materials

250x

Materials

String

AP_MOD_BY

Last Modified By

25x

Last Modified By

String

AP_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

AP_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

AP_NUMBER

Public Outreach ID

30x

Public Outreach ID

String

AP_OTYP_CD

Outreach Type

10x

Outreach Type

String

AP_OTYP_TY

Outreach Type Text

60x

Outreach Type Text

String

AP_PP01

Particpating Permittees 1

 

Particpating Permittees 1

Boolean

AP_PP02

Particpating Permittees 2

 

Particpating Permittees 2

Boolean

AP_PP03

Particpating Permittees 3

 

Particpating Permittees 3

Boolean

AP_PP04

Particpating Permittees 4

 

Particpating Permittees 4

Boolean

AP_PP05

Particpating Permittees 5

 

Particpating Permittees 5

Boolean

AP_PP06

Particpating Permittees 6

 

Particpating Permittees 6

Boolean

AP_PP07

Particpating Permittees 7

 

Particpating Permittees 7

Boolean

AP_PP08

Particpating Permittees 8

 

Particpating Permittees 8

Boolean

AP_PP09

Particpating Permittees 9

 

Particpating Permittees 9

Boolean

AP_PP10

Particpating Permittees 10

 

Particpating Permittees 10

Boolean

AP_PP11

Particpating Permittees 11

 

Particpating Permittees 11

Boolean

AP_PP12

Particpating Permittees 12

 

Particpating Permittees 12

Boolean

AP_PP13

Particpating Permittees 13

 

Particpating Permittees 13

Boolean

AP_PP14

Particpating Permittees 14

 

Particpating Permittees 14

Boolean

AP_PP15

Particpating Permittees 15

 

Particpating Permittees 15

Boolean

AP_PP16

Particpating Permittees 16

 

Particpating Permittees 16

Boolean

AP_PP17

Particpating Permittees 17

 

Particpating Permittees 17

Boolean

AP_PP18

Particpating Permittees 18

 

Particpating Permittees 18

Boolean

AP_PP19

Particpating Permittees 19

 

Particpating Permittees 19

Boolean

AP_PP20

Particpating Permittees 20

 

Particpating Permittees 20

Boolean

AP_PP21

Particpating Permittees 21

 

Particpating Permittees 21

Boolean

AP_PP22

Particpating Permittees 22

 

Particpating Permittees 22

Boolean

AP_PP23

Particpating Permittees 23

 

Particpating Permittees 23

Boolean

AP_PP24

Particpating Permittees 24

 

Particpating Permittees 24

Boolean

AP_PP25

Particpating Permittees 25

 

Particpating Permittees 25

Boolean

AP_PWE

Program Wide Event

 

Program Wide Event

Boolean

AP_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

AP_SCOMMENT

Short Comment

250x

Short Comment

String

AP_START_DT

Start Date

mm/dd/yyyy hh:mm am

Start Date

DateTime

AP_USER1CD

User 1

nnn

User 1

Integer

AP_USER1TY

User 1 Text

50x

User 1 Text

String

AP_USER2CD

User 2

nnn

User 2

Integer

AP_USER2TY

User 2 Text

50x

User 2 Text

String

AP_USER3CD

User 3

nnn

User 3

Integer

AP_USER3TY

User 3 Text

50x

User 3 Text

String

AP_USER4CD

User 4

nnn

User 4

Integer

AP_USER4TY

User 4 Text

50x

User 4 Text

String

AP_USER5CD

User 5

nnn

User 5

Integer

AP_USER5TY

User 5 Text

50x

User 5 Text

String

AP_USER6

User 6

50x

User 6

String

AP_USER7

User 7

50x

User 7

String

AP_USER8

User 8

50x

User 8

String

AP_USER9

User 9

50x

User 9

String

AP_USER10

User 10

50x

User 10

String

AP_USER11

User 11

nnnnnnnn.nn

User 11

Double

AP_USER12

User 12

nnnnnnnn.nn

User 12

Double

AP_USER13

User 13

nnnnnnnn.nn

User 13

Double

AP_USER14

User 14

nnnnnnnn.nn

User 14

Double

AP_USER15

User 15

nnnnnnnn.nn

User 15

Double

AP_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

AP_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

AP_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

AP_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

AP_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

AP_USER21

User 21

 

User 21

Boolean

AP_USER22

User 22

 

User 22

Boolean

AP_USER23

User 23

 

User 23

Boolean

AP_USER24

User 24

 

User 24

Boolean

AP_USER25

User 25

 

User 25

Boolean

AP_USER26CD

User 26

nnn

User 26

Integer

AP_USER26TY

User 26 Text

50x

User 26 Text

String

AP_USER27CD

User 27

nnn

User 27

Integer

AP_USER27TY

User 27 Text

50x

User 27 Text

String

AP_USER28CD

User 28

nnn

User 28

Integer

AP_USER28TY

User 28 Text

50x

User 28 Text

String

AP_USER29CD

User 29

nnn

User 29

Integer

AP_USER29TY

User 29 Text

50x

User 29 Text

String

AP_USER30CD

User 30

nnn

User 30

Integer

AP_USER30TY

User 30 Text

50x

User 30 Text

String

AP_USER31

User 31

50x

User 31

String

AP_USER32

User 32

50x

User 32

String

AP_USER33

User 33

50x

User 33

String

AP_USER34

User 34

50x

User 34

String

AP_USER35

User 35

50x

User 35

String

AP_USER36

User 36

nnnnnnnn.nn

User 36

Double

AP_USER37

User 37

nnnnnnnn.nn

User 37

Double

AP_USER38

User 38

nnnnnnnn.nn

User 38

Double

AP_USER39

User 39

nnnnnnnn.nn

User 39

Double

AP_USER40

User 40

nnnnnnnn.nn

User 40

Double

AP_USER41

User 41

mm/dd/yyyy hh:mm am

User 41

DateTime

AP_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

AP_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

AP_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

AP_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

AP_USER46

User 46

 

User 46

Boolean

AP_USER47

User 47

 

User 47

Boolean

AP_USER48

User 48

 

User 48

Boolean

AP_USER49

User 49

 

User 49

Boolean

AP_USER50

User 50

 

User 50

Boolean