SWIPTF

Sewer Industrial PreTreatment Facilities

Field Name	Caption	Mask	Description	Field Type
IF_ACCT	Account Number	30x	Account Number	Text
IF_ACTIVE	Active Facility		Active Facility	Boolean
IF_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
IF_ADR_B22	Street 2 Post Bldg No	8x	Street 2 Post Building No	Text
IF_ADR_BDG	Address	nnnnnn	Address	Long Integer
IF_ADR_DIR	Street Direction	2x	Street Direction	Text
IF_ADR_PT	Street Prefix Type	5x	Street Prefix	Text
IF_ADR_SFX	Street Suffix	5x	Street Suffix	Text
IF_ADR_STR	Street Name	50x	Street Name	Text
IF_ADR_TY	Street Type	5x	Street Type	Text
IF_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	Text
IF_ADRBDG2	Address 2	nnnnnn	Address 2	Long Integer
IF_ADRDIR2	Street Direction 2	2x	Street Direction 2	Text
IF_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	Text
IF_ADRSTR2	Street Name 2	50x	Street Name 2	Text
IF_ADRTY2	Street Type 2	5x	Street Type 2	Text
IF_AFEE	Annual Fee	nnnnnnn.nn	Annual Fee	Double
IF_APT_NO	Apartment/Suite	8x	Apt Number	Text
IF_AREA	Area (SF)	nnnnnnn.n	Area (SF)	Double
IF_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
IF_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
IF_BR_CD	Default WO Cat	10x	Default Category Code	Text
IF_BR_TY	Default WO Cat Text	60x	Default Category Code	Text
IF_BRAT_CD	Billing Rate	nnn	Billing Rate	Integer
IF_BRAT_TY	Billing Rate Text	30x	Billing Rate Text	Text
IF_CADDR1	Contact Address 1	50x	Contact Address 1	Text
IF_CADDR2	Contact Address 2	50x	Contact Address 2	Text
IF_CADDR3	Contact Address 3	50x	Contact Address 3	Text
IF_CEMAIL	Contact Email	150x	Contact Email	Text
IF_CFAX	Contact Fax Phone	25x	Contact Fax	Text
IF_CITY	City	30x	City	Text
IF_CLAS_CD	Classification	nnn	Classification	Integer
IF_CLAS_TY	Classification Text	30x	Classification Text	Text
IF_CMOBILE	Contact Cell Phone	25x	Contact Mobile/Cell Phone	Text
IF_CNOT_CD	Notification	nnn	Notification	Integer
IF_CNOT_DT	Notification Date	mm/dd/yyyy	Notification Date	Date/Time
IF_CNOT_TY	Notification Text	30x	Notification Text	Text
IF_CONT_CD	Contact Type	nnn	Contact Type	Integer
IF_CONT_TY	Contact Type Text	30x	Contact Type Text	Text
IF_CPHONE	Contact Phone	25x	Contact Phone	Text
IF_CRT_BY	Created By	25x	Created By	Text
IF_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
IF_CSW	Critical Storm Cleaning		Critical Storm Cleaning	Boolean
IF_DOC_FLG	Document Available		Document Flag	Boolean
IF_EMPL	# of Employees	nnnn	# of Employees	Integer
IF_ENVRTN	Envelope Returned		Envelope Returned	Boolean
IF_FA_ID	FOG Facility #	nnnnnnnn	Link to SWFOGFA.FA_ID	Long Integer
IF_FIRST	Name	30x	First Name	Text
IF_FLLW_DT	Follow-up Date	mm/dd/yyyy	Follow-up Date for Violation Corrective actions	Date/Time
IF_FPHONE	Facility Phone	25x	Facility Phone	Text
IF_FSE	FSE		Food Service Establishment (FSE)	Boolean
IF_GINTER	Grease Interceptor		Grease Interceptor	Boolean
IF_GTM_CD	Grease Trap Mon	nnn	Grease Trap Monitor	Integer
IF_GTM_TY	Grease Trap Mon Text	30x	Grease Trap Monitor Text	Text
IF_GTRAP	Grease Trap		Grease Trap	Boolean
IF_HOURS	Open Hours	254x	Open Hours	Text
IF_HPSW	High Priority Storm		High Priority Storm	Boolean
IF_ID	Facility Record No	nnnnnnnn	Facilities Record #	Long Integer
IF_IF_ID	Previous Facility	nnnnnnnn	Link to another record in SWIPTF.IF_ID	Long Integer
IF_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
IF_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
IF_IFRQ_TY	Inspection Freq Units Tex	10x	Inspection Freq Units Text	Text
IF_INDUS_CD	Industry	10x	Industry	Text
IF_INDUS_TY	Industry Text	60x	Industry Text	Text
IF_INMAP	In Map?		Flag indicating this feature is in the map	Boolean
IF_INSP_CD	Assigned Inspector	nnn	Assigned Inspector	Integer
IF_INSP_TY	Assigned Inspector Text	30x	Assigned Inspector Text	Text
IF_LAST	Last Name	30x	Last Name	Text
IF_LINS_DT	Last Inspection Date	mm/dd/yyyy	Last Inspection Date	Date/Time
IF_LINS_TM			Last Inspection Time	Date/Time
IF_LOCATE	General Location	100x	General Location	Text
IF_LTST_DT	Last Test Date	mm/dd/yyyy	Last Test Date	Date/Time
IF_LUSE_CD	Land Use	nnn	Land Use	Integer
IF_LUSE_TY	Land Use Text	30x	Land Use Text	Text
IF_LUSER1	Logical User 1		Logical User 1	Boolean
IF_LUSER2	Logical User 2		Logical User 2	Boolean
IF_LUSER3	Logical User 3		Logical User 3	Boolean
IF_LUSER4	Logical User 4		Logical User 4	Boolean
IF_LUSER5	Logical User 5		Logical User 5	Boolean
IF_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
IF_MA_ID	Structure Rec #	nnnnnnnn	Link to SWNETMH.MA_ID	Long Integer
IF_MAP_NO	Map Number	15x	Map Number	Text
IF_METERNO	Meter Number	25x	Meter Number	Text
IF_MFEE	Monthly Fee	nnnnnnn.nn	Monthly Fee	Double
IF_MOD_BY	Last Modified By	25x	Last Modified By	Text
IF_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
IF_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
IF_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
IF_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
IF_NAM_MI	Middle Initial	1x	Middle Initial	Text
IF_NAM_SAL	Salutation	6x	Salutation Text	Text
IF_NAM_SFX	Suffix	5x	Suffix	Text
IF_NAME	Facility Name	50x	Facility Name	Text
IF_NINS_DT	Next Inspection Date	mm/dd/yyyy	Next Inspection Date	Date/Time
IF_NLOG_DT	Next Log Due Date	mm/dd/yyyy	Next Log Due Date	Date/Time
IF_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
IF_NT_ID	Pipe Rec #	nnnnnnnn	Link to SWNET.NT_ID	Long Integer
IF_NTST_DT	Next Test Date	mm/dd/yyyy	Next Test Date	Date/Time
IF_NUMBER	Facility Number	30x	Facility Number	Text
IF_OADDR1	Owner Address 1	50x	Owner Address 1	Text
IF_OADDR2	Owner Address 2	50x	Owner Address 2	Text
IF_OADDR3	Owner Address 3	50x	Owner Address 3	Text
IF_OBUS	Owner Business	50x	Owner Business	Text
IF_OEMAIL	Owner Email	150x	Owner Email	Text
IF_ONAME	Owner Name	50x	Owner Name	Text
IF_ONSITE	On-Site Contact		On-Site Contact	Boolean
IF_OPHONE1	Owner Phone 1	25x	Owner Phone 1	Text
IF_OPHONE2	Owner Phone 2	25x	Owner Phone 2	Text
IF_OPHONE3	Owner Phone 3	25x	Owner Phone 3	Text
IF_OPHONE4	Owner Phone 4	25x	Owner Phone 4	Text
IF_PAPP_DT	Permit Approval	mm/dd/yyyy	Permit Approval Date	Date/Time
IF_PERMIT	Permitted		Permitted	Boolean
IF_PERMITN	Permit Number	30x	Permit Number	Text
IF_PEXP_DT	Permit Expiration	mm/dd/yyyy	Permit Expiration Date	Date/Time
IF_POSTAL	Zip Code	15x	Zip Code	Text
IF_PROPTAG	Property ID Tag	20x	Property ID Tag	Text
IF_QC_ID	SWQ Commercial Link	nnnnnnnn	Link to SMQC.QC_ID	Long Integer
IF_QF_ID	SWQ Management Plan Link	nnnnnnnn	Link to SMQF.QF_ID	Long Integer
IF_QI_ID	SWQ Industrial Link	nnnnnnnn	Link to SMQI.QI_ID	Long Integer
IF_ROWVER			Rowversion for optimistic locking	Date/Time
IF_SCLA_CD	Sub Class	nnn	Sub Class	Integer
IF_SCLA_TY	Sub Class Text	30x	Sub Class Text	Text
IF_SECT	Section	15x	Section	Text
IF_SRETRN	Survey Returned		Survey Returned	Boolean
IF_STAT_CD	Status	nnn	Status	Integer
IF_STAT_TY	Status Text	25x	Status Text	String
IF_STATE	State	30x	State	Text
IF_STYPE_CD	Subtype	nnn	GIS Subtype Code	Integer
IF_STYPE_TY	Subtype Text	25x	GIS Subtype Text	Text
IF_SUBSECT	Sub-Section	15x	Sub-Section	Text
IF_SV_ID	Service Lateral Rec #	nnnnnnnn	Link to SWSERV.SV_ID	Long Integer
IF_TFREQ	Test Freq	nnn	Test Freq	Integer
IF_TFRQ_CD	Test Freq Units	nnn	Test Freq Units	Integer
IF_TFRQ_TY	Test Freq Units Tex	10x	Test Freq Units Text	Text
IF_TITL_CD	Title	nnn	Title	Integer
IF_TITL_TY	Title Text	30x	Title Text	Text
IF_USER1CD	User 1	nnn	User 1	Integer
IF_USER1TY	User 1 Text	30x	User 1 Text	Text
IF_USER2CD	User 2	nnn	User 2	Integer
IF_USER2TY	User 2 Text	30x	User 2 Text	Text
IF_USER3CD	User 3	nnn	User 3	Integer
IF_USER3TY	User 3 Text	30x	User 3 Text	Text
IF_USER4CD	User 4	nnn	User 4	Integer
IF_USER4TY	User 4 Text	30x	User 4 Text	Text
IF_USER5CD	User 5	nnn	User 5	Integer
IF_USER5TY	User 5 Text	30x	User 5 Text	Text
IF_USER6	User 6	30x	User 6	Text
IF_USER7	User 7	30x	User 7	Text
IF_USER8	User 8	30x	User 8	Text
IF_USER9	User 9	30x	User 9	Text
IF_USER10	User 10	30x	User 10	Text
IF_USER11	User 11	nnnnnnnn.nn	User 11	Double
IF_USER12	User 12	nnnnnnnn.nn	User 12	Double
IF_USER13	User 13	nnnnnnnn.nn	User 13	Double
IF_USER14	User 14	nnnnnnnn.nn	User 14	Double
IF_USER15	User 15	nnnnnnnn.nn	User 15	Double
IF_USER16	User 16	mm/dd/yyyy	User 16	Date/Time
IF_USER17	User 17	mm/dd/yyyy	User 17	Date/Time
IF_USER18	User 18	mm/dd/yyyy	User 18	Date/Time
IF_USER19	User 19	mm/dd/yyyy	User 19	Date/Time
IF_USER20	User 20	mm/dd/yyyy	User 20	Date/Time
IF_USER21	User 21		User 21	Boolean
IF_USER22	User 22		User 22	Boolean
IF_USER23	User 23		User 23	Boolean
IF_USER24	User 24		User 24	Boolean
IF_USER25	User 25		User 25	Boolean
IF_USER26CD	User 26	nnn	User 26	Integer
IF_USER26TY	User 26 Text	30x	User 26 Text	Text
IF_USER27CD	User 27	nnn	User 27	Integer
IF_USER27TY	User 27 Text	30x	User 27 Text	Text
IF_USER28CD	User 28	nnn	User 28	Integer
IF_USER28TY	User 28 Text	30x	User 28 Text	Text
IF_USER29CD	User 29	nnn	User 29	Integer
IF_USER29TY	User 29 Text	30x	User 29 Text	Text
IF_USER30CD	User 30	nnn	User 30	Integer
IF_USER30TY	User 30 Text	30x	User 30 Text	Text
IF_USER31	User 31	30x	User 31	Text
IF_USER32	User 32	30x	User 32	Text
IF_USER33	User 33	30x	User 33	Text
IF_USER34	User 34	30x	User 34	Text
IF_USER35	User 35	30x	User 35	Text
IF_USER36	User 36	nnnnnnnn.nn	User 36	Double
IF_USER37	User 37	nnnnnnnn.nn	User 37	Double
IF_USER38	User 38	nnnnnnnn.nn	User 38	Double
IF_USER39	User 39	nnnnnnnn.nn	User 39	Double
IF_USER40	User 40	nnnnnnnn.nn	User 40	Double
IF_USER41	User 41	mm/dd/yyyy	User 41	Date/Time
IF_USER42	User 42	mm/dd/yyyy	User 42	Date/Time
IF_USER43	User 43	mm/dd/yyyy	User 43	Date/Time
IF_USER44	User 44	mm/dd/yyyy	User 44	Date/Time
IF_USER45	User 45	mm/dd/yyyy	User 45	Date/Time
IF_USER46	User 46		User 46	Boolean
IF_USER47	User 47		User 47	Boolean
IF_USER48	User 48		User 48	Boolean
IF_USER49	User 49		User 49	Boolean
IF_USER50	User 50		User 50	Boolean
IF_USER51CD	User 51	10x	User 51	String
IF_USER51TY	User 51 Text	60x	User 51 Text	String
IF_USER52CD	User 52	10x	User 52	String
IF_USER52TY	User 52 Text	60x	User 52 Text	String
IF_USER53CD	User 53	10x	User 53	String
IF_USER53TY	User 53 Text	60x	User 53 Text	String
IF_USER54CD	User 54	10x	User 54	String
IF_USER54TY	User 54 Text	60x	User 54 Text	String
IF_USER55CD	User 55	10x	User 55	String
IF_USER55TY	User 55 Text	60x	User 55 Text	String
IF_WUSAGE	Water Usage (CF)	nnnnn	Water Usage (CF or any other volume listed)	Long Integer
IF_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
IF_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double
IF_Z	Elevation	nnnnnnnnn.nn	Elevation	Double