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 Contact’s phone number – and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM 326 355 AD_ELECTR_COMMU.CNTRY_CD Contact’s fax number – and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM 356 395 AD_ELECTR_COMMU. Contact’s address – EMAIL_ADDR_TXT
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
17_Texas_Solid_Waste_System_Activity_File.docx