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, Attention – AC_CONT.FIRST_NAME_TXT 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 = DESC’ ‘BUS PA_NOTES.SUBJ_TXT = ‘SWR_NUM_TXT’ PA_NOTES.DENORMAL_ID = PA_IHW_FAC.IHW_FAC_ID PA_NOTES.TABLE_NAME = ‘PA_IHW_FAC’
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’
17_Texas_Solid_Waste_System_Activity_File.docx