SMQC

Field Name

Caption

Mask

Description

Field Type

QC_303DP

303D Pollutants

250x

303D Pollutants

String

QC_AACCOUNT

Asset Account #

45x

Asset Account #

Text

QC_ACT_DT

Active Date

mm/dd/yyyy hh:mm am

Active Date

DateTime

QC_ACTIVE

Active Project

Active Project

Boolean

QC_ADR_B2

Street Post Building No

8x

Street Post Building No

String

QC_ADR_B22

Street 2 Post Building No

8x

Street 2 Post Building No

String

QC_ADR_BDG

Address

nnnnnnnn

Address

Long Integer

QC_ADR_DIR

Street Direction

2x

Street Direction

String

QC_ADR_PT

Street Prefix

5x

Street Prefix

String

QC_ADR_SFX

Street Suffix

5x

Street Suffix

String

QC_ADR_STR

Street Name

50x

Street Name

String

QC_ADR_TY

Street Type

5x

Street Type

String

QC_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

String

QC_ADRBDG2

Address 2

nnnnnnnn

Address 2

Long Integer

QC_ADRDIR2

Street Direction 2

2x

Street Direction 2

String

QC_ADRSFX2

Street Suffix 2

5x

Street Suffix 2

String

QC_ADRSTR2

Street Name 2

50x

Street Name 2

String

QC_ADRTY2

Street Type 2

5x

Street Type 2

String

QC_APN

APN

40x

APN

String

QC_APNUMACT

Asset Proj No - Acct

40x

Asset Proj No - Acct

Text

QC_APT_NO

Apt Number

25x

Apt Number

String

QC_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

QC_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

QC_BDESC

Business Description

100x

Business Description

String

QC_BNAME

Business Name

50x

Business Name

String

QC_BR_CD

Default Category Code

10x

Default Category Code

String

QC_BR_TY

Default Category Code

60x

Default Category Code

String

QC_CADDR1

Contact Address 1

50x

Contact Address 1

String

QC_CADDR2

Contact Address 2

50x

Contact Address 2

String

QC_CCITY

City

100x

City

String

QC_CEMAIL

Contact Email

150x

Contact Email

String

QC_CFAX

Contact Fax

25x

Contact Fax

String

QC_CITY

City

100x

City

String

QC_CMOBILE

Contact Mobile/Cell Phone

25x

Contact Mobile/Cell Phone

String

QC_CNAME

Contact Name

50x

Contact Name

String

QC_CNOT_CD

Notification

nnn

Notification

Integer

QC_CNOT_DT

Notification Date

mm/dd/yyyy hh:mm am

Notification Date

DateTime

QC_CNOT_TY

Notification Text

50x

Notification Text

String

QC_COMMENT1

Long Note

Long Note

Memo

QC_COND_CD

Condition

nnn

Condition

Integer

QC_COND_TY

Condition Text

100x

Condition Text

Text

QC_CPHONE

Contact Phone

25x

Contact Phone

String

QC_CPOSTAL

Zip Code

15x

Zip Code

String

QC_CRT_BY

Created By

25x

Created By

String

QC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

QC_CSTATE

State

30x

State

String

QC_CSTREET

Cross Street

50x

Cross Street

String

QC_DFIRW

Distance from Immediate Receiving Water

nnnnnnnn.nn

Distance from Immediate Receiving Water

Double

QC_DOC_FLG

Document Flag

Document Flag

Boolean

QC_DRW303DL

Are Downstream Receiving Waters 303D Listed?

Are Downstream Receiving Waters 303D Listed?

Boolean

QC_DUNT_CD

Distance Units

nnn

Distance Units

Integer

QC_DUNT_TY

Distance Units Text

10x

Distance Units Text

String

QC_FLLW_DT

Follow-up Date

mm/dd/yyyy hh:mm am

Follow-up Date

DateTime

QC_GISNEED_CD

Needs GIS

nnn

Needs GIS

Integer

QC_GISNEED_TY

Needs GIS Text

100x

Needs GIS Text

Text

QC_ID

Commercial Record No

nnnnnnnn

Commercial Record No

Long Integer

QC_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

QC_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

QC_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

QC_INAC_DT

Inactive Date

mm/dd/yyyy hh:mm am

Inactive Date

DateTime

QC_INMAP

Flag indicating this feature is in the map

Flag indicating this feature is in the map

Boolean

QC_IRW303DL

Is Immediate Receiving Waters 303D Listed?

Is Immediate Receiving Waters 303D Listed?

Boolean

QC_LATLONG_X

Latlong X

nnnnnnnn.nn

Latlong X

Double

QC_LATLONG_Y

Latlong Y

nnnnnnnn.nn

Latlong Y

Double

QC_LICID

License ID

50x

License ID

String

QC_LINS_DT

