SWFOGFA

Sewer FOG Facilities

Field Name	Caption	Mask	Description	Field Type
FA_1CS	1-Compartment Sinks	nnn	1-Compartment Sinks	Integer
FA_2CS	2-Compartment Sinks	nnn	2-Compartment Sinks	Integer
FA_3CS	3-Compartment Sinks	nnn	3-Compartment Sinks	Integer
FA_ACCT	Account Number	30x	Account Number	Text
FA_ACTIVE	Active Facility		Active Facility	Boolean
FA_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
FA_ADR_B22	Street 2 Post Bldg No	8x	Street 2 Post Building No	Text
FA_ADR_BDG	Address	nnnnnn	Address	Long Integer
FA_ADR_DIR	Street Direction	2x	Street Direction	Text
FA_ADR_PT	Street Prefix Type	5x	Street Prefix	Text
FA_ADR_SFX	Street Suffix	5x	Street Suffix	Text
FA_ADR_STR	Street Name	50x	Street Name	Text
FA_ADR_STR	Street Name	50x	Street Name	Text
FA_ADR_TY	Street Type	5x	Street Type	Text
FA_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	Text
FA_ADRBDG2	Address 2	nnnnnn	Address 2	Long Integer
FA_ADRDIR2	Street Direction 2	2x	Street Direction 2	Text
FA_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	Text
FA_ADRSTR2	Street Name 2	50x	Street Name 2	Text
FA_ADRSTR2	Street Name 2	50x	Street Name 2	Text
FA_ADRTY2	Street Type 2	5x	Street Type 2	Text
FA_AFEE	Annual Fee	nnnnnnn.nn	Annual Fee	Double
FA_AG_ID	Agency Record No	nnnnnnnn	Agency Record Number	Long Integer
FA_APT_NO	Apartment/Suite	8x	Apt Number	Text
FA_AREA	Area (SF)	nnnnnnn.n	Area (SF)	Double
FA_ASIAN	Asian		Asian	Boolean
FA_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
FA_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
FA_BADDR1	Billing Address 1	50x	Billing Address 1	Text
FA_BADDR2	Billing Address 2	50x	Billing Address 2	Text
FA_BADDR3	Billing Address 3	50x	Billing Address 3	Text
FA_BAKE	Bakery		Bakery	Boolean
FA_BBQ	BBQ		BBQ	Boolean
FA_BBUS	Billing Business	50x	Billing Business	Text
FA_BEMAIL	Billing Email	150x	Billing Email	Text
FA_BNAME	Billing Name	50x	Billing Name	Text
FA_BPHONE1	Billing Phone 1	25x	Billing Phone 1	Text
FA_BPHONE2	Billing Phone 2	25x	Billing Phone 2	Text
FA_BR_CD	Default WO Cat	10x	Default Category Code	Text
FA_BR_TY	Default WO Cat Text	60x	Default Category Code	Text
FA_BRAT_CD	Billing Rate	nnn	Billing Rate	Integer
FA_BRAT_TY	Billing Rate Text	30x	Billing Rate Text	Text
FA_BURGER	Burgers		Burgers	Boolean
FA_CADDR1	Contact Address 1	50x	Contact Address 1	Text
FA_CADDR2	Contact Address 2	50x	Contact Address 2	Text
FA_CADDR3	Contact Address 3	50x	Contact Address 3	Text
FA_CEMAIL	Contact Email	150x	Contact Email	Text
FA_CFAX	Contact Fax Phone	25x	Contact Fax	Text
FA_CHOUSE	Coffeehouse		Coffeehouse	Boolean
FA_CITY	City	30x	City	Text
FA_CLAS_CD	Classification	nnn	Classification	Integer
FA_CLAS_TY	Classification Text	30x	Classification Text	Text
FA_CMOBILE	Contact Cell Phone	25x	Contact Mobile/Cell Phone	Text
FA_CNOT_CD	Notification	nnn	Notification	Integer
FA_CNOT_DT	Notification Date	mm/dd/yyyy	Notification Date	Date/Time
FA_CNOT_TY	Notification Text	30x	Notification Text	Text
FA_COMCAFE	Commercial Cafeteria		Commercial Cafeteria	Boolean
FA_CONT_CD	Contact Type	nnn	Contact Type	Integer
FA_CONT_TY	Contact Type Text	30x	Contact Type Text	Text
FA_CONV	Convenience Store		Convenience Store	Boolean
FA_CORCAFE	Corporate Cafeteria		Corporate Cafeteria	Boolean
FA_CPHONE	Contact Phone	25x	Contact Phone	Text
FA_CRT_BY	Created By	25x	Created By	Text
FA_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
FA_CSW	Critical Storm Cleaning		Critical Storm Cleaning	Boolean
FA_DAYCARE	Day Care		Day Care	Boolean
FA_DOC_FLG	Document Available		Document Flag	Boolean
FA_DONUT	Doughnuts		Doughnut	Boolean
FA_DW	Dishwasher	nnn	Dishwasher	Integer
FA_EMPL	# of Employees	nnnn	# of Employees	Integer
FA_ENVRTN	Envelope Returned		Envelope Returned	Boolean
FA_FA_ID	Previous Facility	nnnnnnnn	Link to another record in EFFOGFA.FA_ID	Long Integer
FA_FDRAIN	Floor Drains	nnn	Floor Drains	Integer
FA_FFOOD	Fast Food		Fast Food	Boolean
FA_FIRST	Name	30x	First Name	Text
FA_FLLW_DT	Follow-up Date	mm/dd/yyyy	Follow-up Date for Violation Corrective actions	Date/Time
FA_FPHONE	Facility Phone	25x	Facility Phone	Text
FA_FRYER	Deep Fryers	nnn	Deep Fryers	Integer
FA_FSE	FSE		Food Service Establishment (FSE)	Boolean
FA_FSINKS	Floor Sinks	nnn	Floor Sinks	Integer
FA_GD	Garbage Disposals	nnn	Garbage Disposals	Integer
FA_GINTER	Grease Interceptor		Grease Interceptor	Boolean
FA_GRILL	Grills	nnn	Grills	Integer
FA_GROCERY	Grocery		Grocery	Boolean
FA_GTM_CD	Grease Trap Mon	nnn	Grease Trap Monitor	Integer
FA_GTM_TY	Grease Trap Mon Text	30x	Grease Trap Monitor Text	Text
FA_GTRAP	Grease Trap		Grease Trap	Boolean
FA_HA_ID	Hauler Record No	nnnnnnnn	Link to SWFOGH.HA_ID	Long Integer
FA_HOTEL	Hotel		Hotel	Boolean
FA_HOURS	Open Hours	254x	Open Hours	Text
FA_HPSW	High Priority Storm		High Priority Storm	Boolean
FA_ICREAM	Ice Cream		Ice Cream	Boolean
FA_ID	Facility Record No	nnnnnnnn	Facilities Record #	Long Integer
FA_IF_ID	IPT Facility	nnnnnnnn	Link to SWIPTF.IF_ID	Long Integer
FA_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
FA_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
FA_IFRQ_TY	Inspection Freq Units Tex	10x	Inspection Freq Units Text	Text
FA_INMAP	In Map?		Flag indicating this feature is in the map	Boolean
FA_INSP_CD	Assigned Inspector	nnn	Assigned Inspector	Integer
FA_INSP_TY	Assigned Inspector Text	30x	Assigned Inspector Text	Text
FA_ITALIAN	Italian		Italian	Boolean
FA_LAST	Last Name	30x	Last Name	Text
FA_LINS_DT	Last Inspection Date	mm/dd/yyyy	Last Inspection Date	Date/Time
FA_LINS_TM	Last Inspection Time	hh:mm am	Last Inspection Time	Date/Time
FA_LOCATE	General Location	100x	General Location	Text
FA_LTS	Low Temp Sanitizer	nnn	Low Temp Sanitizer	Integer
FA_LUSE_CD	Land Use	nnn	Land Use	Integer
FA_LUSE_TY	Land Use Text	30x	Land Use Text	Text
FA_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
FA_MA_ID	Structure Rec #	nnnnnnnn	Link to SWNETMH.MA_ID	Long Integer
FA_MAP_NO	Map Number	15x	Map Number	Text
FA_MEALS	Meals Served	nnnn	Meals Served	Integer
FA_METERNO	Meter Number	25x	Meter Number	Text
FA_MEXICAN	Mexican		Mexican	Boolean
FA_MFEE	Monthly Fee	nnnnnnn.nn	Monthly Fee	Double
FA_MIDEAST	Middle Eastern		Middle Eastern	Boolean
FA_MOD_BY	Last Modified By	25x	Last Modified By	Text
FA_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
FA_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
FA_MOPSINK	Mop Sinks	nnn	Mop Sinks	Integer
FA_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
FA_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
FA_NAM_MI	Middle Initial	1x	Middle Initial	Text
FA_NAM_SAL	Salutation	6x	Salutation Text	Text
FA_NAM_SFX	Suffix	5x	Suffix	Text
FA_NAME	Facility Name	50x	Facility Name	Text
FA_NCLN_DT	Next Cleaning	mm/dd/yyyy	Next Cleaning Date	Date/Time
FA_NINS_DT	Next Inspection Date	mm/dd/yyyy	Next Inspection Date	Date/Time
FA_NLOG_DT	Next Log Due	mm/dd/yyyy	Next Log Due Date	Date/Time
FA_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
FA_NT_ID	Pipe Rec #	nnnnnnnn	Link to SWNET.NT_ID	Long Integer
FA_NUMBER	Facility Number	30x	Facility Number	Text
FA_OADDR1	Owner Address 1	50x	Owner Address 1	Text
FA_OADDR2	Owner Address 2	50x	Owner Address 2	Text
FA_OADDR3	Owner Address 3	50x	Owner Address 3	Text
FA_OBUS	Owner Business	50x	Owner Business	Text
FA_OEMAIL	Owner Email	150x	Owner Email	Text
FA_OFOOD	Other Food Type	150x	Other Food Type	Text
FA_ONAME	Owner Name	50x	Owner Name	Text
FA_ONSITE	On-Site Contact		On-Site Contact	Boolean
FA_OPHONE1	Owner Phone 1	25x	Owner Phone 1	Text
FA_OPHONE2	Owner Phone 2	25x	Owner Phone 2	Text
FA_OPHONE3	Owner Phone 3	25x	Owner Phone 3	Text
FA_OPHONE4	Owner Phone 4	25x	Owner Phone 4	Text
FA_OVEN	Ovens	nnn	Ovens	Integer
FA_PAPP_DT	Permit Approval	mm/dd/yyyy	Permit Approval Date	Date/Time
FA_PERMIT	Permitted		Permitted	Boolean
FA_PERMITN	Permit Number	30x	Permit Number	Text
FA_PEXP_DT	Permit Expiration	mm/dd/yyyy	Permit Expiration Date	Date/Time
FA_PIZZA	Pizzeria		Pizzeria	Boolean
FA_POSTAL	Zip Code	15x	Zip Code	Text
FA_PROPTAG	Property ID Tag	20x	Property ID Tag	Text
FA_PWS	Pre-Wash Sinks	nnn	Pre-Wash Sinks	Integer
FA_QC_ID	SWQ Commercial Link	nnnnnnnn	Link to SMQC.QC_ID	Long Integer
FA_QF_ID	SWQ Management Plan Link	nnnnnnnn	Link to SMQF.QF_ID	Long Integer
FA_QI_ID	SWQ Industrial Link	nnnnnnnn	Link to SMQI.QI_ID	Long Integer
FA_ROWVER			Rowversion for optimistic locking	Date/Time
FA_SANSOUP	Sandwich/Soup		Sandwich/Soup	Boolean
FA_SCAFE	School Cafeteria		School Cafeteria	Boolean
FA_SCLA_CD	Sub Class	nnn	Sub Class	Integer
FA_SCLA_TY	Sub Class Text	30x	Sub Class Text	Text
FA_SEAFOOD	Seafood		Seafood	Boolean
FA_SEAT	Seating Capacity	nnnn	Seating Capacity	Integer
FA_SECT	Section	15x	Section	Text
FA_SMOOTH	Smoothies		Smoothies	Boolean
FA_SOUTH	Southern		Southern	Boolean
FA_SPORTS	Sports Grill		Sports Grill	Boolean
FA_SRETRN	Survey Returned		Survey Returned	Boolean
FA_STATE	State	30x	State	Text
FA_STEAK	Steakhouse		Steakhouse	Boolean
FA_STOVE	Stove	nnn	Stove	Integer
FA_STYPE_CD	Subtype	nnn	GIS Subtype Code	Integer
FA_STYPE_TY	Subtype Text	25x	GIS Subtype Text	Text
FA_SUBSECT	Sub-Section	15x	Sub-Section	Text
FA_SV_ID	Service Lateral Rec #	nnnnnnnn	Link to SWSERV.SV_ID	Long Integer
FA_TITL_CD	Title	nnn	Title	Integer
FA_TITL_TY	Title Text	30x	Title Text	Text
FA_TKETTLE	Tilt Kettles	nnn	Tilt Kettles	Integer
FA_USER1CD	User 1	nnn	User 1	Integer
FA_USER1TY	User 1 Text	30x	User 1 Text	Text
FA_USER2CD	User 2	nnn	User 2	Integer
FA_USER2TY	User 2 Text	30x	User 2 Text	Text
FA_USER3CD	User 3	nnn	User 3	Integer
FA_USER3TY	User 3 Text	30x	User 3 Text	Text
FA_USER4CD	User 4	nnn	User 4	Integer
FA_USER4TY	User 4 Text	30x	User 4 Text	Text
FA_USER5CD	User 5	nnn	User 5	Integer
FA_USER5TY	User 5 Text	30x	User 5 Text	Text
FA_USER6	User 6	30x	User 6	Text
FA_USER7	User 7	30x	User 7	Text
FA_USER8	User 8	30x	User 8	Text
FA_USER9	User 9	30x	User 9	Text
FA_USER10	User 10	30x	User 10	Text
FA_USER11	User 11	nnnnnnnn.nn	User 11	Double
FA_USER12	User 12	nnnnnnnn.nn	User 12	Double
FA_USER13	User 13	nnnnnnnn.nn	User 13	Double
FA_USER14	User 14	nnnnnnnn.nn	User 14	Double
FA_USER15	User 15	nnnnnnnn.nn	User 15	Double
FA_USER16	User 16	mm/dd/yyyy	User 16	Date/Time
FA_USER17	User 17	mm/dd/yyyy	User 17	Date/Time
FA_USER18	User 18	mm/dd/yyyy	User 18	Date/Time
FA_USER19	User 19	mm/dd/yyyy	User 19	Date/Time
FA_USER20	User 20	mm/dd/yyyy	User 20	Date/Time
FA_USER21	User 21		User 21	Boolean
FA_USER22	User 22		User 22	Boolean
FA_USER23	User 23		User 23	Boolean
FA_USER24	User 24		User 24	Boolean
FA_USER25	User 25		User 25	Boolean
FA_USER26CD	User 26	nnn	User 26	Integer
FA_USER26TY	User 26 Text	30x	User 26 Text	Text
FA_USER27CD	User 27	nnn	User 27	Integer
FA_USER27TY	User 27 Text	30x	User 27 Text	Text
FA_USER28CD	User 28	nnn	User 28	Integer
FA_USER28TY	User 28 Text	30x	User 28 Text	Text
FA_USER29CD	User 29	nnn	User 29	Integer
FA_USER29TY	User 29 Text	30x	User 29 Text	Text
FA_USER30CD	User 30	nnn	User 30	Integer
FA_USER30TY	User 30 Text	30x	User 30 Text	Text
FA_USER31	User 31	30x	User 31	Text
FA_USER32	User 32	30x	User 32	Text
FA_USER33	User 33	30x	User 33	Text
FA_USER34	User 34	30x	User 34	Text
FA_USER35	User 35	30x	User 35	Text
FA_USER36	User 36	nnnnnnnn.nn	User 36	Double
FA_USER37	User 37	nnnnnnnn.nn	User 37	Double
FA_USER38	User 38	nnnnnnnn.nn	User 38	Double
FA_USER39	User 39	nnnnnnnn.nn	User 39	Double
FA_USER40	User 40	nnnnnnnn.nn	User 40	Double
FA_USER41	User 41	mm/dd/yyyy	User 41	Date/Time
FA_USER42	User 42	mm/dd/yyyy	User 42	Date/Time
FA_USER43	User 43	mm/dd/yyyy	User 43	Date/Time
FA_USER44	User 44	mm/dd/yyyy	User 44	Date/Time
FA_USER45	User 45	mm/dd/yyyy	User 45	Date/Time
FA_USER46	User 46		User 46	Boolean
FA_USER47	User 47		User 47	Boolean
FA_USER48	User 48		User 48	Boolean
FA_USER49	User 49		User 49	Boolean
FA_USER50	User 50		User 50	Boolean
FA_USER51CD	User 51	10x	User 51	String
FA_USER51TY	User 51 Text	60x	User 51 Text	String
FA_USER52CD	User 52	10x	User 52	String
FA_USER52TY	User 52 Text	60x	User 52 Text	String
FA_USER53CD	User 53	10x	User 53	String
FA_USER53TY	User 53 Text	60x	User 53 Text	String
FA_USER54CD	User 54	10x	User 54	String
FA_USER54TY	User 54 Text	60x	User 54 Text	String
FA_USER55CD	User 55	10x	User 55	String
FA_USER55TY	User 55 Text	60x	User 55 Text	String
FA_WEST	Western		Western	Boolean
FA_WOK	Wok Ranges	nnn	Wok Ranges	Integer
FA_WUSAGE	Water Usage (CF)	nnnnn	Water Usage (CF or any other volume listed)	Long Integer
FA_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
FA_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double
FA_YGOSC	Container On-Site		Yellow Grease Container On-Site	Boolean
FA_YGR	Yellow Grease Hauler	50x	Yellow Grease Rendering Company	Text
FA_Z	Elevation	nnnnnnnnn.nn	Elevation	Double