Fac This file contains the basic information for a site including the registration number, registration type, company name, mailing address, site location, and other notification information. Columns Field Description 1 5 PA_IHW_FAC.SWR_NUM_TXT Waste Registration number – 6 55 Facility site name – 56 63 PA_IHW_FAC.NOR_CREATE_DT Registration’s initial notification date (YYYYMMDD) – 64 71 PA_IHW_FAC.SIGN_DT Registration’s last amendment date (YYYYMMDD) – 72 83 LM_ADDN_ID.ADD_NUM_TXT EPA ID number for the facility. The record in the – LM_ADDN_ID table will have the ID type used for EPA ID 84 -88 TCEQ Hazardous Waste Permit number 89 148 Description of the facility site location. May be an address – associated to AI or a description of how to locate the site. 149 153 LM_ADDN_ID_INDUS_TYP Site primary Standard Industrialization Code. The record – in the LM_ADDN_ID_INDUS_TYP table will have the ID type used for SIC 154 -154 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification parent for Generator. Otherwise = 0 155 155 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification – parent for Receiver. Otherwise = 0 156 156 LM_ADDN_ID_SITE_CLASS = 1, of is a record found for the site classification – parent for IHW Transporter. Otherwise = 0
Fac This file contains the basic information for a site including the registration number, registration type, company name, mailing address, site location, and other notification information. Columns Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Waste Registration number 6 – 55 Facility site name 56 – 63 PA_IHW_FAC.NOR_CREATE_DT Registration’s initial notification date (YYYYMMDD) 64 – 71 PA_IHW_FAC.SIGN_DT Registration’s last amendment date (YYYYMMDD) 72 – 83 LM_ADDN_ID.ADD_NUM_TXT EPA ID number for the facility. The record in the LM_ADDN_ID table will have the ID type used for EPA ID 84 -88 TCEQ Hazardous Waste Permit number 89 – 148 associated to AI Description of the facility site location. May be an address or a description of how to locate the site. 149 – 153 LM_ADDN_ID_INDUS_TYP Site primary Standard Industrialization Code. The record in the LM_ADDN_ID_INDUS_TYP table will have the ID type used for SIC 154 -154 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification parent for Generator. Otherwise = 0 155 – 155 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification parent for Receiver. Otherwise = 0 156 – 156 LM_ADDN_ID_SITE_CLASS = 1, of is a record found for the site classification parent for IHW Transporter. Otherwise = 0
17_Texas_Solid_Waste_System_Activity_File.docx