Last Inspection Date

mm/dd/yyyy hh:mm am

Last Inspection Date

DateTime

QC_LINS_TM

Last Inspection Time

mm/dd/yyyy hh:mm am

Last Inspection Time

DateTime

QC_LOCATE

General Location

100x

General Location

String

QC_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

QC_MOD_BY

Last Modified By

25x

Last Modified By

String

QC_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

QC_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

QC_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

QC_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

QC_NAIC_CD

NAICS Code

10x

NAICS Code

String

QC_NAIC_TY

NAICS Text

60x

NAICS Text

String

QC_NINS_DT

Next Inspection Date

mm/dd/yyyy hh:mm am

Next Inspection Date

DateTime

QC_NOWORK

No WO/PM/Req

No WO/PM/Req

Boolean

QC_NUMBER

Commercial ID

30x

Commercial ID

String

QC_OADDR1

Owner Contact Address 1

50x

Owner Contact Address 1

String

QC_OADDR2

Owner Contact Address 2

50x

Owner Contact Address 2

String

QC_OCITY

Owner City

100x

Owner City

String

QC_OCOMMENT

Owner Comment

250x

Owner Comment

String

QC_OEMAIL

Owner Contact Email

150x

Owner Contact Email

String

QC_OFAX

Owner Contact Fax

25x

Owner Contact Fax

String

QC_ONAME

Owner Name

50x

Owner Name

String

QC_OPERMIT

Other Permit

250x

Other Permit

String

QC_OPHONE

Owner Contact Phone

25x

Owner Contact Phone

String

QC_OPOSTAL

Owner Zip Code

15x

Owner Zip Code

String

QC_ORP

Owner/Respon Party

50x

Owner/Respon Party

String

QC_OSTATE

Owner State

30x

Owner State

String

QC_OUTDESC

Outreach Description

250x

Outreach Description

String

QC_OUTREAC

Outreach

Outreach

Boolean

QC_POCBV

Pollutants of Concern - Bacteria/Virus

Pollutants of Concern - Bacteria/Virus

Boolean

QC_POCHM

Pollutants of Concern - Heavy Metals

Pollutants of Concern - Heavy Metals

Boolean

QC_POCN

Pollutants of Concern - Nutrients

Pollutants of Concern - Nutrients

Boolean

QC_POCNOTE

Pollutants of Concern - Note

250x

Pollutants of Concern - Note

String

QC_POCO

Pollutants of Concern - Other

Pollutants of Concern - Other

Boolean

QC_POCOC

Pollutants of Concern - Organic Componds

Pollutants of Concern - Organic Componds

Boolean

QC_POCODS

Pollutants of Concern - Oxygen Demand Substances

Pollutants of Concern - Oxygen Demand Substances

Boolean

QC_POCOG

Pollutants of Concern - Oil & Grease

Pollutants of Concern - Oil & Grease

Boolean

QC_POCP

Pollutants of Concern - Pesticides

Pollutants of Concern - Pesticides

Boolean

QC_POCS

Pollutants of Concern - Sediments

Pollutants of Concern - Sediments

Boolean

QC_POCTD

Pollutants of Concern - Trash & Debris

Pollutants of Concern - Trash & Debris

Boolean

QC_POSTAL

Zip Code

15x

Zip Code

String

QC_PROPTAG

Property ID Tag

52x

Property ID Tag

String

QC_QA_ID

Link to Site Record

nnnnnnnn

Link to Site Record: SMQSITE

Long Integer

QC_REF

Ref/File Number

30x

Ref/File Number

String

QC_ROWVER

Rowversion for optimistic locking

TimeStamp

QC_RW_CD

Immediate Receiving Water

10x

Immediate Receiving Water

String

QC_RW_TY

Immediate Receiving Water Text

60x

Immediate Receiving Water Text

String

QC_SIC_CD

SIC Code

nnn

SIC Code

Integer

QC_SIC_TY

SIC Text

100x

SIC Text

String

QC_SRN_CD

SubReach Number

10x

SubReach Number

String

QC_SRN_TY

SubReach Number Text

60x

SubReach Number Text

String

QC_STAT_CD

Status

nnn

Status

Integer

QC_STAT_TY

Status Text

25x

Status Text

String

QC_STATE

State

30x

State

String

QC_STYPE_CD

GIS Subtype Code

nnn

GIS Subtype Code

Integer

QC_STYPE_TY

GIS Subtype Text

25x

GIS Subtype Text

String

QC_TASBS

Tributary to an Area of Speical Biological Significance (ASBS)

Tributary to an Area of Speical Biological Significance (ASBS)

Boolean

QC_TITL_CD

Title

nnn

Title

Integer

QC_TITL_TY

Title Text

50x

Title Text

String

QC_USER1CD

User 1

nnn

