64 66 System type code describes how the waste was handled – – by the receiver. 67 74 PA_IHW_MWRS_DTL.RCV_DT Received Date (YYYYMMDD) – 75 79 Transporter’s Texas registration number – 80 114 Comment. This data is no longer collected. – 115 164 Receiver’s name. The for this field is determined by – the following: LM_ADDN_ID.ADDN_NUM_TXT = PA_IHW_FAC.SWR_NUM_TXT 165 165 Reporting method (P = paper, S = STEERS) – 166 166 = 1, if no shipments were received during the reporting – period. The for this field is determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 167 174 Record creation date (YYYYMMDD) – 175 180 Report Date (MMYYYY). The value for this field is the – + concatenation of the two fields listed. The two fields are PA_IHW_MWRS_HDR.RPT_YR determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 181 181 PA_IHW_MWRS_DTL.ERR_FLG = 1, if the record contains an error in the data – 182 189 Record ID assigned by PARIS –
64 – 66 System type code – describes how the waste was handled by the receiver. 67 – 74 PA_IHW_MWRS_DTL.RCV_DT Received Date (YYYYMMDD) 75 – 79 Transporter’s Texas registration number 80 – 114 Comment. This data is no longer collected. 115 – 164 Receiver’s name. The for this field is determined by the following: LM_ADDN_ID.ADDN_NUM_TXT = PA_IHW_FAC.SWR_NUM_TXT 165 – 165 Reporting method (P = paper, S = STEERS) 166 – 166 = 1, if no shipments were received during the reporting period. The for this field is determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 167 – 174 Record creation date (YYYYMMDD) 175 – 180 + PA_IHW_MWRS_HDR.RPT_YR Report Date (MMYYYY). The value for this field is the concatenation of the two fields listed. The two fields are determined by the following: PA_IHW_MWRS_HDR.MWRS_HDR_ID = PA_IHW_MWRS_DTL.MWRS_HDR_ID 181 – 181 PA_IHW_MWRS_DTL.ERR_FLG = 1, if the record contains an error in the data 182 – 189 Record ID assigned by PARIS
17_Texas_Solid_Waste_System_Activity_File.docx