SWFOGZY

Sewer FOG Facility NAICS Codes

Field Name

Caption

Mask

Description

Field Type

ZY_CRT_BY

Created By

25x

Created By

Text

ZY_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ZY_FA_ID

Facility Rec #

nnnnnnnn

Link to SWFOGFA.FA_ID

Long Integer

ZY_ID

NAICS Rec #

nnnnnnnn

SIC Record Number

Long Integer

ZY_MOD_BY

Last Modified By

25x

Last Modified By

Text

ZY_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

ZY_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ZY_NAIC_CD

NAICS Code

10x

NAICS Code

Text

ZY_NAIC_TY

NAICS Type

60x

NAICS Text

Text

ZY_ROWVER

 

 

Rowversion for optimistic locking

Date/Time