User 1

Integer

QC_USER1TY

User 1 Text

50x

User 1 Text

String

QC_USER2CD

User 2

nnn

User 2

Integer

QC_USER2TY

User 2 Text

50x

User 2 Text

String

QC_USER3CD

User 3

nnn

User 3

Integer

QC_USER3TY

User 3 Text

50x

User 3 Text

String

QC_USER4CD

User 4

nnn

User 4

Integer

QC_USER4TY

User 4 Text

50x

User 4 Text

String

QC_USER5CD

User 5

nnn

User 5

Integer

QC_USER5TY

User 5 Text

50x

User 5 Text

String

QC_USER6

User 6

50x

User 6

String

QC_USER7

User 7

50x

User 7

String

QC_USER8

User 8

50x

User 8

String

QC_USER9

User 9

50x

User 9

String

QC_USER10

User 10

50x

User 10

String

QC_USER11

User 11

nnnnnnnn.nn

User 11

Double

QC_USER12

User 12

nnnnnnnn.nn

User 12

Double

QC_USER13

User 13

nnnnnnnn.nn

User 13

Double

QC_USER14

User 14

nnnnnnnn.nn

User 14

Double

QC_USER15

User 15

nnnnnnnn.nn

User 15

Double

QC_USER16

User 16

mm/dd/yyyy hh:mm am

User 16

DateTime

QC_USER17

User 17

mm/dd/yyyy hh:mm am

User 17

DateTime

QC_USER18

User 18

mm/dd/yyyy hh:mm am

User 18

DateTime

QC_USER19

User 19

mm/dd/yyyy hh:mm am

User 19

DateTime

QC_USER20

User 20

mm/dd/yyyy hh:mm am

User 20

DateTime

QC_USER21

User 21

User 21

Boolean

QC_USER22

User 22

User 22

Boolean

QC_USER23

User 23

User 23

Boolean

QC_USER24

User 24

User 24

Boolean

QC_USER25

User 25

User 25

Boolean

QC_USER26CD

User 26

nnn

User 26

Integer

QC_USER26TY

User 26 Text

50x

User 26 Text

String

QC_USER27CD

User 27

nnn

User 27

Integer

QC_USER27TY

User 27 Text

50x

User 27 Text

String

QC_USER28CD

User 28

nnn

User 28

Integer

QC_USER28TY

User 28 Text

50x

User 28 Text

String

QC_USER29CD

User 29

nnn

User 29

Integer

QC_USER29TY

User 29 Text

50x

User 29 Text

String

QC_USER30CD

User 30

nnn

User 30

Integer

QC_USER30TY

User 30 Text

50x

User 30 Text

String

QC_USER31

User 31

50x

User 31

String

QC_USER32

User 32

50x

User 32

String

QC_USER33

User 33

50x

User 33

String

QC_USER34

User 34

50x

User 34

String

QC_USER35

User 35

50x

User 35

String

QC_USER36

User 36

nnnnnnnn.nn

User 36

Double

QC_USER37

User 37

nnnnnnnn.nn

User 37

Double

QC_USER38

User 38

nnnnnnnn.nn

User 38

Double

QC_USER39

User 39

nnnnnnnn.nn

User 39

Double

QC_USER42

User 42

mm/dd/yyyy hh:mm am

User 42

DateTime

QC_USER43

User 43

mm/dd/yyyy hh:mm am

User 43

DateTime

QC_USER44

User 44

mm/dd/yyyy hh:mm am

User 44

DateTime

QC_USER45

User 45

mm/dd/yyyy hh:mm am

User 45

DateTime

QC_USER46

User 46

User 46

Boolean

QC_USER47

User 47

User 47

Boolean

QC_USER48

User 48

User 48

Boolean

QC_USER49

User 49

User 49

Boolean

QC_USER50

User 50

User 50

Boolean

QC_USER51CD

User 51

10x

User 51

String

QC_USER51TY

User 51 Text

60x

User 51 Text

String

QC_USER52CD

User 52

10x

User 52

String

QC_USER52TY

User 52 Text

60x

User 52 Text

String

QC_USER53CD

User 53

10x

User 53

String

QC_USER53TY

User 53 Text

60x

User 53 Text

String

QC_USER54CD

User 54

10x

User 54

String

QC_USER54TY

User 54 Text

60x

User 54 Text

String

QC_USER55CD

User 55

10x

User 55

String

QC_USER55TY

User 55 Text

60x

User 55 Text

String

QC_WSMPID

WQMP ID#

30x

WQMP ID#

String

QC_X

X Coordinate

nnnnnnnn.nn

X Coordinate

Double

QC_Y

Y Coordinate

nnnnnnnn.nn

Y Coordinate

Double

QC_Z

Elevation

nnnnnnnn.nn

Elevation

Double