765 769 Industrial waste permit number – T 770 774 Municipal waste permit number – 775 775 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification – parent for Non-notifier. Otherwise = 0 776- 776 PA_IHW_FAC.STEERS_FLG = 1 if the facility is a STEERS reporter. Otherwise = 0 777 777 PA_IHW_FAC.AWS_REQD_FLG =1 if the facility is required to submit an Annual Waste – Summary. Otherwise = 0 778 778 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification – parent for Recycler. Otherwise = 0 779 784 RF_INDUS_TYP.INDUS_TYP_CD NACIS Code. To locate the value for this field use the – following: LM_ADDN_ID.ADDN_ID = LM_ADDN_ID_INDUS.ADDN_ID and LM_ADDN_ID_INDUS.INDUS_TYP_ID=RF_INDUS_TYP.INDUS_TYP_ID and RF_INDUS_TYP.INDUS_TYP_CD = ‘NAICS’ 785 792 PA_HIST.CREATE_TMSTMP Registration’s status change date (YYYYMMDD). This – value will be based on the most recent record in the PA_HIST table where: DENORMAL_ID = PA_IHW_FAC.IHW_FAC_ID TABLE_NAME = PA_IHW_FAC DB_COLUMN_NAME = REGIS_STATUS_CD NEW_VALUE_TXT = <current value in PA_IHW_FAC> If there is no record in the PA_HIST table meeting that criteria, use the PA_IHW_FAC.NOR_CRATE_DT
765 – 769 Industrial waste permit number 770 – 774 Municipal waste permit number 775 – 775 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification parent for Non-notifier. Otherwise = 0 776- 776 PA_IHW_FAC.STEERS_FLG = 1 if the facility is a STEERS reporter. Otherwise = 0 777 – 777 PA_IHW_FAC.AWS_REQD_FLG =1 if the facility is required to submit an Annual Waste Summary. Otherwise = 0 778 – 778 LM_ADDN_ID_SITE_CLASS = 1, if there is a record found for the site classification parent for Recycler. Otherwise = 0 779 – 784 RF_INDUS_TYP.INDUS_TYP_CD NACIS Code. To locate the value for this field use the following: LM_ADDN_ID.ADDN_ID = LM_ADDN_ID_INDUS.ADDN_ID and LM_ADDN_ID_INDUS.INDUS_TYP_ID=RF_INDUS_TYP.INDUS_TYP_ID and RF_INDUS_TYP.INDUS_TYP_CD = ‘NAICS’ 785 – 792 PA_HIST.CREATE_TMSTMP Registration’s status change date (YYYYMMDD). This value will be based on the most recent record in the PA_HIST table where: DENORMAL_ID = PA_IHW_FAC.IHW_FAC_ID TABLE_NAME = PA_IHW_FAC DB_COLUMN_NAME = REGIS_STATUS_CD NEW_VALUE_TXT = <current value in PA_IHW_FAC> If there is no record in the PA_HIST table meeting that criteria, use the PA_IHW_FAC.NOR_CRATE_DT T