Operator This file contains the basic information for a facility operator including facility registration number, operator name, mailing address, phone, fax, email, business type, tax ID, and bankruptcy code. The mailing address, phone, fax, and email information is the information for the contact with role of operator or owner/operator. Only the most recent operators for the facility will be included in this file. Columns Table Field Description 1 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number – 6 55 PR_PRINCIPLE. Operator name (company name or individual’s last name). – PRINC_NAME or This is for the PRINC_ID where the PR_PRINCIPLE. RE_AFFILIATION.AFFIL_TYP_ROLE_ID is for operator or LAST_NAME owner/operator. 56 85 PR_PRINCIPLE. Operator optional name (individual’s first name). This is – FIRST_NAME for the PRINC_ID where the RE_AFFILIATION.AFFIL_TYP_ROLE_ID is for operator or owner/operator. 86 127 AD_ADDRESS.DELIV_TXT Operator’s mailing. – 128 167 AC_DAC_ADDR.INT_TXT Operator’s mailing building name address line – 168 193 AD_ADDRESS.DELIV_TXT Operator’s mailing address PO Box address line. This field – will need to be parsed out of the value in the AD_ADDRESS.DELIV_TXT field. 194 229 AD_ADDRESS.CITY_NAME Operator’s mailing address city name – 230 231 AD_ADDRESS.USPS_STATE_CD Operator’s mailing address state abbreviation –
Operator This file contains the basic information for a facility operator including facility registration number, operator name, mailing address, phone, fax, email, business type, tax ID, and bankruptcy code. The mailing address, phone, fax, and email information is the information for the contact with role of operator or owner/operator. Only the most recent operators for the facility will be included in this file. Columns Table Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number 6 – 55 PR_PRINCIPLE. PRINC_NAME or PR_PRINCIPLE. LAST_NAME Operator name (company name or individual’s last name). This is for the PRINC_ID where the RE_AFFILIATION.AFFIL_TYP_ROLE_ID is for operator or owner/operator. 56 – 85 PR_PRINCIPLE. FIRST_NAME Operator optional name (individual’s first name). This is for the PRINC_ID where the RE_AFFILIATION.AFFIL_TYP_ROLE_ID is for operator or owner/operator. 86 – 127 AD_ADDRESS.DELIV_TXT Operator’s mailing. 128 – 167 AC_DAC_ADDR.INT_TXT Operator’s mailing building name address line 168 – 193 AD_ADDRESS.DELIV_TXT Operator’s mailing address PO Box address line. This field will need to be parsed out of the value in the AD_ADDRESS.DELIV_TXT field. 194 – 229 AD_ADDRESS.CITY_NAME Operator’s mailing address city name 230 – 231 AD_ADDRESS.USPS_STATE_CD Operator’s mailing address state abbreviation
17_Texas_Solid_Waste_System_Activity_File.docx