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
793 – 793 PA_IHW_FAC.MWRS_REQD_FLG = 1, if the facility has a monthly waste receipt summary reporting requirement. Otherwise = 0 794 – 803 PA_IHW_FAC.LAND_TYP_CD Site Land Type. The value in the PA_IHW_FAC.LAND_TYP_CD will be used to determine the display value in the PA_REF_GEN_CD table 804 – 813 The receiver facility category (Commercial, captive, captured, etc) 814 – 814 = 1, if the value in the field is either for ‘HIRE’ or ‘HIRE AND OWN’. Otherwise = 0 815 – 815 = 1, if the value in the field is either for ‘OWN’ or ‘HIRE AND OWN’. Otherwise = 0 816 – 817 = 01, if transport waste type = 1. The value in the PA_IHW_WST_CLASS_MANAGE.WST_CLASS_CD = ‘1’ and PA_IHW_WST_CLASS_MANAGE.RCVD_TRANS_IND = ‘TRANSPORT’ 818 – 819 = 02, if transport waste type = 2. The value in the PA_IHW_WST_CLASS_MANAGE.WST_CLASS_CD = ‘2’ and PA_IHW_WST_CLASS_MANAGE.RCVD_TRANS_IND = ‘TRANSPORT’ 820 – 821 = 03, if transport waste type = 3. The value in the PA_IHW_WST_CLASS_MANAGE.WST_CLASS_CD = ‘3’ and PA_IHW_WST_CLASS_MANAGE.RCVD_TRANS_IND = ‘TRANSPORT’ 822 – 823 = 04, if transport waste type = H. The value in the PA_IHW_WST_CLASS_MANAGE.WST_CLASS_CD = ‘H’ and PA_IHW_WST_CLASS_MANAGE.RCVD_TRANS_IND = ‘TRANSPORT’ 824 – 825 (blank) = 05, if transport type = MSW. This data was not migrated into PARIS. This field will contain spaces. 826 – 827 (blank) = 06, if transport type = Medical Waste. This data was not migrated into PARIS. This field will contain spaces. CD
281 – 310 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM fax number 311 – 350 AD_ELECTR_COMMU. EMAIL_ADDR_TXT Owner’s email address 351 – 380 RF_GEN_CD.NAME_TXT Business Type – Convert the value in CR according to the following: PR_PRINCIPAL.OWN_TYPE_TXT = RF_GEN_CD.GEN_CD_TXT and RF_GEN_CD.GEN_CD_TYP_ID = RF_GEN_CD_TYP.GEN_CD_TYP_ID and RF_GEN_CD_TYP.NAME_TXT = ‘OWNERSHIPT_TYPE’ If the PR_PRINCPAL.OWN_TYPE_TXT is not found in the RF_GEN_CD table, then use the RF_GEN_CD.NAME_TXT value for the RF_GEN_CD.GEN_CD_TXT = ‘OT’. 381 – 391 PR_PRINCIPLE. STATE_FRAN_TAX_ID_TXT or FED_TAX_ID_NUM Tax Id 392 – 392 = 1, if the following conditions are met: PY_ADM.DBTACCTTABLE.DB_MAST_ACCT = <AR number for the owner> PY_ADM.DBTACCTTABLE. DB_ACTIV_IND = ‘y’ and PY_ADM.DBTACCTTABLE. DB_ANAL_COD3 in (‘BKRT,CH11,CH12,CH13,CH 7,CH 9’) Otherwise = 0
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
111 – 140 AC_DAY_ACTV_CONT.ROLE_CD Contact role. The for this field will be the REF_GEN_CD.NAME_TXT where REF_GEN_CD.GEN_CD_TXT = < AC_DAY_ACTV_CONT.ROLE_CD> and REF_GEN_CD.GEN_CD_TYP_ID = <IHW contacts> 141 – 182 AD_ADDRESS.DELIV_TXT Contact’s mailing address. 183 – 222 AC_DAC_ADDR.INT_TXT Contact’s mailing building name address line 223 – 248 AD_ADDRESS.DELIV_TXT Contact’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. 249 – 284 AD_ADDRESS.CITY_NAME Contact’s mailing address city name 285 – 286 AD_ADDRESS.USPS_STATE_CD Contact’s mailing address state abbreviation 287 – 291 AD_ADDRESS.ZIP_CD Contact’s mailing address five digit zip code 292 – 295 AD_ADDRESS.ZIP_PLUS4_CD Contact’s mailing address post four digit zip code 296 – 325 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM Contact’s phone number 326 – 355 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM Contact’s fax number 356 – 395 AD_ELECTR_COMMU. EMAIL_ADDR_TXT Contact’s address
Billing Contact This file contains the information for an active facility billing contact including billing contact name, title, phone, mailing address, customer number, customer name, and attention. This file only includes active contacts with the billing contact role. Columns Table Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number 6 – 55 AC_CONT.LAST_NAME_TXT Billing Contact name (individual’s last name) 56 – 85 AC_CONT.FIRST_NAME_TXT Billing Contact optional name (individual’s first name) 86 – 110 Billing Contact 111 – 140 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM Billing Contact’s phone number 141 – 183 AD_ADDRESS.DELIV_TXT Billing Contact’s mailing address. 184 – 223 AD_ADDRESS.DELIV_2_TXT Billing Contact’s mailing building name address line. 224 – 259 AD_ADDRESS.CITY_NAME Billing Contact’s mailing address city name 260 – 261 AD_ADDRESS.USPS_STATE_CD Billing Contact’s mailing address state abbreviation 262 – 266 AD_ADDRESS.ZIP_CD Billing Contact’s mailing address five digit zip code 267 – 270 AD_ADDRESS.ZIP_PLUS4_CD Billing Contact’s mailing address post four digit zip code 271 – 280 BT_ARS.AR_NUM Customer Number. Includes only the AR numeric portion, does not include the “AR” prefix of the number. Left pad with leading zeros.
281 – 360 PR_PRINCIPAL.PRINC_NAME Customer Name Where the AC_DAY_ACTV_CONT.PRINC_ID = PR_PRINCIPAL.PRINC_ID 361 – 400 AC_CONT.LAST_NAME_TXT, AC_CONT.FIRST_NAME_TXT Attention 401-403 BT_AR_INTFS.AR_SUFFIX_TXT = HWF, if AR_SUFFIX_TXT = ‘F’ = HWG, if AR_SUFFIX_TXT = ‘G’ = NWF, if AR_SUFFIX_TXT = ‘I’ = NWG, if AR_SUFFIX_TXT = ‘N’ Business Description This file contains the business description for the facility. The information includes the facility registration number and company business description. Columns Table Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number 6 – 6 = 1, if the business description is longer than 160 characters 7 – 166 PA_NOTES.NOTE_TXT Business description. The value for this field is determined by the following: PA_NOTES.SUBJ_TYP_CD = ‘BUS DESC’ PA_NOTES.SUBJ_TXT = ‘SWR_NUM_TXT’ PA_NOTES.DENORMAL_ID = PA_IHW_FAC.IHW_FAC_ID PA_NOTES.TABLE_NAME = ‘PA_IHW_FAC’
46 – 48 Texas waste form code of the eight-character Texas Waste Code 49 – 49 classification of the eight-character Texas Waste Code 50 – 50 = 1, if the waste is radioactive. Otherwise = 0 51 – 51 = 1, if the waste is treated off site 52 -131 Generator’s description of the waste (first 80 characters) 132 – 136 PA_HIST.OLD_VALUE_TXT Primary standard industrialization code (SIC). The value for this field is determined by the following: PA_HIST.DENORMAL_ID = PA_IHW_WST_STREAM.TWC_ID PA_HIST.TABLE_NAME = ‘PA_IHW_WST_STREAM’ PA_HIST.DB_COLUMN_NAME = ‘NAICS_CD’ PA_HIST.REAS_TXT = ‘EPA CHANGED SIC TO NAICS’ PA_HIST.OLD_VALUE_TXT = ‘SIC – ‘<SIC_CD>. If there is a value found, the ‘SIC – ‘ will be stripped and only the actual numeric SIC code value will be used. 137 – 139 Primary source code 140 – 140 Primary measurement point code. This data was not migrated into PARIS. 141 – 141 Primary origin code
264 – 266 LJ_COUNTY.CNTY_FIPS_CD Site County FIPS 267 – 281 RE_GEO_LOC.LOC_CNTY_NAME Site’s physical location county name. This is determined by using the value found in AD_ADDRESS.ADDR_ID equals RE_GEO_LOC.ADDR_ID. 282 – 283 LJ_TNRCC_REGION. TNRCC_REGION_CD SITE REGION CODE 284 – 291 PA_IHW_OTS_REQ.REQ_RCV_DT Date request sent (YYYYMMDD) 292 – 337 PR_PRINCIPAL.PRINC_NAME or PR_PRINCIPAL.LAST_NAME Company Name 338 – 387 AC_CONT.ORG_NAME_TXT or AC_CONT.*_NAME_TXT OTS Owner contact’s last name or company name. The contact record selected will have the AC_DAY_ACTV_CONT.ROLE_CD for the owner/operator contact and the AC_DAY_CONT.END_DT is null. 388 – 467 AD_ADDRESS.DELIV_TXT Owner’s mailing address 468 – 497 AD_ADDRESS.CITY_NAME Owner‘s mailing address city name
780-787 Date processing completed (YYYYMMDD) 788-795 Waste code of waste that is being reported 796-875 Generator’s description of the waste (first 80 characters) 876-878 Waste form code. The value in this field is determined by the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 879 classification code 880 Waste origin code 881-883 Primary source code 884-886 system type code 887-889 OTS EPA Form Code should be 4 digits – only showing 3 890-895 Primary NAICS code 896-903 PA_IHW_WST_STREAM.TWC_ID PARIS unique ID number identifying the waste code.
6 – 6 Quantity Handler(LQH) Indicator 7 – 7 = B Indicate whether Universal Waste Type B is being managed. The value will be B or blank. If the value is blank, it means the site does not manage Universal Waste Type B (“Batteries”). 8 – 8 = P Indicate whether Universal Waste Type P is being managed. The value will be P or blank. If the value is blank, it means the site does not manage Universal Waste Type P (“Pesticides”). 9 – 9 = Indicate whether Universal Waste Type T is being managed. The value will be T or blank. If the value is blank, it means the site does not manage Universal Waste Type T (“Mercury”). 10 -10 = L Indicate whether Universal Waste Type L is being managed. The value will be L or blank. If the value is blank, it means the site does not manage Universal Waste Type L (“Lamps”). 11 – 11 = R Indicate whether Universal Waste Type R is being managed. The value will be R or blank. If the value is blank, it means the site does not manage Universal Waste Type R (“Paint”). 12 – 12 Destination Facility Indicator.
generator name, the shipped date, waste code, quantity shipped, who received the waste, and how it was handled. (PA_OHW_OTS_WSS.ERR_FLG != ‘N’) Columns Table Field Description 1 – 2 Always ‘S1’ representing the summary code for waste shipments 3 – 7 OTS Request ID. The generator be registered with the IHW program area or unregistered. The value this field will be determined by the following: 8 – 57 PR_PRINCIPAL.PRINC_NAME COMPANY NAME 58 – 69 Manifest tracking number 70 – 74 Receiver’s Texas registration number or ID 75 – 86 Receiver’s EPA ID – should be present when the receiver is from out of state. 87 – 94 PA_IHW_OTS_WSS.TWC_CD Waste code of waste that is being reported 95 – 95 classification. The value in this field is determined by the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 96 – 98 Waste form code. The value in this field is determined by the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 99 – 112 PA_IHW_OTS_WSS.WSS_QTY Quantity shipped (nnnnnnnnn.nnnn) 113 – 113 Unit of measurement of quantity shipped
114 – 116 System type code – describes how the waste was handled once it reached its destination. 117 – 124 PA_IHW_OTS_WSS.SHIP_DT Shipped date (YYYYMMDD) 125 – 129 Transporter’s Texas registration number 130 – 179 Generator’s name as written on the WSS form. 180 – 209 PA_IHW_OTS_WSS. AUTH_AGENT_NAME Authorized name 210 – 239 Authorized agent title 240 – 247 Record creation date (YYYYMMDD) 248 – 248 PA_IHW_OTS_WSS.ERR_FLG = 1, error records 249 – 256 Record ID assigned by PARIS 257 – 264 PA_IHW_WST_STREAM.TWC_ID TCEQ Unique Waste Stream ID
64 – 66 System type code – describes how the waste was handled by the receiver. 67 – 74 PA_IHW_MWRS_DTL.RCV_DT Received Date (YYYYMMDD) 75 – 79 Transporter’s Texas registration number 80 – 114 Comment. This data is no longer collected. 115 – 164 Receiver’s name. The for this field is determined by the following: LM_ADDN_ID.ADDN_NUM_TXT = PA_IHW_FAC.SWR_NUM_TXT 165 – 165 Reporting method (P = paper, S = STEERS) 166 – 166 = 1, if no shipments were received during the reporting period. The for this field is determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 167 – 174 Record creation date (YYYYMMDD) 175 – 180 + PA_IHW_MWRS_HDR.RPT_YR Report Date (MMYYYY). The value for this field is the concatenation of the two fields listed. The two fields are determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 181 – 181 PA_IHW_MWRS_DTL.ERR_FLG = 1, if the record contains an error in the data 182 – 189 Record ID assigned by PARIS
PA_IHW_MWRS_DTL PA_IHW_MWRS_EHWN Wrs_sum_rqmt This file contains one record for each receiver monthly summary ever submitted. The information in the file includes, but not limited to, the receiver’s registration number, a unique record ID, report year, report month, the date the summary report was entered in the system, and a flag to indicate if the report had errors. There may be zero to many monthly waste receipt summary detail records for each record in this file. Columns Table Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Receiver’s registration number. The value for this field is determined by the following: PA_IHW_MWRS_HDR.IHW_FAC_ID = PA_IHW_FAC.IHW_FAC_ID 6 – 13 Header record ID assigned by PARIS 14 – 21 Summary Record ID – this data is no longer stored in the MWRS header table. 22 – 27 PA_IHW_MWRS_HDR.RPT_YR + Report year and (YYYYMM). The value for this field is the concatenation of the two fields listed. 28 – 28 = 1, if the report is a “No Shipment Received” (NSR) report.