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 Shipment Received” (NSR) – “No report.
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.
17_Texas_Solid_Waste_System_Activity_File.docx