264 266 LJ_COUNTY.CNTY_FIPS_CD Site County FIPS – Site’s physical location county name. This is determined by using the value found in AD_ADDRESS.ADDR_ID equals 267 281 RE_GEO_LOC.LOC_CNTY_NAME RE_GEO_LOC.ADDR_ID. – LJ_TNRCC_REGION. SITE REGION CODE 282 283 TNRCC_REGION_CD – 284 291 PA_IHW_OTS_REQ.REQ_RCV_DT Date request sent (YYYYMMDD) – PR_PRINCIPAL.PRINC_NAME or 292 337 PR_PRINCIPAL.LAST_NAME Company Name – OTS Owner contact’s last name or company name. The contact record selected will have the AC_DAY_ACTV_CONT.ROLE_CD for the AC_CONT.ORG_NAME_TXT or owner/operator contact and the 338 387 AC_CONT.*_NAME_TXT 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 –
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
17_Texas_Solid_Waste_System_Activity_File.docx